Microsoft Excel Formulas & Functions Masterclass

Master totaling student marks in Excel by manually adding Hindi, English, math, and science, then automatically with the sum formula, and copy the results down.

Learn to use the sumif function to automatically total yearly sales by employee, matching names and compiling a year-wise sales report.

Learn to use the sumifs function to total amounts by employee and item, freezing ranges and copying the formula to compute laptop sales for each employee.

Master the sumproduct formula to calculate total sales by multiplying quantity by amount across rows, yielding the grand total for the table using ranges such as c2:c16 and d2:d16.

Learn how the d sum function adds quantity from a table based on a condition, using a database, a field, and a criteria table to return the total quantity.

Master the if function in Excel to evaluate scores: pass if 49 or more, fail otherwise, then use nested if to assign grades a, b, or c.

Master the Excel IFS function to evaluate multiple conditions and assign grades from scores, simplifying nested ifs with a clean, rule-based approach.

Apply the if with and technique in Excel to verify multiple conditions, returning pass when both tests are true and fail when any test is false.

Learn to use the or function with if to award an incentive based on department or days worked; if either condition is met, return Yes, otherwise No.

Use isna with match in an if formula to check if a hotel name exists in all three city lists, returning yes when found and no if missing anywhere.

Learn to use the count function to tally numeric values in a range, ignoring blanks and text, apply =count(range), and extend results with the fill handle.

Use COUNTA to count all non-empty cells in a range, including numbers, text, or formulas, while ignoring blanks. This helps verify data completeness in sales data for reports.

Master the countif function to count cells that meet a single condition, such as presence 'P' in attendance data, making Excel count automatically, accurately, and quickly.

Use the countifs function to count employees by department with sales greater than 50,000, applying two conditions, freezing ranges, and dragging the formula to build a department wise performance summary.

Learn how the count blank function identifies empty cells in a sales data range across 2019–2021, revealing missing records to ensure accurate, reliable reports for decision making.

Learn how to find the minimum marks for each student using the min function in Excel, selecting B2:D2 and using the fill handle to copy down.

Apply the max function to each student’s marks range to get their highest score in the max column, then drag to fill for all students and identify top performers.

Discover how the trim function in Excel removes extra spaces from text. Apply it to a list of names to clean data and ensure uniform results using the fill handle.

Master the proper function to convert names to proper case, apply it to a column, and use the fill handle to standardize large lists for professional, error-free records.

Learn how the lower function in Excel converts text to lowercase, standardizing names and data for clean, consistent reporting, easier sorting, searching, and matching.

Master essential Excel formulas and functions, from sum and count to if and text functions, to calculate totals, apply conditions, clean data, and format text for professionals.