0161 226 6032 EMAIL US 0161 226 6032 EMAIL US

Advanced Excel Training Course

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

Small Class Sizes
5 star rated courses
Practice led learning
3 month online support
Lunch & refreshments provided

Dates/ Booking / Enquiries Course Outline

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

Very knowledgeable & understanding trainer. Easy to ask questions and get the right training due to the small groups. Definitely worth doing the [Advanced Excel] course.

Jordan Wood | Dawson Rodgers

I found the [advanced excel] course really informative, delivered professionally with a person touch in a relaxed atmosphere. Louise was incredibly knowledgeable and easy to follow.

Andy Harman | Rotork

I really enjoyed the [Excel} course as I am self-taught and although I knew some parts, I discovered better/quicker ways of doing them and lots of new tips too. Our trainer was very patient and helpful if any of us needed to ask questions.

Jan Hutson | Irvine Springs

We all really enjoyed the [advanced excel] course and feel like we learnt so much from the trainer. We felt he was engaging and really clear in his delivery of the course. Our other colleagues are really looking forward to attending in November.

Niâ Wŷn Roberts | Acasta Europe Limited

The [Advanced] Excel training was very useful, and it was the second time we booked it. The trainer was so flexible and thinking on his feet to our daily challenges.... and all the extra tips on those we didn’t even know we could benefit from.

Xin Gu | British Council

Advanced Excel Training Course

Learn how to use advanced features of Excel to manipulate data and create detailed, useful spreadsheets on this 1 day, 5-star rated course.

Dates/ Booking / Enquiries Course Outline

Advanced Excel Course

If you have day to day experience of using Excel and you want to develop your skills further to use Excel more efficiently and to create more complex and useful spreadsheets, this course is for you.

It will give you theoretical knowledge and practical skills that you can take away and apply to your own spreadsheets and develop your Excel skills even further with confidence.

You will also be shown shortcuts, hints and tips to help you use Excel more efficiently.

This course is suitable for users of Excel 2010/2013/2016/2019 & 365 (Also Excel for Mac).

Improve Your Excel Skills

On this 1 day, 5-star rated, practical course you will be taken through exercises to help you understand how utilising formulas, pivot tables and macros can create complex but useful spreadsheets and reports in an efficient way.

As well as manipulating data, we will also look at formatting tools for you to display your data, or create forms, that are clear and user-friendly.

After the course, you will also be provided with helpful course notes for your own reference.

Advanced Excel Course Topics

Below is a summary of the topics covered on the 1-day Advanced Excel course.

Useful Functions (Left, Right, Trim, Proper)
Creating and Using Pivot Tables
Linking Slicers & adding Timelines to Pivot Tables
Creating Pivot Charts
Error Checking
Adding a Watch Window
What-If Tools
Creating and using Lookups (Vlookup, Hlookup & Xlookup)
Creating and using Macros
Workbook Security
Creating Dynamic Array Functions
Utilising Chat GPT for Excel

For a full course outline see the Course Outline tab on the menu below - or click here to download a PDF

Who Should Attend this Advanced Excel Training?

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.

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

Advanced Excel Course Day Details

Our 5 star rated Advanced 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 Advanced Excel Courses

Our scheduled public Advanced 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 Advanced Courses

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

Small Class Sizes
5 star rated courses
Practice led learning
3 month online support
Lunch & refreshments provided

Select from the tabs below to find out more:

Advanced Excel Course Dates

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

Online Advanced Excel Courses

Timings: Our online Advanced 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 COURSES

Our Online one-to-one and private group training in Advanced 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 Advanced 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 Advanced Excel public courses.

PRIVATE CLASSROOM COURSES

One-to-one and private group courses are available for Advanced 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

Private Advanced Excel Course

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

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 Advanced 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 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 Advanced 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 Advanced Excel Course Enquiry

Close Tab

Advanced Excel Course Outline

Useful Functions
- Concatenate
- Left, Right, Trim and Proper
- Text to Columns
Analysing data using Pivot Tables
- Understanding Pivot Tables
- Using recommended pivot tables
- Editing a pivot table’s data source
- Refreshing pivot table data
- Adding calculated fields
- Creating slicers
- Linking slicers to other pivot tables
- Adding timelines (Office 2013 & above)
- Filtering
- Calculating percentages from data
- Finding and replacing blanks within a pivot table
- Producing Pivot Charts
Auditing Data
- Tracing precedents and dependents
- Error checking
- Adding a Watch Window
- Displaying Formulas
What-If Tools
- Using the Payment function (PMT)
- Applying Goal seek
- Creating multiple scenarios and producing a scenario report
- Creating a data table
LookUp Tables
- Create VLookUps
- Nesting IFNA or IFError into a VLookUp
- Produce a HLookUp
- XLookUp
- Use the Index/Match feature as an alternative to VLookUp
Macros
- Record a new macro
- Perform basic editing using VBA
- Add a macro to the quick access bar
- Run a macro from an object in a worksheet
- Save a workbook containing a macro
Workbook Security
- Add a password to a workbook
- Add security to worksheets
- Secure elements of a worksheet
- Securing formulas
- Adding security to the book
Dynamic Array Functions
- Understand Dynamic Array Functions
- Unique
- Sort and Sortby
- Filter
- Sequence
Chat GPT for Excel
- What is ChatGPT
- Formulas from a description
- Troubleshoot a broken formula
- Complex Formula
- Macro Example
- Best Practice

Close Tab

Manchester Advanced Excel Courses

Our Manchester Venue:

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

Rutherford House
Manchester Science Park
Pencroft Way
Manchester
M15 6SZ

Public Transport/Parking:

The closest public park is 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.

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

Birmingham Advanced Excel Courses

Our Birmingham Venue:

Our public Advanced 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

Online Advanced Excel Courses

The Online Advanced 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

Leeds Advanced Excel Courses

Our Leeds Venue:

Our public Advanced Excel Courses in Leeds are start at 9.30 am and finish at 4 pm.

The courses are either held at:

West One,

100 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

Advanced Excel Course in Liverpool

Our Liverpool Venue:

Our public Liverpool Advanced 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

Close Tab

Advanced 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
Project Management Course
A one day theory and practical skills course to enhance your project management skills.
Find out more
Powerpoint Training Course
Learn how to create a more impressive PowerPoint presentation using the extensive features of PowerPoint.
Find out more
Google Analytics Training
Learn how to set up Google Analytics 4, use the new interface, standard reports and create custom reports to get useful data on how user are using your website
Find out more