Excel TrainingExcel Beyond the Basics

Target Audience

Aimed at regular users of Excel, this comprehensive one day event will look at a wide range of features, functions and tricks to help you manage large and complex workloads, be more productive and save time

Delegate Pre-Requisites

All delegates should have a sound knowledge of building formulae using operators and functions together with the use of range names.

Delegates should be able to use absolute and relative referencing and be familiar with autofill techniques or have attended the Excel – The Basics course available

Course Duration

This is a One Day Course

Course Details

Courses commence at 9:30 a.m. through to 4:30 p.m.
A laptop computer is provided for each delegate attending on this packed programme to try out the tips and techniques demonstrated

All delegates will receive Training Courseware to refer to during the course, together with a Course Attendance Certificate

Scheduled Courses

Off-site scheduled courses are available at a location near you – this course is available on our current programme – call our team for more details

Corporate Courses

On-site Corporate courses are available – you provide the Conference Room … we bring everything else!

Modular Courses

Bite-sized ‘modular’ courses are available where you can build your own day course covering the topics that suit you – these are half day modules that you can mix and match

The Content

Absolute Rows & Columns
Range Names
Data Consolidation
Tables

  • The Table Design Tools
  • Calculated Columns
  • Removing Duplicates
  • Converting to a Range

Sorting & Filtering

  • The filtering tools
  • Date Filters
  • Colour Filters
  • Icon Filters
  • Using Custom Filter
  • Sorting Data using Custom Lists

Pivot Tables

  • The new Pivot Table Design Tools
  • Changing the Structure
  • Filtering in Pivot Tables
  • Using the Slicer Tool (version 2010 + only)
  • Using Grouping
  • Multiple Values
  • Subtotals & Grand Totals
  • Pivot Table Styles & Report Layouts
  • Seeing the Details using Drill Down
  • Report Filter Pages
  • Calculated Fields
  • Creating a Macro to quickly create a Pivot Table

Creating a Pivot Chart

  • Why use Pivot Chart?
  • Pivoting your Chart & The Charting Tools
  • Using Sparklines feature (version 2010 + only)

Subtotalling & Outlining

  • The Functions available
  • Multiple Sub-Totals
  • Using the Outline feature

Conditional Formatting

  • An introduction to Conditional Formatting

Standardising Workbooks

  • Data Validation
  • Protecting areas of a Worksheet

Lookups

  •  Using VLOOKUP and HLOOKUP

Using MATCH and INDEX

  • Why use MATCH and INDEX?

Data Validation
Logical Functions

  •  IF and Nested IF Statements
  • SUMIF
  • COUNTIF
  •  Using AND, OR Functions

Macros

  • An introduction to Macros