| 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
Schedule

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

Course Name Date Location Duration Price Book Online
Microsoft Excel 2010 Advanced 13/04/2017 London
1 day £499 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Manchester
1 day £499 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Birmingham
1 day £499 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Cardiff
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Southampton
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Nottingham
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Belfast
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Reading
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Newcastle
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Milton Keynes
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Glasgow
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Bristol
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Leeds
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Dublin
1 day €995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Liverpool
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Aberdeen
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Norwich
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Cambridge
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Edinburgh
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 28/04/2017 Sheffield
1 day £995 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

best-price      customer-charter

Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews

29. Mar

APM Course Luton - Trainer Tim O'Connor

I recently attended APM Course with The Knowledge Academy and the course was delivered in Luton. I wanted to develop my understanding and knowledge of Project Management concepts and the appropriate Project Management methodologies and processes. It was great to attend the course as this enabled me to build on my practical work experiences. The training was conducted by Tim O'Connor , he was an excellent trainer and provided an enjoyable experience and welcome environment for learning. The course was delivered in a good location in Luton and course timing was great. We covered the course material , had time to go through questions and scenarios and reviewed any areas where I needed extra help. I am now more confident and have developed a stronger foundation in Project Management. Thanks to Tim for his professionalism and great teaching, I am most appreciative and glad that I attended the course and can now apply what I learned in my job. Thank you!

Read more >>

29. Mar

APM and APMP Course - Luton - Booking Process, Pre-Course Information ( Knowledge Academy Advisor - Simon Child)

Great customer service from Knowledge Academy team in particular Simon Child. I have an extremely busy schedule and needed the flexibility and options when I could attend the courses. Simon was very helpful and patient, provided the pre-course information I required and answered all my questions. Planning to come back to Knowledge Academy for another course. Thanks!

Read more >>

 Contact Us  More Courses

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