In this course, you will learn about some of the more advanced features of Excel, including automating worksheet functions, auditing workbooks to avoid errors, sharing your data with other people, importing and exporting data, analyzing data, working with multiple workbooks, and using Excel data in other applications. This course is intended for a delegate who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets. This course prepares you for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications.
Before starting this course, delegates are recommended to take the following PTR courses or have equivalent knowledge: Microsoft Office Excel 2021: Level 1 and Microsoft Office Excel 2021: Level 2.