Mastering Microsoft® Excel® for Office 365® Level 300

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

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

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

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

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

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