Functions
Excel functions to enhance your skills
Functions libraries (26 available)
FILTER Function Mastery
FILTER Function MasteryExcel 365's Revolutionary Dynamic Filtering
PDF
1.13 MB
680 downloads
INDEX and MATCH Mastery
INDEX MATCH MasteryThe Most Powerful & Flexible Lookup Combination
PDF
1.48 MB
2291 downloads
XLOOKUP Mastery
XLOOKUP MasteryMaster Excel 365's Most Powerful Lookup Function
PDF
978.33 KB
1416 downloads
Logical & Error Functions
12 Logical & Error FunctionsMaster Decision Making & Error Handling
PDF
987.41 KB
1827 downloads
Date & Time Functions
14 Date & Time FunctionsMaster Temporal Analysis & Date Calculations
PDF
1.06 MB
1708 downloads
8 Lambda Functions
8 Lambda FunctionsCreate Custom Functions & Advanced Calculations
PDF
986.43 KB
724 downloads
Pivot Table Formulas Guide
Master GETPIVOTDATA and pivot table calculations with this Guide
PDF
1.05 MB
2354 downloads
Top 20 Excel Formulas
Most Powerful Formulas in Excel including 365 version
PDF
1.06 MB
2155 downloads
Dynamic Functions Guide
Learn FILTER, UNIQUE, SEQUENCE and SORT function with this simple guide.
PDF
1.06 MB
858 downloads
SUMIFS with WILDCARD
Master Excel's SUMIFS Function with Wildcards which allows you to sum values based on multiple criteria, inclduing patte...
PDF
1.05 MB
1710 downloads
SWITCH Function CHEATSHEET
Master Excel’s SWITCH Function with Our In-Depth Cheatsheet InfographicElevate your Excel formula skills by learning the...
PDF
106 KB
1432 downloads
IFS Function Cheatsheet
Master Excel’s IFS Function with Our Ultimate Cheatsheet InfographicTransform the way you handle complex logical conditi...
PDF
95.94 KB
1649 downloads