Google Workspace: 6-Course Bundle

Master advanced Google Docs features, including styles for headings and lists, tables and charts, page breaks and sections, table of contents, and collaboration with add-ons.

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.

Add or delete rows and columns in Google Docs tables by right-clicking to insert above or below, left or right, or choose delete column, delete table, or undo with ctrl-z.

Adjust rows and columns in your table by dragging to resize, distributing selected columns or rows for even spacing, and applying table properties such as padding and borders.

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.

Discover how to insert and edit charts in Google Docs, link them to Google Sheets, switch chart types (bar, column, line, pie), adjust data, styling, legends, axes, and wrap text.

Insert a chart from Google Sheets into Google Docs by selecting from sheets, importing, and choosing to link for automatic updates or unlink to freeze current data.

Learn how to link and update a chart between Sheets and Docs. Unlink the chart to turn it into a crop-friendly image; you can reinsert from Sheets.

Master page breaks in Google Docs to move content to a new page, create title pages, and format documents efficiently using the insert menu or keyboard shortcuts.

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.

Format a Google Docs document with columns by selecting text and choosing the number of columns. Insert page breaks, column breaks, and section breaks to manage content flow across columns.

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.

Insert a table of contents in Google Docs at your chosen location, choose page numbers, and update it automatically as you add headings.

Learn to use word count tools for pages, words, and characters (including characters excluding spaces), see live counts while typing, and use the dictionary and personal dictionary to add words.

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.

Learn how to translate a Google Docs document into another language using Tools menu and translate document, creating a copy, and saving as Google Docs, with tips to verify accuracy.

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 to add, edit, delete, link, and assign comments in a shared document without changing the text, using the comment button, right-click, or keyboard shortcut, with a visible comment history.

Learn how to manage comments in Google Docs, including tagging teammates with @, replying, granting edit access, sharing, resolving threads, and tracking notifications for collaboration.

Explore suggesting mode in Google Docs to make edits as tracked suggestions, then review and accept or reject changes, add comments, and compare with track changes in Microsoft Word.

Learn how to share Google Docs with individuals or groups, assign roles (viewer, commenter, editor), and set expiration and link options to control access and collaboration.

Explore download options for a finished Google Docs file, using the file menu to choose a format like Word or open format, and save with a chosen name.

Attach a document to an email using the file menu or compose, with auto-filled subject, optional message, and options to attach or send a Google Drive link.

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.

Discover Google Sheets, Google's online spreadsheet program that rivals Excel, enabling data entry, sorting, filtering, charts, pivot tables, and formulas with cloud autosave, version history, and global sharing.

Access Google Sheets via sheets.google.com or Google Drive, create new blank sheets or use templates, and open existing workbooks for quick viewing and editing.

Learn how to upload Excel files to Google Drive, open them in Google Sheets, and convert between Excel and Sheets formats, including import options and saving as Google Sheets.

Navigate the sheets user interface to locate the file name, folder, and favorites, access the file, edit, and view menus, and use explore for quick data analysis.

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.

Google Sheets saves automatically after you name a file, with changes saved in Drive. Move the file to a folder, create new folders, and star it to mark as favorite.

Explore the Google Sheets help feature with searchable menus, commands, and training resources, including keyboard shortcuts and templates, plus updates on new features.

Master spreadsheet navigation using mouse and keyboard shortcuts, including arrow keys, tab, enter, home, and control arrows to move between cells, reach data ends, and switch sheets.

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.

Explore common sheet commands to manage worksheet structure. Use right-click options and shortcuts like Ctrl+Z, Ctrl+Y, Ctrl+C, and Ctrl+V to undo, redo, cut, copy, paste, and insert rows or columns.

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.

Explore how data types determine cell formatting and data handling, from automatic to number, text, date, time, and currency formats, and how alignment and calculations rely on proper typing.

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.

Start every calculation with an equal sign, then master symbols, operators, cell references, ranges, and function arguments separated by commas and colons to build formulas and functions.

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.

Learn how to use functions and autosum for basic spreadsheet calculations. Select the target cell, choose the function, highlight the range, and press enter to see the result.

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.

Explore how to format and align data in a spreadsheet using Google Workspace, applying currency and accounting formats, adjusting decimals, fonts, and alignments, and using wrap and rotation options.

Modify sheets in Google Workspace by inserting rows above and columns to left, delete columns, merge cells (all, horizontally, or vertically) to center headings, and resize or autofit column widths.

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.

Master spreadsheet tab management in Google Workspace: rename, copy, duplicate, delete, color code, and move or add sheets with drag and drop across spreadsheets.

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.

Freeze panes in Google Sheets to keep headings visible while scrolling, by freezing rows or columns. Practice unfreezing and handling merged cells, then use sorting and filtering to manage data.

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.

In a cloud-based workspace, download files in Excel, PDF, CSV, or TSV formats, or as a web page, and email them as attachments.

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.

Insert and customize charts in Google Sheets by selecting data, choosing types like bar and pie, then adjust axes, legends, and switch rows and columns.

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

Move and resize charts, place them on their own sheet, copy and paste while editing, download as image or pdf, and publish or embed charts on the web.

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.

Explore Google Sheets advanced topics, including linking and protecting data, named ranges, logical and lookup functions, text and date functions, working with data, pivot tables, macros, scripts, and forms.

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.

Enable accessibility settings in Google Sheets to support screen readers, screen magnifier, Braille, and collaborator announcements, then practice with the associated project file to build skills.

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.

Explore logical functions and operators, using if statements to evaluate conditions and decide actions based on true or false outcomes.

Learn to use the if statement to apply three percent or two percent commissions based on sales reaching two million, with absolute references and copying down.

Observe how and and or work in a nested if statement to require sales of at least 1.5 million and more than four SIU credits, awarding a 10 percent bonus.

Discover how to build nested if statements in Excel, using the old approach and the IFS function, to calculate tiered commissions at 2 million, 1 million, and below.

Learn to use countif, sumif, averageif, maxifs, and minifs to extract data and perform analysis. Work with named ranges and criteria to compute metrics like last year production.

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.

Explore horizontal and vertical lookup functions that retrieve data using unique identifiers, such as employee IDs or state tax rates, and learn how index and match extend these capabilities.

Learn to use v look up to fetch employee details from a named roster via a dropdown, retrieving first name, last name, and health plan with an exact match.

Learn how to use hlookup for horizontal lookups by matching a health plan heading and returning the corresponding dental information from the second row using an exact match.

Master index and match to retrieve data from a product table, overcoming vlookup and hlookup limits. Learn to combine match inside index for dynamic, exact lookups across rows and columns.

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.

Use the len function to count characters in a text string and enforce a 20-character limit with an if statement. Nest within other formulas to validate emails.

Clean your data by removing duplicates and trimming extra spaces to ensure accurate lookups and formulas in Google Sheets. Practice with a project file to apply text functions.

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.

Group and ungroup columns and rows in Google Sheets to collapse and expand related data, using the data menu and outline view to organize large datasets.

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.

Learn how macros automate repetitive tasks in sheets by recording actions, generating scripts, and replaying them across sheets, with the basics of using the macro recorder.

Record a macro to format a header across multiple sheets, using absolute references, save the macro, and replay it on other sheets while managing the script.

Explore how to manage and customize Google Sheets macros, edit scripts, set keyboard shortcuts, adjust font and formatting, and use loops and logical statements to automate repetitive tasks.

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.

Learn to share a Google form from drive using the send button, choosing email, embed, or link, including Facebook and Twitter sharing, and practice creating forms, viewing responses, and sending.

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 the Google Drive environment, access and navigate its interface, learn about Drive File Stream, upload and edit files, collaborate with teammates, and customize settings for a streamlined workflow.

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.

Explore Google Drive’s interface, including quick access, priority, and workspaces. Learn to use the new button, left navigation, shared drives, trash, and settings to save time.

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.

Discover how to create a personal workspace in Google Drive, name projects, add up to 25 files, and perform actions like remove or download.

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.

Learn to use Google Drive version history to restore earlier file versions, see changes, and manage versions by downloading or keeping them forever.

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.

Learn how to enable offline access for Google files in Google Drive by adjusting settings, selecting 'available offline,' and understanding offline previews and automatic sync when online.

Share files in Google Drive by selecting the file and using the share option or right-click. Assign edit, comment, or view permissions and learn to stop sharing with advanced options.

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 to control sharing and permissions in Google Workspace by restricting editors from changing access, preventing new collaborators, and disabling download, print, and copy for viewers and commenters.

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.

Discover how Google Drive provides an online environment accessible from any device with Internet, enabling collaboration and sharing with a single copy of the file and syncing for offline work.

Explore Google Chat and Google Meet in Google Workspace bundle, compare group and room conversations, use bots, schedule meetings via chat or calendar, and present with desktop or application sharing.

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.

Edit scheduled meetings in Google Calendar by renaming, changing times, adding attachments, and managing attendees and permissions. Use find a time to check availability and set notifications or cancellation reminders.

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.

Prepare before joining a meeting by adjusting audio and video devices, choosing phone or internet audio, and deciding whether to present or listen. Test mic, webcam, and captions.

Download the chat and meet mobile apps from app stores on your device, then log in with your G Suite account and grant camera, microphone, and notification permissions.

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.