Google Sheets for Data Analysis and Workflow Automation

Learn how to use Google Sheets functions like count, countif, countifs, and countunique to determine team size, count agents by category and department, and verify results with range and criteria.

Explore floor and ceiling functions in Google Sheets, learn how to round down or up to the nearest integer, and use an optional factor to round to multiples.

Master round, round up, and round down in Google Sheets to round numbers up or down and control decimals with the places argument.

Explore iseven and isodd functions in Google Sheets, using a single argument to test employee IDs for even or odd numbers, yielding boolean true or false and guiding data analysis.

explore sum, sumif, and sumifs in Google Sheets to total calls by department and category, using ranges and criteria for data analysis and workflow automation.

Learn to compute averages in Google Sheets using the AVERAGE, AVERAGEIF, and AVERAGEIFS functions, apply rounding for two decimal places, and handle multi-criteria for teams, categories, and departments.

Explore count, counta, min, and max in Google Sheets to distinguish numeric versus non-null records, and compute minimum and maximum averages across a data range.

Learn how to use the rank function in Google Sheets to assign ranks to a data set based on performance, choosing ascending or descending order to rank highest averages first.

Explore core text functions in Google Sheets: len, left, right, mid, upper, lower, proper, and trim, learning how they measure length, extract characters, convert case, and remove extra spaces.

Explore the Google Sheets replace and substitute functions, using text, position, length, and new text to replace or insert, and control occurrences for precise text manipulation.

Learn regex functions in Google Sheets: regexextract, regexmatch, and regexreplace to extract text, test patterns, and replace characters with new values using regular expressions.

Explore how the and and or functions in Google Sheets evaluate multiple conditions to return true or false, using examples like average score greater than 80 and category equals one.

Master the if and nested if functions in Google Sheets to return values based on conditions and build multiple grade brackets from averages.

Explore the IFS function in Google Sheets as a streamlined alternative to nested ifs. Learn to specify all conditions to avoid no-match errors and compare with switch.

Explore how the switch function in Google Sheets evaluates a single expression, matches cases with corresponding results, and handles no-match errors, compared to if and IFS.

Learn to use iferror and ifna in Google Sheets to replace errors with a customized message, highlighting that iferror handles any error while ifna targets specific error types.

Learn how to filter data in Google Sheets using the filter function with conditions and multiple criteria for real-time results. Apply thresholds like average score >= 80.

Learn how to use the sort function in Google Sheets to order data by average score, in ascending or descending order, and apply multiple criteria like department for refined results.

Explore how to use the unique function in Google Sheets to extract unique team leads, then combine with sort and sumif to analyze incoming and outgoing calls across sheets.

Verify date values with isdate, convert text to date with the date function, and compute date differences with date diff in Google Sheets.

Explore extracting day, month, and year from dates with day, month, and year functions, and compare date differences using days, date diff, and days360 in Google Sheets.

Explore edate and eomonth to calculate dates relative to a given date, and now and today to obtain current date and time. Extract hour, minute, and second components.

Learn date and time functions in Google Sheets, including month, weekday, and weeknum, and use the text function to display readable month and weekday names.

Learn to concatenate employee id and agent name in Google Sheets with concatenate or ampersand, using a hyphen as separator. Use arrayformula to auto-extend formulas and handle blanks with if.

Discover how to use the google sheets query function to extract data with sql-like syntax, filtering by conditions such as where g is greater than 80, without copying headers.

Learn how to use the import range function to import data from a specific sheet in another Google Sheets document, manage permissions, and reflect real-time changes for secure data sharing.

Use VLOOKUP in Google Sheets to look up a team lead and extract the corresponding team name and code across sheets, employing an array formula with exact match.

execute project 1: analyze sales data in Google Sheets by performing eight tasks on the raw data sheet, using the provided assignment sheets to practice functions learned.

Learn to enforce data quality in Google Sheets with data validation and conditional formatting, including date validation, dropdown lists for items, and email validation to prevent inconsistent records.

Apply data validation in Google Sheets to enforce binary yes/no fields with checkboxes, validate dispatch numbers starting with exp, and require quantities to be at least ten.

Explore how conditional formatting in Google Sheets highlights key data points using rules for empty cells, text contains, dates, and custom formulas to expose trends and streamline workflows.

Explore data sharing options in Google Sheets, assigning editor, viewer, or commenter rights, notifying users, and restricting edits to specific columns or ranges.