Excel for Beginners

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). A sheet is a grid. Columns are letters, rows are numbers. C2 means column C, row 2.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). COUNTA counts cells with anything in them, even words.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). A name makes an important cell easier to remember.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). LOWER changes capital letters into small letters.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). Dates can be moved forward by adding days.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). IF(question, answer if yes, answer if no).

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). IFERROR shows a friendly message instead of #N/A.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). SUMIFS can add numbers between a low and high limit.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). SUBTOTAL can ignore rows hidden by a filter.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). TEXTSPLIT breaks text wherever it finds a separator.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). SUMIFS: add range first, then pairs of rules.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). Insert ▸ PivotTable. Put the group in Rows and the number in Values (Sum). The formula version is PIVOTBY.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). XLOOKUP can return a whole row of matching values.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). RRI finds the steady growth rate between a start and end value.

You are a data analyst. Finance sheet (column A = payment_id, B = region, C = amount, rows 2–5). MAKEARRAY builds values from row and column positions.

You are a data analyst. Finance workbook (column A = payment_id, B = region, C = amount). A column chart uses tall blocks so you can compare values quickly.

You are a data analyst. Finance workbook (column A = payment_id, B = region, C = amount). Sorting from biggest to smallest makes comparisons faster.

You are a data analyst. Finance workbook (column A = payment_id, B = region, C = amount). A dashboard puts the most important answers on one screen.

You are a data analyst. Finance workbook (column A = payment_id, B = region, C = amount). A dynamic title says which filter the reader selected.

You are a data analyst. A regional bank has a problem: managers cannot see which accounts are running above budget. As a junior finance analyst, you are tasked to build a budget tracker that flags the biggest values. Sheet: column A = payment_id, B = region, C = amount.