Course Overview
This course is designed to teach the student the fundamentals of Google Sheets. Students will learn how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Sheets. Additionally, students will learn how to format spreadsheets, manipulate columns and rows, prepare a spreadsheet for printing. Students will also learn how to create and format charts, and insert graphics and images.
Course Objectives
Introduction, Getting Started with Google Sheets, Entering Data, Understanding Formula Basics, Formatting a Spreadsheet, Managing Spreadsheets, Printing a Spreadsheet, Creating Charts, Working with Graphics, Conclusion
Agenda
1 - Introduction
2 - Getting Started with Google Sheets
- What is Google Sheets?
- Opening Google Sheets
- Importing and Converting Spreadsheets to Sheets
- Navigating the Sheets User Interface
- Understanding Sheet Components
- Using the File Menu
- Creating a Spreadsheet
- Saving a Spreadsheet
- Accessing Help
3 - Entering Data
- Navigating a Spreadsheet by Mouse or Keyboard
- Working with Cell and Ranges
- Using Various Data Selection Techniques
- Working with Common Sheet Commands
- Working with Copy and Paste
- Understanding Data Types
- Formatting Values
- Using the Autofill Handle
- Inserting Links
4 - Understanding Formula Basics
- What are Formulas and Functions?
- Understanding the Components of A Formula
- Understanding Calculation Hierarchy and the Order of Operations
- Creating Basic Formulas
- Working with Basic Functions and Autosum
- Using Cell References
- Using Explore
5 - Formatting a Spreadsheet
- Formatting and Aligning Data
- Modifying Columns and Rows
- Using Borders and Fill
- Using Paint Format
- Inserting Notes or Comments
- Inserting Checkboxes
6 - Managing Spreadsheets
- Using Zoom Tools
- Working with Sheets
- Working with Spreadsheet Tabs
- Hiding and Unhiding Spreadsheets
- Sorting Sheets Data
- Filtering Sheets Data
- Using Filter Views
- Using Freeze Panes
7 - Printing a Spreadsheet
- Using Find and Replace
- Using Spell Check
- Preparing a Spreadsheet for Printing
- Changing Spreadsheet Settings
- Finalizing Printing
- Downloading and Emailing Files
- Sharing a Spreadsheet
8 - Creating Charts
- Inserting a Chart
- Formatting a Chart
- Moving and Sizing a Chart
9 - Working with Graphics
- Inserting Images
- Creating Drawings
10 - Conclusion