Excel Expert for Financial Data Analysis

Job ID: 37607407

Budget: ₹1,500 – ₹12,500 INR

I'm in need of a professional with advanced knowledge in Microsoft Excel to assist with data analysis, creating and modifying formulas and functions, and implementing macros and automation. I have intermediate knowledge about Excel features but need an expert who can guide and support me on this project.

The project revolves around Financial Data, hence an understanding of such data will be necessary.

Key responsibilities include:
*Layering PnL Data from one excel on top of another excel with yearly PnL as columns. Goal is to employ a simple formula but see the overall result in a user friendly way on excel spreadsheet. All the work is done using Excel VBA


A successful candidate should have:
* Proficiency in MS Excel including VBA, Pivot Table, simple formulae.
* Proven experience in creating effective macros for automation
* Exceptional problem-solving skills to assist in overcoming potential roadblocks.
Related categories: Visual Basic Data Processing Excel