Skip to main content

Getting Started with Google Sheets

Before each live online session, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

This class offers an option for in-classroom sessions. Participants attending an in-person class will need to adhere to the respiratory illness policies.

Learn the basics of Google's spreadsheet application and see how it implements equivalent Excel features and offers more by being hosted in the cloud.

By the end of the course, you will have the opportunity to learn how to create Google Sheets and work with formulas, functions, filtering data, and creating a pivot table.

David Casuto

David Casuto

David Casuto is a 20-year veteran in the fields of software training, curriculum design, and training facilitation.

Learning Objectives
By the end of this course, learners will have had the opportunity to: 
  1. Create and format Google Sheets, including modifying columns, rows, and cells, and working with multiple sheets to organize data efficiently.
  2. Utilize formulas and functions effectively, understanding types of cell references and number formats to perform calculations and data analysis.
  3. Organize and analyze data by sorting, filtering, and creating pivot tables to extract meaningful insights.
  4. Import Microsoft Excel sheets into Google Sheets, enabling seamless data manipulation and platform integration.
Topic Outline
  • Modifying columns, rows and cells
  • Formatting cells
  • Working with multiple sheets
  • Creating simple formulas
  • Types of cell references
  • Working with functions
  • Sorting and filtering data
  • Understanding number formats
  • Creating a Pivot Table
  • Importing MS Excel sheets into Google Sheets
Credits
  • 3 Professional Development Units (PDU)
  • 0.3 Continuing Education Units
  • 3 Professional Development Hours 
  • Stanford Technology Training Program Certificate of Completion Awarded

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training.

Special Group Rates

For groups of 5 or more, special rates are available. Please contact techtraining@stanford.edu for more details.

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.