Excel Level 2
Public Scheduled Course Dates
Date | Location | Price | |
24 Sep 2024 | Virtual |
£245
|
|
09 Oct 2024 | Newcastle |
£375
|
|
14 Oct 2024 | Durham |
£295
|
|
24 Oct 2024 | Virtual |
£245
|
|
21 Nov 2024 | Virtual |
£245
|
|
04 Dec 2024 | Durham |
£295
|
|
18 Dec 2024 | Virtual |
£245
|
|
14 Jan 2025 | Virtual |
£245
|
|
29 Jan 2025 | Durham |
£295
|
|
05 Feb 2025 | Newcastle |
£375
|
|
19 Feb 2025 | Virtual |
£245
|
|
20 Mar 2025 | Durham |
£295
|
|
26 Mar 2025 | Virtual |
£245
|
|
08 Apr 2025 | Durham |
£295
|
|
28 Apr 2025 | Virtual |
£245
|
|
21 May 2025 | Virtual |
£245
|
|
18 Jun 2025 | Virtual |
£245
|
|
09 Jul 2025 | Durham |
£295
|
|
24 Jul 2025 | Virtual |
£245
|
|
04 Aug 2025 | Newcastle |
£375
|
|
21 Aug 2025 | Virtual |
£245
|
|
08 Sep 2025 | Durham |
£295
|
|
23 Sep 2025 | Virtual |
£245
|
|
08 Oct 2025 | Newcastle |
£375
|
|
13 Oct 2025 | Durham |
£295
|
|
23 Oct 2025 | Virtual |
£245
|
|
20 Nov 2025 | Virtual |
£245
|
|
03 Dec 2025 | Durham |
£295
|
|
17 Dec 2025 | Virtual |
£245
|
Private Training
Course Duration
1 DayExcel Level 2 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 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.Excel Level 2 Course Prerequisites
-
- Before starting this course, we recommend that delegates have attended the Microsoft Excel Level 1 course or have equivalent knowledge.
- Before starting this course, we recommend that delegates have attended the Microsoft Excel Level 1 course or have equivalent knowledge.
Excel Level 2 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.
Included with this course
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
Excel Level 2 Course Content
-
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 Scheduled Course Dates
Date | Location | Price | |
24 Sep 2024 | Virtual |
£245
|
|
09 Oct 2024 | Newcastle |
£375
|
|
14 Oct 2024 | Durham |
£295
|
|
24 Oct 2024 | Virtual |
£245
|
|
21 Nov 2024 | Virtual |
£245
|
|
04 Dec 2024 | Durham |
£295
|
|
18 Dec 2024 | Virtual |
£245
|
|
14 Jan 2025 | Virtual |
£245
|
|
29 Jan 2025 | Durham |
£295
|
|
05 Feb 2025 | Newcastle |
£375
|
|
19 Feb 2025 | Virtual |
£245
|
|
20 Mar 2025 | Durham |
£295
|
|
26 Mar 2025 | Virtual |
£245
|
|
08 Apr 2025 | Durham |
£295
|
|
28 Apr 2025 | Virtual |
£245
|
|
21 May 2025 | Virtual |
£245
|
|
18 Jun 2025 | Virtual |
£245
|
|
09 Jul 2025 | Durham |
£295
|
|
24 Jul 2025 | Virtual |
£245
|
|
04 Aug 2025 | Newcastle |
£375
|
|
21 Aug 2025 | Virtual |
£245
|
|
08 Sep 2025 | Durham |
£295
|
|
23 Sep 2025 | Virtual |
£245
|
|
08 Oct 2025 | Newcastle |
£375
|
|
13 Oct 2025 | Durham |
£295
|
|
23 Oct 2025 | Virtual |
£245
|
|
20 Nov 2025 | Virtual |
£245
|
|
03 Dec 2025 | Durham |
£295
|
|
17 Dec 2025 | Virtual |
£245
|
Private Training
-
Excel Level 2 Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed 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!PrivatePrivateFlexible 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.BespokeBespokeBespoke 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.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
T.S. SIS mfg, Excel Level 2
S.P. Impact International, Excel Level 2
S.P. Impact International, Excel Level 2
S.P. Impact International, Excel Level 2
J.G. Impact International, Excel Level 2
H.H. Norseal Ltd, Excel Level 2
A.P. James Jones and Sons Ltd, Excel Level 2
R.G. James Jones and Sons Ltd, Excel Level 2
G.C. James Jones and Sons Ltd, Excel Level 2
A.M. Hemingways, Excel Level 2
A.M. Hemingways, Excel Level 2
D.B. James Jones and Son Ltd, Excel Level 2
J.M. James Jones and Son Ltd, Excel Level 2
T.B. Public scheduled course, Excel Level 2
C. , Excel Level 2
J.M. James Jones and Sons, Excel Level 2
E. , Excel Level 2
A.M. James Jones, Excel Level 2
M.C. James Jones, Excel Level 2
D. James Jones, Excel Level 2
A.P. South Tyneside Council, Excel Level 2
M.C. South Tyneside Council, Excel Level 2
W.D. James Jones & Sons Ltd, Excel Level 2
J.H. , Excel Level 2
L.M. NHS South Tyneside, Excel Level 2
M.D.M. Public scheduled, Excel Level 2
A.F. Public scheduled, Excel Level 2
N.B. Public scheduled, Excel Level 2
L.M. , Excel Level 2
R.F. Wetherby Shade Card Co, Excel Level 2
J.P. South Tyneside & Sunderland NHSFT, Excel Level 2
C.L. South Tyneside & Sunderland NHSFT, Excel Level 2
B.W. Tyne & Wear Fire & Rescue Service, Excel Level 2
W.W. Bilfinger, Excel Level 2
A. FALTEC EUROPE LTD, Excel Level 2
S. , Excel Level 2
L. , Excel Level 2
S.B. THARSUS VISION LTD, Excel Level 2
R. Universal Wolf, Excel Level 2
R. Universal Wolf, Excel Level 2
J.M. LSL Property Services, Excel Level 2
J.M. LSL Property Services, Excel Level 2
C.C. Martell Real Estate, Excel Level 2
G.O. Lighthouse Poole, Excel Level 2
A.T. ASW Assurance, Excel Level 2
S.A. ASW Assurance, Excel Level 2
S.A. ASW Assurance, Excel Level 2
C.Y. ASW, Excel Level 2
L. , Excel Level 2
J.H. Lighthouse, Poole, Excel Level 2
T.P. , Excel Level 2
D. , Excel Level 2
I.M. Hitachi Construction Machinery Uk Ltd, Excel Level 2
J.R. Hitachi Construction Machinery UK, Excel Level 2
S.T. UPM Raflatac, Excel Level 2
J.S. Yorwaste, Excel Level 2
S.O. Egger UK, Excel Level 2
B.T. EGGER, Excel Level 2
C.P. , Excel Level 2
C.P. , Excel Level 2
S.F. , Excel Level 2
D.P. , Excel Level 2
J.G. Hitachi, Excel Level 2
V.K. Blue Phoenix UK LTD, Excel Level 2
D.H. , Excel Level 2
D.V. , Excel Level 2
A. , Excel Level 2
M.L. Healthwatch North Tyneside, Excel Level 2
J.H. Egger UK, Excel Level 2
E.F. Egger, Excel Level 2
E.F. Egger, Excel Level 2
D.K. Egger, Excel Level 2
N.W. Riverford Organic Farmers, Excel Level 2
T.C. Riverford Organic Farmers, Excel Level 2
F.W. , Excel Level 2
J.T. Recipharm, Excel Level 2
C.C. EggerUK Ltd, Excel Level 2
J.S. STC, Excel Level 2
D.S. South Tyneside Homes, Excel Level 2
C.M. , Excel Level 2
P.T. South Tyneside Council, Excel Level 2
P.T. South Tyneside Council, Excel Level 2
J. , Excel Level 2
B. , Excel Level 2
M.D. Abraham Moon Sons Ltd, Excel Level 2
C.G. Vehicle Lease and Service Ltd, Excel Level 2
C.G. Vehicle Lease and Service Ltd, Excel Level 2
J.B. Tharsus, Excel Level 2
R.S. William Smith Group, Excel Level 2
V.H. William Smith Group, Excel Level 2
K.W. Hart Biologicals, Excel Level 2
J.P. Intermarketing, Excel Level 2
S.B. Education Development Trust, Excel Level 2
L.S. Intermarketing, Excel Level 2
K.L. Sealy UK, Excel Level 2
N.S. Burnetts Solicitors, Excel Level 2
S.C. Burnetts Solicitors, Excel Level 2
J.R. Sealy UK, Excel Level 2
S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2
S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2
S.P. Drummond Central, Excel Level 2
K.D. GSK, Excel Level 2
I.S. GSK, Excel Level 2
R.B. GSK, Excel Level 2
H.P. GSK, Excel Level 2
A.L. GSK, Excel Level 2
S.H. GSK, Excel Level 2
M.R. GSK, Excel Level 2
T.W. Nicholsons Sealing Technologies, Excel Level 2
P.T. Hyde Park Source, Excel Level 2
A.S. , Excel Level 2
A.B. Nicholsons Sealing Technologies, Excel Level 2
S.R. Edinburgh Woollen Mill, Excel Level 2
C.P. Egger Uk, Excel Level 2
N.S. Egger Uk, Excel Level 2
P.B. Egger UK, Excel Level 2
L.P. Egger UK, Excel Level 2
L.P. Egger UK, Excel Level 2
D.S. Home Office, Excel Level 2
A.G. Home Office, Excel Level 2
L.G. Home Office, Excel Level 2
M.C. CMR UK Ltd, Excel Level 2
D.S. CMR UK Ltd, Excel Level 2
P.C. CMR UK Ltd, Excel Level 2
S.B. FM Coatings, Excel Level 2
B.S. Direct Rail Services, Excel Level 2
S.L. British Gypsum, Excel Level 2
B.M. Direct Rail Services, Excel Level 2
C.L. Direct Rail Services, Excel Level 2
S. Nissan, Excel Level 2
C.D. nissan nmuk, Excel Level 2
N.R. Northern Powergrid, Excel Level 2
T.W. Stobart Rail Ltd, Excel Level 2
S.F. Nissan, Excel Level 2
C.W. Nissan, Excel Level 2
H.M. Nissan, Excel Level 2
A.P. Siemens, Excel Level 2
P.C. Hodgson Sayers Ltd, Excel Level 2
M.S. Nissan, Excel Level 2
A.M. Nissan, Excel Level 2
Public Scheduled Course Dates
Date | Location | Price | |
24 Sep 2024 | Virtual |
£245
|
|
09 Oct 2024 | Newcastle |
£375
|
|
14 Oct 2024 | Durham |
£295
|
|
24 Oct 2024 | Virtual |
£245
|
|
21 Nov 2024 | Virtual |
£245
|
|
04 Dec 2024 | Durham |
£295
|
|
18 Dec 2024 | Virtual |
£245
|
|
14 Jan 2025 | Virtual |
£245
|
|
29 Jan 2025 | Durham |
£295
|
|
05 Feb 2025 | Newcastle |
£375
|
|
19 Feb 2025 | Virtual |
£245
|
|
20 Mar 2025 | Durham |
£295
|
|
26 Mar 2025 | Virtual |
£245
|
|
08 Apr 2025 | Durham |
£295
|
|
28 Apr 2025 | Virtual |
£245
|
|
21 May 2025 | Virtual |
£245
|
|
18 Jun 2025 | Virtual |
£245
|
|
09 Jul 2025 | Durham |
£295
|
|
24 Jul 2025 | Virtual |
£245
|
|
04 Aug 2025 | Newcastle |
£375
|
|
21 Aug 2025 | Virtual |
£245
|
|
08 Sep 2025 | Durham |
£295
|
|
23 Sep 2025 | Virtual |
£245
|
|
08 Oct 2025 | Newcastle |
£375
|
|
13 Oct 2025 | Durham |
£295
|
|
23 Oct 2025 | Virtual |
£245
|
|
20 Nov 2025 | Virtual |
£245
|
|
03 Dec 2025 | Durham |
£295
|
|
17 Dec 2025 | Virtual |
£245
|
Private Training
Other Courses In This Training Series
VBA Essentials using 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 Level 3 Course 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 an Excel Level 1 - Essentials 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 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
General Information
Microsoft and Microsoft Excel are Registered Trademarks Microsoft Excel intermediate training courses in North East England, Durham, Washington, Newcastle. Learn how to work Excel templates. Learn how to sort, filter, create, edit, format and print worksheets. Excel Courses. Excel Intermediate training courses in England. Excel Courses in Newcastle, Durham, Washington. Excel Courses in Sunderland, Darlington, Middlesbrough. Microsoft Excel Courses North East England. Microsoft Excel Courses Newcastle, Durham and Washington.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:9/11/2024 1:06:14 AM