The Complete Google Sheets Course - Google Spreadsheet Tips

Discover Google Sheets as a free, cloud-based spreadsheet tool for personal and professional use, featuring colorful charts, formulas, pivot tables, conditional formatting, templates, and real-time collaboration across devices.

Learn how to create a Google account to access Google Sheets and other Google applications, including account setup, verification, and optional recovery information.

Discover the Google Sheets environment, access sheets.google.com, and navigate the main menu, templates, and offline options. Create sheets or use templates, manage recent spreadsheets, Google Drive uploads, and profile settings.

Explore the basics of cells, sheets, and spreadsheets in Google Sheets, including addresses, rows, columns, and the sheet menu, to build confident data work.

Learn to share a Google Sheet with individuals or groups, set editor, viewer, or commenter permissions, notify recipients, and manage link access and group sharing via Google Contacts.

Explore the essential menus and tools in Google Sheets, name your document, use undo and redo, and master basic formatting, print settings, and conditional formatting in preparation for project-based work.

Master borders, merging cells, alignment, text wrap, and rotation in Google Sheets while learning links, comments, charts, and filters for polished, efficient spreadsheets.

Discover how to install Google Sheets on your PC or laptop and create quick access with start menu or desktop shortcuts, bookmarks, and the Google Sheets extension for fast launches.

Explore the Google Sheets file menu, including creating new documents from templates, opening, importing, sharing with collaborators, publishing, exporting, version history, offline access, and printing.

Explore how to freeze columns or rows, display and hide grid lines, format tables, protect ranges with permissions, and adjust view options like zoom and full screen in Google Sheets.

Explore paste special in Google Sheets, including copying based on values, formats, formulas, conditional formatting, and data validation, with undo and redo and related cut, copy, paste operations.

Learn to use paste special in Google Sheets to paste values only, formats, formulas, data validation, and conditional formatting, then explore transpose and other paste options.

Explore the view menu in Google Sheets to hide or show interface elements, toggle gridlines, protect ranges, freeze rows, group data, manage sheets, and adjust zoom and full-screen mode.

Explore inserting and deleting rows and columns in Google Sheets, shifting data, and using basic functions, with a focus on sales and upcoming chart and pivot table projects.

Explore how to create a static data table of monthly spend and income in Google Sheets and insert a chart to visualize, customize, and compare trends using various chart options.

Learn to insert rows, columns, and cells in Google Sheets, create and customize charts, and add images, drawings, checkboxes, links, and text boxes for clearer visuals of data.

Learn to create pivot tables in Google Sheets, configure values and columns, and apply filters and slicers to analyze monthly data.

Learn to insert images and drawings in Google Sheets, insert images in cells or over cells, add links, comments, and notes, and use drawing tools for shapes and alignment.

Explore essential Google Sheets functions, including sum, average, count, count if, max, min, and count blank, and apply them in real projects to speed up your work with data tasks.

Learn to build a Google Sheets salary table, format with alternating colors, merge cells, center alignment, and use simple formulas to compute salary, overtime, tax, and total.

Practice salary analytics in Google Sheets by computing max, min, total, and average salaries, counting employees, and using sumif and countif to tally cooks and other roles.

Build a currency converter in Google Sheets by creating a table, applying operators, merging cells, and linking dollar values to euro and Afghani with real-time conversion and formatting.

Create and customize charts in Google Sheets using data, comparing features with Microsoft Excel. Learn to select data, insert charts, adjust colors, fonts, and styles to present clear visuals.

Explore basic functions in Google Sheets, learn the difference between functions and formulas, and apply right, left, mid, trim, upper, lower, concatenate, and length to clean and analyze data.

Learn to create pivot tables in Google Sheets to summarize expenses by buyer and date, calculate averages, and count unique expenses with clear, step-by-step guidance.

Learn to filter pivot tables with slicers in Google Sheets, creating and configuring slicers to filter by date and buyer, and customizing appearance for clear, dynamic data insights.

Explore the power of templates in Google Sheets, using the template gallery to insert ready-made solutions for calculations, history, and project organization, then customize them with your creativity.

Explore how to use Google Calendar in Google Sheets to view 2020 calendars, customize themes, adjust colors and text, and insert images into cells for a print-ready calendar.

Learn to build a to-do list in Google Sheets using checkmarks to track completed tasks and filters to show active items. Drag to reorder and add more tasks as needed.

Use the Google Sheets annual budget template to track monthly spending, starting balance, expenses, and income, and view automatic totals, categories, and theme options.

Learn to build a monthly budget in Google Sheets that tracks income and expenses, shows start and end balances, compares actual to planned figures, and tracks transactions with themes.

Learn to use Google Finance in Google Sheets to track stock data, enter symbols, view growth over a month, and monitor open, high, low, close, volume, and a watch list.

Explore a casual daily schedule template in Google Sheets that auto updates by week when you enter a date, and includes notes, a to-do list, plus manual color customization.

Plan trips in google sheets by adding dates, destination, and trip title in a travel planner, track flights and hotels, agenda items, and customize colors and background for clarity.

Explore and customize Google Sheets templates, learn when to use add-ons, and discover free templates for attendance, assignments, CRM, and more, with easy installation and modification.

Learn to turn a Google Form into a quiz by using the gear icon, switching to quiz mode, and configuring the available options.

Create a personalized google forum cover by designing an 800-by-400-pixel image with google drawings, selecting your own photo to represent the group.

Explore the Google Sheets file menu to create new documents from templates, open and import files, make copies, share or publish to the web, and track version history.

Explore Google Forms overview and learn to access forms via apps and the Chrome extension, start a new form or template, and collect information.

Create a new Google Form from scratch, customize the theme, add diverse question types and media, configure responses, and organize sections for interactive quizzes.

Preview and customize a Google Form by applying themes, header illustrations, color options, and fonts, then review the live look and layout.

Explore how to view and analyze Google Form responses, summarize by questions, export to Google Sheets, copy charts to Docs or Slides, and set email notifications.

Learn how to send Google forms by email, collect emails, invite collaborators, edit messages and subjects, and share forms via shortened links, embed options, and social posts.

Master Google Form gear icon settings, including general options like collecting emails, sign-in requirements, progress indicators, and edit-after-submission; enable quizzes with points and auto grading.

Learn how to switch a Google Form to quiz mode, enable quiz features, set answer keys, assign points, and create multiple choice or short answer questions with required responses.

Celebrate your progress in Google Sheets and apply what you learned practically and in theory to create sheets, templates, and projects.