Google Sheets training classes near me in San Diego

Google Sheets Beginning


This class is intended for:

Windows / Mac Users
Certificate of Completion (optional): $5
Course Length: 1 Day

san diego google sheets training classes

Google Sheets Basics:


Recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Google Sheets. Great refresher course for students who haven't used Google Sheets in a long time.

Learn how to navigate the Google Sheets user interface. Create, Open, Close, Save, Preview, and Print a variety of different spreadsheets. Spreadsheet design principles and "best practices" will also be covered. Lots of tips and tricks are included so you'll know how to get the most out of Excel.

google sheets spreadsheet


Calculate with Formulas:


Use Formulas to add, subtract, multiply, and divide numbers, calculate percentages. Learn how to AutoFill (copy) Formulas. Understand cell references in formulas so you can perform basic calculations. Much of the class will be devoted to creating formulas.

Basic Functions:


  • Average (average a range of cells)
  • Max (display highest number in a range cells)
  • Min (display lowest number in a range of cells)
  • Sum (sum or total of a range of cells)

Formatting:


Add borders and background colors to cells, center, bold, italicize, and change font/font size. Learn the 6 most common number formats, including currency and percentages.

Edit a Spreadsheet:


Select, copy, move, format, and delete text and numbers. Insert and delete sheets, columns, and rows. Resize columns and rows. Sort data. Add graphics and SmartArt diagrams, rename a spreadsheet tab, change tab colors, etc.

Work with Large Spreadsheets:


Use Freeze Panes so column and/or row headings always remain visible as you scroll. Hide / unhide columns and / or rows. Learn about various printing options, including how to fit everything on one page. Make titles (column headings) print on every page. Add headers and footers, page numbers, logos, etc.

Charts:


Create and Edit a variety of different dynamic (automatically updating) charts, change chart types, apply Styles and Layouts to charts, format individual elements in a chart, etc. Create Sparkline charts (small charts that occupy a single cell).

google sheets chart


enroll in google sheets class

Computers Etc. Software Training Center, Inc.
6920 Miramar Road - Suite 206
San Diego, CA 92121
858-578-9476