Training Courses

Microsoft Excel : Intermediate

  568 reviews

One Day Course

Now Available As Online Training!

Overview

A continuation on from the introductory course, this one day course looks at more in-depth functionality and commands in Excel.

It introduces new concepts for sorting data and building conditional formulae. If you think you know Excel, this course will show you what you've been missing all these years.

Delegates will leave feeling a new confidence in their Excel expertise and ready to take on new challenges with financial data.

The public course will take place using Office 365 on PC.


You should have attended the Introduction to 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

  • Introduction Refresher on basic formulas & functions
    • Statistical functions (Average, Max, Min, Count and Counta)
    • Using relative & absolute addressing
    • Creating, using and editing range names
    • Locking cells and worksheets

    Working with Worksheets
    • Deleting, moving & copying worksheets
    • Grouping worksheets
    • Setting Tab colour
    • Performing calculations across sheets

    Taking formulas to the next level
    • Using SUMIFS & COUNTIFS
    • The basic IF function
    • Simple VLOOKUP
    • Date functions

    Questions & answers
  • Highlight data with formatting
    • Apply Conditional Formatting Rules
    • Use the Conditional formatting rules manager
    • Create Conditional formatting using a formula
    • Clearing rules

    Quick Analysis
    • Create charts and Sparklines
    • Creating a Combination chart
    • Totals

    Totals Working with Lists
    • Freezing panes
    • Sorting & filtering
    • Advanced filtering
    • Using the subtotal tool
    • Formatting as a table
    • FlashFill

    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




"Being encouraging and providing support"



"Very professional"



"Everything :) Keep up the good work, likely to return and recommend"



"Great place/staff etc. very welcoming."



"overall an amazing experience"



"Great knowledge and useful exercises and tips"



"Lynne was very clear and considered in her approach. Thank you."



"Really organised, very well explained, generally a good pace and good examples. "



"Explaining how to do each section in termonology and breaking it down to how each of us could use it in our jobs."



"Trainer was excellent and very helpful and support from booking helpful to."



"Found it useful there only being a small amount of delegates on the call so we could get assistance from Lisa without delaying the course. Was great receiving tips and shortcut keys these would be good as a handout crib sheet"



"good course"



"Very knowledgeable, friendly and efficient trainer with well thought out schedule and exercises."



"Kevin was brilliant, and catered the course to our needs perfectly! He is very easy to talk to and ask questions, and i found him to be one of the best trainers i've trained under for years because of his personality. The content was exactly what i needed so i'm very happy i attended the course and i have plenty of ideas for how i'm going to implement what i've learnt! Thanks"



"detailed in tasks and exercises that were provided prior to online training "



"explaining things clearly, not patronising, very patient, lovely office, nice people"



"Really great refreshments and clean environment "



"Good food, service, and course"



"The course was really helpful, while I was already familiar and comfortable with some elements of the course, there was still a lot of helpful hints and shortcuts that made tasks easier. Everyone at the centre was very welcoming and helpful and it was definitely a rewarding course. "



"Excellent knowledge"



"Really useful and informative, great tutor and working environment. Thank you :)"



"Kevin was very knowledgeable and helpful, and I was made to feel very welcome. Learnt a lot of excel!"



"Well organised. Great facilities"



"Everything!"



"Friendly, welcoming and engaging trainer. Food was excellent and general environment good"



"Excellent course, kevin was very clear and explained well. I loved this course"



"Perfect course and covered all aspects I would expect at an Intermediate level. "



"Course was just the right level - started from basics to ensure everyone was up to speed and no questions felt stupid!"



"REALLY WELL RUN AND FEEL LIKE HAVE TAKEN AWAY A HUGE AMOUNT OF NEW KNOWLEDGE! THANK YOU"



"Overall very good course."



"Applying knowledge to specific peoples roles so we could see how to implement the knowledge we were learning into our own day to day activities. Making sure that everyone knew and understood everything which was being done before moving onto the next point. The pace of the day was well spread out and everything was explained very clearly. "



"Everything! Very helpful and clear course, went at the right pace and it was really helpful that Kate encouraged us to write down how we would use each lesson in our jobs so we wouldn't forget. The food, drinks and snacks on offer were really nice and the whole space was really pleasant to be in. I want to come back and try all of the other courses on offer!"



"This was an excellent course. The trainer is very knowledgable, patient and really explained things clearly. I feel more confident now. Thank you!"



"Friendly, explain well, helpful "



"Very easy to follow the training!"