Microsoft Excel 2019 – Intermediate

Whether you need to crunch numbers for sales, inventory, IT, human resources, or another business unit, the ability to get the right information to the right people at the right time can create a powerful competitive advantage in a complex market environment. Build upon the foundational Microsoft® Excel 2019 knowledge and skills you’ve already acquired to create advanced workbooks/worksheets that deepen your firm’s business intelligence.

The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. You’ll learn essentials of Excel 2019 including how to create advanced formulas, organize your data into tables, harness the power of PivotTables and PivotCharts and employ slicers to simplify data filtering.

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 functions and lists
    • Analyze data and visualize data with charts
    • Use PivotTables and PivotCharts

    Workshops that compliment this program include:

    Course Dates and Times

    Date and Times Location Course Cost/Fees
    Saturdays
    Oct. 16 to Oct. 23, 2021
    9:00 AM to 12:00 PM
    Live Online Fee: $179 (Tuition: $154, Download Text: $25)
    Saturdays
    Mar. 5 to Mar. 19, 2022
    9:00 AM to 12:00 PM
    (No class 3/12/22)
    In-Person

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

    Course Hours: 6 Hours