Training Courses

Microsoft Excel : Intermediate

  523 reviews

One Day Course

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.

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.

  • 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 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 SUMIFS & COUNTIFS
    • 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 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 19635 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 surveyed19635
  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 was really great at explaining and making the course interesting and engaging. "



"well paced, good support"



"The teaching was amazing, very clear and concise. Excellent facilities and staff and delicious food. I would recommend to anyone "



"explaining concepts clearly and thoroughly with sufficient examples to fully understand usage of software capabilities "



"Very engaging and useful examples. Kevin made it interesting - I enjoyed the training. The centre was very friendly throughout the day "



"It was excellent - one of the best training sessions i have been too"



"venue, food, cleanliness, coffee, tea, overall experience "



"Offices are lovely, the trainer was great and the food was delicious :)"



"Good facilities and easy location near several tubes. Excellent, clear instruction"



"Well Organised! great Teacher/Tutor and lovely food ;) breaks were times great! and gave enough 'take in' time. "



"explaining"



"great training and well set up sheets to work through examples"



"The quality of the course was of a very high standard. "



"Extremely informed trainers "



"Clear and concise explanation of Excel functionality"



"Getting the point across and not dwelling on points too much but enough that we all understood the topic subject."



"Training was very useful and lunch was fab, thanks very much!"



"Good all round"



"The environment was lovely and everyone was very friendly. I was pleasantly surprised :) Going to be a full on excel geek now! "



"I really enjoyed the course, great facilities & staff i would definitely recommend "



"Interactive course with lots of examples to keep us focused"



"Very knowledgable, digestible content. Wasn't overwhelmed at all."



"Very good overview of some important excel features, learned a few new helpful tricks"



"Everything, very well organised, clean, very welcoming. Would defiantly come back again for a course. Debbie was brillant and very patient. "



"Really good atmosphere. Lunch."



"Debbie is extremely knowledgeable and provided clear, concise examples"



"food, hospitality :) "



"Everything else in the course was great - especially keyboard shortcuts!"



"Trainer was really really good. Made the learning enjoyable"



"everything was great, thank you"



"knowledge of excel and the delivery of the materials, the Trainer was very approachable and easy to ask questions"



"The trainer was very helpful and approachable, so there was a very relaxed atmosphere. The practical exercises were very useful. A very enjoyable course."



"Kevin was a great trainer. Very informative, no question he couldn't answer, and a good teacher - very engaging and friendly. The site was wonderful, with a wonderful lunch, and friendly staff at welcoming and over lunch. Couldn't be more helpful. "



"covered some great points"



"Very welcoming, great lunch spread and Kevin was very knowledgeable & helpful. Will definitely recommend Media Training to our HR/People team for anybody internally looking for further training"