Excel Level 2
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 gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.
- 1 Day
- Online or in person
- Private courses available
Course Objectives
- Use the IF function to automate tasks using tests.
-
Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data, eg. an expenses sheet that takes the monthly totals and displays them on a summary sheet.
-
Filter a spreadsheet to show only the records that meet a specific criteria, eg. all surnames beginning with A.
- Display data in various graphical formats that can be easily understood by anyone not using Microsoft Excel.
Prerequisites
- Before starting this course, we recommend that delegates have attended the Microsoft Excel Level 1 course or have equivalent knowledge.
Included
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
Course content Back to top
-
RECAP of Performing calculations
Adding and Subtracting Numbers
Multiplication and Division
Understanding BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Using Absolute Referencing
Difference between Relative and Absolute References
Absolute Reference and Dollar Sign
Why use Absolute References
Applying an Absolute Reference in a formula -
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 -
Linking within a workbook (3D-Referencing)
Linking within a workbook
Simple referencing in a worksheet
Calculating across multiple sheets using 3D-Referencing -
Calculating Data with Logical Functions (IF Function)
IF functions
IF function criteria
Using IF’s to test or check your data -
Conditional Formatting
Conditional Formatting Types
Highlight Cells different colours based on their value
Top Bottom Rules
Icon Sets
Data Bars
Colour Scales
Customising Conditional Formatting -
Performing Date and Time Calculations
Date Shortcuts
TODAY and NOW functions
DATEDIF function
YEAR, MONTH, DAY, TEXT functions
NETWORKDAYS function -
Comments
Adding, Editing and Deleting Comments -
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 -
Presenting Data Using Charts
Creating a chart
Modifying charts
Formatting charts
Advanced Chart Features
Multi-Axis charts
Quick Analysis Tool
Public dates and prices Back to top
Prices are per delegate and exclude VAT.
-
Wednesday 28 October 2026
£295+ VAT
-
Thursday 19 November 2026
£295+ VAT
-
Wednesday 2 December 2026
£345+ VAT
-
Monday 7 December 2026
£425+ VAT
-
Wednesday 16 December 2026
£295+ VAT
-
Tuesday 12 January 2027
£295+ VAT
-
Thursday 22 April 2027
£295+ VAT
-
Monday 17 May 2027
£295+ VAT
-
Monday 28 June 2027
£295+ VAT
-
Tuesday 6 July 2027
£295+ VAT
-
Thursday 29 July 2027
£295+ VAT
-
Monday 9 August 2027
£295+ VAT
-
Tuesday 17 August 2027
£295+ VAT
-
Monday 27 September 2027
£295+ VAT
-
Wednesday 27 October 2027
£295+ VAT
-
Thursday 18 November 2027
£295+ VAT
-
Wednesday 15 December 2027
£295+ VAT
Can't make these dates? Ask about a private course on a date that suits you.
Training a team?
Run this course privately, on your dates
What delegates say Back to top
“Trainer was excellent, very enthusiastic and knowledgeable.”
“Our trainer was always open to questions and was always clear on explaining the main objectives and tasks to do. Was very easy to follow and we covered all I expected for this level. Brilliant!”
“The trainer made me feel very settled and explained everything in detail. Fantastic Course”
“Excellent course, well worth doing.”
“I recently attended the Level 1 course, so this was a perfect and relevant next step in my Excel training. Picked up some tips which will assist me everyday back in the office. Great course, much appreciated.”
“Helped me to improve my skills and find quicker ways to do things. All the material outlined on the course description was covered, exactly as I expected. The training material was very thoughtfully laid out.”
“An all round great course, thanks once again.”
“Very informative practical course.”
“Everything was useful”
“Learned a lot from todays course that I can take into my workplace”
“Excellent training”
“All parts relevant with good training materials”
“Great course, easy to follow, would recommend”
“Great that lunch is provided and snacksbrews”
“Really enjoyable”
“I enjoyed learning about graphs and tables as this will help me within my job.”
Following this training what are you going to do differently
“Use Excel in different and easier ways”
“Enjoyable course”
Which part of the course did you find particularly valuable
“Learning short cuts and filters”
“I was happy with all of it as it will allow me to use Excel more confidently”
“The overall course was a great reminder about certain features. I particularly found data validation and conditional formatting very useful.”
Following this training what are you going to do differently
“Increase technical ability and streamline my work. Use more of the functions rather than typing out formulas.”
“Course was delivered well to someone with limited knowledge and confidence”
“The course has shown me the easier way to do things I was doing before so I will put that into practice.”
Following this training what are you going to do differently
“This will speed up and improve appearance of charts which I produce in reports”
Following this training what are you going to do differently
“Use the formulas and implement them into reports on BO analysis”
Which part of the course did you find particularly valuable
“Learned some quick, simple ways that I didn#39t know were there”
Any other comments or recommendations
“Very good and informative. The trainer was good and not reading from a book, very knowledgeable and approachable.”
“The trainer was very helpful. Took the time to explain things to individuals who needed it.”
“Fantastic!”
Following this training what are you going to do differently
“Use Excel for more intricate functions”
Any other comments or recommendations
“I feel as though I have learnt lots of new functions that will assist me in doing my job”
“Very patient and understanding trainer”
Which part of the course did you find particularly valuable
“All of it, but mostly use of formula and tables”
“Fantastic, well recommended”
Which part of the course did you find particularly valuable
“Shortcuts, pivots, filters, links”
Following this training what are you going to do differently
“Use my training to improve my reports and save time”
Which part of the course did you find particularly valuable
“All of it. Probably more the hints and tips than the general topics!”
Which part of the course did you find particularly valuable
“All of it, particularly graphs and Vlookup function”
Following this training what are you going to do differently
“Now that I know formulas, I won’t have to watch how to videos on Youtube, I can just refer back to my training notes.”
Following this training what are you going to do differently
“I will be able to present and manipulate data at work in a more efficient way. I have learned a lot of new techniques which help to make processes quicker. I will not be scared to see what Excel can actually do and using my booklet I can take my time and keep learning as I grow my confidence in the use of the system.”
Which part of the course did you find particularly valuable
“The practical approach of trying every aspect whether I had already done it before or I was trying it for the first time. It was a safe space to make mistakes and a very encouraging environment.”
Following this training what are you going to do differently
“Learned how to do speedier shortcuts”
Following this training what are you going to do differently
“Use autoformulas to comprise sheets”
Following this training what are you going to do differently
“Loads the way I interpret data and present it”
Which part of the course did you find particularly valuable
“More understanding of setting up spreadsheets setting formulas”
Following this training what are you going to do differently
“Build sheets with more 'depth' now I have a better understanding of scope”
Following this training what are you going to do differently
“Use many tips and tricks, use IF more, use function library within Excel.”
Following this training what are you going to do differently
“Efficiently working in sheets quicker”
Following this training what are you going to do differently
“I won’t be afraid to use Excel anymore”
Following this training what are you going to do differently
“Much better analysis of data use more functions”
Any other comments or recommendations
“Very clear and informative”
Any other comments or recommendations
“Great course. Knowledge is a must.”
Following this training what are you going to do differently
“Tidy up the current spreadsheets that I use using the new features that I have learnt. Will help me with my KPIs.”
Are there any aspects of the course which you feel require improvement
“None, enjoyed every aspect”
Any other comments or recommendations
“Excellent trainer, very knowledgeable”
Following this training what are you going to do differently
“It’ll really change the way I work with others in my team on data, and speed up the way I work in Excel”
Following this training what are you going to do differently
“Use Excel more often for valuable shortcuts to tasks that would otherwise take me a long time.”
“Enjoyable and very useful day course, Excel confidence has improved markedly already!”
“Course was very well delivered, ideal amount of time on each section. No suggestions for improvement.”
“Excellent session, thank you”
Following this training what are you going to do differently
“Create better charts, make use of Tables, and make use of the IF Function and Conditional Formatting. I will also now be able to work better with dates, and generate data on timescales between processes.”
Would it be possible to use your feedback in our marketing we only use your initials and organisation name
“My second Excel course it has made a huge difference to how I present data”
“Liked the course very much, very informative, great tutor”
“Found the course to be exactly what I needed to move forward in my role. Thank you”
“Loved it!”
“I will save loads of time not having to google how to do things on spreadsheets.”
“Just really useful and enjoyable”
“I will feel more confident in general using Excel, I will be able to present data in a better way and will also feel more confident setting up my own worksheets in Excel.”
“I thought the course was really helpful and I would fully recommend.”
“The trainer took lots of time to answer our individual questions and had lots of good examples for us to practice and work through which really helped put theory into practice. The examples made understanding much easier and meant the course wasn#39t too content heavy and nice and interactive.”
“I found it all valuable, the information the trainer gave was informative and very helpful, this course will help me massively in my role at work. I was nervous for doing the Excel course and my knowledge was very basic, but there was no need to be as the trainer was so lovely, friendly and professional she explained things so I we understood and checked as we were going if we were all ok.”
“Looking forward to trying some of the things I’ve learned”
“Very satisfied with this training, would recommend it! The presenter was very professional and friendly!”
“Very good training made a potentially monotonous topic very engaging and easy to follow”
“I found all aspects of the course valuable as I learned something from each section.”
Are there any aspects of the course which you feel require improvement
“No, it was really good!”
“I particularly benefitted from the level of depth and explanation that went into the course step by steps. the exercisers allowed learning time to understand each module and skill.”
“The short cuts when using formulas as I wasn’t aware of them whereas I’ve done doing things the long way round.”
“Everything was explained really well and I now have a better understanding of things I struggled with before”
Following this training what are you going to do differently
“I will be reviewing the excel spreadsheets that I use on a regular basis to see how I can improve them by using different formulas”
Which part of the course did you find particularly valuable
“I found all of the course valuable. Although I do use Excel on a daily basis I wasn’t aware of some of the shortcuts that were shown to us today and these will certainly benefit me goung forward”
Are there any aspects of the course which you feel require improvement
“I thought the structure of the course was perfect. I was really impressed by the prepopulated worksheet.”
Are there any aspects of the course which you feel require improvement
“I think the course was filled with great content and the trainer was very good. Extremely engaging.”
Which part of the course did you find particularly valuable
“The work with formulas and 39If Statements39 is particularly valuable and useful as is how to protect the data, and Data Validation”
Following this training what are you going to do differently
“A definite will be using the insert function tool & using keyboard shortcuts regular till become 2nd nature hopefully ??”
“Very enjoyable course with a lot of good information in a short time.”
Following this training what are you going to do differently
“I will be more confident and competent at compiling spreadsheets.”
Following this training what are you going to do differently
“I will be more confident working with spreadsheets and analysing data and presenting charts”
“All aspects were enlightening and I am eager to put my new found knowledge to use”
“Great course, look forward to Level 3”
“I know how to do things properly now so I will spend alot less time googleing!!”
“All of it was brilliant, lots I didn’t know, the shortcuts, formulas, grouping”
“I would really recommend this training to people that use Excel and want to make their life a bit easier.”
Following this training what are you going to do differently
“Take less time to do everything on excel”
“Enjoyed all of it learnt some useful quick tips I was not aware of and also functions that I’ve not come across. Liked the charts section too.”
“Very well presented course and lots of very useful pointers on how to do things.”
“Fantastic course. Could be boring material but the teacher makes it fun and interactive”
“Thoroughly enjoyed this course!”
“It was the best virtual course I have been on!”
“GREAT COURSE, WELL PRESENTED!!”
“The trainer was a great teacher and I cant wait for level 3.”
“Things I was doing on Excel that would take up hours of my day now only take 10 minutes”
Following this training what are you going to do differently
“Use these techniques throughout my work, it will help me massively.”
“I would recommend this course to others”
“To be honest, every part of the training is very valuable. The most valuable though is vlookup”
Following this training what are you going to do differently
“I will be far faster at multiple things as I seem to have been doing everything the long way round.”
“Everything was useful and delivered very well.”
“I thought the trainer was very patient and helped the less able candidates on our course ie me! Thank you.”
“I thoroughly enjoyed this course”
“Everything was clearly explained and useful”
“I found all aspects of this course valuable. I am looking forward to adding formulas to my spreadsheets and creating graphs for reporting purposes.”
Following this training what are you going to do differently
“I will be using excel in a completely different way. But data validation is going to really improve my efficiency. And then conditional formatting is something I think I will be able to use in all parts of my life.”
“Honestly found everything on the course extremely useful. It has shown simpler, easier ways to create things in Excel and shown me how easy and useful Excel can be.”
“Excellent course and trainer. Very informative.”
“Very informative and presented well”
“There was none of the course I didn#39t find valuable. I especially enjoyed the first part learning about formatting”
“This course will help me produce information more quickly and efficiently”
“Excellent session”
“Extremely informative and very beneficial in enhancing my knowledge and skills”
Following this training what are you going to do differently
“Stop ruining other colleagues spreadsheets! Joking aside, Ill be better placed to present production figures and pinpoint any trends.”
“Really enjoyed the course, the trainer was very engaging and most helpful.”
“Very good useful course. Trainer was brilliant and I wasn’t scared to ask her to show me how to do different parts again.”
“Extremely useful with insights on why you use functions, not only how.”
“Very good run course, I learnt a lot of new skills throughout the day.”
“All course content very informative and easy to follow. Full of handy information”
“Good allround training”
“The trainer was fabulous at explaining and very patient.”
“Very enjoyable and a very proactive and easy training session.”
“Great Course! Great Trainer!”
“The trainer was really helpful when I needed assistance and made me feel at ease”
“Enjoyed the whole course”
“An enjoyable day!”
“A lot of detail to take on board but interesting nonetheless.”
“Will definitely use a lot from this course, mostly dashboards and use of formulas.”
“It was brilliant thank you”
“There are lots of little nuggets and time saving opportunities the time spent today has been invaluable, shame I haven’t completed it sooner would have saved me quite a lot of time!”
“The trainer was super patient, kept going over areas and answered all our weird and wonderful questions”
“Learnt so much it was great.”
Following this training what are you going to do differently
“Not sure maybe do some graphs and slicing, just because I can now”
“The course was taught well and was very informative”
“Learnt a lot from this course really enjoyed it”
“I have found all of the course valuable however I particularly found the section around formulas very helpful”
Following this training what are you going to do differently
“I will be able to set up analysis and documents myself”
“Very impressed, would recommend this course”
“Great balance of practical examples and teaching.”
“This has been really helpful and should improve our efficiency”
“Well done it was really useful and exceeded my expectations”
“I really enjoyed the course”
Other courses in this series Back to top
- You are here Excel Level 2
-
Microsoft 365 Copilot for Business Users - Introduction
This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool…
-
VBA Essentials using Microsoft Excel
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…
-
Excel Level 3
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…
-
Excel Level 1
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will…
-
Excel Analysing and Presenting Data with Dashboards and Pivot Tables
This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive…
Please contact us to discuss your Excel Level 2 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 2 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 get a quote for your Excel Level 2 course.
Excel Training: Mastering the Art of Spreadsheets
Welcome to the comprehensive world of Excel training, where data meets design, and numbers transform into insights. Our Excel training programs are tailored to equip you with the prowess to navigate the complexities of Microsoft Excel, from basic functionalities to advanced data analysis.
The Core of Excel Training
At the heart of our Excel training lies a commitment to excellence. Whether you’re a novice looking to understand the basics or a professional seeking to refine your skills, Excel training with us offers a structured path to mastery.
Foundational Excel Training (Level 1): Begin your journey with the essentials. Learn about cell formatting, formula creation, and charting basics.
Intermediate Excel Training (Level 2): Elevate your abilities with intermediate Excel training. Dive into If functions, working with dates and conditional formatting etc.
Advanced Excel Training (Level 3): Reach new heights with advanced Excel training. Explore macros, complex functions, and data modelling etc.
The Benefits of Excel Training
Engaging in Excel training is more than just learning about a software application; it’s about unlocking the potential to make informed decisions based on data.
Efficiency: Excel training teaches you shortcuts and techniques to streamline your workflow.
Accuracy: With Excel training, reduce errors and increase precision in your calculations.
Analysis: Excel training empowers you to perform sophisticated data analysis, turning raw data into actionable insights.
The Experience of Excel Training
Excel training isn’t a one-size-fits-all approach. We offer various formats to suit your learning style and schedule.
Live Excel Training:
Participate in instructor-led Excel training sessions for real-time learning and feedback. This can take place in one of our physical classrooms, or our virtual classrooms. (See below for more information on Virtual Training.)
Corporate Excel Training: Customise Excel training for your team to meet specific organisational needs.
The Future of Excel Training
As technology evolves, so does our Excel training. Stay ahead of the curve with updated courses that reflect the latest features and best practices in Excel.
Embrace Excel Training Today
Take the first step towards becoming an Excel pro.
Enrol in Excel training and transform the way you work with data. With Excel training, the possibilities are endless.
Virtual Excel Training: Your Gateway to Spreadsheet Mastery
In this digital era, the ability to effectively utilise Excel is more important than ever. Virtual Excel training offers a flexible and efficient way to enhance your spreadsheet skills from the comfort of your own home or office.
What is Virtual Excel Training?
Virtual Excel training is an online educational experience that provides you with the knowledge and skills to use Excel to its full potential. Whether you’re a beginner or an advanced user, virtual Excel training can help you:
Benefits of Virtual Excel Training
Convenience: Learn from anywhere, without the need to travel.
Interactivity: Virtual Excel training programs offer interactive elements, such as live Q&A sessions, hands-on exercises, and real-time feedback.
Access to Experts: Virtual training connects you with experienced instructors who can provide personalised guidance and support.
Get Started with Virtual Excel Training
Ready to take your Excel skills to the next level? Explore the range of virtual Excel training options available and enrol in one of our programs that fits your needs. With virtual Excel training, you’re just a few clicks away from becoming an Excel expert.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/23/2026 6:55:21 AM