Excel Advanced Level 2

Prices from £245

Course duration 1 day

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.

CALL NOW

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

Book your place

Key :

Full
Limited Availability
Spaces Open

Wed 29 May 2024

This is a 1 day course (9.30am - 4.30pm)
  • 29 May
Classroom: Norwich
£245+VAT
Available
Book now

Wed 29 May 2024

This is a 1 day course (9.30am - 4.30pm)
  • 29 May
Virtual: Instructor-led
£245+VAT
Limited Availability
Book now

Fri 28 Jun 2024

This is a 1 day course (9.30am - 4.30pm)
  • 28 June
Classroom: Norwich
£245+VAT
Available
Book now

Fri 28 Jun 2024

This is a 1 day virtual course (9.30am - 4.30pm)
  • 28 June
Virtual: Instructor-led
£245+VAT
Limited Availability
Book now

Tue 23 Jul 2024

This is a 1 day course (9:30am - 4:30pm)
  • 23 July
Classroom: Norwich
£245+VAT
Available
Book now

Tue 23 Jul 2024

This is a 1 day course (9:30am - 4:30pm)
  • 23 July
Virtual: Instructor-led
£245+VAT
Limited Availability
Book now

Wed 21 Aug 2024

This is a 1 day course (9.30am - 4.30pm)
  • 21 August
Classroom: Norwich
£245+VAT
Available
Book now

Wed 21 Aug 2024

This is a 1 day virtual course (9.30am - 4.30pm)
  • 21 August
Virtual: Instructor-led
£245+VAT
Limited Availability
Book now
Date  Location Price  Availability
Wed 29May 2024Show session dates Hide session dates  Classroom: Norwich£245+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 29 May
Wed 29May 2024Show session dates Hide session dates  Virtual: Instructor-led£245+VAT Limited AvailabilityBook now
This is a 1 day course (9.30am - 4.30pm)
  • 29 May
Fri 28Jun 2024Show session dates Hide session dates  Classroom: Norwich£245+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 28 June
Fri 28Jun 2024Show session dates Hide session dates  Virtual: Instructor-led£245+VAT Limited AvailabilityBook now
This is a 1 day virtual course (9.30am - 4.30pm)
  • 28 June
Tue 23Jul 2024Show session dates Hide session dates  Classroom: Norwich£245+VAT Spaces AvailableBook now
This is a 1 day course (9:30am - 4:30pm)
  • 23 July
Tue 23Jul 2024Show session dates Hide session dates  Virtual: Instructor-led£245+VAT Limited AvailabilityBook now
This is a 1 day course (9:30am - 4:30pm)
  • 23 July
Wed 21Aug 2024Show session dates Hide session dates  Classroom: Norwich£245+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm)
  • 21 August
Wed 21Aug 2024Show session dates Hide session dates  Virtual: Instructor-led£245+VAT Limited AvailabilityBook now
This is a 1 day virtual course (9.30am - 4.30pm)
  • 21 August

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

Next Level

Visual Basic for Excel

Read more
Read all Testimonials

Enquiry

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

*All fields are required

Get in touch

Telephone
+441603 677107

Email
enquiries@jarroldtraining.co.uk