Training Courses

Microsoft Excel : Advanced

One Day Course

Overview

This course is designed for those who require a greater knowledge of the more advanced features of Excel including Goal Seek, What-if scenarios and pivot tables.

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

Maximum class size on this course is eight delegates. You should have attended the Intermediate Microsoft Excel course at Media Training or have an equivalent working knowledge.

Public Course Dates & Pricing

Course DatesLocationPriceStatus


  • 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 £475 + VAT

    Free Consultation

Course Outline

  • Enhance your workflow
    • Understanding Macros
    • Setting Macro security
    • Recording Macros
    • Editing your Macro
    • Assigning a Macro to your toolbar
    • Running a Macro from your toolbar
    • Customising your Macro toolbar
    • Understanding Macro buttons
    • Macro keyboard shortcuts
    • Saving and using a Macro enabled Workbook
    • Deleting your Macro

    Lookups - a powerful way of working with big data
    • Understanding different Data LOOKUP functions
    • Using the VLOOKUP formula
    • Using the HLOOKUP formula
    • Using the VLOOKUP match
    • Finding partial matches
    • Using the CHOOSE LOOKUP function

    Building your formula toolbox
    • Using the Concatenate function
    • Using Nesting functions
    • Using Data functions
    • Using Financial functions
  • Reducing your audit risk
    • Using Trace Precedents
    • Using Trace Dependents
    • Removing Arrows
    • Using the error checking function
    • Evaluate Formula
    • Watch Window

    Forms
    • Understanding how forms work
    • Designing a User form
    • Displaying your data
    • Editing your data
    • Using a Macro to display your User form

    Other useful Excel operations
    • Creating Histograms
    • Using Sparklines to show data trends
    • Outlining data to reveal detail data
    • Using Custom views
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
Value + Choice
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 4960 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 surveyed4960
  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.7 / 10
  % Who Would Recommend Us99.7%

"the speed and relevancy of the course, making student feel comfortable and welcomed. would definitely use again "

"General organisation was good. The training centre and rooms were excellent."

"Nice space to work in, relaxed etc Intense but covered a good amount of ground in limited time, breaks came just as needed"

"My trainer was prepared and able to explain complicated things in a simple way. Always available for questions."

"Facilities. Training materials. Knowledge of trainer. "

"All course material was easy to understand and well explained by the teacher."

"Very clear instruction, Dallas was aware of the different levels of people in the class and catered well for the slower ones. Very good tutor."

"Good learning environment."

"Everything I needed for today. Dallas was fab at leading a session that I really needed to put into my daily work. "

"VERY INTERESTING DAY "

"Allowing me lots of practice examples and doing it myself activities to help re-enforce what I had learnt. I was lucky to have a 1-2-1 but in general it looked like all groups were small, which is great when trying to learn."

"listening to individual needs and working through tasks/showing things in a non-intimidating way "

"good overall course. Dan was very polite and friendly. "

"very friendly, accommodating and informative"

"Friendly staff in the whole office. Great lunch!"

"Very friendly Very well prepared lessons Simple and practical examples Incredibly knowledgeable and willing to answer specific questions "

"Hugely impressed with the whole day - pleasantly surprised by the warm and welcoming environment and atmosphere. Tom is a fantastic teacher, incredibly knowledgeable and adapts his examples and teaching to our personal circumstances. Thank you!!"

"Very friendly and well presented. Was easy to follow and learnt a lot!"

"The course leader, Karl, was really informative and a great teacher - good at finding other ways to explain if didn't immediately understand. He was patient and clear. The course answered all the questions I had before attending. "

"Excellent course structure, clear explanations"

"The whole course was well structured and enjoyable. I have taken a lot of new things away from it."

"Making me feel comfortable throughout, it's a great learning environment here and the food and refreshments were amazing. Kojo was a very good teacher and ensured the examples related to my experience using excel out of the training. "