Google Sheets - Beginner

Explore Google Sheets, a web-based spreadsheet program similar to Excel, enabling you to enter, sort, filter data, and create charts and pivot tables.

Access Google Sheets from sheets.google.com or Google Drive, using Chrome for best performance; sign in with a Google account, then create new sheets or open existing ones, or use templates.

Learn how Google Sheets opens and edits Excel files, converts them to Google Sheets, and imports or uploads spreadsheets from Google Drive to new sheets while preserving originals.

Navigate Google Sheets from the home page to open files, rename spreadsheets, and manage drive folders; use menus for file, edit, formatting, data, and help, including multi-sheet navigation.

Explore the fundamental components of Google Sheets, including the formula bar, cells and cell references, the name box, ranges, columns and rows, and managing multiple sheets.

Explore Google Sheets file menu to create new sheets from blank or templates, import and convert Excel files, share, publish to the web, and manage versions, offline access, and printing.

Create a new spreadsheet from anywhere—within a current sheet, Sheets home, or Google Drive—by choosing a blank spreadsheet or a template and naming it.

Google Sheets saves your work automatically as you edit, so you never need to press save and you see it saved to drive.

Explore the Google Sheets help menu to search menus, including conditional formatting, and launch features. Access training, updates, function list, and keyboard shortcuts to navigate efficiently and get guidance.

Navigate Google Sheets by mouse or keyboard. Learn shortcuts such as arrow keys, tab, enter, shift, and ctrl+arrow to move quickly through data, and access the help menu for shortcuts.

Learn how to select cells and ranges in Google Sheets using mouse and keyboard, including contiguous and noncontiguous selections, shift and control shortcuts, and applying formatting across multiple ranges.

Learn essential Google Sheets commands, including undo and redo with keyboard shortcuts Ctrl+Z and Ctrl+Y, right-click quick actions, and insert/delete rows and columns.

Learn to cut, copy, and paste in Google Sheets, including paste values, paste special options (formatting, formulas, data validation), and transpose to switch rows and columns.

Understand how text, numbers, dates, and dollar amounts are handled in Google Sheets, and how data types influence formatting, sorting, and filtering in pivot tables.

Learn how to format numbers in Google Sheets using currency, accounting, and percent styles, adjust decimal places, and apply custom formats for clear data presentation.

Learn to use the autofill handle in Google Sheets to quickly fill months, days, numbers, and patterns, copy formatting, and extend formulas and dates across cells.

Add links in Google Sheets to connect cells, other sheets, or external sites using insert link, ctrl k, or right-click, then customize the displayed text and destination.

Understand the difference between formulas and functions in Google Sheets. Formulas perform manual calculations with operators like =A1+B1, while functions use built-in presets such as =SUM(A1:Z1).

Explore the components of formulas and functions in Google Sheets, including the leading equals sign, operators, and how to reference cells and ranges. Learn about constants and predefined functions.

Learn how Google Sheets follows the order of operations (Pemdas) and how parentheses control calculation order when building formulas, including averaging monthly totals.

Compare constants and cell references in basic formulas using sales data, showing how references auto-update totals and commissions for the northeast division in quarter one.

Explore how to sum numbers with the sum function, calculate averages, and find maximum and minimum values using cell ranges and built-in functions in Google Sheets.

Explore absolute, relative, and mixed cell references in sheet formulas, and learn how autofill and keyboard toggling with F4 ensure totals, averages, and commissions stay correct.

Learn to format numbers and text in Google Sheets, including currency and date formats, and apply alignment, wrapping, rotation, and fonts to enhance data readability.

Explore how to manage and email students quickly through Google Classroom, including emailing individuals or groups, muting students, and sending class-wide reminders from Gmail.

Apply borders and fills to your Google Sheets data, selecting border options (all, inner, outer), colors, and styles; use fills and alternating colors to enhance readability and emphasis.

Copy cell formatting across Google Sheets using the format painter, applying bold, font size, and rotation to selected destinations, with limited sticky mode and manual, one-at-a-time application.

Learn to insert notes and comments in Google Sheets to convey information without editing cells, using shortcuts, mentions, and the ability to mark comments as resolved and view history.

Insert checkboxes in google sheets by selecting a cell, choosing insert, and clicking checkbox. The formula bar shows false when unchecked and true when checked, enabling basic if logic.

Apply a theme in Google Sheets to quickly format fonts, colors, and borders. Preview presets like retro or ocean, customize fonts and axis colors, and finish with done.

Learn to adjust Google Sheets view with zoom tools, using the ribbon dropdown (50–200%), the view menu, and browser zoom (ctrl+scroll) for comfortable reading.

Learn to add, delete, and navigate multiple sheets in a Google Sheets file, using the plus sign, right-click delete, and the all-sheets menu for quick jumps.

Learn to organize Google Sheets by renaming and color-coding tabs, reordering tabs, and duplicating or copying sheets across or within spreadsheets, including deleting unused sheets.

Hide a sheet to remove it from view without deleting it. Unhide it later, or use the view hidden sheets option to see all sheets.

Learn how to sort data in Google Sheets, choosing between sort sheet and sort range, use headers and advanced sort options to group by division and order by totals.

Filter data in Google Sheets using filters and filter views to narrow rows by criteria. Filter by division and totals under a threshold, with conditional filters and clear active filters.

Create, save, and share targeted filter views in Google Sheets to preserve specific data views, then switch between northeast, northwest, southeast, and southwest segments without losing work.

Freeze panes to keep headers or labels visible as you scroll in Google Sheets. Freeze up to a row or column, adjust by dragging, and handle merged cells.

Use find and replace in google sheets to clean data, locating with ctrl f and replacing with control h, with options like match case and match entire cell contents.

Master spell check in Google Sheets by using the tools menu to run spelling across all sheets, fix errors, and build a personal dictionary before sharing or printing.

Learn how to prepare a google sheets sheet for printing by adjusting print settings, paper size, orientation, margins, headers and footers, and repeating headers for multi-page output.

Learn how to adjust Google Sheets settings, focusing on calculation options, date-time formatting with now, and locale and time zone to format currency and numbers correctly.

Finalize printing by selecting the data range, previewing, freezing header panes, and saving as pdf for easy digital sharing.

Discover how to share Google Sheets by downloading a copy or emailing it directly. Choose pdf, excel, or csv formats and send to recipients who may not use Google Sheets.

learn how to share a Google Sheets file, choose viewer, commenter, or editor access, manage link sharing from the share menu, and explore publish or download options.

Learn how to insert charts in Google Sheets, choose chart types, and tailor visuals by selecting data ranges from January through March and totals to reveal sales patterns.

Format and customize charts in Google Sheets by editing charts, adjusting chart style, titles, axis labels, series colors, gridlines, and legends to clearly convey quarter one sales.

Move and resize charts on a sheet using corner handles to preserve proportions. Export as png, svg, or pdf, then copy charts to a new sheet to build a dashboard.

Learn how to create and customize scorecard charts in Google Sheets, showing January totals, max, min, and average with simple aggregate options and dynamic updates.

Insert images into google sheets using two options: into a cell or over cells, with sources like upload, browse, google drive, google photos, webcam, or a URL.

Learn to insert drawings in Google Sheets, create and customize shapes, arrows, callouts, and lines, add text or freeform sketches, and insert the drawing into your sheet.

Demonstrates Google Sheets’ compatibility with Excel, including uploading, editing, converting between formats, and live collaboration in Google Workspace, with formulas, formatting, and sharing options.