Data Insights
Beautiful visualizations powered by advanced Excel formulas
All Formulas
Lookup
XLOOKUP
Modern lookup function that searches in any direction with built-in error handling
Use Case
Finding exact matches or approximate values across large datasets
Lookup
INDEX MATCH
Powerful combination for flexible lookups with multiple criteria
Use Case
Complex searches that VLOOKUP cannot handle, like leftward lookups
Array
FILTER
Dynamic array function that extracts rows meeting specific criteria
Use Case
Creating live-updating filtered lists without helper columns
Array
UNIQUE
Returns unique values from a range, eliminating duplicates automatically
Use Case
Generating distinct lists for analysis and deduplication tasks
Advanced
LET
Assign names to calculation results for cleaner, more efficient formulas
Use Case
Simplifying complex formulas and improving performance
Array
SEQUENCE
Generate arrays of sequential numbers for dynamic calculations
Use Case
Creating dynamic ranges and custom numbering systems