Microsoft Office Excel Level 2

This course builds upon the foundational Microsoft Office Excel 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, analyse data with logical and lookup functions, organise worksheet data with tables, visualize data by using charts, analyse data with PivotTables, slicers, and Pivot Charts, insert graphic objects and enhance workbooks.

This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities.

This course is suitable for all versions of Excel up to and including Office 365 and Office 2024.

Before starting this course, delegates are recommended to take the following PTR course or have equivalent knowledge: Microsoft Office Excel 2013: Level 1.