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.

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 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 complement this program include:

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

Course Dates and Times

Course Hours: 6 Hours