Microsoft Excel Formulas and Functions: Learn Fast and Smart

Explore beginner-friendly Microsoft Excel formulas for sum, average, min, and max, using range selection and the functions dialog to build quick calculations.

Learn how to use count, count a, and count blank in Microsoft Excel to count numbers, non-empty cells, and empty cells within a data range.

Explore basic cell referencing in Excel, demonstrating relative, absolute, and mixed references with practical copy-paste examples using the dollar sign to lock values.

Learn to use AutoSum and QuickSum in Excel to quickly total a range, view the sum and count on the status bar.

Master if statements and nested if formulas in Excel, apply conditional formatting to set passing thresholds, and assign grades A, B, C, or F based on numeric scores.

Master Excel formulas with and, or, and not to evaluate multiple conditions in student scores, showing how and requires both scores above 50, or at least one, not reversing results.

Explore the difference between ISERROR and IFERROR in Excel, showing how ISERROR returns true or false while IFERROR allows custom outputs when errors occur, such as division by zero.

Master the IFS function in Excel 2016+ to replace nested ifs, evaluate multiple conditions in order, and return the first true result, enabling automatic grade calculations.

Explore concatenate and text join in excel to join values into a string. Learn how text join, a newer function since 2016, uses a delimiter and ignores blanks, unlike concatenate.

Explore Excel's left, right, and mid functions to extract parts of an id, such as emp and country code, and automate the process with a table.

Explore the value, text, and rept (repeat) functions in Excel to pull cell values, format numbers as currency or percent, and repeat symbols for custom outputs.

Master essential time functions in Excel by using today, now, day, month, and year to extract dates, times, and components from cells, boosting daily workflow.

Master weekday, networkdays, and workday functions in Excel to count workdays between dates, add workdays, and factor in holidays for accurate scheduling.

Master datedif and edate to calculate differences between two dates and to add or remove months, days, or years in Excel.

Master vlookup and hlookup to search data in vertical and horizontal tables. Use exact-match with false to retrieve salaries and IDs accurately.

Master the index and match functions and their combination to perform powerful lookups in Excel, using exact-match lookups to retrieve a salary by id.

Master x lookup in Excel 365/2021 to replace vlookup, hlookup, and index match, handling vertical, horizontal, and reverse lookups for salary, id, and department.

Explore how to use the choose, offset, and indirect functions in Excel to create dynamic lists, drive drop-down selections, reference cells, and build dashboards that adapt as data changes.

Explore Excel rounding in depth with round, round up, and round down, learn how to set decimal places, and apply precise rounding to numbers in real data.

Explore ceiling, floor, int, and mod in Excel: ceiling rounds up to the next multiple, floor rounds down, int returns the integer part, and mod returns the remainder.

Learn how to use rank, large, and small in Excel to rank numbers, identify the top values, and find the largest and smallest numbers with fixed ranges.

Discover rand and rand between in Excel to generate random numbers, specify ranges, and convert into percentages or rounded values for probability and risk simulations.

Explore legacy array formulas, dynamic arrays, and array formulas in Excel to perform fast, auto-updating calculations, leverage sum product, and support dashboards and reports.

Learn to build dynamic named ranges in Excel that auto-update with new data, using offset and countA to create flexible ranges for sums, averages, and maximum values.

Explore how nested functions in Excel evaluate pass, retake, or fail by score and attendance, building nested if formulas that drive decisions within a data table.

Master formula auditing in Excel by tracing precedents and dependents, evaluating formulas, and using error checking to pinpoint and fix data errors quickly.

Explore how to use pmt, rate, npv, fv, and pv in Excel to calculate monthly loan payments, interest rates, and present and future values with practical data.

Explore IRR (internal rate of return), SLN (straight line depreciation), DV (declining balance), and DDB (double declining balance) to evaluate projects, compute depreciation, and model asset depreciation in Excel.

Learn to build an amortization table in excel using formulas to track loan payments, interest, principal, and balance, including fixed payments calculated with inverse pmt and automated monthly updates.

Learn to filter data, sort by various parameters, and use sort by color or subject within an Excel table, keeping headers intact and mastering quick data ranking.

Explore Excel formulas unique, sequence, and randarray to extract unique values, generate serial data, and create random integers for dynamic data tables.

Discover how spill ranges in Excel generate multi-cell results, using sequence and rand array, with unique and sum across the range.