Training Courses

Microsoft Excel : Advanced

  39 reviews

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.

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

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

  • Expanding your functions toolbox
    • Using SUMIF and COUNTIF
    • Using SUMIFS and COUNTIFS
    • Using Database functions – DSUM and DCOUNT
    • Using CONVERT (2016 only)
    • VLOOKUP and HLOOKUP
    • VLOOKUP and MATCH
    • INDEX and MATCH

    Reducing your audit risk
    • Using Trace Precedents
    • Using Trace Dependents
    • Removing Arrows
    • Using the error checking function
    • Evaluate Formula
    • Watch Window

    Effectively analyising 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
    • Analysing data using Pivot Charts

  • Enhance your workflow
    • Understanding Macros
    • Setting Macro security
    • Recording Macros
    • Editing your Macro
    • Understanding the VBA edit window
    • Adding a message box using VBA
    • Assigning a Macro to the ribbon and your toolbar
    • Running a Macro from the ribbon and your toolbar
    • Customising your Macro toolbar
    • Understanding Macro buttons
    • Macro keyboard shortcuts
    • Saving and using a Macro enabled Workbook
    • Deleting your Macro

    Q&A - delegates are encouraged to ask questions where time permits.
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 7446 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 surveyed7446
  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




"Explaining, doing examples from the workbook to cement the understanding, being engaging and friendly and helpful."



"Take time to play around with Macros and employ DSUM function and Pivot slicer!"



"Overall energy was good and really liked the classroom (aside from the temperature) and screens on both sides of the wall. Liked also that there were drinks and snacks available throughout the day as I felt the course was good value for money and look forward to coming on another course and recommending courses to my friends and colleagues. "



"Welcoming of students, Hospitality and Time effectiveness of course criteria"



"I was apprehensive when I turned up this morning, but I was greeted with music in the lobby and two very friendly people. The space itself is incredible, very bright (the weather helped I'm sure!) with lots of tables and refreshments. I spoke to the trainer just before I started the class, as I was worried I had booked onto a course that was too advanced for me. He was very re-assuring and I felt comfortable starting the session. The structure was fabulous. We started with a review of concepts and practised using them which immediately made me feel comfortable with my level of knowledge in the room. Dallas used his voice in a very engaging way, it absolutely carried the room and kept us alert. His explanations with examples and use of questioning was very educational. I really really enjoyed the training and feel much more confident with the more 'advanced' aspects of excel."



"I signed up for Excel advance and I've got the information I have wanted"



"keeping everyone on the same page and balancing the pace of the course with the knowledge of the other participants"



"The highly applicable excel functions at work, very clear instruction. "



"friendly staff, good teacher, nice location ,great food + facilities"



"Overall the course was very useful, building facilities, equipment and staff were lovely. "



"Hosting, all staff are friendly people."



"great, clean & bright facilities, amazing lunch, lovely trainer."



"student engagement and on the spot problem solving. "



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



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