- Master Excel's powerful features and functions.
- Make the most of pivot tables and dashboards in Excel.
- Let your skills shine as a Microsoft Office Expert.
Prepare for the Excel Expert - Microsoft Office Specialist Exam for M365 Apps (MO-211)
via LinkedIn Learning Path
Overview
Demonstrate your mastery of Microsoft Excel by getting certified as a Microsoft Office Specialist (MOS) Expert. This learning path—covering everything from advanced formulas and formatting to pivot tables and dashboards—will help you prepare for the Excel Expert exam for Microsoft 365 Apps.
Syllabus
Courses under this program:
Course 1: Excel Essential Training (Microsoft 365)
-Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.
Course 2: Excel: Tips and Tricks
-Learn powerful tips, tricks, and shortcuts from Excel trainer and popular instructor Dennis Taylor.
Course 3: Excel: Advanced Formulas and Functions
-Learn the important formulas and functions you need to know about in Microsoft Excel.
Course 4: Excel: Advanced Formatting Techniques
-Get expert advice on Excel formatting to help your data stand out.
Course 5: Excel: PivotTables in Depth
-Learn how to summarize and analyze data using Excel’s most powerful feature: PivotTables.
Course 6: Excel: Creating a Basic Dashboard
-Learn how to surface and summarize your data effectively in an Excel dashboard.
Course 7: Cert Prep: Excel Expert - Microsoft Office Specialist for Microsoft 365 Apps
-Prepare for the Microsoft Office Specialist Expert exam for Excel in Microsoft 365.
Course 1: Excel Essential Training (Microsoft 365)
-Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.
Course 2: Excel: Tips and Tricks
-Learn powerful tips, tricks, and shortcuts from Excel trainer and popular instructor Dennis Taylor.
Course 3: Excel: Advanced Formulas and Functions
-Learn the important formulas and functions you need to know about in Microsoft Excel.
Course 4: Excel: Advanced Formatting Techniques
-Get expert advice on Excel formatting to help your data stand out.
Course 5: Excel: PivotTables in Depth
-Learn how to summarize and analyze data using Excel’s most powerful feature: PivotTables.
Course 6: Excel: Creating a Basic Dashboard
-Learn how to surface and summarize your data effectively in an Excel dashboard.
Course 7: Cert Prep: Excel Expert - Microsoft Office Specialist for Microsoft 365 Apps
-Prepare for the Microsoft Office Specialist Expert exam for Excel in Microsoft 365.
Courses
-
Prepare for the Microsoft Office Specialist Expert exam for Excel in Microsoft 365.
-
Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.
-
Learn powerful tips, tricks, and shortcuts from Excel trainer and popular instructor Dennis Taylor.
-
Learn the important formulas and functions you need to know about in Microsoft Excel.
-
Learn how to summarize and analyze data using Excel’s most powerful feature: PivotTables.
-
Get expert advice on Excel formatting to help your data stand out.
-
Learn how to surface and summarize your data effectively in an Excel dashboard.
Taught by
Dennis Taylor, Oz du Soleil, Curtis Frye and Jennifer McBee