All Excel Workflows

Free step-by-step guides for solving Excel problems with tested ChatGPT prompts — formulas, errors, finance models, data cleaning and reports.

Fix Excel Errors

Fix #REF! Errors in Excel

Read workflow →

Fix #N/A Errors in VLOOKUP and XLOOKUP

Read workflow →

Fix Circular Reference Errors in Excel

Read workflow →

Fix an Excel Formula Not Calculating

Read workflow →

Fix Excel Showing Formula Instead of Result

Read workflow →

Compare Two Lists or Columns in Excel

Read workflow →

Compare Two Excel Sheets

Read workflow →

Highlight Duplicates in Excel

Read workflow →

Understand Complex Inherited Formulas

Read workflow →

Formulas & Functions

XLOOKUP Formula in Excel

Read workflow →

SUMIFS Formula for Multi-Criteria Reports

Read workflow →

IF and IFS Formulas for HR and Payroll

Read workflow →

LAMBDA Functions in Excel

Read workflow →

Conditional Formatting Based on Another Cell

Read workflow →

Excel IF Cell Contains Text

Read workflow →

INDEX MATCH Multiple Criteria

Read workflow →

Data Cleaning & Reports

Clean and Standardise Data in Excel

Read workflow →

Turn Manual Reports into Dynamic Models

Read workflow →

Pivot Table Reports in Excel

Read workflow →

How to Remove Duplicates in Excel

Read workflow →

Remove Blank Rows in Excel

Read workflow →

How to Remove Spaces in Excel

Read workflow →

Convert Text to Date in Excel

Read workflow →

Fuzzy Match in Excel

Read workflow →

Merge Multiple Excel Files

Read workflow →

Split Text in Excel

Read workflow →

Convert Text to Number in Excel

Read workflow →

Finance Models

Automated Bank Reconciliation in Excel

Read workflow →

3-Statement Financial Model in Excel

Read workflow →

Payroll Reconciliation Template in Excel

Read workflow →

12-Month Rolling Forecast in Excel

Read workflow →

CapEx Planning Template in Excel

Read workflow →

Month-End Close Checklist in Excel

Read workflow →

Multi-Entity Financial Consolidation in Excel

Read workflow →

Fixed Asset Depreciation Schedule in Excel

Read workflow →

Loan Amortization Schedule in Excel

Read workflow →

Small Business Bookkeeping Template

Read workflow →

Budget Variance Analysis Report in Excel

Read workflow →

Accounts Payable Aging Dashboard in Excel

Read workflow →

Accounts Receivable Tracking in Excel

Read workflow →

Financial KPI Dashboard in Excel

Read workflow →

Cash Flow Dashboard in Excel

Read workflow →

13-Week Cash Flow Forecast in Excel

Read workflow →