Microsoft Office training -  Excel Advanced

Excel Training

Advanced Excel Training Course

£585 + VAT for most venues (£685 + VAT for London)

2 days

Excel can do so much more than simple formulae!  This two-day advanced course will show you how to use VLOOKUP and MATCH/INDEX functions, create pivot tables and much, much more.  The idea is that by the time you finish the course you will have seen virtually everything that Excel can offer(apart from VBA, the subject of a separate two-day Excel VBA course).

Course details

  • Locations for Excel Advanced coursesLocations:Manchester, London
  • Next Excel Advanced course locationNext course:Wed 06 June 2018
  • Excel Advanced course timesTime:09.30-16.30

Course Contents

Advanced IFs

  • Training topicRevision of single IFs
  • Training topicNesting =IF
  • Training topic=IFS and =SWITCH

Lookup functions

  • Training topicUsing VLOOKUP for continuous values
  • Training topicUsing VLOOKUP for exact matches
  • Training topicList data validation for exact matches
  • Training topicDynamic range names
  • Training topicHandling errors in lookup tables

Advanced lookup functions

  • Training topicUsing = MATCH to find values
  • Training topicCombining =INDEX and =MATCH
  • Training topicThe OFFSET function
  • Training topicThe INDIRECT function

Text functions

  • Training topicBasic text functions
  • Training topicFinding and replacing text
  • Training topicExtracting and joining text

Multiple worksheets

  • Training topicGroup editing
  • Training topicFormulae across sheets
  • Training topic3D summing across sheets

Advanced tables

  • Training topicRemoving duplicates
  • Training topicAdvanced filters (multiple criteria)
  • Training topicAdding and removing subtotals
  • Training topicGrouping/outlining controls

Pivot tables

  • Training topicCreating pivot tables
  • Training topicChanging the aggregation function
  • Training topicDrilling down
  • Training topicFiltering and sorting

Advanced pivot tables

  • Training topicGrouping fields
  • Training topicShowing % of grand totals, etc
  • Training topicSlicers and timelines

Getting data (was Power Query)

  • Training topicUsing different data sources
  • Training topicQuery steps
  • Training topicMassaging data before loading it
  • Training topicThe "Column by example" transform

Covered if time allows If time

Advanced charts

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

Covered if time allows If time

Scenarios

  • Training topicCreating what-if scenarios
  • Training topicThe scenario manager

Covered if time allows If time

Goal-seeking

  • Training topicTargeting a given value
  • Training topicSetting the number of iterations

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Very informative, well paced, well resourced. Good introduction to the material with enough exercises to enhance learning."

Martin Buckley (Hoist Finance)

"Really good. Most useful course I've possibly ever been on! It was genuinely excellent."

Leah Henshall (AQA Education Limited)

"Forward thinking approach, is apparent from Wise Owl website."

Andy Taylor (Production Bureau Ltd)

"It was a great two days, learnt so much. I think that I have only been programming for 2 months that understanding the usage and application of VBA was difficult. However, worthwhile as now I have started looking at my work in a completely different way. Thanks to the training!"

Nathan Sexton (University of Kent)

"The course was exactly what I was looking for in order to complete a specific project that I am working on shortly. Many of the topics are relevant to what I had in mind for the project. The content of the course and duration were right for a basics to RB. The trainer, was excellent and I learned a lot from his teaching method."

Mark McArdle (BAE Systems)

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 and one-day intermediate Excel courses).  Note that the course uses Excel 2016, although if you're using Excel 2013, 2010 or even 2007 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

Excel Modelling

2 day course

Excel VBA macros RECOMMENDED

VBA macros in Excel

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, Excel VBA or PowerPivot exercises

Excel videos

Excel videos

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

View Excel tips, Excel VBA - Basics, Microsoft Excel, PowerPivot or Excel VBA - pivot tables/charts 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 Test your current Excel skills or Test your VBA knowledge 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