Microsoft Excel 2019 – Advanced

Your experience to date with Microsoft® Excel 2019 gives you a solid foundation with this software. This class builds upon the knowledge presented in the Microsoft® Office Excel® 2019 Basic and Intermediate classes to help you get the most of your Excel experience. This course covers Excel’s more advanced features—automating common tasks, auditing workbooks to avoid errors, sharing your data with others, analyzing data and using Excel data in other applications.

Use Excel to actually solve problems for your business. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

Learning Outcomes:

  • Work with multiple worksheets and workbooks
  • Use Lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create sparklines and map data
  • Forecast data

Workshops that compliment this program include:

Course Dates and Times

Date and Times Location Course Cost/Fees
Saturdays
Apr. 9 to Apr. 16, 2022
9:00 AM to 12:00 PM
In-Person

Main Campus,
Center for Business and Industry
Fee: $179 (Tuition: $154, Download Text: $25)

Course Hours: 6 Hours