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.
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