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

Getting and Cleaning Data
Johns Hopkins University via Coursera
数据结构与算法第二部分 | Data Structures and Algorithms Part 2
Peking University via edX
社会调查与研究方法 (下)Methodologies in Social Research (Part 2)
Peking University via Coursera
統計学Ⅰ:データ分析の基礎 (ga014)
University of Tokyo via gacco
Fundamentos do Google para o Ensino
Fundação Lemann via Coursera