Google Sheets Functions - Be the hero in the office

Compute the average, maximum, and minimum exam scores in Google Sheets using the average, max, and min functions to quickly assess class performance.

Apply count to count numbers in a range and counta to count nonblank cells, then compute the percentage of students who sat the exam using a simple division.

Master rounding in Google Sheets with round, round up, and round down. Learn how to set decimals, copy formulas, and round numbers to the tenth or thousand, including 0.5 behavior.

Practice applying Google Sheets formulas to analyze mock exam results using the first practical challenge, following scenarios and comparing your finished sheet with the example.

Learn to use the if function and nested ifs in Google Sheets to grade pass/fail, handle blank cells, and apply tiered discounts with absolute references.

Learn to use the or and and functions in Google Sheets, combined with the if function, to test conditions, take actions, and handle weekend pricing with the weekday function.

Learn to use countif and countifs to count with conditions, including dynamic criteria, wildcards, dates, averages, and duplicates with conditional formatting.

Learn how to use sumif to add values that meet a single criterion and sumifs to add values across multiple criteria, including date ranges.

Analyze shipment data for Global Goods Shipping to identify delivery statuses, assess weekend surcharges, track package types, and calculate total revenue under various conditions.

Master Google Sheets filter to extract exactly what you need by building multi-condition formulas, placing results on another area or sheet, and combining with count, sum, and date logic.

Remove duplicates with the unique function and sort the results; then use count unique across multiple columns and an open-ended range to auto-update drop-downs via data validation.

Learn to validate emails, phone numbers, and URLs in Google Sheets with ISEMAIL, ISNUMBER, ISURL, and NOT. Use conditional formatting to highlight valid and invalid data.

Develop a data-driven workflow in Google Sheets to track product status, identify unique items, and ensure data integrity across multiple warehouse inventories, and follow the challenge instructions.

Learn how to use Google Sheets' VLOOKUP to find data in tables, handle exact and approximate matches, apply wildcards, combine keys, and manage errors with iferror.

Learn how index and match overcome vlookup limitations by enabling leftward lookups, adapting to added columns, and returning multiple columns or rows, with exact and range-based match options.

Xlookup offers a clearer, more flexible lookup in Google Sheets, handling left and right searches, optional missing value and match-mode parameters, and easier error handling than VLOOKUP.

Master the hyperlink function in Google Sheets to insert URLs, display friendly text, link to specific sheets and cells, and preview drive documents showing owner and last viewed details.

Master the offset function to create dynamic Google Sheets formulas that adapt to added rows or columns and sum the last n months of data.

Build a dynamic Google Sheets dashboard for Global Tech Solutions to quickly retrieve critical information, track project progress, and centralize key resources across departments.

Learn to format text in Google Sheets with proper, upper, lower, trim, left, right, and len; tidy whitespace, correct names, and convert sentences with a single ampersand formula.

Break down long Google Sheets formulas step by step, analyze each function, and extract initials from a full name, using line breaks for readability.

Learn how to join data in Google Sheets using concatenate, ampersand, and textjoin, with delimiters and ranges, to create names, addresses, part numbers, and dates formatted with the text function.

Transpose data in Google Sheets to switch between vertical and horizontal layouts, using the transpose function on a complete range to rearrange rows into columns without altering the original data.

Act as a data analyst for Swift Reads Books to clean, standardize, and reformat an import of book catalog entries and customer feedback data in Google Sheets for accurate reports.

Learn how to use importrange to link multiple Google Sheets, import ranges, and maintain formatting while syncing data to a master sheet.

Use the Google Translate function in Google Sheets to translate between languages, auto-detect source language, and handle blanks with IFERROR, covering English to Spanish and other languages.

Centralize global customer feedback from around the world into one spreadsheet and translate all comments to English, then complete practical challenge 6 by copying and organizing three spreadsheets.

Master basic Google Sheets date functions, including now, today, day, month, year, hour, minute, and second, to extract date parts and build dynamic countdowns and calculations.

Explore Google Sheets date functions, including weekday with start day, choose for day names, workday and networkdays for deadlines, working days, and holidays, and edate and eomonth for month boundaries.

Automate project duration calculations, track leave and attendance across time zones, and analyze shift patterns to generate monthly reports for global HR in Google Sheets, aligned with practical challenge 7.

Master the Google Sheets query function to filter, sort, group, and pivot data from questionnaires and HR databases, using dynamic criteria, date ranges, and aggregate results.

Explore how to use Google Sheets' query function to group by department and compute average salaries, sort results by salary, limit rows, and rename headers with employee data.

Manage department hire dates, salary, and performance reviews at Talent Link Solutions to extract, filter, and summarize data for hr reports using Google Sheets functions.

Learn how Google's Gemini in the sheets sidebar analyzes data and creates charts without formulas, and how the AI function prompts Gemini from Excel for product descriptions and sentiment-based emails.

Be the hero in the office by mastering Google Sheets functions, from VLOOKUP and INDEX MATCH to QUERY, IF statements, and text and date operations.