Learn Excel formulas, step by step
Excel CSE explains Excel functions in plain language, with small worked examples you can copy straight into your own spreadsheet. No long videos, no fluff: just what the formula does, how to write it and how to fix it when it breaks.
Start here
Excel tutorial for beginnersStart from zero: data, formulas, formatting and a first chart.
Formulas cheat sheetAll the important Excel formulas on one page, with an example of each.
VLOOKUPFind a value in a table and return a matching value from the same row.
XLOOKUPThe modern lookup: search any column and return a match, left or right.
IFReturn one value if a condition is true and another if it's false.
SUMIFAdd up only the values that meet a condition, like sales per region.
What does CSE mean?
In Excel, Ctrl+Shift+Enter (CSE) is the key combination that used to turn a regular formula into an array formula. It's a nod to the power users who know their way around a spreadsheet, and that's where we want to help you get to.