Business / Data Analyst / Excel Expert
Last active: 1 day ago
MBA + MS Excel whiz with > 10 yrs creating and managing spreadsheets + Google Spreadsheet expert.
Highly efficient in MS Excel vlookup, hlookup, sumif, macros, pivot table etc. to mine and extract the meaningful report and results with graphical presentation and dashboards..
Take advantage of my spreadsheet expertise in 3 areas:
To exclude and calculate the desired report from available data by advance spreadsheet analytics and using advance functions and formulas.
To create automated dashboard to analyze the available data and business performance.
Demonstrates the technical Excel tools and techniques needed to build a good model successfully.
Illustrates successful best practice modelling techniques such as linking, formula consistency, formatting, and labelling.
Describes strategies for reducing errors and how to build error checks and other methods to ensure accurate and robust models.
Loves to do make-overs on existing spreadsheets to make the calculations more robust, and the solutions simpler, more elegant, less confusing, and easier for a third party to understand what is going on.
Do you know what you want out of your spreadsheets, but are tangled in a mess of equations, manual inputs and fields that don't update automatically? I'll sort that out for you.
Do you need to show your customers something that is easily digested? I'll do that for you.