Beginner essentials

Write your first Excel formula by calculating 32+57 directly in a cell.

Use the SUM function with cell references to calculate total monthly income after expenses.

Use the AVERAGE function to calculate the average of a group of numbers.

Calculate extended cost (quantity × unit price) for each line item.

Use VALUE to turn imported text numbers into real numbers that Excel can total.

Use ROUND to clean up invoice totals so each price shows exactly two decimal places.

Use INT and TRUNC to remove decimals from imported time offsets and compare how they behave with negative numbers.

Count how many products are in the inventory list.

Identify the highest sales amount from monthly data.

Find the lowest expense in a budget line items list.

Use COUNTIF to count cells that match one condition in a list.

Use MEDIAN to find the middle salary in a compensation list and compare it with a prefilled average in a skewed dataset.

Apply a single tax rate (in a fixed cell) to multiple product prices.

Calculate what percentage each department's budget is of the total.

Combine first and last names into full names using the CONCATENATE function.

Fix inconsistent capitalization in names and remove extra spaces from imported notes.

Extract the 3-letter department code from the start of each SKU (e.g. FIN-1042 -> FIN).

Use the IF function to determine whether students passed or failed based on their scores.

This one's an opportunity to practice your IFs, ANDs and ORs. You may find yourself combining these functions when you require more complex...

Calculate an employee's current age from their date of birth.

Find a product's price from a product catalog using the product code.

Use XLOOKUP to find a product's category from a product catalog.