Microsoft Excel 2019/Office 365 Series
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.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.
72 Course Hours
Students will need their own computer or access to one with the courses system requirements in order to take this course. The system requirements can be found by clicking on the link in the registration area below.
To register for the course please click the link below
Northern Lights College works with trusted third party education providers to deliver current and relevant online courses. We pride ourselves on ensuring the appropriate security measures are being conducted to keep your personal information safe. To learn more about NLC's policies visit https://www.nlc.bc.ca/policies
Providers outside of British Columbia follow their individual privacy regulations, which you can review by visiting https://www.cengage.com/privacy/