Home overview
What the brand covers and why Power Query, VBA, and AI sit together.
Go to home →Resources
Official docs, deep references, and on-site guides. External links open documentation from Microsoft and the wider Excel community.
On this site
Start with Nifty Excel’s own technique cards and AI prompting patterns.
Techniques
Power Query steps, modern formulas, VBA structure, and workbook layering.
Browse techniques →AI + Excel Hub
Prompt templates, safety habits, and a three-step verification workflow.
Open AI Hub →Microsoft documentation
Authoritative references for functions, Power Query, and automation surfaces.
-
Microsoft Excel help & learning
Official how-to articles for formulas, charts, Tables, and collaboration features.
-
Power Query documentation
Connectors, transformation guidance, and M language concepts for refreshable data pipelines.
-
Excel VBA object model
API reference for Workbook, Worksheet, Range, ListObject, and related objects.
-
Office Scripts
TypeScript-based automation for Excel on the web and Power Automate integrations.
-
XLOOKUP function
Modern lookup syntax with optional if-not-found handling and search modes.
Practice checklists
Lightweight lists you can copy into a workbook Notes sheet.
Before you automate
Is the process stable enough? Can Power Query replace the macro? Do you have a sample file and expected outputs? Who will maintain this after holiday leave?
Before you ship a file
Broken links cleared, named ranges still valid, volatile formulas minimised, sample refresh tested offline, password policy agreed, and a one-page README sheet included.
AI review pass
Prompt disclosed assumptions, secrets not pasted, edge cases listed, results compared to prior month, and a human signed off on destructive actions.
Handover pack
Source system names, refresh order, parameter cells, known quirks, and contact for data owners. Prefer boring clarity over clever shortcuts.
Need a technique, not a link?
Jump into the techniques library for Power Query, formulas, VBA, and structure patterns written for real workbooks.