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 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.

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 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 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.

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 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 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.

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 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.

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 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.

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.

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 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.

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 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 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.