0161 226 6032 EMAIL US 0161 226 6032 EMAIL US

Intermediate Excel Course

Duration :1 DayCost: From £295
Venues :Manchester | Leeds | Liverpool | Birmingham | Online

5 star rated courses
Small Class Sizes
Practice led learning
3 month online support
Lunch & refreshments provided
Public & In-House Courses

Dates/ Booking / Enquiries Course Outline

Excellent [Beginner Excel] course. Learnt lots. Everything was explained and I wasn't rushed. Used real working examples relevant to my job. Questions were welcome. Andy was a fantastic trainer!

Jamie Foss | Westminster Building

I have found the [Beginners Excel] course very informative and useful, the trainer helped me put things into practice within my daily working in what was delivered. This on its own is saving me loads of time . I will definitely be booking onto the next course

Kevin B | Falcon Cranes

Well worth the day [Beginner Excel] course, will save valuable time for my working day. Thank you.

Dean Whitmore | Central Electrical Services

Rachel was a great teacher and was able to go through each [Advanced Excel] subject with us explaining in detail and was able to assist where needed with extra questions and help with assigned tasks to make things clear. Thank you

Nicola W | Expert Complete Property Maintenance Ltd

Rachel was brilliant and very helpful. The way the [Advanced Excel] course was delivered was very easy to understand and Rachel answered any questions with detailed explanations.

Rebecca S | Tarnwest Ltd

The team thoroughly enjoyed the [Advanced Excel] training and I have already seen them putting into practice the techniques they were taught on the day, which is fantastic! Edd is a brilliant trainer!

Natasha B | Golden Eagle Luxury Trains

Louise was very knowledgeable and was great at teaching the different topics. The support provided was really good - there were four of us in the group and the speed which we went through topics was just right. I would be keen to book on to another course which covers different topics too!

Heather G | Cheshire Police

Just wanted to say the [Advanced Excel] training was fab, Andy, the trainer was brilliant, the right pace and content with the right amount of humour!

Brett S | Dudley Metro Council

Intermediate Excel Training

Master intermediate Excel skills to handle data efficiently, create advanced formulas, and build professional spreadsheets on this 1-day, highly-rated course with practical exercises

Dates/ Booking / Enquiries Course Outline

Intermediate Excel Course Introduction

Gain the knowledge and skills to handle larger datasets, create advanced formulas and analyse data effectively on this 1 day Intermediate Excel course.

From working with named ranges and 3D calculations to using features like data validation, filters, and conditional formatting.

Along with plenty of shortcuts, tips, and techniques to improve your efficiency and create professional-looking spreadsheets.

These skills will equip you to use Excel more effectively and confidently.

This course is suitable for users of Excel 2010/2013/2016/2019 & 365 (including Excel for Mac) and includes helpful course notes for future reference.

Build Your Microsoft Excel Skills

This course is perfect for anybody who uses Excel in their day to day roles but have limited experience in creating more complex formulas or using features to customise their spreadsheets.

You will learn the features and functions, as well as the theory, that will allow you to easily build a spreadsheet that can pull the data you need and display it in a readable way.

This is also an ideal next step for those who’ve completed our beginner course and would like to gain more insight.

Intermediate Excel Course Topics

This one day course covers:

Using Filters & Sorting Data
Linking and Manipulating Workbooks
Creating Sub Totals
Data Validation
Creating Drop Down Lists
Working with Tables
Conditional Formatting
IF & Nested IF
3D Calculations

Download the full course outline

Who Is this course for?

This course is designed for people who are currently using Excel within their work and have a good understanding of the basic data manipulations and formulas and want to expand on this.

You will have prior knowledge of Excel basics and are comfortable using Excel.

This is also the next step for anyone who has attended our Beginners Excel course.

If you do not feel like you have enough knowledge of the basics of Excel take a look at our Beginners Excel Course

Intermediate Excel Course Day Details

Our 5 star rated Intermediate Excel courses are practical courses with small class sizes, a maximum of 6 delegates, which allows for plenty of time to interact with the trainer and ask any questions!

These are held as in-person classroom courses or as live, online courses (over Zoom). All courses, run from 9:30 am to 4:30 pm, with plenty of breaks.

Scheduled Intermediate Excel Courses

Our scheduled public Intermediate Excel Courses are run in Manchester, Birmingham, Leeds, Liverpool and Online.

Dates for these can be found below and information about the venues can be found on the Timing & Venue Info tab.

Private / Bespoke Intermediate Excel Training

We run private one to one and group Excel Courses at our training centres, or at a location to suit you, anywhere in the UK. These can also be held Online.

See the Private Course tab further down the page for more information.

Why Choose M Training's Intermediate Excel Training?

Run by an experienced trainer
This course is limited to 6 places so you are guaranteed personal support throughout the course
From only £250 + VAT per delegate
Convenient locations in central Manchester, Leeds, Liverpool, Birmingham and Online
Course notes and support material provided
Lunch and refreshments provided
Certificate of achievement
5 Star Rated in Google Reviews

5 star rated courses
Small Class Sizes
Practice led learning
3 month online support
Lunch & refreshments provided
Public & In-House Courses

Select from the tabs below to find out more:

Intermediate Excel Course Dates

Browse all public Intermediate Excel course dates below or use the filter to show only dates in specific locations

Online Intermediate Excel Courses

Timings: Our online Intermediate Excel public courses start at 9:30am and will finish around 4:30pm with plenty of breaks.

Timings for private courses can be arranged to suit you.

Payment: Once booked an invoice will be sent which can be paid by Credit Card, PayPal, Bank Transfer or Cheque.

PRIVATE ONLINE EXCEL TRAINING

Our Online one-to-one and private group training in Intermediate Excel are available from £550 + VAT (6 hours).

KEY BENEFITS:

Highly Interactive: You will see the trainer, their screen, and be able to chat/ask questions.

Ongoing Support: After the course, you receive the course notes, certificate, and 3 months of online support.

Click here for information about how our online Courses work

Classroom Based Courses

Timings: The Intermediate Excel course starts at 9:30am and will finish around 4:30pm with 45 mins for lunch. Timings for private courses can be arranged to suit you.

Payment: Once booked an invoice will be sent which can be paid by Credit Card, PayPal, Bank Transfer or Cheque

Lunch & Refreshments: A great lunch and plenty of tea/coffee & biscuits are provided on all Intermediate Excel public courses.

PRIVATE CLASSROOM COURSES

One-to-one and private group courses are available for Intermediate Excel Training from £590 + VAT (Full Day)

These courses are ideal if you cannot make one of the set course dates or if you already know the basics and want something more specific.

After the course, you receive the course notes, certificate and 3 months online support.

More Information can be found on the Private Course Enquiry Tab (above) or call us on 0161 226 6032 or contact us

Close Tab

We are happy to run private Intermediate Excel courses at your offices, at our Manchester office, or at a venue to suit you or Online

The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.

Private Intermediate Excel courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.

Private Excel Course Costs:

The cost of any private courses is dependent on the number of delegates, the location, the length of the course and the degree of adaption of the course. The following are for guidance only:

Private one to one classroom-based courses are available from £590 plus VAT

Private Group Courses in Excel are available from £690 plus VAT

Online Private Intermediate Excel Courses are available from £550 + VAT (6 hours).

To get a quote please complete the form below or call us on 0161 226 6032.

Private Intermediate Excel Training

Close Tab

Intermediate Excel Course Outline

Quick Recap of Useful Introduction Features
- Customising the Quick Access Bar
- Creating and using custom lists
- Page set up shortcuts
- Revision of basic formulas such as AutoSum, Min, Max and Average
- Behaviour of Relative cells v Absolute cells
Manipulating Workbooks
- Renaming and deleting worksheets
- Colouring worksheet tabs
- Moving and copying worksheets within the workbook & into new or existing workbooks
Excel Tables
- Benefits of Excel Tables
- Converting an Excel range (data) into an Excel table
- Adding and using a Slicer
- Finding & removing Duplicates
- Using automatic Freeze Panes
- Converting back to Excel range
Sorting and Filtering
- Applying a Filter to your data
- Sorting a filtered list
Subtotals
- Creating outer sub totals
- Producing inner sub totals
- Using the Outlining feature
Data Validation
- Adding validation rules to cells to limit data input
- Using data validation to create drop-down lists
- Managing invalid data
- Remove data validation
Linked drop-down lists
- Use the Indirect function to create linked drop-down menus
Linking Workbooks
- Create external links between books
- Edit links
- Break links
IF and Nested IF Function
- Creating and performing calculation using a single level IF function
- Creating calculations using Nested IF function
- Creating calculations using IFS function
Conditional Functions
- Use COUNTIF, AVERAGEIF and SUMIF
- Use COUNTISF, AVERAGEIFS and SUMIFS
3D Calculations
- Grouping worksheets
- Using 3D Calculations
Conditional Formatting
- Creating a conditional formatting rule
- Editing the rule
- Using Icon sets to format reports
- Amend criteria in Icon sets

Close Tab

Manchester Intermediate Excel Courses

Our Manchester Venue:

All our Intermediate Excel Manchester courses run from 9.30 am to 4.30 pm at our head office:

Manchester Science Park
Pencroft Way
Manchester
M15 6SZ

Public Transport/Parking:

The closest public park is Manchester Science Park Visitor Car Park or Cecil Street Car Park - 5 min walk

Manchester Oxford Road Train Station - 15 min walk

Manchester Piccadilly Train Station - 30 min walk

Access

Please let us know in advance if you have any mobility issues and will need any assistance. Disabled parking is provided.

More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

Leeds Intermediate Excel Courses

Our Leeds Venue:

Our public Intermediate Excel Courses in Leeds start at 9.30 am and finish at 4:30 pm.

The courses are usually held at:

West Village,
Wellington Street,
Leeds,
LS1 4LT

(venue subject to change)

Public Transport /Parking:

There are a few public car parks close to the venue, the nearest is Wellington Street Multi-Story Car Park.

The venue is also only a 15 minute walk from Leeds Train Station.

More Information about our Leeds training courses, along with a map, can be found on our Leeds Training page

Birmingham Intermediate Excel Courses

Our Birmingham Venue:

Our public Intermediate Excel courses in Birmingham are usually ran 9.30am to 4.30pm at:

Innovation Birmingham Campus,
Faraday Wharf,
Holt Street,
Birmingham,
B7 4BB

Public Transport /Parking:

Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability.

Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.

More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page

Intermediate Excel Course in Liverpool

Our Liverpool Venue:

Our public Liverpool Intermediate Excel Courses are usually ran at 9.30am to 4.30pm at:

The Plaza
Liverpool,
L3 9QJ

(venue subject to change)

Public Transport/Parking:

The closest public car park is St Paul's Square Car Park which is around 1 minute walk from The Plaza.

The venue is a 20 minute walk from Liverpool Lime Street Station, however the closest station is Moorfields which is a 10 minute walk.

More Information about our Liverpool training courses, along with a map, can be found on our Liverpool Training page

Online Intermediate Excel Courses

The Online Intermediate Excel courses are run on Zoom.

You will be sent a link to join the training session the day before the course along with any course materials needed.

The courses run from 9:30 am to 4/4:30 pm.

Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:

9.20 am | Sign in
9.30 am | Start - First session
11.00 am | 15 min break
11.15 am | Second session
12.30 pm | 30 min break
1.00 pm | Third session
2.15 pm | 15 min break
2.30 pm | Fourth session
3.50 pm | Finish & Q&A
4.30pm | End

Find out more about how our online courses work on the Online Courses Page

Close Tab

Excel Course Reviews

See more review

Close Tab

Bookings / Enquiries

Download Course Outline

Back to the top

Other Courses You May Be Interested In

Beginners Excel Training Course
This is a one day training course that gives you an introduction to using Microsoft Excel features and shortcuts. It is designed for anyone who only has a little (or no knowledge) of using Excel.
Find out more
Advanced Excel Course
This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel.
Find out more
1 Day Power BI Course: The Essentials

Find out more
Office 365 Training
Learn how to utilise the powerful features and programs of Office 365 to work more efficiently.
Find out more