Business professional using Excel for powerful data analysis

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

Print Agenda

Module 1: Building Advanced PivotTables With Calculated Items and Fields

Module 2: Power Query Including the M Language

Module 3: Introduction to Power Pivot — Gathering Data

Module 4: Power Pivot DAX Measures

Module 5: Developing Reports and Dashboards Using Power BI

Power BI is the intersection of Power Query and Power Pivot. Everything you know about Power Query and Power Pivot is the same in Power BI. However, Power BI adds a visual dimension to your data enabling you to display tables, charts and graphs connected to your data source.

Explain the value of Power BI
Navigate the Power BI interface
Recognize how to pull data into Power BI
Discuss how to begin to build your Power BI dashboard

Module 6: 3D Maps for Excel

Power BI is not the only resource you have for visualizations. Within the sphere of modern Excel features is the dazzling 3D Maps for Excel add-in. With 3D Maps for Excel, you can develop videos that depict a time-phased illustration.

Discuss the fundamentals of 3D Maps for Excel
How to build a 3D map and customize its settings
How to share your map with others
How to build a 3D map — that’s not from a map: custom mapping

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

Instructor-Led Training Business & Technology

Related Courses