Loading page details...
Instructor-Led Training
Mastering Microsoft® Excel® for Office 365® Level 300
Are you worried you’re using “modern” Excel® like it’s “old-fashioned” Excel? Are you convinced that if you’re not keeping up, you’re falling behind? Microsoft rolls out updates to Excel constantly. How can you keep up? With this new training opportunity, you’ll save countless hours of frustration trying to figure out the powerful advanced features like Power Pivot, Power Query, DAX, Power BI and Power Maps.
For those who don’t have the time to spend at long, dry, multiple-day classroom sessions to learn the essence of modern Excel, this modular approach can show you the most time-saving, cutting-edge features in easy-to-digest chunks or one complete, fascinating day.
Course Outcomes
- Training activities focused on essential Excel tools like PivotTable calculated items, calculated fields and conditional formatting
- Hands-on data management using Excel’s collection of Power Tools, such as Power Query, Power Pivot, DAX Functions, Power BI and Power Maps
- Learning resources centered on extracting, transforming and loading data that will be hosted on Power BI dashboards
- Instruction to produce custom-animated 3D map videos for Microsoft PowerPoint presentations
- Adult learning theory approaches to relate Excel features to everyday business needs
Course Agenda
Instructor-Led Training
Module 1: Solve Data Challenges With Formulas
Module 2: Automate Solutions With Office Scripts
Module 3: Manage Data Challenges With Power Query
Module 4: Solve Modeling Challenges With Power Pivot
Module 5: Apply DAX Functions in Power Pivot
Module 6: Visualize Data and Build 3D Maps for Excel
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in
Related Courses