Training Courses

Microsoft Excel : Intermediate

  191 reviews

One Day Course


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.

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

What are the 5 things you will get out of the course?
• Move around a spreadsheet using range names & use them to make formulas easier to read
• Create calculations based on a condition
• Summarise data quickly using Subtotals
• Use conditional formatting to show important data
• Use the quick analysis tools to present data more visually

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.

    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

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

    Working with Worksheets
    • Deleting, moving & copying worksheets
    • Grouping worksheets
    • Performing calculations across sheets
    • Performing calculation across workbooks

    Taking formulas to the next level
    • Using SUMIF & COUNTIF
    • Using Database functions – DSUM & DCOUNT
    • The basic IF function

    Questions & answers
  • Highlight data with formatting
    • Quick Analysis Tools
    • Conditional formatting rules manager
    • Conditional formatting using a formula
    • Clearing rules
    • Highlighting duplicate values

    Working with lists
    • Freezing panes
    • Sorting & filtering
    • Advanced filtering
    • Using the subtotal tool
    • Formatting as a table
    • Creating dynamic charts
    • FlashFill

    Additional topics (if there is time)
    • Using text functions
    • Date & Time functions

    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 10793 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 surveyed10793
  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

"Lisa is great!!!!!!!!!!"

"Good pace, good examples and practical exercises, managed attendees of different levels well, giving additional tasks to people who left early. Thanks very much."

"Really nice facilities and personable, knowledgeable trainers "


"It was excellent, exactly the right level. I almost like Excel now"

"Good at explaining and pace"

"Everything was very good! Thank you! "

"Clear lessons. Learned many new things. "

"I was very impressed overall! Compared to other training centres I have been to it was very modern, clean and bright. I was expecting soggy sandwiches for lunch so was very pleased with what was on offer."

"As far as I can tell, everything that I wanted covered was covered and I feel far more comfortable in my Excel ability."

"Love the creative, clean & cool environment. "

"Really great course, lovely workspace and great trainer. "

"Really good at explaining and waiting for people to get it."

"Good environment, great knowledgeable trainer"

"Lovely food. Excellent standard of training & taught at a really good pace"

"The course was good overall and provided a lot of information that was relevant. Friendly team in general. "

"using what we learnt straight away is very useful "

"Trainer expertise and refreshments. Suitable for everyone in attendance. I will definitely recommend this venue for training in the future."

"Really effective training. I took a lot in and am excited to apply these to my day at work. It was good how the trainer asked if what we had learned can be applied to our jobs and the tasks required after each thing."

"very structured course"

"Teaching in small classes"

"Overall great"

"Everything. Excellent"

"Providing subtle individual support. Good support. Good tips and tricks, Lots of shortcuts. Will help me work efficiently!"

"I had a really good feeling about the course from the second I walked in, everything looked really new and everyone was really welcoming :) Lisa was really knowledgeable and came and helped me personally with a small part I had issues with on my letter I sent previously. Thanks"

"Instructor was very clear and helpful, will definitely recommend to others!"

"Welcoming, food, enviroment, trainer and examples"

"Fantastic tutor. Engaging and patient. Genuinely felt like I learnt a lot. Will be signing up for advanced course"

"Everything venue, teaching and food were all brilliant "

"Everything was well organised, the food was superb and Kate is an excellent trainer."

"Really comfortable throughout the course, felt at ease and was able to take things in in my own time, really informative and will help loads once back at work!"

"Friendly environment, peaceful and clean. Engaging and informative. Relatable to the trainer and interested in making the course suitable for our requirements"

"Nice small groups, and very interactive. Kate was very knowledgeable and approachable :)"

"Breaks are important to stay refreshed and continue learning, this I find every time helps me stay concentrated and absorb the course. Trainers are always very helpful and knowledgable. "

"fantastic knowledge of information, great examples given of daily tasks"