Introduction to Google Spreadsheet Features with 5 Projects

Navigate file, edit, and view menus to create new spreadsheets, import data, and manage templates. Copy, export, print, share, and restore with version history to track changes.

Master file, edit, and view features in Google Sheets, including undo/redo and cut, copy, paste. Apply find and replace, insert images, delete rows, and use freeze, group, and zoom.

Learn how to insert and format data using Google Sheets toolbars, covering insert cell and shift options, rows and columns, images in and over cells, drawings, links, checkboxes, and dropdowns.

Explore how to create drop-downs and data validation in Google Sheets, apply checkboxes, and use smart chips for files, calendars, and people, then add notes and comments for collaboration.

Explore text and number formatting in google sheets, including date and currency formats, locale settings, alignment, wrapping, rotation, and merging cells, with a brief intro to conditional formatting.

Learn to apply conditional formatting in Google Sheets, highlighting text like tech, setting rules for empty cells, dates, or large numbers, and using alternating colors for readable tables.

Sort data and manage filters in Google Sheets; freeze header, sort by multiple columns, use filter views and slicers, and explore column stats.

Master data validation, version history, and cleanup in Google Sheets, then design a printable certificate with borders, merged cells, images, and a print-ready PDF layout.

Explore how Google Sheets sharing and access work, from private to anyone with the link, with view, comment, and editor roles, including workspace options and email-specific access.

Explore Google Spreadsheet sharing and access controls, including creating independent filter views, protecting sheets and ranges, and publishing options such as web pages, PDFs, or embedded views.

Create a practical expenses tracker in Google Sheets, with a dedicated expenses sheet, headers, date validation, category dropdown, and currency formatting, plus sharing a reusable template.

Create a Google spreadsheet sales transactions template to track date, salesperson, product, amount, cost of goods, and net profit, with data validation and dropdowns for sales team and location.

Build an employee database in Google Sheets, capturing salary history, payments, and leaves with data validation, dropdowns, and date formats, plus alternating colors and frozen headers.

Design a professional invoice in Google Sheets, building a header, item table with totals, and drop-down item selection, then export a one-page pdf with proper page setup.

Learn to create graphs in Google Sheets, build a multi-chart dashboard with slicers, and visualize sales data like deal value by salesperson, locations, and lead source.

Explore pivot tables in Google Sheets to summarize sales data with real-time updates. Build and customize rows, columns, and values, apply filters and slicers, and group dates.

Record and run macros in google sheets to automate repetitive tasks. Format headers, adjust column widths, and clean up the data with a saved macro.

Explore how absolute and relative references affect macro recording in Google Sheets, and learn to record, manage, and run macros that copy data, paste values, and automate tasks.

Tackle the final project by building an expense tracker dashboard with pivot tables, charts, and formulas to visualize base amount, tax, and total amount across categories.