- Went through the Implemenation plan.
- Can get the End date time calculated based on the Duration and the start date.
- Show the percentage completion in graphical format based on the actual time utilized.
Similarly in the Backout highlevel show the percenatage of completion using graphical format.
The overall status graphs can be generated as an Excel sheet so that it could be as a Status Report to be sent to the stakeholders.
- Have done similar project report, Status RBG showing milestones and highlevel summary.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- 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.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables