Microsoft Excel: Formulas for Beginners

Explore how the sum function adds numbers, whether as individual values, cell references, or ranges like C8:E8, with real-world examples using 1.25 and 2.50.

Learn how the average function computes the arithmetic mean of its arguments, including individual values, cell references, and ranges, with examples using 1.25 and 2.50 across c8:e8.

Discover how the count function tallies numeric cells in values, references, and ranges, and why it only counts numbers; use counta to count nonnumeric data.

Explore the min and max functions in Excel, learning to find the smallest and largest numbers from individual values, cell references, and ranges with practical examples.

Master concat, len, and replace to manipulate text in Excel by joining strings from cells or ranges without delimiters or ignoring empty arguments, counting characters, and replacing parts.

Learn to use VLOOKUP to pull region-based account managers from a lookup table into a working table, with table array, absolute references, and exact-match false.

apply the second vlookup example to join a March invoices table with a region id lookup table, using region ids and exact match; convert text numbers with the value function.

Combine VLOOKUP with the King Cat formula to create a unique lookup value, perform an exact-match lookup, and retrieve account managers from the table array.

Explore the if statement in Excel, including logical tests, true/false outputs, and summing results to count adults at a party, with practical tips for entering formulas.

Apply an if statement to calculate a 10% rebate for invoices $100 or more, returning zero otherwise, with absolute references to key cells.

Explore the third example of the if statement with nested ifs to assign rebates: 10% at 100, 5% at 50, and 2.5% below 50, using absolute references.

Use a two-condition if statement with the and formula to award invoices greater than or equal to $100 that have a contract with a 10% rebate, else return zero.