Functions
Excel functions to enhance your skills
Functions libraries (26 available)
EOMONTH/EDATE Mastery
EOMONTH/EDATE MasteryMonth-End Calculations & Date Shifting
PDF
1.33 MB
2158 downloads
SUBSTITUTE Mastery
SUBSTITUTE Mastery
PDF
1.4 MB
2310 downloads
TRIM/CLEAN Mastery
TRIM/CLEAN MasteryRemove Whitespace & Non-Printable Characters
PDF
1.31 MB
2388 downloads
ROUND Functions Mastery
ROUND Functions MasteryControl Precision in Calculations
PDF
1.29 MB
996 downloads
IS Functions Mastery
IS Functions MasteryISNUMBER, ISTEXT, ISBLANK & Data Validation
PDF
1.36 MB
701 downloads
MATCH Function Mastery
MATCH Function MasteryFind Positions & Build Dynamic References
PDF
1.29 MB
1426 downloads
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF
1.7 MB
2412 downloads
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF
1.48 MB
704 downloads
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF
1.47 MB
865 downloads
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF
1.8 MB
1026 downloads
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF
1.76 MB
1256 downloads
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF
1.04 MB
1574 downloads