EXCEL · 01 FOUNDATIONS
The $ sign,
finally
explained.
every row → same cell=C2*$E$1
eoinderry.com
EXCEL · 02 WORKING WITH DATA
Clean messy data
without tears.
  aoife MURPHY
↓
Aoife Murphy
eoinderry.com
EXCEL · 02 WORKING WITH DATA
Ctrl+T
changes
everything.
DateItem£
3 JunPaper41
4 JunToner118
+ new row absorbed ✓
eoinderry.com
EXCEL · 03 FORMULAS THAT THINK
One formula.
Every answer.
how much · how many=SUMIFS(…)
eoinderry.com
EXCEL · 04 LOOKUPS
Forget
VLOOKUP.
the one to learn first=XLOOKUP(…)
eoinderry.com
EXCEL · 05 ANALYSIS
PivotTables
aren't hard.
ΣLitePro
Cork150480
Dublin220610
Total3701,090
eoinderry.com
EXCEL · 06 POWER TOOLS
Stop bad data
at the door.
Dublin    ▾
Cork
Galway
dub.  ✗
eoinderry.com
MONEY · EXCEL APPLIED
The 4-number
budget.
IN      £2,400
FIXED   £1,310
FLEX     £640
FUTURE   £450 ← the point
eoinderry.com
MONEY · EXCEL APPLIED
Watch your
money grow.
eoinderry.com
M365 · FIELD NOTES
Copilot in Excel:
the truth.
drafts    ✓
grunt work ✓
your numbers ✗
judgement  ✗
eoinderry.com