Overview

This one day course will provide you with a thorough understanding of the analysis, format and presentation of data using excel via pivotal tables, formulae, lookups and graphics.

Pre-Requisites
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 through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.
Prerequisites Before taking this course, students are recommended to take the following course, or have equivalent knowledge: • Microsoft Excel Introduction

Delivery Method
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course Content:
Upon successful completion of this course, students will be able to:
• Create advanced formulas.
• Analyse data with logical and lookup functions.
• Organize worksheet data with tables.
• Visualize data by using charts.
• Analysing data with PivotTables, slicers, and PivotCharts.
• Insert graphic objects.
• Enhance workbooks