Google Workspace: 6-Course Bundle

Discover how to use styles in Google Docs to format and organize text by applying title, subtitle, and normal text formats, and navigate long documents with the document outline.

Modify heading one by adjusting font size, bold, color, and other formatting. Update heading one across the document with the styles box and undo.

Save your styles as default to apply them to new Google Docs. Access format, paragraph styles, options, then save as my default styles or reset styles to Google defaults.

Use Google Docs document outline to navigate long documents by viewing and organizing headings. Add or remove entries with the View menu or by right-clicking, and jump to sections quickly.

Learn to create and format bulleted lists in documents, choose bullet shapes, nest lists using indent and increase and decrease controls, and apply quick formatting via the format menu.

Learn how to customize bullet lists in Google Docs by changing bullet styles, using special characters such as arrows and emojis, and starting bullets with keyboard shortcuts.

Create and customize numbered lists in your documents using keyboard shortcuts. Manage multi-level lists with indentation, auto-updating numbering, and formats like parentheses or letters.

Learn to customize documents by using tabs, hanging and left indents, and ruler-based tab stops. Set left, center, and right tab stops to align items.

Add a table in Google Docs via the insert menu, hover to select up to 20 columns and rows. Type in cells, use tab to move, and backspace to delete.

Format text in table cells by selecting text or rows, applying bold or color changes, and adjusting alignment (left, center, middle, top, bottom) and table properties to control cell layout.

learn to merge cells in Google Docs tables by selecting cells, right-clicking, and choosing merge cells; undo restores previous formatting if needed.

Format your table by adjusting borders and shading for improved readability. Select the whole table, choose border color and thickness, switch line styles, and apply background colors through table properties.

Learn to insert and manage section breaks in Google Docs to format different sections, adjust margins per section, view blue dotted lines, and apply page setup options.

Learn to modify column layouts in google docs by adjusting columns, spacing, and lines, managing column and section breaks, and moving content between columns with undo.

Learn to insert and manage footnotes to cite data and add notes, using the insert menu, quick footnote, and the keyboard shortcut, while numbering updates as you move text.

Learn to add bookmarks in Google Docs using the insert menu. Link to bookmarks within your document for quick navigation.

Insert and edit hyperlinks in Google Docs, copy or unlink links, and customize link text. Use bookmarks, cloud search, and recent Google suite files to find and apply links.

Learn to edit, remove, and insert hyperlinks in your document, adjust link text, manage bookmarks, and search Drive or the web to link specific files.

Enable voice typing in Google Docs via tools > voice typing, start the microphone, select the correct language, speak clearly, and edit or insert text as it transcribes.

Learn to use voice typing and voice commands in Google Docs, accessed via tools > voice typing. Commands cover selecting text, formatting, editing, and navigation in English.

Learn how to save recurring phrases in Google Keep, pin them for quick access, and insert them into documents using the Keep menu and the add to document feature.

Learn how Google Drive automatically saves Google Docs, records changes in version history, and lets you rename, restore, or copy named versions to compare edits.

Navigate the add-ons menu to discover, preview, and install tools for Google Docs, Sheets, and Drive, including bibliography, diagrams, and mail merge with reviews and updates.

Explore formatting with styles for headings and body text, manage long documents with a table of contents and bookmarks, and collaborate using comments, sharing, and email attachments.

Begin your Google Sheets journey as you learn to get started, interpret data, master formula basics, format and manage spreadsheets, print, and create charts and graphics.

Explore how a Google Sheets worksheet is built, from the formula bar and cell references to columns, rows, and adding or navigating between sheets.

Explore the file menu essentials in Google Drive and Sheets, including sharing links, creating new documents and templates, importing, exporting, saving offline, and accessing version history and settings.

Learn to create a new blank spreadsheet in Google Sheets from the Sheets UI, Drive, or templates, name and locate it, and fill in using a monthly budget template.

Learn how cells intersect columns and rows and what a cell reference is. See how formulas use cell references and both continuous and non-continuous ranges to calculate values.

Explore data selection in spreadsheets using click and drag for continuous ranges, shift and arrow keys to extend or refine selections, and control to select noncontiguous ranges.

Master copying and pasting in spreadsheets using cut, copy, paste, and keyboard shortcuts, plus paste special to control values, formatting, formulas, and data validation, including relative references and transposing.

Format data types by applying currency and accounting formats, adjust decimals, format percentages, explore more formats and custom number formats.

Learn how to use the autofill fill handle to quickly populate months, days of the week, dates, numbers, and formulas, and to copy formatting across cells.

Learn how to insert links in Google Sheets, linking to other sheets, cells, or external URLs, and manage links with right-click options and the insert link menu.

Explore the difference between formulas and functions in Google Sheets, learning how formulas are user-created and functions are built-in with their inputs inside parentheses.

Master how Google Sheets follows the Pim Dos order of operations, including parentheses, exponents, multiplication, division, addition, and subtraction, and see how parentheses alter a formula's result.

Create basic formulas and learn constants versus cell references, showing how cell references auto-update totals and commission rate as values change.

Master relative, absolute, and mixed cell references in formulas, and how fill down or copy-paste adjusts them. Use dollar signs to lock rows or columns and preserve constants.

Explore the explore feature to analyze highlighted data, insert charts, and apply basic formulas. Practice with the project file to compare formulas and functions in Sheets.

Apply fill colors and borders to header and table areas, adjust formatting with bold text, and use format painter; explore alternating colors for table styles to customize visuals.

Use the format painter to duplicate formatting across the sheet; select a formatted cell, click the format painter, and paste, since there is no sticky double-click option.

Insert notes and comments in a shared Google Sheets file; notes appear as hover indicators, while comments form threads with history you can view, reply to, and resolve.

Insert checkboxes into cells to produce true or false values that drive formulas, enabling conditional yes or no outputs and lookups from other worksheets.

Explore how to zoom in and out in Google Sheets using the toolbar dropdown and the view menu, adjust percentages, and use the mouse wheel with control for quick zoom.

Add, delete, rename, and reorder sheets to structure a workbook, and navigate between sheets using the bottom sheets bar and the all sheets view.

Hide and unhide sheets to declutter workbooks, protect hidden data in shared environments, and keep formula sources and dropdown lists accessible, using right-click, the sheet arrow, or the view menu.

Explore Google Sheets sorting options, including sorting entire sheets vs. specific ranges, with or without headers, and order data by columns in ascending or descending.

Learn to filter sheets data to show only rows that meet criteria, using dropdown arrows, filter by values or condition, and turning filters on via the data menu.

Learn how to create and use prebuilt filter views to save time, apply division-specific filters (northeast, southeast, northwest, southwest), and help users who may not know how to filter.

Learn to use find and replace in spreadsheets with keyboard shortcuts (Ctrl+F, Ctrl+H), choose search scope, match options, and replace all to update data.

Use spell check in Google Workspace to find and fix misspellings in a spreadsheet before printing, using tools to change, ignore, or add words to your personal dictionary.

Select the exact data (current sheets, whole sheet, or selected cells), then tweak page size, orientation, scaling, margins, gridlines, headers and footers, and repeat frozen rows for a polished print.

Modify general and calculation spreadsheet settings to customize formatting, dates, currency, time zone, and recalculation options, then save the settings.

Finalize your print job by reviewing the print preview, selecting data, and choosing a destination, including saving as PDAF or saving to Google Drive when a printer isn’t available.

Learn how sharing a google sheet creates a single, accessible document for multiple collaborators, enabling real-time coauthoring with configurable permissions (view, comment, edit) via a shareable link or direct invitations.

Navigate chart formatting in Google Sheets, editing the chart to customize style, axis titles, data labels, legend placement, fonts, colors, and grid lines.

learn how to insert images in google sheets, choosing between image in cell or over the cells, uploading from drive or pasting a url, and resizing with handles.

Learn to insert and edit drawings in a spreadsheet, using a drawing canvas, line, arrow, shapes, text box, image, word art, and download options to create and place a logo.

Master the explore feature in Google Sheets to save time, make charts, and perform calculations, while using find and replace shortcuts and understanding sharing versus email attachments.

Learn to import data from an Excel file into Google Sheets, choose import options (insert new sheets or replace), and optionally keep the original theme.

Link totals from item lists, fruit lists, beverage lists, and tea lists into a summary sheet in Google Sheets using cell references and sum functions; changes update automatically.

Learn to pull data from another Google Sheets workbook using import range, including setting the source spreadsheet URL, sheet name, and cell range, with first-time permission steps.

Set up protection settings in sheets by locking entire sheets or specific ranges, and assign edit permissions to specific users, using the data > protected sheets and ranges menu.

Versioning activates by default in Google Sheets, saving a new version with each change. View version history, rename or restore versions, and see blue-highlighted edits.

Name a continuous range of cells to reuse in formulas and navigate using plain English range names, while following rules: start with a letter or underscore and avoid spaces.

Create named ranges for sales values across sheets, then navigate quickly to 17, 18, and 19; edit via the pencil and delete via the trashcan as needed.

Use named ranges in formulas to compute the overall total and average from ranges 17, 18, and 19. Learn to rely on autocomplete and easy syntax for reuse across formulas.

Use the iferror function to wrap an average or look-up formula, suppressing errors like division by zero or no values and displaying no data or zero instead.

Compare two lists with vlookup to see if a value exists, fetch sales by product id, and wrap in iferror to display 'no sales' when no match.

Explore text functions for cleaning and joining data, comparing concat, concatenate, and text join to build full names and labeled data with delimiters, including the option to ignore empty cells.

Split joined data into columns with the split text to columns tool, using a delimiter such as dash, and duplicate the original data to preserve it.

Learn how to use left, right, and mid text functions to extract department, division, and extension from an employee code.

Use upper, lower, and proper functions in Google Sheets to standardize text casing, fix names and emails, and replace data with paste special values for clean, consistent data.

Explore date and time functions to calculate between dates, extract year or month, and identify the current date or time, using dynamic today and now and shortcuts for timestamps.

Apply today and now functions to insert current dates and times, compute days since the last review, and determine remaining days in the year with the days between dates function.

Learn to calculate tenure and remaining work days in spreadsheets using yearfrac and networkdays, account for holidays with a holiday list, and use dynamic dates for current year calculations.

Explore how data validation controls data entry by creating dropdown lists from ranges (divisions, departments, health plans), enforcing six-character employee numbers, date constraints, checkbox options, with helpful prompts and lookups.

Apply conditional formatting in a spreadsheet to highlight stock levels, set thresholds, and categorize prices with color scales and rules, including out-of-stock indicators.

learn what a pivot table is and how it queries, organizes, and summarizes repetitive data to create consolidated reports by dropping field headings into pivot areas.

Create a pivot table from a continuous data range, drag fields into rows, columns, and values, adjust totals and averages, move fields, and group by category and product IDs.

Filter pivot table data with report and category filters to view items by category. Use show details to export the underlying values to a new sheet for further analysis.

Create a chart from a pivot table, adjust the data range and fields such as quantity sold, and switch to average to reflect changes in the chart and format dashboards.

Create a form linked to Google Sheets to capture responses, add and customize questions (multiple choice, linear scale, short answer, paragraph, checkboxes, upload), and view results in Google Sheets.

Preview and test Google Forms, submit multiple responses, view results in the form and in Sheets, and manage responses by printing, stopping submissions, or editing questions.

Review key takeaways on using named ranges to simplify formulas and embedding match in index, vlookup, and hlookup for dynamic lookups; capture and view form responses in sheets.

Explore Google Drive, a cloud-based file storage system that lets you access Google or non-Google files from any device, with built-in collaboration and permission controls.

Access Google Drive from your desktop using Chrome, the app launcher, or the drive.google.com URL. Log in with a Google or Gmail account to start using Drive across devices.

Stream your drive files to your computer with drive file stream, access them from an external drive, and set non-google files for offline use.

Create and upload files in Google Drive to collaborate with teammates, using folders, templates, and Google Docs, Sheets, Slides, and Forms, with version history to manage files with identical names.

Learn to organize Google Drive with grid and list views and sorting; adjust density and color folders, preview files, and manage with rename, copy, star, and trash.

Navigate Google Drive's search bar and slash shortcut to locate files quickly. Use simple and advanced search options—filter by type, owner, location, and last modified—to refine results.

Download Google Drive files to work offline. Use the three-dot menu or right-click to download single or multiple files, then organize them into folders or a zip file.

Open and edit various file types in Google Drive, preview documents, and open with Google Docs to edit, while noting that all changes are automatically saved.

Open and convert a Microsoft file in Google Drive, with options to download, preview, or open with Google Docs to create a Google Docs document and keep both formats.

Delete unneeded files in Google Drive by selecting them and clicking remove, or right-clicking to remove, then permanently delete from trash or restore to the original location.

Create and share a folder link, set permissions; anyone with the link can view or edit, copy and email the link, and revoke access by turning off the link.

Learn to permanently delete shared files by moving them to trash and choosing delete forever; non-owned shared files remain accessible to others until deletion, with recovery via the email link.

Learn how to share large files in Gmail by converting oversized attachments to Google Drive links, and use the Drive icon to insert Drive links for multiple files.

Explore Google Drive settings to access features, convert uploads to Google Docs, manage storage, language, offline mode, density, and suggestions, and set your default home page for efficient file management.

Explore Google Chat and Google Meet, two G Suite apps that replace Hangouts and enable quick messaging, audio and video meetings, and shared presentations for remote collaboration.

Access Google Chat and Google Meet using Chrome and the Google Apps grid to sign in with your G Suite account, then launch either app quickly from the upper-right corner.

Learn to send messages from the chat home page by selecting conversations, reading history, and using typing indicators or auto responses, then start conversations or group chats with coworkers.

Explore message options in Google Workspace chat, including toggling history, uploading Drive files, sharing with view and comment access, emojis, formatting, editing or deleting messages, and forwarding to inbox.

Learn to create and manage rooms in Google Workspace chat to organize conversations with multiple threads, add people and bots, customize notifications, and preserve conversation history.

Manage a room by viewing members, messaging individuals, removing or adding members and bots, renaming, starring for quick access, muting notifications, and starting threaded discussions with bold titles.

Use the search feature to locate messages, files, and links across rooms and direct messages, filtering by person, file type, or keyword to retrieve what you need.

Manage conversations and rooms in Google Workspace chat by adjusting notifications, blocking or deleting or hiding chats, and using mentions and following threads to control updates and stay organized.

Explore how bots in Google Workspace act as chat partners to access services, look up information, assign tasks, and schedule meetings, with steps to add, mention, and interact in rooms.

Learn to use the Google Drive bot in chat to receive notifications about new comments, access requests, and files shared with you in a direct message.

Explore Google Chat settings to customize notifications, enable do not disturb for focused work, and manage per-room or per-conversation alerts with smart reply and feedback options.

start a meeting on the spot to add audio and video and invite external contacts. share the joining info or link to bring others into the call.

Learn to schedule meetings using the Meet bot in chat and Google Calendar, including finding available times, adding guests, and creating video calls with Hangouts Meet.

Learn multiple ways to join meetings—from the meet home page and calendar links to nicknames and chat invitations—using video or phone to start collaborating.

Explore Google Meet's essential meeting controls—mute and camera, captions, layouts for up to 250 participants, spotlight and tiling, full screen, plus joining information, attachments, and in-meeting chat.

Learn to present in a meeting using present now, choose between sharing your entire screen or a specific window, and use presenter mode and laser pointer to guide your audience.

Configure audio, video, and general settings from the gear menu, test devices, troubleshoot with help articles, and provide feedback for a smoother meeting experience.

Discover how to use Google Chat on mobile: navigate conversations, share media, start video calls, manage rooms and people, and customize do-not-disturb and notification settings.

Explore how the Google Meet mobile app provides a full, intuitive meeting experience on the go, with pre-join controls, joining options, chat, captions, screen sharing, and schedule access.

Explore chat and meet capabilities in Google Workspace, including group conversations, rooms, threaded topics, bots for automation and scheduling, and presenting with captions for effective remote collaboration.