Be more creative in their use of Microsoft Excel and Power BI for business and reporting
Become proficient in using PivotTables for analyzing a large data
Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboards/reports.
Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
Make a sample Excel VBA user form that gets data from user and input into a table in Excel
Learn Power BI and other new interesting business data analysis tools by Microsoft