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?

Detailed course content

What to expect on the day?

Further courses to consider

Book your place

Key :

Full
Limited Availability
Spaces Open

Tue 20 Feb 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 20 February
Norwich
£175+VAT
Available
Book now

Thu 15 Mar 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 15 February
Norwich
£175+VAT
Available
Book now

Tue 27 Mar 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 27 March
Norwich
£175+VAT
Available
Book now

Fri 20 Apr 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 20 April
Norwich
£175+VAT
Available
Book now

Tue 15 May 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 15 May
Norwich
£175+VAT
Available
Book now

Fri 8 Jun 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 8 June
Norwich
£175+VAT
Available
Book now

Wed 13 Jun 2018

This is a 1 day course (9.30am - 4.30pm) 
  • 13 June
King's Lynn
£175+VAT
Available
Book now
Date LocationPrice Availability
Tue 20Feb 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 20 February
Thu 15Mar 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 15 February
Tue 27Mar 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 27 March
Fri 20Apr 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 20 April
Tue 15May 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 15 May
Fri 8Jun 2018Show session datesHide session dates Norwich£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 8 June
Wed 13Jun 2018Show session datesHide session dates King's Lynn£175+VAT Spaces AvailableBook now
This is a 1 day course (9.30am - 4.30pm) 
  • 13 June

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
  • Joyce Wood

    IT Trainer & Client Support
Meet the full team

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