Google Sheets - Beginner

Price
$29.99
Duration
2 Hours, 47 Minutes
Delivery Method
LearnNow On Demand

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.

 

Purchase This On Demand Title or a LearnNow On Demand subscription

Google Sheets - Beginner
  Buy Now $29.99 Purchase this course for 12 months.
  Buy Now $99.00 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

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
  • 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
  • Course Recap