MS Excel Sessions: MS Excel for Data Science - Recurring

MS Excel for Data Science is a custom-made session focused on solving personalized needs with MS Excel. Students will develop a bespoke solution for individual project using a tailored-made training and curriculum. Students will improve technical skillset in MS Power Query, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables as well as conceptional understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics.

Benefits

• Bespoke solution for individual project

• Technical skillset in MS Power Query, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables

• Conceptual understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics

• Personalized private training

• Continuous learning resources

Topics

1. Data Transformations using MS Power Query

2. Data Modeling using MS Power Pivot

3. Calculated Measures using DAX

4. Data Visualizations using Pivot Charts

5. Data Analytics using Pivot Tables

Deliverables

• Live 60-min screensharing via Google Meet

Requirements

• MS Excel Desktop

• Private information secured during screensharing