Master Microsoft Excel

Go to class
Write Review

Free Online Course: Master Microsoft Excel provided by LinkedIn Learning is a comprehensive online course. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Master Microsoft Excel is taught by Dennis Taylor, Oz du Soleil, Curtis Frye and Jennifer McBee.

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
  • 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).