| Available 24 Hours Monday - Friday | 01344 203999
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Microsoft Excel Training Advanced | Microsoft Excel Training Advanced Training

  • Learn how to Use & Apply Excel by your Accredited Microsoft Partner
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Enhance Your Productivity at work & Fast Track Your Career
  • Training includes Official Detailed User-Friendly Manual
  • Pre & post course Email Support is Provided
  • Flexible Dates to suit your timetable
  • Courses delivered by Highly Experienced certified Excel instructors
  • Excel Training in Luxury Nationwide Venues
  • Book Online or Call 01344 203999 to speak to an Excel advisor today

Course Dates, Locations & Prices (Top) | View Course Info

Course Name Date Location Duration Price Book Online
Microsoft Excel 2010 Advanced 23/03/2017 London
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Manchester
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 London
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Birmingham
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Cardiff
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Belfast
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Newcastle
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Bristol
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Liverpool
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Dublin
1 day €1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Reading
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Glasgow
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Cambridge
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Edinburgh
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Milton Keynes
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Reading
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Nottingham
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Southampton
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Leeds
1 day £1499 Book now Enquire
Microsoft Excel 2010 Advanced 24/03/2017 Sheffield
1 day £1499 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Who Should Attend the Course? 

Users with a good understanding of Microsoft Excel 2010 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. 

Course Outline 

Grouping & Outlining and Subtotals

• Outlining and Grouping Data  • Using the Subtotals Tool 

What-If Analysis

• Exploring Scenarios  • Goal Seek and Data Tables  • Using Solver 

PivotTables

• Getting Started with PivotTables  • Displaying Data in a PivotTable  • Formatting a PivotTable  • Using the Classic PivotTable Layout  • Slicers 

Charting Pivoted Data

• Getting Started with PivotCharts  • Using the PivotChart Tools Tabs  • Formatting a PivotChart 

Advanced Excel Tasks

• Excel and Hyperlinks  • Using Custom AutoFill Lists  • Sharing Workbooks 

Creating Lookup Functions

• Using the VLOOKUP Function  • Using the LOOKUP Function 

Introduction to Macros

• Recording and Playing Macros  • Copying and Deleting Macros  • Visual Basic and Macros

FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.

  • What is Microsoft Excel training?

    Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.

  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am

  • What level of training is best for me?

    Introduction - You can open files, save them, make changes but not a lot more. Intermediate - Fairly confident to perform formulae calculations but able to do most stuff, but not detailed programming. Advanced - Able to perform all tasks within Excel.

What's Included?
  • Highly Experienced Instructor
  • Detailed User-Friendly Manual
  • Pre/Post Course Email Support
  • Refreshments
  • Attendance Certificate
Video

We do not currently have a video for this topic

Send us your onsite requirements and we will
provide a tailor made course for you!

Happy Customers

I don't have the motivation to study after a long day's work nor did I want to spend months learning material which I need to apply in my role today, but The Knowledge Academy gave me the opportunity to learn what I needed to in a shorter space of time, and helped me pass the exam in order for me to get to where I wanted to be.
57
I received fantastic service from The Knowledge Academy before and during the training course. I would recommend this company to anyone who wanted to take part in the Excel Advanced training course
4.97
The trainer we were provided with had the ability to make the course come to life. I would like to thank him for helping me pass my exam and get to where I am today.
4.87
Course was just what I was after, thank you.
57
At first I found the content challenging, but with the help of the trainer I was soon on my way to success. Thank you.
4.97
Great course, really informative.
57
Really good course, and really good company, will be using TKA again.
57