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
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
 | skillpath.com/EX300 |
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.
Module 1: Solve Data Challenges With Formulas
How much do you really know about Excel? Are you an expert or are you only an expert in the features you use?
In this session, you’ll be challenged to solve typical formula problems.
Create a table from a list
Solve logical formula challenges
Solve lookup formula challenges
Module 2: Automate Solutions With Office Scripts
This section, with examples and practice tasks, shows what Office Scripts can do for you.
Record a script
Edit a script
- Run the script from a button
Module 3: Manage Data Challenges With Power Query
In this session, you’ll go further into your Power Query toolbox, explore the Get & Transform features and find solutions to more data challenges.
Transform a Summary Report into a table
Transform a Cross Tab Report daily transactions into a table grouped by week
Transform report data from separate files into a single table
Module 4: Solve Modeling Challenges With Power Pivot
With Power Pivot, you can accommodate an unlimited amount of data — plus discover solutions to challenges provided by Power Pivot’s other components. In this session, you’ll solve data challenges by exploring the data modeling features of Power Pivot.
Bridge a single fact table with multiple dimension tables
Bridge multiple fact tables with multiple dimension tables
Module 5: Apply DAX Functions in Power Pivot
This session teaches you the essential DAX functions and guides you practice steps to learn how to build them efficiently.
Calculate year-on-year variances
Calculate YTD totals for a fiscal year
Module 6: Visualize Data and Build 3D Maps for Excel
This session introduces 3D maps…and how you can use 3D Maps for Excel to develop videos that depict a time-phased map illustration of values in your workbook.
Discuss the fundamentals of 3D Maps for Excel
Build a 3D Map and customize its settings
Share your map with others
Create a custom map