- Went through the comments and the template Gantt chart. The chart can be established using customisation so that once the tasks, start date, end date and the status entered (like as in legend ToDo, Doing, Done, Overdue) accordingly the right color coding can be used to represent the timeline.
- This can be on click of a button the chart would be generated to show the "As is" status of the project.
- Have expertise in Excel macros and also in Project Management (Microsoft Project).
-
- 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.,
Sample HighComplex Projects using Macros:(via Freelancer)
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
- System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report.
- Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
- Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio.
- University, US - Scoring the answer sheets based on keyword and number of occurences.