ExcelHub
Excel — Guides, Functions, and Tutorials
Everything Excel in one place. Complete pillar guides, every function reference, step-by-step how-tos, downloadable templates, and the AI tools that make Excel faster. Whether you're a first-time user or an advanced analyst, start here.
What's on this page
Complete Guides
In-depth pillar guides covering each major area of Excel from the ground up.
Conditional Formatting
Data Validation
Macros & VBA for Beginners
Array Formulas & Dynamic Arrays
Pivot Tables
Power Query
Power Pivot
Charts
Function References
Every Excel function with syntax, arguments, examples, and tips.
Lookup & Reference
Lookup Hub
VLOOKUP
XLOOKUP
INDEX / MATCH
INDEX
MATCH
XMATCH
OFFSET
INDIRECT
CHOOSE
LET
ADDRESS
TRANSPOSE
FILTER
SORT
UNIQUE
Math & Statistical
Math Hub
SUMIF
SUMIFS
COUNTIF
COUNTIFS
AVERAGEIFS
MINIFS
MAXIFS
ROUND
ROUNDUP
ROUNDDOWN
Statistical Hub
AVERAGE
AVERAGEIF
COUNTIF (Statistical)
MEDIAN
MIN
MAX
Text
Logical
Date & Time
Information & Other
Information Hub
ROW
COLUMN
ROWS
COLUMNS
Financial Functions Hub
Dynamic Arrays Hub
AI Functions Hub
Engineering
Database
Cube & Web
Compatibility
Charts & Visualization
Charts Hub
Charts Complete Guide
Bar Charts Guide
Line Charts Guide
Pivot Charts Guide
Dashboards Guide
Pivot Tables & Power Pivot
Pivot Tables Complete Guide
Getting Started
Calculations
Formatting
Slicers
Troubleshooting
Power Pivot Guide
Data Model
DAX Formulas
Measures vs Calculated Columns
Automation — VBA & Power Query
Macros & VBA Beginners Guide
Power Query Complete Guide
M Language Guide
Data Cleaning
Merging & Appending
Dynamic Arrays & Modern Formulas
Formatting & Validation
How-To Posts
Step-by-step tutorials for common Excel tasks.
Use SUMIFS with Multiple Criteria
Link Cells Across Sheets & Workbooks
Password Protect an Excel File
Import Data from PDF to Excel
Convert Excel to Google Sheets
Add a Checkbox
Add a Dropdown
Compare Two Columns
Filter Data
Freeze Rows
Lock Cells
Merge Cells
Protect a Sheet
Remove Duplicates
Sort Data
Split Cells
Unhide Rows
Make Sparklines
Make a Bar Chart
Make a Pie Chart
Make a Combo Chart
Make a Gantt Chart
Make a Histogram
Make a Scatter Plot
Make a Waterfall Chart
Make a Funnel Chart
Make a Radar Chart
Create a Pivot Table
Add a Calculated Field
Group Data in a Pivot Table
Refresh a Pivot Table
Sort a Pivot Table
Import CSV with Power Query
Unpivot Columns in Power Query
Use CALCULATE in DAX
Create a Relationship in Power Pivot
Comparisons
XLOOKUP vs VLOOKUP
INDEX/MATCH vs XLOOKUP
SUMIF vs SUMIFS
COUNTIF vs COUNTIFS vs COUNTA
IFS vs Nested IF
IFERROR vs IFNA
FILTER vs AutoFilter
Pivot Tables vs Formulas
CONCATENATE vs TEXTJOIN vs &
Power Query vs Power Pivot
ARRAYFORMULA vs Dynamic Arrays
Excel vs Google Sheets
Excel vs Airtable
Excel vs Monday
Excel vs Notion
Excel vs Smartsheet
Excel vs Retool
Top Lists
10 Excel Functions Every Analyst Needs
15 Excel Formulas That Save Hours
Excel Charts Every Analyst Should Master
Excel Text Functions for Data Cleanup
Excel Keyboard Shortcuts Every Pro Uses
Excel Keyboard Shortcuts Cheatsheet
XLOOKUP Tricks You Didn't Know
Excel Dashboard Templates
Financial Excel Functions for Analysts
Best Excel Templates for Small Business
Excel Error Messages Explained
Excel Errors and How to Fix Them
AI in Excel
AI in Excel Hub
AI in Excel Complete Guide
Microsoft Copilot
ChatGPT with Excel
Claude for Excel
Best AI Add-ins for Excel
Generate Formulas with AI
Clean Data with AI
Analyze Data with AI
Explain Formulas with AI
Write Better AI Prompts
ChatGPT vs Copilot for Excel
Copilot vs Excel Wizard
Copilot vs Gemini
Excel AI vs Google Sheets AI
Templates
Templates Hub
Finance Templates
Business Ops Templates
Dashboards
Data Analysis
Personal
Student
Budget Tracker
Loan Calculator
Invoice Template
Inventory Tracker
Expense Report
Employee Attendance
Project Timeline
KPI Dashboard
Sales Dashboard
Timesheet
Error Reference
Errors Hub
Formula Errors
Dynamic Array Errors
Lookup Errors
File Errors
Feature Errors
Function Errors
#VALUE!
#REF!
#N/A
#NAME?
#DIV/0!
#NUM!
#NULL!
#SPILL!
#CALC!
Circular Reference
Excel Wizard
Excel at the speed of thought
Formulas, pivot tables, charts, automation — Excel Wizard builds them from plain-English intent, right inside Excel. Free to try.
Install Excel Wizard →