ExcelToolkit Pro

Resources

The references worth keeping open in a second tab: shortcuts that actually save time, formulas worth memorising, and templates with working logic rather than screenshots.

Shortcuts that repay learning them

Not a list of every shortcut — the eight that change how quickly you work.

Excel keyboard shortcuts
ShortcutWhat it does
Ctrl + Shift + LToggle filters on the current range
Ctrl + TConvert a range into a real table — formulas then expand automatically
Alt + =Insert a SUM over the range above
F4Cycle absolute and relative anchors on the reference under the cursor
Ctrl + Shift + VPaste special — the fastest way to paste values only
Ctrl + EndJump to the last used cell — reveals a bloated used range instantly
Alt + F1Insert a chart from the selected range
Ctrl + graveShow formulas instead of results across the whole sheet

Formula cheat sheet

Copy it, adjust the ranges, done.

  • =XLOOKUP(A2, $B$2:$B$500, $D$2:$D$500, "Not found")

    Exact-match lookup that survives a column being inserted

  • =SUMIFS($D:$D, $B:$B, "West", $A:$A, ">="&DATE(2025,1,1))

    Sum with several conditions, including a date bound

  • =TEXTJOIN(", ", TRUE, A2:A10)

    Join values with a separator, skipping blanks

  • =IFERROR(VALUE(SUBSTITUTE(A2,"$","")), 0)

    Turn currency text into a real number without breaking on bad rows

  • =LET(rate, B1, base, C2, base * (1 + rate))

    Name intermediate values so a long formula stays readable and computes each part once

  • =SORT(UNIQUE(FILTER(B2:B500, C2:C500="Active")))

    A distinct, sorted list of the values that match a condition

Excel Formula GeneratorDescribe what you need and get a working formula.Excel Formula ExplainerPaste a formula and understand it line by line.Excel Formula CheckerAudit a formula for errors before it reaches production.VLOOKUP & XLOOKUP GeneratorBuild a correct lookup formula in four clicks.

Free templates

Every one downloads as a native .xlsx with real formulas. No watermark, no attribution required, commercial use fine.

Invoice GeneratorProfessional invoices with tax, totals and numbering built in.Invoice TemplatesTwelve invoice layouts for freelancers, agencies and retail.Payroll GeneratorBuild a payroll sheet with deductions and net pay formulas.Attendance GeneratorMonthly attendance sheets with automatic totals.Timesheet TemplatesWeekly, biweekly and monthly timesheets that add themselves up.Budget PlannerPlan income and expenses with variance tracking.
All templates

Guides