Training Courses

Microsoft Excel : Advanced

  213 reviews

One Day Course

Overview

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 may choose to use either MS Office 2013 or 2016 on PC and only MS Office 2016 on Mac.

There is a maximum class size of eight delegates, which ensures quality time with the trainer and the ability to ask questions.

What are the 5 things you will get out of the course?
• Use HLOOKLUP & VLOOKUP functions to help find data in a table
• Use the formula auditing tools to help troubleshoot errors
• Summarise data using a Pivot table
• Create a pivot chart
• Record macros to automate repetitive tasks
You should have attended the Intermediate Microsoft Excel course at Media Training or have an equivalent working knowledge.

Public Course Dates & Pricing

Weekday SOLD  OUT SOLD  OUT
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
  • Public Courses

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

    A great, cost efficient way to learn, discounts are also available for group bookings.

     

    Discount Info
  • 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

    Free Consultation

Course Outline

  • Expanding your functions toolbox
    • Recap on the basic IF function
    • Recap on creating & using range names
    • Nesting formulas
    • Using AND & OR
    • IFERROR
    • VLOOKUP & HLOOKUP
    • INDEX & MATCH

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

    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

    Enhance your workflow
    • Setting Macro security
    • Recording Macros
    • Editing your Macro
    • Understanding the VBA edit window
    • Assigning & running a Macro from the ribbon
    • Saving & using a Macro-enabled Workbook
    • Deleting your Macro

    Additional topics (if there is time)
    • 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 5 working 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 17635 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 surveyed17635
  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




"very friendly and knowledgeable "



"Kevin was great and explained important concepts in a fun and easy way. Really appreciate all the help, support, and advice. Looking forward to continuing my Excel journey! "



"Brilliant session, learnt alot of new things thaat i can apply in my job. Entertaining and informative and engaging. Great day!"



"Very clear instructions, friendly manner, relevant examples. very open to questions and tailoring the course to what i needed to learn. Sheets provided to work from were very detailed and well-suited to the instructions i was being given. Staff and facility all very good and lunch was lovely."



"you always provide good food and happy staff"



"explaining V lookups and Pivot tables "



"very professional tutor"



"Trainer was very personable and knowledgeable with lots of handy tips - by far most erudite trainer had thus far"



"Everything very well explained and useful."



"engaging delivery, helpful team"



"Food, friendly trainer, knowledgable trainer"



"Providing examples relevant to our individual jobs. Giving us time to explore pivot tables A good balance between the trainer demonstrating and our own involvement "



"Very good explanations from the trainer, as well as a very organised and well structured course"



"Great environment for learning, decor & refreshments."



"Good at explaining vlookup and index/match and the data that the functions are looking for/pulling in. "



"Very kind teaching and great facilities "



"Trainer excellent and really knowledgeable"



"Trainer v knowledgeable"



"Everything was great"



"good Trainer, nice atmosphere, really enjoyed training today "



"Covered a wide range of subjects and the trainer was very knowledgeable. Presenting information was one of the main things I wanted to know and the advanced "Pivot Chart" tables helped me with this"



"Well structured and informative. Good communication and excellent class size"



"Lunch and Refreshments!"



"Kate is very patient!"



"very clear on what was being taught and well timed. good amount of breaks"



"Good group size, knowledgeable and approachable trainer. Kate was great."



"Everything!! The training environment was comfortable and light and I like the small number of candidates. Kate was really engaging and knowledgeable. I will definitely recommend her to my colleagues."



"providing course and looking after us"



"Excellent trainer"



"Really approachable - thorough - helpful - willing to help after class/lunch "



"Great examples given, very practical course. The instructor was very knowledgeable and friendly, answered all our questions without derailing the course. The lunch and refreshments were also excellent. Thank you very much."



"Fun, knowledgeable, full of good tips"



"Excellent Training "



"Friendly, Interesting, Knowledgeable , Good Examples"



"Excellent service"