Excel at Work — 30 Essential Formulas

Stop searching for formulas every time Excel gives you a workplace problem.

Excel at Work is a beginner-friendly, practical course for people who know basic Excel but still hesitate when a real task requires a formula.

WHAT YOU WILL LEARN

• Calculate invoices, GST and totals accurately

• Clean messy names and coded text

• Track overdue and upcoming deadlines

• Use IF, AND and OR for workplace decisions

• Find records instantly with XLOOKUP

• Create conditional summaries with SUMIFS and COUNTIFS

• Replace confusing errors with useful messages

• Build a one-screen performance summary

• Create live filtered lists with FILTER and UNIQUE

WHAT YOU WILL RECEIVE

• A 44-page visual, no-video course

• Nine realistic office rescue missions

• Annotated Excel-style examples with arrows and highlighted cells

• Plain-English formula explanations

• Power shortcuts for faster work

• A downloadable Practice Workbook

• A completed Answer Workbook

• A final practical assessment

Every mission follows a simple learning method:

SEE THE PROBLEM → UNDERSTAND THE FORMULA → FOLLOW THE STEPS → PRACTISE IT YOURSELF

Designed for employees, job seekers and basic Excel users who want practical workplace confidence without sitting through hours of video lessons.

Format: PDF guide + two Excel workbooks

Recommended: Microsoft 365 or a current version of Excel

Delivery: Immediate digital download