| Print |

Excel Advanced - Validate and Summarise

Location Cambridge
Price ex. VAT 215 GBP
Start Date 26 February 2019
Course type Standard
Course code FROG227
Duration 1 Day


The aim of this course is to assist users who need to become proficient in manipulating data within Excel.  By the end of the course you will be able to Clean and Summarise, Filter, Sort, Import, Share and Protect data. You will also have gained an understanding of how to create and edit Macros to speed up processes.


Target Audience

Designed for existing users of Excel who wish to progress their Excel skills and benefit from its powerful data analysis tools.


It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.


Data Validation


  • “Cleansing Data”
  • Single & Multi-level sorting
  • Auto Filter & Advanced Filter
  • Tables

Pivot Tables and Pivot Charts

  • Summarising with Pivot Tables
  • Creating Pivot Charts
  • Using the Slicer/Timeline
  • Quick Analysis Tool


  • Grouping
  • Subtotals

Importing Data

  • Importing Data from Various Sources
  • Query Databases
  • Get & Transform


  • Excel Templates
  • Create/Edit a Template
  • Default Templates

Introduction to Macros

  • Recording a macro
  • Personal macro workbook
  • Running and editing a macro
  • Assigning a macro to Objects or Buttons

Using Excel in a Workgroup

  • Comments
  • Sharing Workbooks
  • Tracking Changes
  • Document Inspector
  • Mark as Final

Protecting Cells and Workbooks

Book the course: Excel Advanced - Validate and Summarise

Course Search