Google Sheets Level 2
In Google Sheets 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 delegates for this course are those 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 content Back to top
-
RECAP of performing calculations in Sheets
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 the Dollar Sign
Why use Absolute References?
Using an Absolute Reference in a formula -
Naming Cells (Ranges)
Giving names to cells and ranges of cells
Names in formulas
Editing and deleting names -
Linking within a workbook
Linking within a workbook
Simple referencing in a worksheet
Calculating across multiple sheets -
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
Single colour and 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 -
Cleaning Data
Remove Duplicates
Trim whitespace
Use Clean up suggestions -
Data Validation
Specifying validation criteria
Controlling entry into a cell
Types of Validation Criteria
Creating a drop-down list -
Security
Protecting a range or a worksheet -
Presenting Data Using Charts
Creating a chart
Modifying charts
Formatting charts
Advanced Chart Features -
Slicers
Using Slicers -
Sharing and Collaborating
Sharing in Sheets
Emailing a Document as an Attachment
Collaborating in Real-Time
Public dates and prices Back to top
Prices are per delegate and exclude VAT.
-
Thursday 26 November 2026
£355+ VAT
-
Thursday 4 March 2027
£355+ VAT
-
Tuesday 18 May 2027
£355+ VAT
-
Thursday 22 July 2027
£355+ VAT
-
Thursday 23 September 2027
£355+ VAT
-
Thursday 25 November 2027
£355+ 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
“I found learning about data relationships and models particularly helpful. More generally, being able to build a report excel dashboard from scratch is going to change the way I work for the better.”
“GREAT COURSE, WELL PRESENTED!!”
Any other comments or recommendations
“The trainer was excellent”
“Very good course would recommend to anyone needing upskilling.”
“Really enjoyable”
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.”
“Very friendly and helpful trainer, very knowledgeable.”
Which part of the course did you find particularly valuable
“The whole course was very informative”
Please contact us to discuss your Google Sheets Level 2 course, we have many solutions available to ensure you receive the best training possible.
Learn with IT Training Solutions. Small course sizes. Course materials included. Flexible Google Sheets Level 2 course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account. Please contact us to booka place or get a quote for your Google Sheets Level 2 course.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/25/2026 11:50:53 PM