MS Excel for Data Science is a team-based workshop focused on solving collaborative trainings needs. Throughout the training, students will build complete MS Excel demos using real-world scenarios and datasets. At the completion of training, students will have developed tangible demos for work portfolios as well as improved technical skillsets in MS Excel and enhanced conceptional understandings of data science.

Benefits

• Tangible demos for work portfolios

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

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

• Live group trainings

• 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

• 60-min live group training via Google Meet

Requirements

• MS Excel Desktop

• Private information secured during screensharing

Policies

• Cancellation Policy - Cancelled or Missed attendance without 7-day notice will be charged in full and ineligible for rescheduling, exchange, or refund. Late arrival over 15-min will be considered Missed.

MS Excel Workshops - MS Excel for Data Science