Google Sheets Level 1
Course Overview
Google Sheets is a spreadsheet program that can be used for storing, organising and manipulating data.This course will enable delegates to gain a good general understanding of the main features of Google Sheets, giving them the ability to produce standard spreadsheets, create formulae and format and print sheets.
Course Content
-
Exploring the Environment
Accessing Sheets
Exploring the User Interface
Getting Help -
Understanding Workbooks and Worksheets
Creating a new workbook
Saving in Sheets
Opening an existing workbook
Navigating
Selecting and entering data
Saving a workbook in Sheets as a .xlsx file
Upload an existing Excel spreadsheet into Sheets
Downloading your worksheet -
Entering and Editing Data
Entering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
Manipulating data
Undo and redo buttons -
Selecting Data
Select a range of cells
Select more than one range
Select an entire column and row
Highlight the entire worksheet -
Cell Formatting in Sheets
Cell Formats options
Understanding the General Format
Date and Time Formats
Currency and Accounting Formats
Text Formats
Clearing and Resetting Formats -
AutoFill
Using Autofill to automate data entry
Text AutoFill
Number Autofill
Date AutoFill
Custom Lists
Flash Fill -
Columns and rows
Inserting and deleting cells, columns and rows
Changing column widths and row heights
Auto-fitting a column to its contents
Hiding and un-hiding a column or row
Searching for data in a worksheet
Freezing and unfreezing rows and columns -
Formatting a worksheet
Changing fonts
Merging cells
Aligning cell contents
Applying borders to a selection
Deleting borders around a selection of cells
Changing the alignment of the contents of a cell
Using the format painter
Clearing cells (removing formats) -
Developing a workbook
Formatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets -
Cut, Copy and Paste
Cut, Copy and Paste
Shortcuts
Copying and Pasting to different sheets
Paste Options -
Performing calculations
Adding and Subtracting Numbers
Multiplication and Division
BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Basic Sorting and Filtering Data
Sorting data
Filtering data -
Basic Charts
Chart types
Simple Chart Customisations -
Spelling and Printing
Spell checker
Print preview
Printing the spreadsheet
Printing a section of a worksheet -
Sharing and Collaborating
Sharing in Sheets
Emailing a Document as an Attachment
Collaborating in Real-Time
Public Scheduled Course Dates
Private Training
-
Public Dates
Prices per delegate. All prices exclude VAT.22 Aug 2025Virtual£29529 Oct 2025Virtual£29519 Dec 2025Virtual£295Private Courses
Private courseFlexible date and locationPlease quote for prices -
Google Sheets Level 1 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
T.W. Watmos, Outlook Overview and MS Teams for Hosts
A. Kookaburra, Microsoft Power BI Desktop
R.B. NOCN, Microsoft Power BI Desktop
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
S.H. Macmillan Cancer Support, Microsoft Power BI Desktop
T. Westrock, VBA Essentials using Excel
A.B. UMi Commercial Ltd, Google Analytics Essentials
D.H. , Excel Level 2
Public Scheduled Courses
Private Courses
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:7/14/2025 1:44:52 AM