Excel libraries
Cheatsheets, templates, guides and more to master Excel
All libraries
Functions
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF
1.7 MB
62 downloads
Functions
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF
1.48 MB
178 downloads
Functions
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF
1.47 MB
391 downloads
Functions
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF
1.8 MB
657 downloads
Functions
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF
1.76 MB
789 downloads
Functions
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF
1.04 MB
459 downloads
Cheatsheet
UNIQUE with FILTER Functions
UNIQUE with FILTER FunctionsCombine UNIQUE and FILTER for powerful data extraction
PDF
1.04 MB
477 downloads
Functions
FILTER Function Mastery
FILTER Function MasteryExcel 365's Revolutionary Dynamic Filtering
PDF
1.13 MB
512 downloads
Functions
INDEX and MATCH Mastery
INDEX MATCH MasteryThe Most Powerful & Flexible Lookup Combination
PDF
1.48 MB
317 downloads
Functions
XLOOKUP Mastery
XLOOKUP MasteryMaster Excel 365's Most Powerful Lookup Function
PDF
978.33 KB
332 downloads
Cheatsheet
Dashboard Formulas
12 Dashboard FormulasBuild Interactive Business Dashboards
PDF
1.13 MB
523 downloads
Cheatsheet
IF Function Complete Guide
IF Function Complete GuideMaster Excel's Most Powerful Logic Function
PDF
986.33 KB
499 downloads