Advanced Excel (classroom or online)

Wise Owl

Course

In Manchester

£ 795 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Workshop

  • Level

    Advanced

  • Location

    Manchester

  • Duration

    2 Days

  • Start date

    Different dates available

If you have been using Microsoft Excel for a while now, maybe it is time to move on a bit. This two-day course shows how you can use Excel to , create , use some of the in Excel and much more besides! Why not spend two days finding out just what Excel can do? Suitable for: This Advanced Excel course is aimed primarily at businesses and public sector organisations

Important information

Documents

  • Excel Advanced course outline.pdf

Facilities

Location

Start date

Manchester (Lancashire)
See map
Barlow House, Minshull Street, M1 3DZ

Start date

Different dates availableEnrolment now open

About this course

Delegates should already have a good working knowledge of Excel.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Advanced IFs
  • Lookup functions
  • Advanced Lookup Functions
  • Text Functions
  • Multiple Worksheets
  • Advanced tables
  • Pivot tables
  • Advanced pivot tables
  • Getting data (was Power Query)
  • Excel

Teachers and trainers (2)

Jenny Brown

Jenny Brown

Microsoft Trainer

Shaun Wantling

Shaun Wantling

Trainer

Course programme

Advanced IFs
  • Revision of single IFs
  • Nesting =IF
  • =IFS and =SWITCH
Lookup functions
  • Using VLOOKUP for continuous values
  • Using VLOOKUP for exact matches
  • List data validation for exact matches
  • Dynamic range names
  • Handling errors in lookup tables
Advanced lookup functions
  • Using = MATCH to find values
  • Combining =INDEX and =MATCH
  • The OFFSET function
  • The INDIRECT function
Text functions
  • Basic text functions
  • Finding and replacing text
  • Extracting and joining text
Multiple worksheets
  • Group editing
  • Formulae across sheets
  • 3D summing across sheets
Advanced tables
  • Removing duplicates
  • Advanced filters (multiple criteria)
  • Adding and removing subtotals
  • Grouping/outlining controls
Pivot tables
  • Creating pivot tables
  • Changing the aggregation function
  • Drilling down
  • Filtering and sorting
Advanced pivot tables
  • Grouping fields
  • Showing % of grand totals, etc
  • Slicers and timelines
Getting data (was Power Query)
  • Using different data sources
  • Query steps
  • Massaging data before loading it
  • The "Column by example" transform

If time

Advanced charts
  • Combination charts
  • Regression and trendlines
  • Picture charts
  • Sparklines

If time

Scenarios
  • Creating what-if scenarios
  • The scenario manager

If time

Goal-seeking
  • Targeting a given value
  • Setting the number of iterations

Additional information

£625 + VAT for online training

See related categories

Advanced Excel (classroom or online)

£ 795 + VAT

The best Excel courses

See all

See all