Closed

Build a Complex Excel Workbook with Dashboard

Hello everyone,

We need an Excel expert to build us a few complex Excel workbooks including dashboards, VBA, pivot tables and so on. (financial knowledge would be helpful) This workbooks will be used by executives and small business owners, so it is important that it looks quite sleek and professional.

This job opening is for the first workbook: Basically, the user retrieves his/her inventory data from SAP (or any similar ERP software) and want to input this raw data into our workbook. Our template should take this data and process it with necessary tools such as pivot tables, formulas and VBA. (the workbook should have a robust and clean structure in the background) After putting the raw data, user wants to see the results on a dashboard supported with some pivot charts.

For the development of following workbooks, we want to work with the same person if he/she can do this job well enough. The first job is not super urgent (3-4 weeks should be fine).

For those who are interested, please fill in and submit this form:

[login to view URL]

Please write the keyword in the beginning of your application so that we understand you've read the job description (keyword is in the form above)

Thanks!

Skills: Data Processing, Excel, Financial Analysis, Visual Basic, Visual Basic for Apps

See more: excel workbook software, convert excel workbook windows application, convert excel workbook, excel dashboard examples, excel dashboard template, how to create a dashboard in excel 2016, best excel dashboards, excel dashboard tutorial pdf, how to create a dashboard in excel from scratch, how to create dashboard in excel step by step, how to create a dashboard in excel 2013, convert excel workbook stand alone application, convert excel workbook standalone, data excel workbook master workbook using vba, convert excel workbook visual basic, upload excel workbook turbolister, excel workbook update service, build program excel, convert excel workbook stand alone program, excel workbook packaged standalone software

About the Employer:
( 43 reviews ) Izmir, Turkey

Project ID: #18058580

49 freelancers are bidding on average $777 for this job

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Complex Excel Workbook with Dashboard. I can assure you the quality job. I have good experience in Data Processing, Excel, Financial Analysis More

$1000 USD in 6 days
(295 Reviews)
7.7
priyal1997

SNOWFLAKE Hi There, As a financial modeling and dashboard specialist I'm happy to help you on this task. You can refer my profile to see details of my qualifications, experience and reliability, and if you are comf More

$800 USD in 5 days
(196 Reviews)
6.8
dgled

I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and More

$950 USD in 10 days
(69 Reviews)
6.8
prameswara

the keyword Hello Sir Im excel VBA mcro and formula Expert i already read your project description :) and i love make dashboard for your excel spreadsheet Sir :) please ping me if u interested with me and we c More

$500 USD in 10 days
(324 Reviews)
7.0
TonmoyRoy111

SNOWFLAKE Dear client I have previously carried out a number of projects in excel using macros and formulas in the past. Kindly contact me for further details. Roy

$700 USD in 20 days
(279 Reviews)
6.6
polarjin2017

Hello? How are you? I have good experiences in "Build a Complex Excel Workbook with Dashboard" as you can see my profile for these (Data Processing, Excel, Financial Analysis, Visual Basic, Visual Basic for Apps). I More

$833 USD in 3 days
(64 Reviews)
6.4
aimefx

The keyword is: SNOWFLAKE Hi, I have filled and submitted the google form. I am expert in Excel, VBA, MySQL and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power More

$500 USD in 10 days
(49 Reviews)
5.6
SPARKtechBD

"Someka" I am good in Excel data sheet automation and processing. Also have experience on Excel VBA. Basically I work on Visual Basic to build any kinds of Windows application. Have more than 15 years of experience on More

$1000 USD in 30 days
(11 Reviews)
5.6
Sanjupanchal

Hello there!, I am highly interested in your project I read your project descriptions carefully before bidding. your 100% satisfaction is assured if you allow me to serve. First please chat with me where we can talk a More

$500 USD in 10 days
(37 Reviews)
5.1
vsprybhanu

SNOWFLAKE Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Button More

$1000 USD in 10 days
(69 Reviews)
5.3
antoinepal

Someka. Hello, I can build these dashboards for you as i have advanced excel skills and over 10 years in the field. Please check my portfolio to see my work. I am waiting to hear from you in order to discuss a More

$800 USD in 10 days
(19 Reviews)
4.8
supergana

SNOWFLAKE I have built systems that take in data from disparate sources, massages them and converts them for output or to build beautiful reports. I use my skills in pivot, vba and power query to perform such activi More

$944 USD in 10 days
(24 Reviews)
4.6
telfordm

SNOWFLAKE Hi, I am a native English speaking Finance professional with over 15 years experience working in financial management roles using Excel to build a variety of complex models. I am university educated in More

$1000 USD in 15 days
(13 Reviews)
4.4
sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with financial analysis using Excel. I have finished many projects like this. I'm confident in your project and I promise to do your project in time. More

$833 USD in 10 days
(11 Reviews)
4.1
marudelavallaz

Hi! I am an excel expert use to work with data. I am willing to help you with the task! Hope to talk with you for further data! Regards,

$833 USD in 10 days
(1 Review)
3.7
Sercho56

SNOWFLAKE I will work with you to automate the importation of the User data and develop the necessary User Interface ‘Dashboard’ to meet your requirements. While my knowledge of financial modelling is not extensive, More

$833 USD in 20 days
(8 Reviews)
3.8
paulodayto08

Hi Good Day! A serious freelancer here! I already filled-up the form on the link that you posted. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. More

$500 USD in 5 days
(16 Reviews)
3.5
AhmedSalama007

Hi sir, I am a professional certified management accountant have a high level experience in creating financial models and dashboards using excel spreadsheets, I made a lot of professional models in similar ideas, just More

$666 USD in 5 days
(4 Reviews)
2.9
axiomconsultants

SNOWFLAKE Hi, I'm an Excel expert with over 5 years' experience of working in Excel formulas like (SUMIF, OFFSET, COUNT, VLOOKUP, GETPIVOTDATA), Pivot tables, Excel tables, Data validation, Auto-shapes, Named range More

$500 USD in 7 days
(2 Reviews)
2.8
AshkanPRO

Hi there My name is Ashkan and I'm a data analyst in an international company. My job is data visualization and creating dashboards for our managers. I'm new in freelancer, but I've gained my costumers approval in eve More

$555 USD in 10 days
(3 Reviews)
2.2