- I can create the Sales run rate for your organisation which will help you analyse what is the current Sales run rate, required run rate to meet the budgeted profit.
- Also comparison of Budgeted Sales Vs Actual, Budgeted GP vs Actuals and its %
- Also the projection for the yearend, if at current level what would be your Sales and GP
I have good expertise in Excel formulas, macros and automation.
- Data merging, graphs on click of a button.
Can get started....
My skills:
- I have good skills in Excel automation and used extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries.
- With summary data plotting graphs, bringing pivot tables etc.
- Outlook autoamtion - Peforming different actions other that using the existing rules, updating calendars based on logic.
- MS Access - Expert in designing table, user input forms and also reporting from data.
- Excel to MS access data porting and conversion and designing new system for use.
- Please review my portfolio on recent projects completed.