Duration

One Day

Suitable for

This course is for anyone who wants to gain an advanced skill set necessary for calculating data using functions and formulas, sorting and filtering data, creating PivotTables to analyse data and customising workbooks.

Location

Objectives

You will use advanced formulas and work with various tools to analyse data in spreadsheets. You will also organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphical objects.

Programme

Lesson One – Calculating Data with Advanced Formulas

• Apply Cell and Range Names
• Calculate Data across Worksheets
• Use Specialised Functions
  • Concatenate, Proper, Left and Right
• Analyse Data with Logical and Lookup Functions
  • If, SumIf, CountIf and Vlookup

Lesson Two – Organising Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort and or Filter Data
• Use Functions to Calculate Data

Lesson Three – Presenting Data using Charts

• Create a Chart
• Modify a Chart
• Format a Chart

Lesson Four - Analysing Data using PivotTables, Slicers and PivotCharts

• Create a PivotTable Report
• Filter Data using Slicers
• Analyse Data using PivotCharts

Lesson Five – Inserting Graphical Objects

• Insert and Modify Images
• Draw and Modify Shapes
• Illustrate Workflow using SmartArt Graphics
• Layer and Group Graphical Objects

Lesson Six – Customising and Enhancing the Excel Environment

• Customise the Excel Environment
• Customise Workbooks
• Manage Themes
• Create and Use a Template

Duration (in days)