Google Sheets for Data Analysis & Business Intelligence

Launch Google Sheets and create your first spreadsheet on Google Drive, then explore its interface, settings, and core components while comparing similarities and differences with Excel.

Discover Google Sheets as an online tool for data analysis, dashboards, and collaboration, including collecting survey data with Google Forms. Sign in for free at docs.google.com/spreadsheets to start creating.

Compare Google Sheets and Microsoft Excel to highlight their similarities, differences, and pivot tables. Explain how cloud-based collaboration and Apps Script versus VBA enable automation and data visualization.

Discover three ways to create a new spreadsheet in Google Sheets—via Sheets home, Google Drive, or Sheets dot new—and learn to name, move, and enable offline access.

Create desktop shortcuts for Google Sheets and Google Drive in Google Chrome using the Create shortcut option, choose open as window or not, and optionally pin to the taskbar.

Open and convert Excel files in Google Sheets by saving to Google Drive and saving as Google Sheets. Note compatibility issues with formulas, charts, and pivot features.

Explore the Google Sheets interface, including the menu bar, shortcuts, collaboration options, formula bar, sorting and filtering tools, charts, pivot tables, and help and keyboard shortcuts.

Configure locale and display language to match your google sheets environment. Set locale to united states and display language to english to standardize dates, currencies, numbers, and menus.

Unlock Google Sheets version history and recovery to view, compare, and restore prior states. Name versions for easy access and track changes without losing later edits.

Explore Google Sheets as free spreadsheet with function library, pivot tables, and data visualization; collaborate in real time on Google Drive and use version history after setting United States English.

Build core spreadsheet fundamentals in Google Sheets for data analysis and business intelligence. Navigate cells, manage rows and columns, and apply data types, validation, conditional formatting, and sorting and filtering.

Explore a real-world data project in Google Sheets, organizing an employee database and satisfaction survey to improve formatting, data validation rules, and filter views for HR insights.

Learn essential data literacy terms in Google Sheets and Excel, including cells, ranges, rows, columns, cell addresses, fields, records, and tables to analyze data effectively.

Learn to navigate data in Google Sheets by creating, moving, hiding, and grouping rows and columns, freezing panes, and using keyboard shortcuts to select, copy, and paste values.

Edit data in Google Sheets using double-click, the formula bar, or enter and escape to confirm or revert; add new records with tab and enter, and use Ctrl+D for autofill.

Learn to enter data into Google Sheets via Google Forms, watch form responses populate timestamped records, manage and share forms, and unlink to stop submissions while preserving data.

Understand that Google Sheets stores data as numeric, date or time, or text, using default alignment as a cue, and see how prefixes and symbols alter interpretation.

Learn how Google Sheets stores dates as serial numbers with day zero on December 30, 1899, and times as fractions of a day; formatting reveals dates, including negatives before 1899.

Format numbers in Google Sheets to display currency, percentages, and custom date formats while preserving underlying values. Learn to apply presets and custom formats for salaries, IDs, and phone numbers.

Apply data validation in Google Sheets to restrict cell entries by type and criteria, such as ages greater than or equal to 18 and valid emails, with warnings or rejections.

Learn to use data validation to add checkboxes and dropdowns in Google Sheets, enabling binary yes/no values and a color-coded performance score list from predefined options.

Apply conditional formatting in Google Sheets using single color rules and color scales. Highlight ages >=60 in blue bold and green-red salary scales, with checkboxes for yes values.

Learn to filter data in Google Sheets by values or conditions, using header icons and save as filter view presets for quick, repeatable views like department and salary.

Sort data in Google Sheets by text, numbers, or dates in ascending or descending order, then perform multi-level sorts by department, job title, and salary using header row options.

Explore how a spreadsheet uses a grid of cells addressed by column letters and row numbers, storing numbers, dates, or text, with data validation, conditional formatting, and sort and filter.

Explore essential Google Sheets formulas and functions for data analysis and business intelligence, including math, logical, text, date, and lookup functions; learn syntax, reference and error types.

Use Google Sheets to manipulate the orders dataset, including growth and forecasting reports, across orders, products. Create calculated columns, join data from related tables, and summarize insights for management.

clarifies the difference between formulas and functions in Google Sheets, explains function syntax with arguments and optional components, and notes using English display and US locale for consistency.

Explore the three types of Google Sheets functions: traditional single-value functions, array functions that spill, and volatile functions that recalculate.

Master basic math functions in Google Sheets: multiply unit price by quantity for gross revenue, compute delivery window with date arithmetic, and use sum, average, max, min, and count.

Learn fixed, relative, and mixed references in Google Sheets, using dollar signs and F4 to control how formulas copy; build dynamic forecasts with rounding and absolute references.

Explore common error types in Google Sheets, including name error, value error, div zero, ref error, and lookup errors with fixes for correct names and references.

Explore counting functions in Google Sheets, including count, counta, countblank, and countunique, to tally total orders, total customers, and orders to ship using ranges and handling headers.

Explore how the unique function removes duplicates from a data range, returns the distinct records, and supports by column and exactly once options for dynamic results.

Explore how Google Sheets uses logical functions to guide decisions, using operators =, >, <, >=, <=, and not equal, plus if, and, or, and if error for robust analysis.

Master the if function to test a condition and return true or false values, illustrated with a 5% discount example and late or on time status in Google Sheets.

Master nested if functions in Google Sheets to apply tiered discounts: >10 for 5%, >25 for 10%, >50 for 15%. Status checks: late, at risk, on time.

Learn how to use and and or operators in Google Sheets to evaluate conditions, flag high priority orders when delivery window equals 14 and the customer is a top customer.

Master the iferror function in Google Sheets to return a dash for division errors, compute year-over-year growth from 2013 to 2014, and format results as percent.

Learn to use Google Sheets conditional math functions to perform sums, averages, and counts by criteria. Apply multi-criteria filters to analyze gross revenue and order status using count unique ifs.

Explore how lookup functions locate a product ID in a dimension table and return the corresponding product name, using fact and dimension tables, keys, and the upcoming xlookup.

Discover how XLOOKUP in Google Sheets replaces VLOOKUP by returning a value from the result range using a matching lookup range, with optional missing value handling.

Learn to use xlookup with approximate match to assign discounts by quantity, returning the next smallest or next largest value and applying a missing value for no match.

Learn basic date and time functions in Google Sheets. Use today, now, year, month, day, hour, minute, second, week, and date diff to extract components and compute differences.

Master basic text functions in Google Sheets, including upper, lower, proper, trim, left, right, mid, split, and text join. Clean data, format names, extract initials, and split addresses by delimiter.

Use Google Sheets smart fill to quickly separate full names into last names across many rows, with auto-filled formulas using the Len function, even when name lengths vary.

Discover how formulas and functions drive data analysis in Google Sheets, including fixed and relative references with the dollar sign and f4, and understand function types and operations.

Explore and analyze data with pivot tables in Google Sheets, using drag-and-drop features to summarize values, sort, filter, and group results, and create calculated fields.

Learn to explore and analyze data in Google Sheets, create calculated fields, and derive insights from a dataset of 190 marketing campaigns with impressions, clicks, conversions, and costs.

Structure data for pivot tables as a single tabular table with column headers and rows of observations, using uniform data types and avoiding calculated fields.

Learn how pivot tables in Google Sheets enable quick data analysis by filtering, summarizing, and slicing data with dimensions and measures via drag and drop editing.

Learn to modify pivot table views in Google Sheets by pivoting data, moving platform and keyword between rows and columns, and comparing impressions, clicks, and conversions across desktop and mobile.

Explore how the summarize by option governs data aggregation in pivot tables, using sum, count, average, max, and count unique, with examples on campaigns, keywords, and impressions.

Master show as calculations in Google Sheets pivot tables, including percent of row, percent of column, and percent of grand total, with examples on impressions, conversions, and match types.

Sort and filter pivot tables in Google Sheets, using ascending or descending order and sorting by metrics like average revenue. Use slicers to narrow data by platform and date.

Group text fields in a pivot table to create keyword types. For many groups, add a keyword type column in the source data.

Group numeric fields in a Google Sheets pivot table to create buckets with min and max values and an interval size, then visualize the distribution of impressions across campaigns.

Group date fields in Google Sheets to roll dates into components such as month or day, use pivot table group to analyze monthly trends, campaigns, conversions, and cost.

Explore calculated fields in pivot tables to create measures like cost per click and conversion rate, adapting automatically to your data structure in Google Sheets.

Master custom aggregations in Google Sheets by using calculated fields to divide sum of impressions by count unique of the keyword, enabling pivot table calculations not in Excel.

Master pivot tables in Google Sheets: use clean tabular data with clear headers, include dimensions and measures, and create dynamic calculated fields; sort, filter, and group with show as calculations.

Master data visualization in Google Sheets by choosing the right chart types, formatting visuals effectively, and creating basic charts, including line, bar, and pie, to tell compelling data stories.

Explore Kickstarter project data in Google Sheets to prepare it for visualization, create and customize charts that reveal trends across categories, goals, pledges, and backers, enabling clear storytelling.

Visualize data to bring numbers to life with data visualization, reveal clear patterns, and deliver quick insights as four charts show monthly sales across four products.

Learn to visualize data in Google Sheets by creating charts, choosing chart types (bar, column, pie), and using aggregation and pivot tables to reveal category project counts.

Choose chart types by data type and what you want to communicate. Line charts suit time series, bar charts compare categorical data, and pie charts show composition.

Explore line and stacked area charts in Google Sheets to visualize time series trends and composition, learn data structuring, formatting, labeling, and highlighting for clear storytelling.

Learn to use bar charts to compare category values, sort bars, and highlight key insights with color and labels; compute success rates via a pivot table to compare categories.

Create and tailor combo charts in Google Sheets, combining two series—projects launched and the success rate—with a secondary y axis to reveal time-based comparisons and relationships.

Explore pie and donut charts for part-to-whole data. Prepare data with slices as rows, build the chart in Google Sheets, and highlight insights like 35% of projects were successful.

Explore scatterplots to visualize relationships between numerical variables using project data; plot backers vs pledged amount, identify outliers, and customize axes and labels in Google Sheets.

Learn to build map visuals in Google Sheets from geographic data, using a pivot table to create one row per location and visualize the region’s success rate.

Bring data to life with charts and graphs that make numbers intuitive. Choose the right chart type for your data and message, and refine visuals with purposeful color and storytelling.

Explore Google Sheets sharing and collaboration options, including sharing with others, real-time collaboration with comments and chat, edit notifications, history tracking, and protecting and publishing sheets and ranges.

Learn to use Google Sheets to share a project tracker, set edit permissions, and collaborate with notes and chat while tracking tasks, due dates, owners, status, and hours.

master google sheets sharing by switching between restricted and anyone with the link, assigning roles (viewer, commenter, editor), and using email invites, expiration dates, and real-time collaboration.

Learn to use notes, comments, and chat in Google Sheets to collaborate without leaving the app. Add, reply, tag people, resolve comments, and manage chat inside the sheet.

Explore edit history and set notifications in Google Sheets, viewing cell changes with show edit history and receiving email alerts or daily digest for changes or form submissions.

Protect sheets and ranges in Google Sheets to prevent edits, display warnings, and grant edit rights to specific ranges or the owner, with practical setup steps.

Learn to convert a task table with start and due dates into a Google Sheets timeline (Gantt chart), using status colors, owner grouping, and zoom levels from months to weeks.

Publish to the web to display Google Sheets data as a web page, either the entire document or a single tab, via a link or embed, with automatic updates.

Collaborate in real time with Google Sheets, sharing via email or public link and editing simultaneously. Track changes with edit and version history, manage comments, enable notifications, and protect sheets.