Finance and Accounts with Excel Proficient

Hi,
I have 6 years of experience of handling Finance & Accounts and excel. I am Finance Executive by profession.

(Please check my profile to see work history)

I am expertise at Microsoft Excel, so I can assist you to solve your Accounts & Finance related problems through excel. i.e. reporting , data analysis, consolidation, ageing etc. I can create formula base template as per your requirement. I have good knowledge & experience handling of Advance excel. i.e. Vlookup, Hlookup, Index, Logical IF, SUMIF, COUNTIF, COUNIFS, SUMIFS, COUNTA, Dashboard, Pivot tables, conditional formatting, advance filter etc.
I have experience of handling finance related issues & know how to solve issues with my logical & excel skill; which can save production time.

I have solved many problems & save production time of my organization through my excel skills.

I have completed many local projects.

I have been solving many issues with my excel skills at my workplace.


Some Examples of completed work:-

1. Created excel template for YTD Consolidation. (Before creation of this template, total time required to complete task was 3 Hours, Now with the help of my template time require to complete this task is 1.5 hours. (50% time saved)

2. Month on month comparison template for changes in employees pay structure (i.e. Increase or decrease in allowances, pay, new joinee, leaver)

3. Formula based reconciliation template. Which can save more than 40% time.

4. Formula based stock management template:-
Features:-
- Calculate automatically stock in Head Office & Branch Office.
- Generate Sales report, Office location wise Debtors report automatically.
- Create Graph of office location wise payment recovery ratio automatically.
- Generate Graph of Gross Profit, Expense & Net Profit automatically.
- Checkpoints for errors in recording data.
- Save more than 50% time.

It will be honored for me to assist you.

Thanks & Regards,
Umesh Mahadik

Work Terms

I can work 2 to 3 hours on working days & 4 to 6 hours on weekends (Friday, Saturday, Sunday)