Great Shelford, Cambridge
1 day course
£225.00 (ex. VAT)

This is our 1 day Microsoft Excel Advanced course focusing on how to validate and summarise data. If you already have a good level of Excel skills or if you have previously attended our Excel Intermediate course, then this training session will show you how to manipulate and analyse larger sets of data.

During this course you’ll work through examples of how to create dropdown boxes for lists and protect areas of a spreadsheet, cleanse data with functions, summarise data including using advanced filters and  PivotTables and charts, import data from various sources such as databases or a website ready to manipulate in Excel, record and run simple macros effectively and more.

By the end of the session you will be comfortable at transforming data in Excel through a number of advanced techniques that will support you in your daily working situation.

This course is designed for those who already have a good level of Excel skills or may have previously attended our Excel Intermediate course.

Course Outline

Data Validation

 

Protecting Cells and Workbooks

 

Lists

  • “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

Outlining

  • Grouping
  • Subtotals

Importing Data

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

Templates

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

Introduction to Recording Macros

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

If time:

  • Collaborating on files (Office 365)

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel Power Pivot and Power Query

Microsoft Excel VBA