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:

• Microsoft Excel 2019 – Advanced
• Microsoft Word 2019 – Basic
• Microsoft Word 2019 – Intermediate
• Microsoft Word 2019 – Advanced

Course Dates and Times

Course Hours: 6 Hours