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
2141 downloads
SUBSTITUTE Mastery
SUBSTITUTE Mastery
PDF
1.4 MB
2300 downloads
TRIM/CLEAN Mastery
TRIM/CLEAN MasteryRemove Whitespace & Non-Printable Characters
PDF
1.31 MB
2377 downloads
ROUND Functions Mastery
ROUND Functions MasteryControl Precision in Calculations
PDF
1.29 MB
986 downloads
IS Functions Mastery
IS Functions MasteryISNUMBER, ISTEXT, ISBLANK & Data Validation
PDF
1.36 MB
687 downloads
MATCH Function Mastery
MATCH Function MasteryFind Positions & Build Dynamic References
PDF
1.29 MB
1415 downloads
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF
1.7 MB
2404 downloads
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF
1.48 MB
696 downloads
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF
1.47 MB
857 downloads
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF
1.8 MB
1019 downloads
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF
1.76 MB
1247 downloads
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF
1.04 MB
1566 downloads