This comprehensive one-day class teaches you how to create, edit, share, and print documents efficiently using Google Sheets. The class is particularly recommended for users seeking a deeper understanding of Google Sheets functionality or those transitioning to Google Workspace from other office productivity suites such as Microsoft Office. You will gain practical skills to manage spreadsheets effectively in a modern cloud-based environment.
Prerequisites:
To ensure your success in this course, you should possess end-user computer skills, including the ability to start and switch between programs, locate and manage saved files, close applications, and navigate websites using a web browser.
Who Should Not Attend:
If you have never used a spreadsheet program before, this class may not be appropriate for you. The course moves at a fast pace and assumes you understand fundamental spreadsheet concepts. This class is designed for individuals who already know how to perform tasks in Microsoft Excel and simply need to learn how to accomplish the same tasks using Google Sheets.
Course Outline:
Getting Started
- Signing in to Google Workspace apps
- Using the Google Workspace apps menu
- Accessing Sheets from Google Drive
- Creating a copy of a spreadsheet
- Understanding the display screen layout
- Using the menu and toolbar features
- Accessing help resources
Entering Data
- Changing the active cell in a spreadsheet
- Selecting a range of cells
- Creating a new spreadsheet from a template
- Creating and naming a new spreadsheet
- Inserting, renaming, and deleting sheets
- Entering constant values and using autofill features
- Modifying cell contents and data
- Closing a spreadsheet
Using Formulas
- Entering formulas in cells
- Using autofill with formulas
- Using the SUM function
- Using common formulas and functions
- Correcting formula errors
Modifying Sheet Data
- Copying and pasting constant values and formulas
- Cutting and pasting constant values and formulas
- Checking spelling in your spreadsheet
- Using find and replace functionality
- Working with document versions
- Viewing spreadsheet details and history
Formatting Sheets
- Formatting numbers and currency
- Formatting text and fonts
- Formatting cells and cell borders
- Aligning cell contents
- Using paint format tools
- Using alternating row colors
- Changing the spreadsheet theme
- Using conditional formatting rules
Modifying Columns and Rows
- Moving columns or rows
- Resizing columns and rows
- Inserting columns or rows
- Deleting columns or rows
- Hiding columns or rows
- Grouping columns or rows
- Freezing and unfreezing columns or rows
- Using zoom functionality
Printing Sheets
- Previewing a sheet for printing
- Working with print settings and options
- Inserting page breaks
- Creating headers and footers
- Repeating row and column headers on each page
- Printing a sheet
Working with Charts and Pictures
- Creating a chart
- Changing the chart location and size
- Working with the chart editor setup options
- Working with the chart editor to customize options
- Inserting an image
- Creating a drawing
- Editing a drawing
