This course builds upon the foundational Microsoft Office Excel 2021 knowledge and skills you've already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your business intelligence. In this course you will, create advanced formulas, analyze data with logical and lookup functions, organize worksheet data with tables, visualize data by using charts, analyze data with PivotTables, slicers, and PivotCharts, insert graphic objects and enhance workbooks. This course is designed for individuals who already have foundational knowledge and skills in Excel 2021 and are ready to advance their data analysis skills and abilities. This course will help you prepare 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 course or have equivalent knowledge: Microsoft Office Excel 2021: Level 1.