Course
Google Sheets Level 1
Course Duration
1 Day
Public Scheduled Dates
<<
<
>
Public scheduled prices per delegate +VAT
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Course Content
-
Exploring the EnvironmentAccessing Sheets
Exploring the User Interface
Getting Help -
Understanding Workbooks and WorksheetsCreating 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 DataEntering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
Manipulating data
Undo and redo buttons -
Selecting DataSelect a range of cells
Select more than one range
Select an entire column and row
Highlight the entire worksheet -
Cell Formatting in SheetsCell Formats options
Understanding the General Format
Date and Time Formats
Currency and Accounting Formats
Text Formats
Clearing and Resetting Formats -
AutoFillUsing Autofill to automate data entry
Text AutoFill
Number Autofill
Date AutoFill
Custom Lists
Flash Fill
-
Columns and rowsInserting 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 worksheetChanging 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 workbookFormatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets -
Cut, Copy and PasteCut, Copy and Paste
Shortcuts
Copying and Pasting to different sheets
Paste Options -
Performing calculationsAdding and Subtracting Numbers
Multiplication and Division
BODMAS
Cell references
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT -
Basic Sorting and Filtering DataSorting data
Filtering data -
Basic ChartsChart types
Simple Chart Customisations
-
Spelling and PrintingSpell checker
Print preview
Printing the spreadsheet
Printing a section of a worksheet -
Sharing and CollaboratingSharing in Sheets
Emailing a Document as an Attachment
Collaborating in Real-Time
Learn with IT Training Solutions. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
Please contact us to book a place or request a quote for your course.
-
Course Options
Please contact us to discuss options for this courseVirtualVirtualThese courses can be attended from anywhere.PrivatePrivateFlexible content, flexible date, flexible location, variable 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
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/19/2024 4:26:21 PM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/19/2024 4:26:21 PM