- Have extensive knowledge on Excel automation.
- Can get the formulas lookups improvised/corrected using macros and generate the graphs/charts.
- Also based on the button clicks can generate the week/day, month/day reports.
- Have done similar graphs and dashboards to get the summary.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- 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.,