Training Courses

Microsoft Excel : Advanced

  263 reviews

One Day Course

Now Available As Online Training!


This course is designed for those who require a greater knowledge of the more advanced features of Excel.

This is a 'power-user' course and you will leave able to create and customise your own macros and utilise Excel's auditing tools.

Delegates attending the public scheduled course will need to use Office 365 on PC.

You should have attended the Intermediate Microsoft Excel course at Media Training or have an equivalent working knowledge.

Public Course Dates & Pricing

Public Courses

Small class sizes so you get the maximum amount of trainer time possible. You attend with delegates from other companies.

Private Courses

One to one tuition or a private group with just your colleagues. Your choice of duration, content and location. We can train at one of our centres or onsite with you wherever you are located.

We offer a free consultation service to help work out every detail and build the perfect course for you.

From £499 + VAT per day

Enquire Here

Course Outline

  • Expanding your functions toolbox
    • Nesting formulas
    • Using AND & OR

    Reducing your audit risk
    • Data validation
    • Using Trace Precedents
    • Using Trace Dependents
    • Removing Arrows
    • Error checking
    • Evaluate Formula

    Questions & answers
  • Effectively analysing your data
    • Creating Pivot Tables
    • Changing the look of your pivot
    • Grouping your data
    • Updating Pivot Tables with new data
    • Filtering your data with a Slicer
    • Linking slicers to more than one Pivot Table
    • Using a timeline
    • Creating a Pivot chart

    What If Analysis
    • Goal Seek
    • Scenarios

    Questions & answers
Experience + Flexibility

We know training inside out. We can advise you on all the options to make sure you get the best possible course.

Tell us you need to cancel more than 7 days before your course and there's no charge. Great for your peace of mind.

Our trainers bring their years of industry experience into the classroom. You'll leave confident and prepared.

The smallest class size in the industry. More one on one time with the trainer and a less intimidating group size.

Tell us which you use and it'll be booted up and waiting with the latest software when you arrive.

We provide a lovely onsite lunch so you can relax. We can cater for any dietary requirement with no fuss.

Comfort + Location
Reputation + Feedback

Our Clients

We've worked very hard over the last 20 years to grow our business through personal recommendations.

When you attend a course we ask you to tell us how it went. We use your feedback to help us improve our courses.

We publish all our customer satisfaction stats live on our site (good or bad) because we want everyone to know just how highly you rate us every day, every week and every year.

We know that choosing the best course can be difficult, maybe the thoughts of the 20861 other clients we've asked will give you the inspiration to join us too.

The most recent comments from attendees of our courses are shown below. We reckon they will give you a pretty good indication of how they think we perform.

  Client Ratings

Attendees surveyed20861
  Trainer Knowledge9.8 / 10
  Trainer Materials9.6 / 10
  Trainer Preparation9.8 / 10
  Overall Trainer Score9.7 / 10
  Centre Lunch9.6 / 10
  Centre Staff9.9 / 10
  Overall Centre Score9.7 / 10
  Overall Experience9.6 / 10
  % Who Would Recommend Us99.7%

  Recent Feedback

"going over the advanced options: vlookup, functions, pivot tables with exercises. The fact that only 2 of us attended the course was very good"

"Good examples to work with"

"Breaking things down into easy to understand chunks"

"Good interaction "

"Kevin was great at explaining things, and very patient - thanks!"

"I enjoyed the one to one , understood concepts much better. Kevin very thorough and patient."

"Very friendly, good sense of humour and good pace of work book. All staff are so friendly and welcoming, such a professional environment, definitely coming back "

"the teacher was patient to listen and explain clearly want we ask as questions"

"The instructor was very engaging, patient, and helpful. I'm confident that I can use what I learned from today. Good lunch and other staff were friendly and helpful as well. "

"Tom was very detailed and help me understand how i could implement my skills to day to day job"

"Content, teaching the content at a great pace, the facilities, the food."

"Professional, excellent trainer. "

"Keith was really knowledgeable and enthusiastic and friendly throughout. The facilities (lunch, tables, coffees etc) were excellent and I can't wait to come back. I have already recommended it (and the intermediate course) to everyone I've talked to about it!"

"Kevin was incredibly knowledgeable and approachable, and the content was interesting and varied. The facilities were fantastic - good equipment, great food and refreshments and friendly staff. By far the best Excel course I've been on. "

"The excel training was really good, learned the fundamentals of excel formulas and macros."

"The food was superb, and the course trainer was very professional and covered a huge swathe of content. "

"Very useful, good pace"

"10/10 !"

"Course taught at really good pace, easily explained when we had problems "

"Interactive with lots of good examples"

"Very clear, applicable and easy to understand. Well-paced with lots of opportunity to ask questions, yet we still managed to get through all the content and not feel rushed."

"Nice environment and knowledgeable trainer"

"Overall, extremely happy with everything. Very informative, helpful, resourceful and I can go away and teach the others in my team :) Five Stars!"

"the pastries! super helpful trainer - nice environment"

"I think the course was pitched just right."

"classroom size is great"

"Course, facilities and food was all wonderful. "

"Very good step by step course to follow"

"Really great provider would definitely recommend coming here for any training. Trainer was really interested in the topics she was teaching and lunch was really good!"

"Thorough training from a knowledgeable and enthusiastic trainer. Highly recommend. "

"Kevin is amazing!! I am leaving feeling much more confident in my excel skills!!"

"Good overview of topics"

"great trainer - perfect pace for an 'advanced' course."

"Listening and understanding any issues we had."

"Great trainer "