Description
MS Excel for Data Science is a custom-tailored session focused on solving customized training needs with MS Excel. Throughout the training, students will build custom MS Excel solutions using custom-built curriculums and methodologies. At the end of training, students will have developed bespoke solutions for work portfolios as well as improved technical skillsets in MS Excel and enhanced conceptional understandings of data science.
Benefits
• Bespoke solutions 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 private 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 private training via Google Meet
Requirements
• MS Excel Desktop
• Private information secured during screensharing
Policies
• Scheduling Policy – Scheduling is in 60-min increments. Attendance will be charged in full at start of each 60-min increment.
• Cancellation Policy – Cancelled or Missed attendance without 24-hr notice will be charged in full and ineligible for rescheduling, exchange, or refund. Late arrival over 15-min will be considered Missed.
