Google Sheets + MS Excel Course: Basic to Advance Level

Master Google Sheets math functions from sum and average to count, max, min, and large and small, including countA and countblank, with nesting, text handling, and blank cell logic.

Explore logical operators and the if function in Google Sheets and Excel, using greater than, less than, equals, and does not equal tests to determine true or false outcomes.

Master nested if statements in Google Sheets and MS Excel to handle three or more conditions, classifying scores as less than 40, 40–60, and above 60.

Explore the if function to determine scholarship eligibility and calculate the amount by multiplying scores over 70 by 1000, and rank top and bottom scorers.

Use the if function to determine scholarship eligibility: if score is greater than 70, calculate (score-70)*1000; otherwise mark not eligible, while using max, min, and absolute references for reliable autofill.

Explore how to transform text in spreadsheets using upper, lower, proper, sentence case, and trim functions, learn to nest these functions, remove extra spaces, and apply changes across cells.

Learn left, right, and find functions in Google Sheets and MS Excel with practical examples to extract left or right characters and locate positions in text.

Learn left, right, and find nesting to extract a name and a mobile number from a sentence using dynamic character counts and dot-based delimiters.

Learn to use the concatenate function in Google Sheets and Excel to join text and format phone numbers as 123-456-789 by combining left, mid, and right substrings.

Learn to use the replace function in Google Sheets and Excel to standardize pin codes, using find, right, and length to locate six-character sequences and replace with a new value.

Explore how the substitute function differs from replace in Google Sheets, using text-based matching, position-based replacement, and optional occurrence controls, with practical examples and length-based counts.

Learn how to split a single column into multiple fields in Google Sheets using split text to column, with automatic and custom separators, including comma, space, semicolon, and hyphen.

Apply conditional formatting in Google Sheets using color to implement rules such as is not empty, text contains, greater than, between, and custom formulas, with rules and color scales.

Learn to create and name ranges in Google Sheets using the data menu, apply underscores rather than spaces, and use named ranges for navigation and formulas.

Learn to create and manage links in Google Sheets by linking named ranges, specific cells, other sheets, and external websites, and editing or removing links for efficient data navigation.

Explore data validation in Google Sheets by applying text, date, email, list, and checkbox rules; build conditional validations with formulas to enforce entry accuracy.

Learn how to use vlookup to find names and retrieve contact details in Excel and google sheets, including exact matches, range selection, and importing ranges across spreadsheets.

Discover how to combine iferror with vlookup to handle missing matches and show 'no data found' messages in Google Sheets and Excel, enabling cross-sheet lookups.

Master the hlookup function for horizontal data, learn to transpose data when needed, and retrieve contact numbers using a unique name key in the master data.

Learn to combine Vlookup with Match to dynamically retrieve names, courses, contacts, and locations from a master data sheet, using absolute references and proper range locking.

Apply vlookup with approximate match by using true to map scores to grade ranges like fail, compartment, pass, and distinction.

Explore datedif to compute age in years, months, and days using today and birth dates, and master networkdays to count working days between dates, excluding weekends and holidays.

Master the PMT, PPMT, IPMT, and PV functions in Excel to calculate the equated monthly installment, total payments, interest, and principal from rate, periods, and present value.