Google Sheets Level 1

1. Exploring the Environment

   Accessing Sheets
   Exploring the User Interface
   Getting Help
2. 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
3. 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
4. Selecting Data

   Select a range of cells
   Select more than one range
   Select an entire column and row
   Highlight the entire worksheet
5. 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
6. AutoFill

   Using Autofill to automate data entry
   Text AutoFill
   Number Autofill
   Date AutoFill
   Custom Lists
   Flash Fill
   
7. 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
8. 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)
9. Developing a workbook

   Formatting worksheet tabs
   Repositioning worksheets in a workbook
   Inserting and deleting worksheets
   Copying and pasting worksheets
10. Cut, Copy and Paste

    Cut, Copy and Paste
    Shortcuts
    Copying and Pasting to different sheets
    Paste Options
11. Performing calculations

    Adding and Subtracting Numbers
    Multiplication and Division
    BODMAS
    Cell references
    SUM function
    AUTOSUM
    Useful Basic Functions AVERAGE, MIN, MAX and COUNT
12. Basic Sorting and Filtering Data

    Sorting data
    Filtering data
13. Basic Charts

    Chart types
    Simple Chart Customisations
    
14. Spelling and Printing

    Spell checker
    Print preview
    Printing the spreadsheet
    Printing a section of a worksheet
15. Sharing and Collaborating

    Sharing in Sheets
    Emailing a Document as an Attachment
    Collaborating in Real-Time
    

Can't make these dates? Ask about a private course on a date that suits you.