Training Courses

Microsoft Excel : Intermediate

  134 reviews

One Day Course

Overview

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

Weekday SOLD  OUT SOLD  OUT
Weekday SOLD  OUT SOLD  OUT
Weekday
Weekday SOLD  OUT SOLD  OUT
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
  • 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
    • VLOOKUP

    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 9642 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 surveyed9642
  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




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



"EXCELLENT TRAINER -VERY APPROACHABLE AND DIDNT MAKE YOU FEEL FOOLISH"



"The staff are super friendly and helpful and there's plenty of breaks."



"Everything has been fabulous!"



"Sandy was excellent, very helpful and explained things really clearly. "



"Knowledgeable instructors, amazing environment, amazing food"



"Excel course was very well explained, gained useful tips!"



"Extremely knowledgeable, friendly and helpful"



"Good machines and lunch."



"I liked everything. Thank you for excellent service! Will definitely come back again! "



"everything! I'm very satisfied :)"



"Great course! Very knowledgeable trainer. Thank you!"



"Detail and excellent service and trainer"



"Explanations were clear and concise. Kate and the other staff were friendly and helpful. "



"It was a very well run course, friendly staff, informative. Will highly recommend."



"Very good course preparation. Trainer was excellent."



"Everything - truly enjoyed my training today"



"keep it up. explanation and understanding method of delivery was very good time and course organisation was A1 quality."



"Friendly, approachable and very knowledgeable."



"Keeping everyone up to speed effectively- the class worked at different paces although Dallas was great at balancing all needs"



"Picking out useful tips and explaining them at a good pace."



"SERVICE OVERALL"



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