Search tutorials and deep dives. Error Directory has quick fixes; Deep Dive opens only full guides.
Three downloadable guides built for learning, reference, and real workbook work.
A practical reference for formulas, functions, lookups, arrays, finance, statistics, errors, and real-world spreadsheet tasks.
A structured start for someone with little or no Excel knowledge, moving from cells and formulas to practical beginner projects.
Build stronger formula, data, lookup, dynamic-array, statistics, finance, and verification skills for real workbooks.
Digital downloads are delivered through Payhip after purchase. ExcelFormulaAI does not expose the paid PDF files directly from this page.
Clear blocked spill ranges, Tables, merged cells.
Lookup not found patterns.
Spelling, quotes, Name Manager, xlfn.
Text numbers and type mismatches.
Broken references after delete.
Safe division guards.
Find and redesign loops.
Manual mode and text formulas.
Set keyword and object variables.
Range and sheet runtime errors.
Unreadable workbook recovery.
Large file performance.
if_not_found and match issues.
TRIM and CHAR(160).
Boolean and concatenated keys.
When to migrate.
Exact match troubleshooting.
Geometric growth rate.
Cash flow yields.
FV and EFFECT.
SUMPRODUCT patterns.
Discounted cash flows.
Dynamic unique lists.
Spill engine basics.
Ctrl+Shift+Enter issues.
Record, security, first Sub.
Trusted locations and enable.
Core operators and functions.
Criteria patterns.
TRIM and CHAR(160).
Tool + UNIQUE formula.
Serials, NETWORKDAYS, TEXT.
Data validation fixes.
Rules not applying.
Array size, nesting, and Sheets spill issues.
Find, repair, or remove external links.
Grant access and fix source references.
Simplify nested formulas with LET and helpers.
Fix query columns, quotes, and header rows.
Fix relative, absolute, and mixed references.
Resolve cross-platform function differences.
Preserve formatting, zeros, and text encoding.
Diagnose constraints and convergence issues.
Resolve legacy Excel compatibility issues.
Fix invalid numeric calculations and limits.
Fix incorrect range-intersection syntax.
Resolve dynamic-array calculation failures.
Fix Stocks and Geography data-type fields.
Diagnose RTD and live-data delays.
Restore broken external data connections.
Troubleshoot stalled data retrieval.
Fix Google Sheets export and save failures.
Fix Google Sheets formula syntax.
Understand platform-specific reference errors.
Fix formulas copied between platforms.
Make formulas return results again.
Fix criteria and range mismatches.
Turn raw date numbers into dates.
Correct incompatible variable types.
Find missing sheet and array indexes.
Diagnose query steps and type failures.
Fix data-source refresh failures.
Repair source headers and ranges.
Fix source and refresh problems.
Repair date and number grouping.
Reduce workbook formatting overload.
Resolve save and permission failures.
Clear Excel memory-limit blocks.
Prevent merged cells breaking formulas.
Stop automatic formula corruption.
Fix misleading custom displays.
Full XLOOKUP syntax and use cases.
Advanced two-way lookup architecture.
Conditional averages by criteria.
Single-criteria counting patterns.
Control decimal rounding correctly.
Count characters and validate text length.
Get cell coordinates dynamically.
TEXTSPLIT, LEFT, RIGHT patterns.
Cleaner multi-tier logic.
Extract specific columns and rows.
Slice arrays to the rows you need.
Sort data dynamically with formulas.
Asset depreciation schedules.
Growth and variance calculations.
Conditional formatting and sparklines.