Functions
Excel functions to enhance your skills
Functions libraries (20 available)
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF
1.7 MB
62 downloads
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF
1.48 MB
178 downloads
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF
1.47 MB
391 downloads
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF
1.8 MB
657 downloads
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF
1.76 MB
789 downloads
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF
1.04 MB
459 downloads
FILTER Function Mastery
FILTER Function MasteryExcel 365's Revolutionary Dynamic Filtering
PDF
1.13 MB
512 downloads
INDEX and MATCH Mastery
INDEX MATCH MasteryThe Most Powerful & Flexible Lookup Combination
PDF
1.48 MB
317 downloads
XLOOKUP Mastery
XLOOKUP MasteryMaster Excel 365's Most Powerful Lookup Function
PDF
978.33 KB
332 downloads
Logical & Error Functions
12 Logical & Error FunctionsMaster Decision Making & Error Handling
PDF
987.41 KB
770 downloads
Date & Time Functions
14 Date & Time FunctionsMaster Temporal Analysis & Date Calculations
PDF
1.06 MB
599 downloads
8 Lambda Functions
8 Lambda FunctionsCreate Custom Functions & Advanced Calculations
PDF
986.43 KB
492 downloads