Name: Master Microsoft Excel
Price: -1 USD

Master Microsoft Excel

Overview

Employers around the world cite Microsoft Excel as one of the most sought-after skills for any new hire. This learning path helps you become an Excel power user—covering everything from functions and formatting to PivotTables and dashboards.

Master the powerful features and functions in Excel.
Learn how to use Excel's robust built-in formulas.
Become certified as a Microsoft Office Specialist (MOS) or MOS Expert.

Syllabus

Course 1: Excel Essential Training (Office 365/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: Advanced Formulas and Functions

Take advantage of the most powerful features in Microsoft Excel. Learn how to use advanced formulas and functions, including lookup, statistical, text, and math functions.

Course 3: Excel: Advanced Formatting Techniques (365/2019)

Learn advanced formatting techniques in Excel that can help you create effective and appealing spreadsheets.

Course 4: Excel: Creating a Basic Dashboard

Discover how to summarize data in Excel 2016. Learn how to set up a dashboard worksheet, create links to workbook elements, maximize your screen space by hiding rows, and more.

Course 5: Excel: Charts in Depth

Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.

Course 6: Excel: PivotTables in Depth

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.

Course 7: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019 and Office 365

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist (MOS). Get training for the Excel Associate certification exams for Office 365 and Office 2019.

Course 8: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Demonstrate your mastery of Excel by becoming a Microsoft Office Specialist Expert. This course prepares you for the Excel Expert exam for Office 2019 and Office 365 (MO-201).