- 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.
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.
Syllabus
Courses under this program:
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
-Get expert advice on Excel formatting to help your data stand out.
Course 4: Excel: Creating a Basic Dashboard
-Learn how to surface and summarize your data effectively in an Excel dashboard.
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).
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
-Get expert advice on Excel formatting to help your data stand out.
Course 4: Excel: Creating a Basic Dashboard
-Learn how to surface and summarize your data effectively in an Excel dashboard.
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).
Courses
-
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).
-
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.
-
Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.
-
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.
-
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 how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
Taught by
Dennis Taylor, Oz du Soleil, Curtis Frye and Jennifer McBee