Excel Advanced Level 2

Course overview

This course is all about data analysis. You'll start with some What If analysis to remove guess work and time consuming edits for scenarios before using Custom Views to efficiently switch between different aspects of the spreadsheet.

Excel is the place to analyse lists of information. We'll show you how to extract information from text, summarise numeric data and use lookups to combine information in different tables. Auto Filter is good, but Advanced Filter is better, and you'll be able to filter with complex criteria similar to that used for databases queries.

With complex data we need the charts to match. We show you trend lines and multiple value axis charts, all saved as a template for quick future use.

Is this course right for you?

What will I learn?

Course duration and private study

Detailed course content

What to expect on the day?

Further courses to consider

Course profile PDF

Book your place

Key :

Full
Limited Availability
Spaces Open

Fri 17 Sep 2021

This is a 1 day course (9.30am - 4.30pm)
  • 17 September
Classroom: Norwich
£195+VAT
Limited Availability
Book now

Fri 17 Sep 2021

This is a 1 day course (9.30am - 4.30pm)
  • 17 September
Virtual Training
£195+VAT
Limited Availability
Book now

Fri 15 Oct 2021

This is a 1 day course (9.30am - 4.30pm)
  • 15 October
Classroom: Norwich
£195+VAT
Available
Book now

Fri 15 Oct 2021

This is a 1 day course (9.30am - 4.30pm)
  • 15 October
Virtual Training
£195+VAT
Full
Book now

Tue 16 Nov 2021

This is a 1 day course (9.30am - 4.30pm)
  • 16 November
Classroom: Norwich
£195+VAT
Available
Book now

Tue 16 Nov 2021

This is a 1 day course (9.30am - 4.30pm)
  • 16 November
Virtual Training
£195+VAT
Full
Book now

Fri 17 Dec 2021

This is a 1 day course (9.30am - 4.30pm)
  • 17 December
Classroom: Norwich
£195+VAT
Available
Book now

Fri 17 Dec 2021

This is a 1 day course (9.30am - 4.30pm)
  • 17 December
Virtual Training
£195+VAT
Limited Availability
Book now
Date  Location Price  Availability
Fri 17Sep 2021Show session datesHide session dates Classroom: Norwich£195+VAT Limited AvailabilityBook now
This is a 1 day course (9.30am - 4.30pm)
  • 17 September
Fri 17Sep 2021Show session datesHide session dates Virtual Training£195+VAT Limited AvailabilityBook now
This is a 1 day course (9.30am - 4.30pm)
  • 17 September
Fri 15Oct 2021Show session datesHide session dates Classroom: Norwich£195+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 15 October
Fri 15Oct 2021Show session datesHide session dates Virtual Training£195+VAT FullBook now
This is a 1 day course (9.30am - 4.30pm)
  • 15 October
Tue 16Nov 2021Show session datesHide session dates Classroom: Norwich£195+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 16 November
Tue 16Nov 2021Show session datesHide session dates Virtual Training£195+VAT FullBook now
This is a 1 day course (9.30am - 4.30pm)
  • 16 November
Fri 17Dec 2021Show session datesHide session dates Classroom: Norwich£195+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 17 December
Fri 17Dec 2021Show session datesHide session dates Virtual Training£195+VAT Limited AvailabilityBook now
This is a 1 day course (9.30am - 4.30pm)
  • 17 December

For more information about multi-booking discounts click here or please call 01603 677107

Read all Testimonials

Training and support

  • Charlie Abramson

    IT Trainer & Technical Support
Meet the full team

Next Level

Visual Basic for Excel

Read more

For help and advice choosing the right course for you,
call us on 01603 677107 or email enquiries@jarroldtraining.co.uk

Enquiry form

*All fields are required

Get in touch

Telephone
01603 677107

Email
enquiries@jarroldtraining.co.uk