Google Sheets Basic to Advance Course

Open Google Sheets through three methods, create a blank sheet, and understand automatic saving, sharing with permissions, templates, and the interface, including cells and the formula bar.

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

Create your first data table by entering headers and rows, navigate with tab, enter, and arrow keys, and apply date and currency formatting including rupees.

Master data selection and formatting in Google Sheets using keyboard shortcuts, such as ctrl+home, shift+arrows, and ctrl+a, to quickly select cells, ranges, and entire tables.

Master how to insert and delete rows and columns in Google Sheets, including left/right insertion, automatic row expansion when pasting data, and essential shortcuts for selection and modification.

Explore basic formatting in Google Sheets, including font, alignment, currency and percentage formats (Indian rupees), merging cells, borders, fills, hyperlinks, comments, and simple sums.

Master copy paste basics in Google Sheets, including selecting data, using Ctrl+C and Ctrl+V, and pasting across sheets. Explore paste special options like values only, format only, and transpose.

Learn to configure Google Sheets printing settings, choose current sheet, area, or workbook, and export to pdf with margins, orientation, scaling, headers, and gridlines for shareable reports.

Learn how calculations work in Google Sheets by performing addition, subtraction, multiplication, and division. Start formulas with the equals sign and use cell references to update results automatically.

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 create named ranges in Google Sheets, such as employee list and total salary, and use the counta function to automatically reflect updates when the list changes.

Learn how to create professional Google Forms for surveys, quizzes, and registrations, customize design, validate data, and collect responses via links, embeds, or print-ready PDFs.

Learn to create Google Forms from Google Drive, forms.google.com, or from scratch, using templates or custom fields, with header customization, diverse question types, and validation for supplier data collection.

Learn Google Forms basics, including sections and bank details, required fields, titles, descriptions, YouTube videos, and how to collaborate with others via shared access.

Connect a Google form to a new Google Sheet named supplier data responses to automatically collect submissions, then share by email or embed the form and review timestamps.

Learn to use the Arabic and Roman functions in Google Sheets to convert numbers to Roman numerals, with proper syntax, cell references, and a default zero.

Learn how to use the concatenate function in google sheets to join strings and cell references, control spacing with quoted spaces, and handle ranges for lists.

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 how to use the fixed function in Google Sheets to format numbers with a fixed number of decimal places, control thousand separators, and toggle true/false (0/1) options.

Learn how to use the join function to combine text from multiple cells with a delimiter in Google Sheets, replacing concatenate and creating clean, spaced results.

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 to format text in Google Sheets using lower, upper, and proper functions to convert strings to lowercase, uppercase, and proper case.

Master the replace function in Google Sheets to modify text strings by specifying text, position, length, and new text, with practical examples like correcting misspelled words.

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.

Learn to use the repeat function in Google Sheets, repeating given text a set number of times to build charts and dashboards, with practical examples and tips.

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 how the value function in Google Sheets converts strings to dates or times or numbers for calculations, including formatting options and practical examples.

Learn how the trim function removes leading, trailing, and extra spaces from text or a cell reference in Google Sheets. See how trim cleans sentences to remove unwanted spaces.

Learn how the exact function tests whether two strings are identical in Google Sheets; it is case sensitive and returns true or false when you compare using the equals sign.

Explore the substitute function in Google Sheets, including its syntax, how to replace text, optional occurrence count, and how partial matches can affect replacements.

Learn to dynamically split full names into first and last names in google sheets using advanced text functions like left, right, search, and proper to handle space and update automatically.

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 use edate and eomonth in Google Sheets to add or subtract months, format dates, and determine the first or last day of a month.

Learn how the days360 function computes the number of days between dates using a 360-day year, with US or European methods for financial calculations.

Learn how to use the networkdays.intl function to calculate working days between a start date and an end date, with optional weekends and holidays, to exclude nonworking days.

Use workday.intl in Google Sheets to calculate an end date by counting working days from a start date while excluding weekends and holidays, with customizable weekend days and holidays lists.

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.

Calculate working hours and overtime in Google Sheets from time data, including night shifts, weekly offs, and holidays, using min/max logic and vlookup for wages.

Learn logical operators in Google Sheets, including equal, not equal, greater than, and less than, plus their equal variants, to compare values and support if and countif formulas.

Master how to use the if function in Google Sheets to return good or bad based on a logical test, with an example comparing a value to the average.

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.

Use the end function with a nested if in Google Sheets to return true or false based on two conditions: first three letters 202 and middle fica, for 10% discount.

Explore the OR function in Google Sheets using IF with logical expressions to grant a 10 percent discount when item codes start with 202 or 203, otherwise zero.

master the IFS function in Google Sheets to handle multiple conditions without nested if, understand its syntax, and apply it to membership discounts in admin reporting.

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

Learn how the choose function selects an item by index from a list in Google Sheets, using up to 29 choices and no table reference, with color codes and ranks.

Explore essential Google Sheets functions, including column, columns, and rows for range selections, and the formulatext (formula text) function to display a cell’s formula.

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 automate salary slips in Google Sheets with vlookup. Create a dynamic employee code dropdown and fetch name and department to update slips automatically.

Learn four essential concepts before using financial functions in Google Sheets: time value of money, cash in and cash out, matching time periods, and timing of the first payment.

This lecture shows how to compute the present value of future cash flows using google sheets, detailing rate, nper, pmt, optional fv and type (ending or beginning) arguments.

Calculate the present value of a lump sum using the future value of $200,000 after ten years at a 10 percent rate; the present value is about $77,108.66.

Calculate the present value of an annuity plus a lump sum with the present value function. Evaluate a 100,000 upfront investment with 2,000 monthly payments and a 150,000 future value.

Learn to calculate future value in Google Sheets using rate, periods, payment, present value, and type, illustrated by three examples: investments, a lump sum, and loan amortization.

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.

Use Google Sheets rate function to calculate interest rates, with periods, payment, present value, future value, type, and guess, illustrated by payday loan and mutual fund growth examples.

Use the NPER function to determine periods to reach 5 million with present value 1 million and future value 5 million, plus 15k monthly payments and early loan payoff.

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.

Calculate the bond price and determine face value using a Google Sheets price function, considering settlement, maturity, rate, yield, redemption, frequency, and discount convention.

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.

Learn to compute net present value (NPV) using the NPV function with a discount rate, applying it to a 150,000 investment over ten years with escalating cash inflows.

Learn how to use pivot tables in Google Sheets to summarize sales by region, create a pivot table, and explore fields, rows, and values for quick grand totals.

Learn to build pivot tables in Google Sheets with pivot table editor, ensure headings and data types, group dates by year and month, filter by date, and analyze sales.

Learn to build pivot tables in Google Sheets and apply count, counta, min, max, average, and median functions to summarize orders, sales, and city data.

learn to group sales amounts in 500-dollar intervals in a google sheets pivot table, count orders per group, and extract detailed orders between selected values for actionable business insights.

Learn to create calculated fields in a Google Sheets pivot table to compute cost of goods sold by subtracting profit from sales, format as currency, and customize the pivot table.