Training course

Google Workspace Essentials

The course is an introduction to Google Workspace. It will help users format, manage and present data effectively and improve workflow and team collaboration.

  • 1 Day
  • Online or in person
  • Private courses available
Download outline (PDF)

Course content Back to top

  1. Introduction to Drive
    Accessing Drive
    What is Drive?
    Exploring the User Interface
    Getting Help
    Creating a Folder
    Moving Files into a Folder
    Deleting Files from Drive
  2. Introduction to Google Docs
    What is Docs?
    Create a New Document
    Saving in Docs
    Naming a Document
    Uploading an Existing Word Document into Docs
    Downloading your Document as a .docx
  3. Editing and Formatting
    Selecting Techniques
    Formatting Text
    Formatting Paragraphs
    Borders and Shading
    Clear Formatting
    Cut, Copy and Paste
    Find and Replace
  4. Introduction to Google Sheets
    What is Sheets?
  5. 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
  6. 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
  7. Selecting Data
    Select a range of cells
    Select more than one range
    Select an entire column and row
    Highlight the entire worksheet
  8. 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
  9. AutoFill
    Using Autofill to automate data entry
    Text AutoFill
    Number Autofill
    Date AutoFill
    Custom Lists
    Flash Fill
  10. Introduction to Google Slides
    What is Slides?
  11. Creating a Presentation
    Creating a presentation
    Adding slides to a presentation
    Working with themes
    Entering and editing text
    Navigating through a presentation
    Presentation views
    Saving in Slides
    Downloading your Google Slides presentation as a .pptx file
    Uploading a PowerPoint presentation into Slides
  12. Formatting Text on Slides
    Character formats
    Paragraph formats
    Formatting text placeholders
  13. Slide Transitions
    Adding Transitions to slides
    Modifying and Removing Transitions
  14. Animations
    Adding Animation
    Modifying or Removing Animations
  15. Running the Slide Show
    Starting the Slide Show presentation
    Slide Show presentation options

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.

What delegates say Back to top

“Great course”
R.B., Microsoft Teams in Office 365 Essentials

Following this training what are you going to do differently

“Create my own metrics. Analyse statistics”
J.C., Cmr Uk Ltd, Excel Level 3
“Another very useful course that will help me in my job role, brilliant, thank you.”
L.B., Greggs, Excel Analysing and Presenting Data with Dashboards and Pivot Tables
“Really enjoyed the training and found it useful.”
K.M., Durham County Council, Microsoft Power BI Desktop
“Great teaching, tailored to my requirements as I already had some knowledge”
B.E., Nordem Ltd, Sage Accounts Level 1
“Trainer was very enthusiastic about Excel and how it could help. I found it quite infectious!”
A.S., The Hr Dept, Durham & Newcastle South, Excel Level 3
“To be honest, every part of the training is very valuable. The most valuable though is vlookup”
A., Faltec Europe Ltd, Excel Level 2
“An all round great course, thanks once again.”
S.F., Nissan, Excel Level 2

Please contact us to discuss your Google Workspace Essentials 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 Workspace Essentials 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 Workspace Essentials course.

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