Microsoft Office training -  Advanced Excel

Excel Training

Advanced Excel (2 days)

£695 + VAT for most venues (£795 + VAT for London)

We call this our advanced Excel course, but perhaps it should be called intermediate-to-advanced. This two-day course is aimed squarely at those who have already learnt to use (and love?) Excel, but who suspect that it can do much more than they currently use it for. We'll aim to show you that your suspicions are correct! 

Course details

  • Locations for Advanced Excel coursesLocations:Manchester, London
  • Next Advanced Excel course locationNext course:Thu 11 January 2018
  • Advanced Excel course timesTime:09.30-16.30

Course Contents

Formatting numbers and dates

  • Training topicStandard number formats
  • Training topicCreating custom formats
  • Training topicDates and times
  • Training topicScaling, colours and underscores

Conditional formatting

  • Training topicCreating/using cell rules
  • Training topicData bars and colour sets

Covered if time allows If time


  • Training topicUsing the default styles
  • Training topicCreating custom styles
  • Training topicUsing styles with protection

Cell comments

  • Training topicAdding comments
  • Training topicPrinting comments


  • Training topicSetting validation rules
  • Training topicInput messages (a bad idea)
  • Training topicHighlighting validated cells
  • Training topicSingle-cell dropdown lists


  • Training topicUnlocking cells
  • Training topicProtecting worksheets
  • Training topicProtecting workbooks
  • Training topicVery hidden worksheets

Grouping and outlining

  • Training topicGrouping rows/columns
  • Training topicMoving the outline symbols

Range names and absolute references

  • Training topicFixing cell references ($)
  • Training topicFixing rows/columns only
  • Training topicRange names
  • Training topicLabelling ranges

IF family of functions

  • Training topicThe IF function
  • Training topicNesting Ifs (and why not to)
  • Training topicIFS and SWITCH functions

Lookup functions

  • Training topicExact-match lookup formulae
  • Training topicContinuous value lookups
  • Training topicIntercepting and handling errors

Multiple worksheets

  • Training topicMoving and copying sheets
  • Training topicGroup editing
  • Training topicConsolidation across sheets

Basic tables

  • Training topicCreating and naming tables
  • Training topicSorting tables
  • Training topicFiltering table data
  • Training topicTable styles and formatting

Advanced Tables

  • Training topicRemoving duplicates
  • Training topicAdvanced filters
  • Training topicCreating table styles
  • Training topicSubtotals

Pivot tables

  • Training topicCreating pivot tables
  • Training topicGrouping fields
  • Training topicDrill-down
  • Training topicSlicers and timelines


  • Training topicSelecting data
  • Training topicQuick ways to create charts
  • Training topicFormatting your chart
  • Training topicChart templates

Advanced charts

  • Training topicCombination charts
  • Training topicPicture charts
  • Training topicRegression and trendlines
  • Training topicSpecialist charts

Covered if time allows If time


  • Training topicCreating sparklines
  • Training topicChanging chart types
  • Training topicFormatting sparklines

Recording Macros

  • Training topicAbsolute/relative recording
  • Training topicWhere macros are stored
  • Training topicAssigning macros to buttons

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Nice and relaxed, friendly atmosphere."

Darren Askew (Zurich Assurance Ltd.)

"I really enjoyed the course and more importantly learned a lot but the presence of your manual and the USB to ensure I can practice and develop until it is embedded is very useful. The trainer was very friendly, helpful and despite some of my questions, at no point made me feel inadequate despite the other delegate needing very different levels of input. I would highly recommend Wise Owl after this experience."

Mary Blackwell (Househam Henderson)

"Course was very beneficial and I have gained a lot from it."

Michael Millar (Booker Cash & Carry)

"The quality of manuals, examples and trainer were excellent. The trainer was happy to move off course to answer questions and tailor the content, this was great."

James Lodge (The Office of the Director of Public Health)


Paige Alcock (Merchant Rentals Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Delegates should already have a good working knowledge of Excel (one way to achieve this would be to attend our one-day introduction to Excel course).  Note that the course uses Excel 2016, although if you're using Excel 2013 or 2010 you'll still find the vast majority of this course useful (you can see what's different about Excel 2016 here).

Related Courses

Excel Business Modelling


2 day course



2 day course

PowerPivot / Excel Power BI


2 day course

Other Microsoft Excel training resources

Excel exercises

Excel exercises

Don't book a course blind - have a look at some of our Excel exercises published online first, to see if you like our approach.

View Excel 2010, Excel VBA or Power BI exercises

Excel videos

Excel videos

We've got loads of videos on Excel tips and other Excel subjects online.

View Excel VBA, Microsoft Excel or Excel 2013 Power BI Tools videos

Excel skills assessment

Excel skills assessment

To see how well you know Excel, try taking one of our tests - they're designed to show you how well you know Excel relative to others.

View Excel or Excel Visual Basic skills assessment tests

Excel blogs

Excel blogs

There are lots of Wise Owl blogs on Excel, usually answering specific questions about the software.

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post