Hi,
I have 6 years of experience of handling Finance & Accounts and excel. I am Finance Executive by profession.
(Please check my profile & portfolio to know my skills)
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 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:-
Regards,
-Umesh Mahadik