Google Workspace Productivity Bundle

Explore Google Sheets basics in Google Drive, including creating and naming a sheet, navigating the toolbar and menus, and using explore to analyze data while building a family recipe book.

Create a recipe book in Google Sheets by adding column headers and organizing recipes into a table. Use shortcuts to copy, paste, move, and merge cells for cleaner data.

Add and rearrange rows and columns in a recipe book by dragging, inserting, merging cells, and using keyboard shortcuts; master positioning, deletion, and basic shortcuts for efficient spreadsheets.

Learn to format a Google Sheet by selecting themes and applying alternating colors, then customize fonts and hyperlink colors. Apply these styles to the entire sheet for a cohesive look.

Format data efficiently using the toolbar and format drop-down in Google Sheets, customizing dates, numbers, fonts, colors, borders, and alignment to create a clean, presentable recipe workbook.

Master essential formatting in Google Sheets, from horizontal and vertical alignment to text wrapping and rotation, using shortcuts and clear formatting for clean, readable spreadsheets.

Apply theme selection, engaging titles, and advanced formatting to a Google Sheets data table from a Data.gov dataset, including alternating colors, percentage formatting, borders, and freezing panes for clarity.

Learn to insert images in Google Sheets, choosing between in-cell and over-cells images, using upload, URL, Google Photos, Drive, or Google Image Search, with images snapping to cell size.

Learn to insert Google Drawings into Google Sheets to place images over cells, drag and drop objects, and embed videos for dynamic data presentations.

Insert checkboxes in Google Sheets and customize data validation to track items with true/false or yes/no values, control invalid entries, and extend ranges for large datasets.

Learn to add notes and comments in Google Sheets using the insert menu, right-click, or keyboard shortcuts, compare notes (black triangle) with comments (yellow icon), and tag teammates for notifications.

Apply Google Sheets skills to plan a landscaping project by researching 5 to 10 plants and recording title, image, description, link, price, location, growing zone, height, width, sunlight, and checkboxes.

Learn to clean up data quickly with Google Sheets' data cleanup, removing duplicates, trimming whitespace, formatting numbers, and identifying anomalies before analysis.

Learn how to use conditional formatting in Google Sheets to highlight data, apply rules to multiple ranges, and identify data issues for cleanup.

Apply color scales in Google Sheets to visualize data by min, mid, and max, adapt formatting as data changes, and extend rules across columns using paint format or copy-paste.

Apply drop-down menus in Google Sheets through data validation to keep course and protein columns consistent, prevent formula errors, and streamline collaboration.

Learn advanced data validation in Google Sheets, applying number, text, email, URL, date, and custom formula criteria to prevent errors and improve data quality and collaboration.

Clean the US Agriculture Trade dataset by trimming whitespace, apply decade-based single-color formatting, implement color scales for imports, exports, and trade balance, and convert months to dropdowns with data validation.

Sort and filter data in Google Sheets using sort sheet, sort range, and filter views; master multi-column sorting and conditional filtering to organize recipes by time, ingredients, and category.

Master basic formulas and functions in Sheets, apply absolute references with dollar signs, drag formulas across rows, and combine text from columns using quotation marks for spaces.

In the Google Workspace Productivity Bundle, learn basic functions in Google Sheets, using the function toolbar to apply max and sum with proper syntax and arguments.

Explore Google Sheets query function to select data, apply where and other clauses, name ranges for efficiency, and generate snapshot outputs across multiple tabs.

Learn how to add, rename, organize, duplicate, and copy multiple sheets in a single Google Sheet, color code tabs, hide sheets, and view comments to manage data efficiently.

Turn on filters, sort the landscaping data alphabetically, and use filters to answer the questions. Calculate plant costs with a basic formula and a grand total to complete the exercise.

Explore how to insert and customize a wide range of charts in Google Sheets, from line and area charts to geo charts and timelines, using data selection, axes, and legends.

Explore how to edit and customize charts in Google Sheets, including chart type choices, stacking options, range updates, and switching rows and columns to reveal different data insights.

Master editing and customizing charts in Google Sheets by adjusting chart style, colors, fonts, labels, axes, legends, gridlines, and accessibility options, including alt text and chart on its own sheet.

Create a yearly line chart of USDA exports and imports, with year on the x-axis, aggregate the data, and add clear titles and units in billions of dollars.

Learn to share and collaborate on Google Sheets, selecting editor, viewer, or commenter access, sending links, and using notification rules and edit history to manage edits.

Learn to protect ranges and sheets in Google Sheets, assign permissions, and manage comments and action items to control who edits what, enabling secure collaboration.

Learn how to download Google Sheets as Excel or PDF, print sheets with settings, and publish to the web with links or embed codes for portfolios or LMS.

Share your completed recipe book with at least one person by inviting them and setting permissions. Protect ranges, add comments, tag assignees as action items, and enable notifications.

Celebrate completing the Google Sheets basics course by mastering from-scratch sheet building, grouping and formatting. Share and publish your finished recipe book.

Explore Gmail settings and features like undo send, hover actions, nudges, and archiving. Improve organization with labels, filters, templates, and multiple signatures, plus efficient search and chat.

Explore Gmail productivity settings, mastering undo send up to 30 seconds and hover actions to speed inbox management, while tuning density, reading pane, themes, and archiving preferences.

Archive emails to remove them from your primary inbox, reducing clutter and stress. Find archived messages later via labels or all mail, and use hover actions for quick cleanup.

Explore Gmail's smart features, including smart compose, smart reply, and nudges, speed typing and manage follow-ups. Personalize smart compose to your writing style and use conversation view to group threads.

Explore Gmail stars and indicators to boost productivity by tagging emails with urgent, waiting on, or general action markers, then star items to reduce inbox clutter from one location.

Explore how Gmail inbox types organize your messages by default tabs, primary vs categories like promotions, social, updates, and forums, and learn to customize with priority, important markers, and labels.

Create and manage multiple signatures in Gmail by navigating settings, creating two signatures, saving, and switching between them when composing emails.