Training Course
Google Sheets Level 2
1 Day
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.
Public Scheduled Course Dates
Prices per delegate. All prices exclude VAT.
28 Nov 2024
Virtual Course
attendance
20 Mar 2025
Virtual Course
attendance
20 May 2025
Virtual Course
attendance
24 Jul 2025
Virtual Course
attendance
25 Sep 2025
Virtual Course
attendance
27 Nov 2025
Virtual Course
attendance
Private Training
Flexible dates, location and content. All prices exclude VAT.
Google Sheets Level 2 Course Content
-
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 Scheduled Course Dates
Prices per delegate. All prices exclude VAT.
28 Nov 2024
Virtual Course
attendance
20 Mar 2025
Virtual Course
attendance
20 May 2025
Virtual Course
attendance
24 Jul 2025
Virtual Course
attendance
25 Sep 2025
Virtual Course
attendance
27 Nov 2025
Virtual Course
attendance
Private Training
Flexible dates, location and content. All prices exclude VAT.
-
Google Sheets Level 2 Course Options
Please contact us to discuss options for this courseVirtualVirtualThese courses can be attended from anywhere.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.
- Virtual Training
Training was pitched at right level, adapted for skill set of attendees, involved everyone and we all learnt something to put into practice
T.W. Watmos, Outlook Overview and MS Teams for Attendees
It was excellent
J.B. Tyne and Wear Pension Fund, PowerPoint Essentials
Are there any aspects of the course which you feel require improvement
No, I feel that the pace was good and the way that the training was setup with a ';lecture'; period followed by a ';practical'; period is a good way of learning.
D.W. Deepocean, Microsoft Project Essentials
Following this training what are you going to do differently
Loads the way I interpret data and present it
N.S. Burnetts Solicitors, Excel Level 2
Everything was clear and straight forward
A.S. Hitachi CMUK, Excel Level 1 Essentials
Thought provoking, extremely interesting
R.C. Alnwick Medical Group, Coaching and Mentoring
[The trainer] explained everything really well at a good pace. I felt I have learnt a lot of new skills which I shall try to put into practice.
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
I can now use Project to generate reports for weekly meetings, presentations etc. More generally confident in my use of Project.
C.S. Seymour Civil Engineering, Microsoft Project Essentials
Public Scheduled Course Dates
Prices per delegate. All prices exclude VAT.
28 Nov 2024
Virtual Course
attendance
20 Mar 2025
Virtual Course
attendance
20 May 2025
Virtual Course
attendance
24 Jul 2025
Virtual Course
attendance
25 Sep 2025
Virtual Course
attendance
27 Nov 2025
Virtual Course
attendance
Private Training
Flexible dates, location and content. All prices exclude VAT.
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 book a place or request 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:11/10/2024 8:53:58 PM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:11/10/2024 8:53:58 PM