YoVDO

Master Microsoft Excel

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Organization Courses PivotTables Courses

Course Description

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

Taught by

Dennis Taylor, Dennis Taylor, Dennis Taylor, Curtis Frye, Dennis Taylor, Curtis Frye, Jennifer McBee and Jennifer McBee

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Microsoft Excel - Excel from Beginner to Advanced
Udemy
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy
Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel Mastery: From Beginner to Pro
Udemy