Google Sheets Basic to Advance Course

Insert, delete, rename, hide, and unhide sheets in a Google Sheets workbook, then color, move, and copy sheets across workbooks using menus and shortcuts.

Learn to use relative and absolute references in Google Sheets to copy formulas for annual salaries from monthly pay, fix columns with dollar signs, and toggle references with F4.

Learn to define named ranges in Google Sheets, name a cell or range for easy reference in formulas, and apply it to bonus rate and total salary calculations.

Learn to use the concatenate and text functions to join text and format numbers and dates in Google Sheets, including thousands separators and currency signs.

Learn to extract text and measure length in Google Sheets using left, right, mid, and len functions. Practice examples to pull characters from strings and count total characters, including spaces.

Learn how the find function (case sensitive) and the search function (not case sensitive) locate text positions in Google Sheets, using text to search, starting position, optional arguments.

Use the split function in Google Sheets to divide text by a delimiter and create separate columns. This helps clean data from fixed-delimiter sources like ERP and bank statements.

Learn to extract year, month, and day with date functions in Google Sheets, assemble dates from components, format them with the text function, and compute day differences using today.

Learn to calculate age from date of birth in Google Sheets using yearfrac and data live functions, with start date and end date, and optimize for thousands of rows.

Learn to build nested if formulas in Google Sheets to auto-detect vehicle type, returning coupe for cars with two doors, pickup for trucks, and SUV otherwise.

Master the address function in google sheets, exploring its five-argument syntax, absolute and relative modes, and how to reference rows and columns dynamically.

Explore vlookup, hlookup, and lookup functions for vertical and horizontal lookups, with exact and approximate matches, tax slab and employee lookup examples, and error handling with iferror.

Learn to use the PMT function in Google Sheets to calculate monthly loan installments. The lecture shows rate, periods, present value, and optional future value with a car loan example.

Learn to calculate the present value of a loan with a deferred first payment, using a deferred start and monthly rate derived from 8% annual interest over 10 years.

Learn to calculate bond yield in Google Sheets using the yield function with settlement date, maturity date, rate, price, and face value, and see how market conditions affect yield.