Training Course

Excel Level 3

PDF
1 Day

Course Overview

This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

Course Prerequisites

    • Before attending this course, we recommend that you have attended our Microsoft Excel Level 1 and 2 courses or have equivalent knowledge.

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support

Course Content

  • Using Absolute and Mixed Referencing

    Difference between Relative and Absolute References
    Absolute Reference and Dollar Signs
    Why use Absolute References
    Applying an Absolute Reference in a formula
    Mixed References

  • Tables

    Creating Tables
    Advantages of using tables
    Adding data to tables
    Table Options
    Slicers

  • Naming Cells (Ranges)

    Giving text to cells and ranges of cells
    Create Names from Selection
    Create Names using the Name Box
    Names in formulas
    Name Manager

  • Complex Functions

    Using Complex Functions
    IF Function
    Nested Ifs
    SUMIF function
    COUNTIF function
    COUNTBLANK function
    Wildcards in functions

  • Lookup Functions

    Understanding Lookup Functions
    VLOOKUP
    Approximate and Exact Matches
    Fixing Common Lookup problems
    HLOOKUP

  • Data Validation

    Specifying Validation Criteria
    Controlling entry into a cell
    Types of Validation Criteria
    Creating a Drop-down List

  • Security

    Protecting a worksheet and a workbook

  • Pivot Tables

    Creating a pivot table
    Fields to create row headings
    Fields to create column headings
    Data in the summary area
    Dynamically building a pivot table
    Rearranging fields in a pivot table
    Number formatting of the data area
    Moving pivot tables from one sheet to another or around the same sheet
    Deleting a pivot table

  • Summarising Pivot Table Data

    Managing subtotals and grand totals
    Changing the data field calculation (Sum, Count, Average etc.)
    Sort and Filter
    Drilling down to the raw data
    Building and using Report Pages

  • Grouping Pivot Data

    Grouping Date Fields
    Including Years when Grouping by Months
    Grouping Date Fields by Week
    Multi Grouping

  • Pivot Charts

    Building Pivot Charts
    Editing Pivot Chart Layouts
    Editing Pivot Chart Styles
    Using the built in chart filter buttons for presentation

  • Macros

    Recording a Macro
    Absolute References and Relative References
    Run a Macro
    Delete a Macro
    Assign a Macro to a Button
    Viewing the Code behind a Macro
    Macro Security

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
10 Jul 2025
in Durham
£295
29 Jul 2025
Virtual Course
£245
12 Aug 2025
in Durham
£295
13 Aug 2025
Virtual Course
£245
04 Sep 2025
Virtual Course
£245
22 Sep 2025
in Newcastle
£375
07 Oct 2025
Virtual Course
£245
16 Oct 2025
in Durham
£295
07 Nov 2025
Virtual Course
£245
11 Nov 2025
in Durham
£295
12 Dec 2025
in Newcastle
£375
12 Dec 2025
Virtual Course
£245
18 Dec 2025
in Durham
£295

Private Training

Flexible dates, location and content. All prices exclude VAT.

  • Public Scheduled Courses

    Prices per delegate. All prices exclude VAT.
    10 Jul 2025
    in Durham
    £295
    29 Jul 2025
    Virtual Course
    £245
    12 Aug 2025
    in Durham
    £295
    13 Aug 2025
    Virtual Course
    £245
    04 Sep 2025
    Virtual Course
    £245
    22 Sep 2025
    in Newcastle
    £375
    07 Oct 2025
    Virtual Course
    £245
    16 Oct 2025
    in Durham
    £295
    07 Nov 2025
    Virtual Course
    £245
    11 Nov 2025
    in Durham
    £295
    12 Dec 2025
    in Newcastle
    £375
    12 Dec 2025
    Virtual Course
    £245
    18 Dec 2025
    in Durham
    £295

  • Private Courses

    Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask a Question
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Excel Level 3 Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

 

Course Reviews
"Really enjoyed the course today, thank you. Very well presented."

A. Primula, Excel Level 3

Following this training what are you going to do differently "Going to use excel at a higher level to maximize efficiency."

J.B. Primula, Excel Level 3

"Course was really detailed and informative."

N.F. , Excel Level 3

Following this training what are you going to do differently "Everything!"

J.D. KAEFER Limited, Excel Level 3

Which part of the course did you find particularly valuable "Everything was useful and amazing"

T. , Excel Level 3

Any other comments or recommendations "Very worth attending"

T. , Excel Level 3

Any other comments or recommendations "Really enjoyed this training, [the trainer] was great at explaining and helping out"

D.G. Kaefer, Excel Level 3

"I have picked up lots of shortcuts and things I didn't know before today which I will use going forward"

K.M. Kaefer, Excel Level 3

"This is improve my working life just like the last course"

P.P. Merton Council, Excel Level 3

"It was brilliant"

S.M. British Gypsum, Excel Level 3

Following this training what are you going to do differently "Everything. I will adapt my new skills and integrate them into my work as I do work with large data sets"

L.D. Nothumbrian Water Group, Excel Level 3

"I thought the training was delivered really well, the content was good and was set at the right level for the group"

M. NWL, Excel Level 3

Following this training what are you going to do differently "I will be able to deliver better, more reliable, useful data for my team"

N.F. Tyne and Wear Fire and Rescue Service, Excel Level 3

"Thoroughly enjoyed it. Can't wait to put it all in to use"

N.F. Tyne and Wear Fire and Rescue Service, Excel Level 3

"Very informative, good input and time allowed"

S. , Excel Level 3

"I felt the course was really excellent and no improvement needed"

S.D. Everyturn, Excel Level 3

"Great trainer and was very patient and worked thorough at a good pace"

K.K. Everyturn, Excel Level 3

"I found the VLOOKUP and flash field functions really useful. I also enjoyed learning all the additional uses of pivot tables. All of the training was very detailed whilst also being enjoyable!"

B.C. , Excel Level 3

Following this training what are you going to do differently "I am going to be turning my spreadsheets into tables and naming them. I will also now be able to use the VLOOKUP function that I was previously struggling with. I am also definitely going to use the flash field function."

B.C. , Excel Level 3

"Would highly recommend the course. Many thanks"

B.W. Public scheduled course, Excel Level 3

"Everything was fantastic"

L.R. Public scheduled course, Excel Level 3

"[The trainer] was fantastic, an absolute credit to the company. Very well presented and engaging throughout very knowledgeable."

L.R. Public scheduled course, Excel Level 3

"The whole course was a good refresher of previous skills"

T.T. Marelli, Excel Level 3

"It has given me the confidence to start a spreadsheet from scratch again rather than copying and amending other peoples."

J.R. Yorwaste, Excel Level 3

"Trainer was very enthusiastic about Excel and how it could help. I found it quite infectious!"

A.S. The HR Dept, Durham & Newcastle South, Excel Level 3

"[The trainer] was very knowledgeable and enthusiastic, and made sure the content was delivered in an engaging way."

M.G. Tharsus, Excel Level 3

"Pivot Tables will help me present reports and information much better and more comfortably on a day to day basis"

J.C. , Excel Level 3

Following this training what are you going to do differently "I will work a lot more efficiently"

A.W. EGGER, Excel Level 3

"Thank you very much for the course. It was very useful and very practical. I refreshed my knowledge and learned new practical skills I can use at work."

O. , Excel Level 3

"Informative, helpful, professional, valuable"

O. , Excel Level 3

Following this training what are you going to do differently "Use macros more to simplify and make tasks quicker"

K.S. Betech 100PTLtd, Excel Level 3

Following this training what are you going to do differently "Write some macros into my spreadsheets following the course next month, always create tables for the data, name cells to use in formulas"

A.G. Yorwaste, Excel Level 3

Following this training what are you going to do differently "Lots! Lots of little shortcuts to remember and use, I will definitely apply all that I've learnt, I knew the basics of many of the functions but great to get more training on them from a pro because I am mainly self taught."

V.K. , Excel Level 3

Are there any aspects of the course which you feel require improvement "The course was very informative and ran at a great pace. I'd book more courses with IT Training Solutions"

S. carveti partnership, Excel Level 3

Any other comments or recommendations "I would recommend this course to many more colleagues"

S. carveti partnership, Excel Level 3

"Very satisfied with the course"

V.K. , Excel Level 3

Which part of the course did you find particularly valuable "All very valuable, particularly how to use Pivot Tables and LookUps effectively, as well as the introduction to Macros."

D.S. South Tyneside Homes, Excel Level 3

Which part of the course did you find particularly valuable "Very easy to follow along with Adele, and very easy to understand. The Data Validation and macros will be very valuable. I thought the excel sheet that we were sent was very well set all."

S.R. , Excel Level 3

"I learnt a lot more than I thought I would during the course, and Adele was able to explain some functions that I have used before, but didn't fully understand, which will benefit me in applying to more of my work."

S.R. , Excel Level 3

"Loads of very useful tips and explanations,"

C.W. South Tyneside Council, Excel Level 3

"Very easy to follow and great to do from home"

C.W. South Tyneside Council, Excel Level 3

Any other comments or recommendations "Rob was an excellent teacher and I have found his course extremely helpful, more so than I originally thought it would be."

C. NHSBSA, Excel Level 3

"Very useful course. Good venue. "

J.B. -, Excel Level 3

Following this training what are you going to do differently "I can work differently and efficiently"

I.M. , Excel Level 3

Which part of the course did you find particularly valuable "Working on the pivot table slicers and recording Macros. "

E.D. Tharsus, Excel Level 3

Which part of the course did you find particularly valuable "Slicers in pivots and table pivots. Macros, Data validation. Sum IF/Count IF "

M.P. Tharsus, Excel Level 3

Any other comments or recommendations "The trainer was excellent "

N.W. South Tyneside Council, Excel Level 3

Any other comments or recommendations "Very good, useful course."

K.G. South Tyneside Council, Excel Level 3

"Well explained. Nicely paced"

M.L. Emotional Logic, Excel Level 3

"I found Pivot table and splitting columns of the most use however the whole course was helpful, Adele gave me some 1 on 1 training at the end which was very good."

M.T. UKCG, Excel Level 3

Which part of the course did you find particularly valuable "Pivots and shortcuts and security "

A.T. Sealy UK, Excel Level 3

Following this training what are you going to do differently "Not refer to internet as much for any Excel problems! For what I require in my work I feel more confident with the knowledge I've gained after today. Also feel I have more knowledge to help my seniors in other Excel based projects. "

R.Y. GSK, Excel Level 3

Which part of the course did you find particularly valuable "The macro and pivot functions"

S.B. GSK, Excel Level 3

Following this training what are you going to do differently "Use pivot tables and charts to display information clearly "

S.B. GSK, Excel Level 3

Following this training what are you going to do differently "Use shortcuts more effectively "

W.O. S Sheard & Son Limited, Excel Level 3

Following this training what are you going to do differently "It will speed up my work with spreadsheets "

A.R. S Sheard & Son Limited, Excel Level 3

Which part of the course did you find particularly valuable "All of the course for me was excellence, it has shown me alot of things I did not know you could do and it will help me save time and handle data much better."

L.H. Esh Group, Excel Level 3

Following this training what are you going to do differently "Will be reviewing how we produce data to make more efficient process for team producing and better output for customer."

J.I. County Durham & Darlington NHS FT, Excel Level 3

Any other comments or recommendations "The trainer is very informative and patient "

D.S. Home Office, Excel Level 3

Following this training what are you going to do differently "Put the principles into practice autosum named ranges pivot tables "

B.R.H. Quorn Foods, Excel Level 3

"Fantastic. All great!"

A.S. University of Leeds, Excel Level 3

Which part of the course did you find particularly valuable "Lookups and Pivot tables but I feel as though I have learned lots from each unit we covered."

L.W. County Durham Community Foundation, Excel Level 3

Which part of the course did you find particularly valuable "Data validation plus numerous other aspects "

A.T. Hyperdrive Innovation Ltd, Excel Level 3

"Fantastic course"

D.C. Gestamp, Excel Level 3

"Very well presented course with good information, materials and exercises provided."

A. Demeter Ltd, Excel Level 3

"The tutor was excellent, patient and clear"

S.D. Ground Control, Excel Level 3

"Brilliant once again."

M.K. Durham County Council, Excel Level 3

Following this training what are you going to do differently "Create my own metrics. Analyse statistics"

J.C. CMR UK Ltd, Excel Level 3

"All of the course gave me new knowledge"

C.B. CMR UK Ltd, Excel Level 3

"All aspects greatly improved my knowledge."

P.T. Bruker JV UK Ltd., Excel Level 3

"All of the course was great"

L.T. The Labour Party, Excel Level 3

"[The trainer] was great, he explained everything really well and was very helpful when anyone was struggling"

L.T. The Labour Party, Excel Level 3

"Really enjoyed this!"

R. Labour, Excel Level 3

"All informative, but pivot tables extremely useful"

G.B. The Labour Party, Excel Level 3

"This course will change the way we format and present data in the department, saving us time and giving us a much better overview of our workload, budgets, and monthly stats."

G.B. The Labour Party, Excel Level 3

"Really useful course thank you!"

L.O. Labour Party, Excel Level 3

"Very well presented"

A.C. Engie Fabricom, Excel Level 3

"Great course thank you!"

H.T. HKA, Excel Level 3

How would you rate the course content overall "Amazing I feel I will be so much more efficient. Content was so relevant and useful. Looking forward to applying what I have learned"

K.B. Education Development Trust, Excel Level 3

"Thank you for an excellently presented training day :"

E.C. Nissan, Excel Level 3

"Superb course. Possibly the best course I have been on in 22 years in the Fire Service."

J.W. Durham & Darlington Fire & Rescue, Excel Level 3

"Pivot Tables I'm going to have fun with this when I return to work!"

K.T. PX Group, Excel Level 3

"Great practical examples, with extra focus on sections tailored to individual areas of interest"

S.K. Nissan, Excel Level 3

"Excellent trainer with huge knowledge and friendly attitude. Fab course!"

E.S. Nissan, Excel Level 3

 

Public Scheduled Courses

Prices per delegate. All prices exclude VAT.
10 Jul 2025
in Durham
£295
29 Jul 2025
Virtual Course
£245
12 Aug 2025
in Durham
£295
13 Aug 2025
Virtual Course
£245
04 Sep 2025
Virtual Course
£245
22 Sep 2025
in Newcastle
£375
07 Oct 2025
Virtual Course
£245
16 Oct 2025
in Durham
£295
07 Nov 2025
Virtual Course
£245
11 Nov 2025
in Durham
£295
12 Dec 2025
in Newcastle
£375
12 Dec 2025
Virtual Course
£245
18 Dec 2025
in Durham
£295

Private Courses

Flexible dates, location and content. All prices exclude VAT.

Other Courses In This Training Series

Microsoft 365 Copilot for Business Users - Introduction Course Course Overview: This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool that uses artificial intelligence to provide real-time intelligent assistance within Microsoft 365 productivity apps including Word, Excel, PowerPoint, Teams and O Excel Business Intelligence using Excel Power Tools Course Course Overview: This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard Creation with Pivot Tables, Charts and SlicersIt is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.Thi Excel Advanced Macros Course Course Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it. We even teach you some commands that cannot be recorded, such as how to sh VBA Essentials using Microsoft Excel Course Course Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures. Excel Analysing and Presenting Data with Dashboards and Pivot Tables Course Course Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to Excel Level 2 Course Course Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gai Excel Level 1 Course Course Overview: Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create

 

 

Please contact us to discuss your Excel Level 3 course, we have many solutions available to ensure you receive the best training possible.
Your Excel course can be delivered online or in-person.  You can choose your Excel path with introduction to advanced levels. Master Excel Business Intelligence and Power Tools, VBA and more.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Excel Level 3 course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master Excel, please contact us to book a place or request a quote for your Excel Level 3 course.
Microsoft and Microsoft Excel are Registered Trademarks Advanced Microsoft Excel Training in North East England, Durham, Washington and Newcastle.<a href=';/uk-training-courses/microsoft-excel-training-courses.asp';>Microsoft Excel Training Courses in the UK</a> Microsoft Excel Advanced Training . Microsoft Excel Advanced Training England. Advanced Excel Training. Advanced Excel Training Newcastle. Learn how to work with complex data sets. Learn how to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data. Advanced Excel Training Courses.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:6/18/2025 11:24:22 AM