Training Courses

Microsoft Excel : Intermediate

  81 reviews

One Day Course


A continuation 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.

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 Introduction to 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

  • Introduction
    • Refresher on basic formulas and functions
    • Working with dates
    • TODAY and NOW functions
    • Using relative and absolute addressing
    • Create and use range names
    • Linking worksheets/workbooks

    Taking formulas to the next level
    • Using the IF function
    • Nesting formulas
    • Using AND and OR
    • IFS and SWITCH (2016)
    • Using the IFERROR formula

    Highlight data with formatting
    • Creating custom number formats
    • Controlling date formats
    • Conditional formatting
    • Conditional formatting rules manager
    • Clearing rules
    • Highlighting duplicate values
    • Using data bars
    • Adding Sparklines
  • Working with lists
    • Sorting and filtering
    • Using the sub total tool
    • Using outlining
    • Flash fill
    • Formatting as a table
    • Using slicers
    • Creating dynamic charts
    • Using text functions - CONCAT, UPPER, LOWER, PROPER, LEFT, RIGHT, TRIM
    • Advanced filtering
    • Quick Analysis tool

    Securing your document
    • Worksheet protection
    • Unlocking cells
    • Hidden formula
    • Workbook protection

    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 7525 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 surveyed7525
  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


"A lovely environment and culture to learn"

"Engaging, level of knowledge, food, cleanliness and good environment, excellent space, good computer facilities. Very happy."

"very hospitable"

"Everything was great. I'll definitely recommend you to our company for future training"

"friendly and approachable trainer"

"Listening to things that we wanted to learn about and going over examples of them. "

"It was very informative and a lot better than the last course i was on with a different provider."

"Going through each task and then providing numerous examples to work on, both individually and collectively. Relating the tasks back to our own particular jobs and requirements."

"Taking time to check we understand. Refreshments and general running of the training center."

"Examples, taking time to check everyone was ok, refreshment options were great"

"There was a good structure to the day and lots of topics were covered."

"The speed of the class was good. I had time to watch and also take notes. "

"In-depth detail of examples and practice. Covering a large amount of material in a short space of time. Very friendly and approachable trainer "

"Clear overview of what we would cover over the day. Good examples, relating to real life experiences we would have with excel."

"Good tutor, nice facilities and location. Amazing food!"

"instructor anticipated questions very well and was quick to help students"

"Trainers are very informative. Last time my course was less than 6 people which was better working as a smaller group."

"Having small groups. Kate was great! Always felt I could ask a question or ask her to repeat if i did not understand. "

"Training was very good and Greg was relaxed and taught well"

"Nice venue, very comprehensive and interactive course. Also great hospitality!"

"Explaining things simply and making the course easy to understand. Not letting people get left behind."

"Very good working environment which made you feel at ease and ready to learn. Well structured day to ensure you are able to absorb all of the information. Tom was extremely knowledgeable and extremely funny which made the time go even quicker. I am looking forward to using my new skills in the office"

"Examples were very detailed and knowledge of the trainer is obvious and helpful "

"The course was really engaging and the trainer very friendly and attentive, happy to answer all the questions. The lunch was delicious with a great selection. The facilities and the space itself were really good."

"going through examples in detail, small class is better, good teacher!""

"From the staff who greeted me at the front door to the trainers, everyone who works here is very friendly. I also like the physical environment you've created here - it's certainly conducive to positive working space. "

"really good examples, lots of time to understand and ask questions. good to have the time at the end to work on your own spreadsheet which is relevant to you and to ask how to do other things. Food was EXCELLENT! And the staff are lovely."

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

"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."

"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."