This course builds upon the foundational Microsoft Office Excel 2016 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 2016 and are ready to advance their data analysis skills and abilities.
Before starting this course, delegates are recommended to take the following PTR course or have equivalent knowledge: Microsoft Office Excel 2016: Level 1.