(0) | 0115 958 6699
Request a Quote

Microsoft Excel Intermediate Course – Classroom

Build on from the basics of Microsoft Excel by creating advanced workbooks and worksheets to organise, analyse and filter data using formulas, tables and slicers.

Section background Microsoft Excel Intermediate Course – Classroom
100% Money Back Guarantee
Free Assessment
Post Course Support
Share This

Course Overview

This course builds upon the foundational knowledge presented in the Microsoft Excel Introduction course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence. The ability to analyse massive amounts of data, extract actionable information from it, and present that information to decision makers can create a powerful competitive advantage.

You will learn how to create advanced formulas and organise your data into tables. You’ll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.

This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.

Price

£198 + VAT

Duration

1 Day

Training Options

Classroom

Course Content Objectives Delivery Method What’s Included Who is it for? Prerequisite Certification

Microsoft Excel Intermediate Course Content:

Lesson 1: Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialised Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions

Lesson 2: Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data

Lesson 3: Analysing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualising Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Analyse PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers

Upon successful completion of this course, students will be able to:

  • Work with functions
  • Work with lists
  • Analyse data
  • Visualise data with charts
  • Use PivotTables and PivotCharts

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

  • Professional Microsoft Certified Trainer
  • CPD Accredited Classroom training in Small Groups for Max Focus
  • Only Microsoft Approved Courseware and Exercise Files are used
  • Free Assessment of Skills prior to booking
  • Certificate of Completion & Complementary 12 Months Post Course Support
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £89 per person

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Before taking this course, students are recommended to take the following course, or have equivalent knowledge:

This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.

The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Choose Your Date & Location

Start Date
Location
Session Times
Duration
Price (Excl Tax)
26/09/2024
Liverpool
09:00 - 17:00
1 day
£198
26/09/2024
Manchester
09:00 - 17:00
1 day
£198
03/10/2024
Bristol
09:00 - 17:00
1 day
£198
03/10/2024
Leeds
09:00 - 17:00
1 day
£198
07/11/2024
Birmingham
09:00 - 17:00
1 day
£198
07/11/2024
Nottingham
09:00 - 17:00
1 day
£198
19/12/2024
Liverpool
09:00 - 17:00
1 day
£198
19/12/2024
Manchester
09:00 - 17:00
1 day
£198
30/01/2025
Liverpool
09:00 - 17:00
1 day
£198
30/01/2025
Manchester
09:00 - 17:00
1 day
£198
06/02/2025
London
09:00 - 17:00
1 day
£198
20/02/2025
Bristol
09:00 - 17:00
1 day
£198
20/02/2025
Leeds
09:00 - 17:00
1 day
£198
27/02/2025
Birmingham
09:00 - 17:00
1 day
£198
27/02/2025
Nottingham
09:00 - 17:00
1 day
£198
Please contact us for information
Leicester
There is no public schedule for this course
1 Day
£198

Related Courses

Microsoft Excel Intermediate Course – Classroom

Microsoft Excel Advanced Course - Classroom
Microsoft Excel Intermediate Course – Classroom

Microsoft Excel Advanced Course - Virtual
Microsoft Excel Intermediate Course – Classroom

Microsoft Excel Intermediate Course - Virtual
Microsoft Excel Intermediate Course – Classroom

Microsoft Excel Introduction Course - Classroom
Microsoft Excel Intermediate Course – Classroom

Microsoft Excel Introduction Course - Virtual

Testimonials

quote image
quote image
I completed the Advanced Excel course and found it so good that I returned to complete the VBA course. By chance both courses happened to be on a 1-1 basis and my tutor Huseyn tailored the course to my needs. The course was very hands on as most of the course involved using the info learned in class and applying it to data supplied by Infero. The workbooks provided were clearly illustrated and had a step by step guide to complete each process.

Gerard Cahill Commercial Accountant from Capital One

quote image
quote image
I found the Excel Bespoke Course at Infero to be excellent and exactly the training that I required so that I can implement these skills in my job. I feel the main thing that has directly impacted me so far is the efficiency in conducting analysis and reports. What used to take me hours to do is now taking minutes. This is directly down to the effective manner taught to me by Huseyn in which he related the theory very well with the practice so that it became easier for me to apply in my work life. Examples of what I have learnt from the course coming into practice are advanced formulas, sorting and filtering tables, modifying charts, and I believe macros will play a vital role in the near future too.

Khalid Tai Ecotricity (Stroud)

quote image
quote image
Large Creative had been using Excel for years without realising its full potential. Suada’s relaxed style made the training modules both pleasurable and easy to follow. The training we received on Excel at Infero has proved invaluable to my company.

Steve Large Director from Large Creative

quote image
quote image
I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan Payroll Manager from Decathlon UK

quote image
quote image
I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare I say it, enjoyable. I would highly recommend.

Michael Sexton

quote image
quote image
The course was excellent. Learnt Pivot Tables & Applying Conditional Logic

John Clarke

quote image
quote image
I have just recently changed jobs and thought it was about time I got my excel skills up to speed. Although I have been using Excel for a number of years I found that attending the intermediate course very useful. It has given me a better understanding of Excel and now I am more confident in using it. Samer was a great tutor and made what could have been a boring day a little more interesting.

Sarah Harvey Assistant Accountant from QD Commercial Group Holdings

quote image
quote image
The day after taking the Excel Intermediate Course, I created two pivot tables and used several advanced formulas to do, in ten minutes, tasks that would previously have taken me hours. The teaching at Infero is easy to follow, the lessons are brilliantly delivered and the instructors are experts in their field, extremely friendly and endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortless as possible. The ‘aftercare’ element - a tutor will usually answer your queries within hours - is particularly valuable. A great lunch, too.

Harry Frost Marketing Assistant from Babcock International Group

quote image
quote image
The Formulas were most helpful for me as I’ve never wrote on before and we use them every day in my job. I honestly think no improvements are needed. It ran incredibly smoothly, Martin was very patient with us all and answered any questions wonderfully.

Emily North

quote image
quote image
How we started from the very basics. There were no presumptions that we knew anything which helped me pick up things I never would have known if I hadn’t been shown. Martin’s delivery was brilliant. Excel training has the potential to be very boring and I expected it to be but Martin kept it interesting and kept us involved in the session. I have taken quite a lot away from the training which will come into good use.

Sam Fletcher

Take Yourself Further With Infero

Free Assessment or Consultancy
Training Option
12 month support
100% Money back guarantee
High feedback rate
Interactive & Hands on

Top Microsoft Excel FAQs

What is the schedule for the training course?
  • Start: 9:00am
  • Break: 11:00am
  • Lunch: 1:00pm
  • Break: 3:00pm
  • Finish: 5:00pm
The schedule for 1, 2 and 3 days training will be the same but course content will vary. Times can be changed for group and onsite to start earlier, you can ask before booking.
Can we have a course in our own workplace?
If you are interested in having a training course at your own workplace, whether it be through one-to-one sessions or group training, we offer Onsite Bespoke courses.
How is the course structured?
The course is structured to blend instructor-led tuition with hands-on exercises, reinforcing learning through practical activities. This interactive approach ensures you learn both theory and application effectively. Each module begins with a theoretical foundation followed by immediate practice to solidify your understanding. Our instructor guides you through the material, addresses any questions you have, and supervises your practical work throughout the course.
Do I need any equipment for training?
For Classroom training courses you usually don’t need any equipment, unless we specifically advise otherwise. For Live Virtual training courses you will need a computer, or laptop with full version of the software you are training in. We also strongly recommend having access to a second screen for the training course such as a tablet or phone. This will allow you to do the exercises on your primary device and see the virtual whiteboard on a secondary device.
How do I know which level is right for me?
If you are unsure about which training course level suits you best, we recommend you give us a call and one of our telephone experts or trainers will be able to advise you.
How experienced are your tutors?
Our company prides itself on the quality of our training courses, which is not possible without our exceptional trainers! Our tutors have both practical and teaching experience, and specialist knowledge. We are happy to provide references and their profiles upon request.
Is there ongoing support after completing the course?
Absolutely! Following the training course, we provide a variety of post-course support documents so you can revisit the content at your own pace, along with offering 12 months of support via email.
Will I receive a certificate upon completion?
Yes, all of our training courses come with a certificate of completion. Once you finish the course, we will email your certificate to you within 2-3 working days.

Looking to book some training for your team?

Request a Quote