Google Sheets - The Complete Google Sheets Course

Explore the Google Sheets user interface, including the top menu, toolbar, formula bar, and grid, and learn how sheets, tabs, and the right sidebar boost data workflow.

Learn to use find and replace in Google Sheets to search text with ctrl+f and replace across cells, including options like match case and entire cell content.

Access Google Sheets revision history by opening a sheet, selecting file, and viewing version history to see past edits and restore a prior version if needed.

Create new files in Google Drive, rename them with meaningful titles, and manage sharing with editors, viewers, or commentators.

Master basic formatting in Google Sheets, including font style and size, bold, italic, underline and strikethrough, text and fill colors, alignment, and currency and decimal controls.

Learn to use logical functions in Google Sheets, including and, or, and if, to evaluate multiple criteria and produce conditional results. Apply these functions for data analysis and decision making.

Learn to use the sum, average, max, min, and count functions in Google Sheets, with practical examples on student scores and data ranges.

Learn six essential text functions in Google Sheets—upper, lower, proper, trim, concatenate, and len—and apply them to transform, format, and analyze text data with clear examples.

Learn to use the left and right functions in Google Sheets to extract characters from the start or end of a text string, with simple examples.

Explore charts and graphs in Google Sheets; learn to create line, column, and pie charts, and customize with the chart editor to visualize data and build dashboards.

Learn to create and customize a line chart in Google Sheets using revenue data for 2020 and 2021, including chart editor, axis titles, colors, and series.

Create column charts in Google Sheets by selecting data and choosing chart type, then customize titles, axes, legend, and series, including 100% stacked options with sum or average aggregates.

Learn to create bar charts in google sheets, customize chart title, axis, colors, and data labels using the chart editor to visualize monthly sales data.

Create and customize a pie chart in Google Sheets to visualize data as percentages, from preparing data to selecting chart options, customizing slices, and sharing or embedding.

Create and customize area charts in Google Sheets to visualize data trends over time, including revenue by month, with options for stacked area charts and chart personalization.

Learn to create and customize a scatter chart in Google Sheets, using rainfall as the x axis and crops purchased in kilos as the y axis.

Create treemap charts in Google Sheets to visualize hierarchical data, customize colors and levels, and analyze sales, budgets, and other category-based data.

Learn to create an organizational chart in Google Sheets by setting up two columns for title and report to, then inserting and customizing the chart.

Master sorting and filtering data in Google Sheets to organize records by column and header criteria, then apply multiple filters for precise, efficient analysis.

Learn to use the vlookup function in Google Sheets to search the leftmost column and retrieve data from the same row, with exact matches and index guidance.

Learn to use the hlookup function for horizontal lookups in Google Sheets, locating values in the top row and returning data from a chosen row with an exact-match option.

Master Xlookup in Google Sheets to perform horizontal and vertical lookups, matching item names to fetch descriptions and prices from a return array.

Learn how to automate repetitive tasks in Google Sheets by recording and applying macros. Create and manage macros to format data as tables, perform data cleaning, and generate consistent reports.

Learn how to freeze rows and columns in Google Sheets to keep headers visible while scrolling. Explore the view tab, zoom levels, and practical tips from a daily schedule example.