| Available 24 Hours Monday - Friday | 01344208452
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 23/06/2017 Birmingham
1 day £499 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Manchester
1 day £499 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Dublin
1 day €995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Liverpool
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Norwich
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Cambridge
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Bristol
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Newcastle
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Nottingham
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Milton Keynes
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Reading
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Belfast
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Cardiff
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Glasgow
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Edinburgh
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Aberdeen
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Sheffield
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Leeds
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 23/06/2017 Southampton
1 day £995 Book now Enquire
Microsoft Excel 2010 Advanced 29/06/2017 London
1 day £499 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
 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
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.
Course was just what I was after, thank you.
At first I found the content challenging, but with the help of the trainer I was soon on my way to success. Thank you.
Great course, really informative.
Really good course, and really good company, will be using TKA again.