CBH Training

Call Now: 01524 424678, Email: This email address is being protected from spambots. You need JavaScript enabled to view it. or open Contact Form

Microsoft Excel Advanced


This course provides you with the knowledge of how to use Excel as a tool for forecasting and advanced data manipulation.  Covering the more complex functions and showing how to nest functions allowing compound calculations and the functionality of analysing multiple conditions within a single formula.

It will enable you to enhance your skills by exploring some of Excel’s analysis, planning and development features in particular "What-if" functions and will also cover the creation and use of Pivot Tables and will show how routine tasks can be automated by the use of simple Macro's attached to an action button.


By the end of this course you will be able to:


  • Use pivot tables to group and count data
  • Work with goal seek, scenario and solver
  • Understanding advanced functions
  • Automate routine tasks with simple macros

Session 1: Recap

  • Sort & Filter, Sort, Auto Filter
  • IF statements
  • Shortcut Tools
  • Advanced Filter, Complex Sorting

Session 2: Complex Functions

  • Database Functions
  • Logical Functions
  • Lookup Functions
  • Text, Date & Maths Functions
  • Nested/Cascaded Functions

Session 3: Pivot Tables

  • Creating a Pivot Table
  • Changing Pivot Table Fields
  • Refreshing Data
  • Pivot Charts

Session 4: Creating and using Macro's

  • Recording Simple Macros
  • Assigning Macros
  • Editing Simple Macros
  • Assigning a Macro to an Action Button

Session 5: What-If Functions

  • Goal Seek
  • Scenarios
  • Solver

Session 6: Charts and Forecasting

  • Forecasting Functions
  • Growth & Linear Trend Fills
  • Use Of Charts In Forecasting
This course is designed for experienced users of Excel. It is recommended that you have attended our level 2 training course or have equivalent knowledge.
In this course you will:
  • Learn how to use Scenarios to automatically substitute values in your worksheet to produce forecasting reports, essential if you are responsible for financial planning.
  • Manipulate large sets of data using Pivot Tables allowing you to summarise easily into written reports or by using charts.
CBH have been delivering training into businesses for over seven years. All our Trainers come from industry so you are assured of their competence to deliver professional and practical knowledge throughout the course. All training is backed by our 90-day free support line, which can assist you when putting your learning into practice.


Latest Articles

How to take Minutes Effectively WHY SHOULD YOU LEARN TO TAKE MINUTES? Minute Taking is a key skill and is often far more involved than given credit.  Many people start taking minutes with...
Finance for non-financial Managers COURSE AIMS This one day training course will look at the tools and processes you need to build, present and work with your budget, understand a Profit and Loss Statement, Cash Flow...
Business Writing COURSE AIMS Every email, report or letter speaks volumes about you and you organisation. This is why it is important to ensure that every document that leaves your organisation is crisp, professional...

Contact Us

You are here: Home Microsoft Microsoft Excel Training Microsoft Excel Advanced

CBH Training Logo White

CBH Training

"Work smarter, not harder!"

01524 424678
This email address is being protected from spambots. You need JavaScript enabled to view it.



Training Venues


Wyboston Lakes, Great North Road, Wyboston, Bedfordshire.  MK44 3AL


Greenlands Farm Village, Tewitfield, Carnforth, Lancashire.  LA6 1JH

Clawthorpe Hall Business Centre, Burton-in-Kendal, Carnforth, Lancashire.  LA6 1NU


1 Lyric Square, King Street, Hammersmith, London.  W6 0NB


Morecambe Office

30 Lowlands Road
T: 01524 424678
E: This email address is being protected from spambots. You need JavaScript enabled to view it.
F: 01524 424678

Huntingdon Office

PO Box 617
PE29 9FT
T: 01480 718008

Follow Us

Copyright © 2012 CBH Training
All Rights Reserved
Created by Showing Off Ltd