Google Sheets Introduction (Live Online)

This one-day class will show you how to create, edit, share, and print documents with Google Sheets. The class is recommended for users who would like to get to know Google Sheets in more depth or who are converting to Google Workspace from another office suite such as Microsoft Office.Prerequisites: To ensure your success in this course, you should have end-user computer skills, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.Who Should Not AttendIf you have never used a spreadsheet program before, you should not take this class. The class is fast-paced and assumes you understand the basic spreadsheet concepts. You know how to do things in Microsoft Excel--now you just need to learn how to do the same things in Google Sheets.Course OutlineGetting StartedSigning in to Google AppsUsing the Google Apps MenuAccessing Sheets from DriveMaking a Copy of a SpreadsheetUnderstanding the Display ScreenUsing the Menu and the ToolbarUsing HelpEntering Data:Changing the Active CellSelecting a Range of CellsCreating a New Spreadsheet from a TemplateCreating and Naming a New SpreadsheetInserting, Renaming and Deleting SheetsEntering Constant Values and using AutofillModifying Cell ContentsClosing a SpreadsheetUsing Formulas:Entering FormulasUsing Autofill with FormulasUsing the SUM FunctionUsing Common FunctionsCorrecting Formula ErrorsModifying Sheet Data:Copying and Pasting Constant Values and FormulasCutting and Pasting Constant Values and FormulasChecking SpellingUsing Find and ReplaceWorking with VersionsViewing DetailsFormatting Sheets:Formatting NumbersFormatting TextFormatting CellsAligning Cell ContentsUsing Paint FormatUsing Alternating ColorsChanging the ThemeUsing Conditional FormattingModifying Columns and Rows:Moving Columns or RowsResizing Column or RowsInserting Columns or RowsDeleting Columns or RowsHiding Columns or RowsGrouping Columns or RowsFreezing and Unfreezing Columns or RowsUsing ZoomPrinting Sheets:Previewing a Sheet for PrintingWorking with Print SettingsInserting Page BreaksCreating Headers and FootersRepeating Row and Column HeadersPrinting a SheetWorking with Charts and Pictures:Creating a ChartChanging the Chart Location and SizeWorking with the Chart Editor Setup OptionsWorking with the Chart Editor Customize OptionsInserting an ImageCreating a DrawingEditing a Drawing