Microsoft Excel 2019/Office 365 Series (OME19/365S)
(03/17/2021-07/30/2021)

Course Memo

Introduction to Microsoft Excel 2019/Office 365
This course focuses on the fundamentals of Excel 2019. You will first learn how to quickly and efficiently create fully formatted worksheets. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course.

Intermediate Microsoft Excel 2019/Office 365
This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

Advanced Microsoft Excel 2019/Office 365
This course will help you make the most of your investment in Microsoft Excel 2019. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. By the time you finish this course, you will know all the possible features and function of Microsoft's powerful spreadsheet software.