Training course

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
Download outline (PDF)

Course content Back to top

  1. 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
  2. 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
  3. Naming Cells (Ranges)
    Giving names to cells and ranges of cells
    Names in formulas
    Editing and deleting names
  4. Linking within a workbook
    Linking within a workbook
    Simple referencing in a worksheet
    Calculating across multiple sheets
  5. Calculating Data with Logical Functions (IF Function)
    IF functions
    IF function criteria
    Using IF’s to test or check your data
  6. Conditional Formatting
    Conditional Formatting Types
    Highlight Cells different colours based on their value
    Single colour and colour scales
    Customising Conditional Formatting
  7. Performing Date and Time Calculations
    Date Shortcuts
    TODAY and NOW functions
    DATEDIF function
    YEAR, MONTH, DAY, TEXT functions
    NETWORKDAYS function
  8. Comments
    Adding, Editing and Deleting Comments
  9. Cleaning Data
    Remove Duplicates
    Trim whitespace
    Use Clean up suggestions
  10. Data Validation
    Specifying validation criteria
    Controlling entry into a cell
    Types of Validation Criteria
    Creating a drop-down list
  11. Security
    Protecting a range or a worksheet
  12. Presenting Data Using Charts
    Creating a chart
    Modifying charts
    Formatting charts
    Advanced Chart Features
  13. Slicers
    Using Slicers
  14. 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

    Virtual, live online 9:30–16:30

    £355+ VAT

  • Thursday 4 March 2027

    Virtual, live online 9:30–16:30

    £355+ VAT

  • Tuesday 18 May 2027

    Virtual, live online 9:30–16:30

    £355+ VAT

  • Thursday 22 July 2027

    Virtual, live online 9:30–16:30

    £355+ VAT

  • Thursday 23 September 2027

    Virtual, live online 9:30–16:30

    £355+ VAT

  • Thursday 25 November 2027

    Virtual, live online 9:30–16:30

    £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

  • Virtual These courses can be attended from anywhere.
  • 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 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.

What delegates say Back to top

Any other comments or recommendations

“Very worth attending”
T., 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
“Following this course, the reports that we will create will be more robust and interactive”
G.S., Northern Power Grid, Microsoft Power BI Desktop
“All aspects of the course were valuable”
J.C., William Smith, VBA Essentials using Access

Following this training what are you going to do differently

“Going to adopt using one drive as my default storage solution”
N.D., Leeds and Yorkshire Houisng Association, OneDrive Essentials
“Have had quite a bit of clerking and minuting experience previously but this was a good all around refresher of key skills, things to think about and new ways of working when it comes to minuting”
I.T., Hmpps, Minute Taking

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”
C.P., Excel Level 2

What were the most useful aspects of the course

“I already knew a bit about indesign but compound paths and gradients were new to me.”
R.R., Egger, Adobe InDesign Level 1

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.

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/23/2026 11:52:57 PM