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.

Please note: To ensure success, students need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable working in a Windows environment and be able to manage information on the computer like opening and closing applications and managing files and folders. For those looking for fundamental computer competencies, we recommend the following course - Basic Computer Skills for the Workplace.

Learning Outcomes:

    • Work with functions and lists
    • Analyze data and visualize data with charts
    • Use PivotTables and PivotCharts

    Workshops that complement this program include:

    Course Dates and Times

    Date and Times Location Course Cost/Fees
    Saturdays
    Oct. 14 to Oct. 21, 2023
    9:00 AM to 12:00 PM
    In-Person

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

    Course Hours: 6 Hours