Excel libraries
Cheatsheets, templates, guides and more to master Excel
All libraries
Cheatsheet
VLOOKUP Guide
VLOOKUP MasteryFrom Basic to Advanced VLOOKUP Techniques
PDF
1.06 MB
366 downloads
Cheatsheet
Data Validation Guide
12 Data Validation TechniquesControl Data Entry & Prevent Errors
PDF
1.06 MB
470 downloads
Functions
Logical & Error Functions
12 Logical & Error FunctionsMaster Decision Making & Error Handling
PDF
987.41 KB
770 downloads
Functions
Date & Time Functions
14 Date & Time FunctionsMaster Temporal Analysis & Date Calculations
PDF
1.06 MB
599 downloads
Functions
8 Lambda Functions
8 Lambda FunctionsCreate Custom Functions & Advanced Calculations
PDF
986.43 KB
492 downloads
Cheatsheet
5 Levels of Excel Mastery
5 Levels of Excel MasteryFrom Beginner to Expert - Your Complete Roadmap
PDF
1.06 MB
500 downloads
Functions
Pivot Table Formulas Guide
Master GETPIVOTDATA and pivot table calculations with this Guide
PDF
1.05 MB
668 downloads
Cheatsheet
Hidden Excel Shortcuts
List of 25 Hidden Excel Shortcuts
PDF
976.56 KB
477 downloads
Functions
Top 20 Excel Formulas
Most Powerful Formulas in Excel including 365 version
PDF
1.06 MB
757 downloads
Cheatsheet
21 Advanced Excel Functions
Master the top 21 Advanced Functions in Excel with this simple guide.
PDF
1.06 MB
927 downloads
Functions
Dynamic Functions Guide
Learn FILTER, UNIQUE, SEQUENCE and SORT function with this simple guide.
PDF
1.06 MB
369 downloads
Functions
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
519 downloads