Complete Google Sheets Training - Beginner to Advance Level

Explore how to build equations in Google Sheets using mathematical operators, including addition, subtraction, multiplication, division, and brackets, and learn the correct order of operations with cell references.

Explore how to apply Google Sheets math functions like sum, average, count, counta, countblank, max, min, large, and small, using ranges, arguments, and nesting, to handle text and blanks.

Master advanced math functions in google sheets, including sumifs, averageifs, and countifs, using criteria ranges and multiple conditions to analyze sales by region and city.

This lecture trains you to use wild cards in Google Sheets, including non-character-specific and character-specific wildcards, with countif examples for names starting with a and emails like Gmail and Yahoo.

Explore logical operators such as greater/less than and equals in Google Sheets, and use the if function to classify scores as pass or fail.

Master nested ifs in Google Sheets to classify a score into three ranges—less than 40, 40 to 60, and above 60—using sequential tests and locking the first condition.

Apply the if function in Google Sheets to determine scholarship eligibility and amounts for scores above 70 (times 1000), then flag fail or pass and mark highest and lowest scorers.

Use the IF function in Google Sheets to award scholarships: scores 70 or less are not eligible; above 70, (score-70) multiplied by thousand, with max/min to find topper and lowest.

Use and and or with the if function in Google Sheets to evaluate multiple conditions; and requires all true, while or requires any one true to pass.

Master Google Sheets text functions by practicing upper, lower, proper, sentence, and toggle case, and learn to trim spaces for clean data formatting.

Learn how left, right, and find functions in Google Sheets extract from text and locate positions. Handle spaces and case sensitivity, then adjust results to pinpoint targets.

Master nesting methodology with text functions in Google Sheets, using left, find, and right to dynamically extract a name and a mobile number from sentences, including dot-delimited endings.

demonstrates using the mid function in Google Sheets to extract mobile numbers from sentences by dynamically locating the hyphen with the find function and extracting 10 characters after it.

Learn to use the concatenate function in Google Sheets to join text, prefix numbers with 91, and format phone numbers as 123-456-789 using left, mid, and right.

Use the replace function in Google Sheets to replace six-digit pin codes by detecting the code with find and right, then substituting it with 100110.

Learn how the substitute function in Google Sheets differs from replace by using text-based search, optional occurrence, and examples with find and length to count or replace occurrences.

Split a single column in google sheets using the text to column tool. Learn to apply separators such as comma, semicolon, space, or a custom delimiter, with optional automatic detection.

Learn to apply and tailor filters in Google Sheets to organize data, including empty cells, text and number conditions, custom formulas, and saved filter views.

Explore slicers as a column-specific filter in Google Sheets, and learn sorting and column statistics, including ignoring the column title as data.

Learn to use conditional formatting in Google Sheets to highlight data by condition across a range with color, including text and value rules, multiple rules, and color scales.

Create named ranges in Google Sheets by selecting a cell group, naming it with underscores, then navigate via the name box and reuse in formulas; edit or delete as needed.

Learn to create various links in Google Sheets, including linking to named ranges, specific cells, in-sheet destinations, functions like IF, external websites, and other Google Sheets.

Explore data validation in Google Sheets by enforcing rules such as text contains specific keywords, valid dates, drop-down lists, email formats, checkboxes, and conditional scholarship amount using custom formulas.

Learn to create a pivot table in Google Sheets, using rows, columns, values, and filters to summarize item sales by date and client with sums, counts, and averages.

Master chart creation in Google Sheets by selecting data, inserting charts, choosing types (column, stacked, combo, pie), and refining axes, legends, labels, colors, and styles.

Learn to use vlookup to fetch a matching record from a master data sheet, using lookup value, range, and index number, with exact and approximate matches and cross-sheet import range.

Learn how to use iferror with vlookup to handle missing matches across two data sources, returning custom messages like no data found instead of errors.

Master the Hlookup function in Google Sheets by retrieving data from horizontal layouts, learn to transpose between horizontal and vertical data, and extract details from the master data range.

Learn how to use match and index functions in Google Sheets, covering exact and approximate searches, and how to nest them to retrieve names from master data using contact numbers.

Learn to retrieve names and qualification from master data by nesting index and match functions in google sheets, using exact match and absolute references to map phone numbers to records.

Learn to use vlookup with match to fetch course, contact, and location from master data by matching titles. Apply absolute references to drag formulas reliably.

Learn to use vlookup with approximate match (true) to map scores to fail, compartment, pass, or distinction in Google Sheets, using a sorted range and index.

Learn to use an array formula with vlookup to return multiple columns in one go, by selecting the full range and applying exact match.

Explore managing date and time in Google Sheets, including proper date entry, key functions (year, month, day, date, time, today, now), and basic date-time formatting.

Use datedif to calculate age in years, months, and days from birthdates to today, and learn to count working days with networkdays and networkdays.intl, excluding weekends and holidays.

Extract and analyze loan details using PMT, PPMT, IPMT and PV to calculate the equated monthly installment, total payments, interest, and principal breakdown across monthly and yearly loan scenarios.

Learn to automate tasks in Google Sheets by recording macros with relative references and a shortcut. Apply formatting and conditional formulas using the stored macro.