We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:

  • Microsoft Office: Word, Excel, Outlook, PowerPoint, OneDrive, Visio, Teams
  • Microsoft Project
  • Microsoft SharePoint
  • Adobe Creative Suite: Photoshop, InDesign, Illustrator, Acrobat
  • Power BI
  • And many others…just call us on 01223 841848 or email us

Excel Advanced - Formulae and Functions

Location Great Shelford, Cambridge
Price ex. VAT £225.00
Start Date 19 May 2020
Course type Standard
Course code FROG226
Duration 1 Day


By the end of this course you will be able to create a wide range of advanced calculations including IFs, LOOKUPs, Date and Text Functions.

Target Audience

Designed for existing users of Excel.


It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.  A basic understanding of calculations in Excel is essential although there will be a refresher of this topic.


Advanced Autofill 

  • Flash Fill 
  • Fill Weekdays 
  • Fill Values Only 
  • Growth Trend 

Advanced Formatting

  • Styles and Themes
  • Custom Number Formatting
  • Conditional Formatting
  • Quick Analysis Tool


  • Refresh on Formulae 
  • Absolute referencing 
  • Mixed referencing 

Named Ranges 

  • Add & delete a named range 
  • Use named ranges in a formula 
  • Natural Language 

Advanced Functions 

  • Text Functions 
  • Logical Functions 
  • Lookup Functions
  • Date Functions
  • Round Functions 
  • IF and Nested Functions
  • SUMIF 

Multiple Workbooks 

  • Link Workbooks 
  • Arrange Workbooks 
  • Consolidate Data

What-If Analysis 

  • Goal Seek 

Auditing Worksheets

  • Checking Errors
  • Formula Evaluator
  • Watch Window
  • GoTo Special


  • Customise Quick Access Toolbar 
  • Customise the Ribbon 
  • Excel Options  
We are no longer accepting registration for this event

Course Search

Contact Us
Contact Us