Training Courses

Microsoft Excel : Intermediate

  385 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

Weekday SOLD  OUT SOLD  OUT
Weekday SOLD  OUT SOLD  OUT
Weekday SOLD  OUT SOLD  OUT
Weekday SOLD  OUT SOLD  OUT
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
Weekday
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 £499 + VAT per day

    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 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 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 15732 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 surveyed15732
  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




"Explaining, and giving plenty of examples and shortcuts"



"I was very happy with all aspects of the training and found it very useful."



"Very efficient and professional"



"Good at explaining how to do use"



"Lisa was a very good trainer, she was attentive and her learning style was very approachable and helpful. She was friendly and came across very knowledgeable to the group. She gave lots of shortcuts which would save me time and make my work alot quicker to complete. I will be recommending this course to my colleagues. "



"Good explanation with good examples. "



"friendly, informative"



"Tom was great fun as well as being extensively knowledgable in all that the class asked of him."



"overall all good"



"Super informative, very helpful knowledge, my second course taken here and definitely doesn't disappoint."



"Very relaxed working and learning environment"



"Not rushing over anything and making sure everyone understood before moving on"



"Clear and concise explanations, plenty of time left to do the work"



"The day was very well organised and ran very smoothly. The small number of participants in each class it great as you get one on one attention and help. "



"Excellent day course - informative and the right pace. My confidence with Excel is much better, and I've made comprehensive notes. Thank you!"



"lunch...facilities...computers..friendly and approachable"



"Love the venue and the smiling faces that greet you at the door. Also a great idea to pop you at a table with your classmates before you go in so we avoid the awkwardness of trying to find someone to talk to."



"Great course, coming from an artistic background I am now not afraid of Excel anymore! The day was quite fun, and the course was absolutely clear, I learned a lot in one day. I would definitely recommend it to a colleague or to a friend! "



"It was correctly paced and very useful. The trainer was also very approachable."



"Debbie was very engaging and the session was highly interactive, which made learning so much easier"



"Explaining everything we needed thoroughly and stopping to answer any questions we might of had."



"Ran through all of the points thoroughly and made sure i understood everything before moving onto the next part. Was very thorough and explained everything in depth. Feel as though i have a wider knowledge of excel and am more confident using it."



"Trainer was excellent at explaining each scenario, class size was great."



"It was a really clear way of understanding quite a dry subject. I learnt a lot and Tom was really approachable and engaging"



"Tom really enthusiastic and good at shortcuts!"



"Welcoming, creative environment with great food and refreshments"



"Very friendly environment and excellent trainer. "



" Kevin was brilliant, he was hugely knowledgable and I really benefitted from the size of the small class. The food was also delicious- and overall the whole process was thoroughly enjoyable. I feel much more equipped going forward working with Excel. "



"Great examples and training method, I feel I've learnt lots of new, handy Excel tips from this course. "



"knowledgeable, friendly and approachable "



"All good thanks"



"All explained clearly. Great lunch :)"



"very nice location and great trainer"



"everything, really satisfied"



"Welcome environment, approachable people, useful and relevant content"