Excel libraries
Cheatsheets, templates, guides and more to master Excel
All Resources
Cheatsheet
35 Excel Formulas Master Guide
35 Excel Formulas Master GuideEach formula includes: Syntax · Description · Real Dataset · Practical Example · Pro TipsF...
PDF
426.72 KB
Cheatsheet
Advanced Lookup Functions Guide
EXCEL LOOKUP FUNCTIONS12 complex, production-ready scenarios from HR, Sales, Finance, Inventory, Operations, and Analyti...
PDF
274.34 KB
Cheatsheet
The Only Excel Pivot Guide You'll Ever Need
Master Excel's most powerful data analysis tools with this free 8-page visual guide. Covering Pivot Tables, Pivot Charts...
PDF
616.93 KB
Cheatsheet
XLOOKUP in Excel: The Complete Guide with Real-World Examples
If you've been getting by with VLOOKUP for years, XLOOKUP is the upgrade you didn't know you were waiting for. It does e...
PDF
518.59 KB
Cheatsheet
50 Excel Formulas for HR & Finance Professionals
50 Excel Formulas Every HR & Finance Professional Should KnowIf you've ever stared at a spreadsheet wondering "there...
PDF
76.52 KB
Cheatsheet
Excel Data Cleaning Tips, Tricks & Formulas
Excel Data Cleaning Tips, Tricks & FormulasDirty data costs organisations time, money, and trust. This guide walks y...
PDF
526.61 KB
Cheatsheet
Top 100 Excel Tips & Tricks
Top 100 Excel Tips & TricksCategories Covered:Keyboard ShortcutsData ManagementPivot TablesProductivity HacksFormula...
PDF
110.98 KB
Cheatsheet
Excel Lookup Formulas Unleashed
Excel Lookup Formulas Unleashed - Complete Reference GuideThis guide covers every major Excel Lookup & Reference for...
PDF
156.42 KB
Cheatsheet
100 Most Asked Excel Interview Questions
100 Most Asked Excel Interview QuestionsIf you're preparing for Data Analyst, MIS, Business Analyst, or Excel-related ro...
PDF
2.74 MB
Cheatsheet
Excel Progress Map
Excel Progress Map12 practical fixes to clean, analyze, and control data faster.
PDF
1.81 MB
Cheatsheet
Complete Pivot Table Guide
Complete Pivot Table GuideTransform Raw Data into Insights
PDF
1.43 MB
Cheatsheet
Top 8 Excel Formulas
Top 8 Excel FormulasEssential Formulas Every Professional Must Know
PDF
1.47 MB
Cheatsheet
Top 50 Excel Shortcuts
Top 50 Excel ShortcutsEssential Keyboard Shortcuts Every Excel User Must Know
PDF
1.16 MB
Cheatsheet
Excel for HR - Complete Guide
Excel for HR - Complete GuideHR Functions, Errors, Shortcuts & Tips
PDF
705.16 KB
Cheatsheet
Excel for Finance - Complete Guide
Excel for Finance - Complete GuideFinancial Functions, Errors, Shortcuts & Tips
PDF
717.42 KB
Cheatsheet
10 Excel Hacks That Save Hours
10 Excel Hacks That Save HoursWork Smarter, Not Harder
PDF
1016.71 KB
Cheatsheet
Top 50 Excel Tips
Top 50 Excel TipsFormulas, Shortcuts & Productivity Hacks
PDF
1.39 MB
Cheatsheet
XLOOKUP vs FILTER Comparison
XLOOKUP vs FILTER ComparisonSingle Result vs Multiple Results
PDF
1.12 MB
Cheatsheet
Periodic Table of Project Management Functions
Periodic Table of Project Management FunctionsEssential Excel Functions for Project Managers
PDF
984.7 KB
Cheatsheet
Periodic Table of Data Analysis Functions
Periodic Table of Data Analysis FunctionsEssential Excel Functions for Data Scientists & Analysts
PDF
983.38 KB
Cheatsheet
Periodic Table of Sales & Marketing Functions
Periodic Table of Sales & Marketing FunctionsEssential Excel Functions for Revenue Growth
PDF
1009.26 KB
Cheatsheet
Periodic Table of Financial Functions
Periodic Table of Financial FunctionsEssential Excel Functions for Financial Analysis
PDF
950.78 KB
Cheatsheet
Periodic Table of HR Functions
Periodic Table of HR FunctionsEssential Excel Functions for Human Resources Management
PDF
1.21 MB
Functions
EOMONTH/EDATE Mastery
EOMONTH/EDATE MasteryMonth-End Calculations & Date Shifting
PDF
1.33 MB
Cheatsheet
Power Query M Mastery
Power Query M MasteryEssential M Functions for Data Transformation
PDF
1.41 MB
Functions
SUBSTITUTE Mastery
SUBSTITUTE Mastery
PDF
1.4 MB
Functions
TRIM/CLEAN Mastery
TRIM/CLEAN MasteryRemove Whitespace & Non-Printable Characters
PDF
1.31 MB
Functions
ROUND Functions Mastery
ROUND Functions MasteryControl Precision in Calculations
PDF
1.29 MB
Functions
IS Functions Mastery
IS Functions MasteryISNUMBER, ISTEXT, ISBLANK & Data Validation
PDF
1.36 MB
Cheatsheet
Periodic Table of Excel Shortcuts
Periodic Table of Excel ShortcutsEssential Keyboard Shortcuts for Excel Mastery
PDF
1.48 MB
Cheatsheet
Ultimate Excel Formulas Cheatsheet
Ultimate Excel Formulas CheatsheetComplete Reference Guide for All Essential Functions
PDF
1.39 MB
Cheatsheet
Periodic Table of Excel Functions
Periodic Table of Excel FunctionsInteractive Visual Guide to All Excel Functions
PDF
1.42 MB
Cheatsheet
Top 50 Excel Formulas
Top 50 Excel FormulasComplete Essential & Advanced Formula Reference
PDF
1.47 MB
Functions
MATCH Function Mastery
MATCH Function MasteryFind Positions & Build Dynamic References
PDF
1.29 MB
Functions
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF
1.7 MB
Functions
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF
1.48 MB
Functions
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF
1.47 MB
Functions
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF
1.8 MB
Functions
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF
1.76 MB
Functions
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF
1.04 MB
Cheatsheet
UNIQUE with FILTER Functions
UNIQUE with FILTER FunctionsCombine UNIQUE and FILTER for powerful data extraction
PDF
1.04 MB
Functions
FILTER Function Mastery
FILTER Function MasteryExcel 365's Revolutionary Dynamic Filtering
PDF
1.13 MB
Functions
INDEX and MATCH Mastery
INDEX MATCH MasteryThe Most Powerful & Flexible Lookup Combination
PDF
1.48 MB
Functions
XLOOKUP Mastery
XLOOKUP MasteryMaster Excel 365's Most Powerful Lookup Function
PDF
978.33 KB
Cheatsheet
Dashboard Formulas
12 Dashboard FormulasBuild Interactive Business Dashboards
PDF
1.13 MB
Cheatsheet
IF Function Complete Guide
IF Function Complete GuideMaster Excel's Most Powerful Logic Function
PDF
986.33 KB
Cheatsheet
VLOOKUP Guide
VLOOKUP MasteryFrom Basic to Advanced VLOOKUP Techniques
PDF
1.06 MB
Cheatsheet
Data Validation Guide
12 Data Validation TechniquesControl Data Entry & Prevent Errors
PDF
1.06 MB
Functions
Logical & Error Functions
12 Logical & Error FunctionsMaster Decision Making & Error Handling
PDF
987.41 KB
Functions
Date & Time Functions
14 Date & Time FunctionsMaster Temporal Analysis & Date Calculations
PDF
1.06 MB
Functions
8 Lambda Functions
8 Lambda FunctionsCreate Custom Functions & Advanced Calculations
PDF
986.43 KB
Cheatsheet
5 Levels of Excel Mastery
5 Levels of Excel MasteryFrom Beginner to Expert - Your Complete Roadmap
PDF
1.06 MB
Functions
Pivot Table Formulas Guide
Master GETPIVOTDATA and pivot table calculations with this Guide
PDF
1.05 MB
Cheatsheet
Hidden Excel Shortcuts
List of 25 Hidden Excel Shortcuts
PDF
976.56 KB
Functions
Top 20 Excel Formulas
Most Powerful Formulas in Excel including 365 version
PDF
1.06 MB
Cheatsheet
21 Advanced Excel Functions
Master the top 21 Advanced Functions in Excel with this simple guide.
PDF
1.06 MB
Functions
Dynamic Functions Guide
Learn FILTER, UNIQUE, SEQUENCE and SORT function with this simple guide.
PDF
1.06 MB
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
Cheatsheet
Excel Shortcuts Cheat Sheet
Mastering Excel becomes super easy when we know the right shortcuts! I created this Excel Shortcuts Cheat Sheet to help...
PDF
696 KB
Functions
SWITCH Function CHEATSHEET
Master Excel’s SWITCH Function with Our In-Depth Cheatsheet InfographicElevate your Excel formula skills by learning the...
PDF
106 KB
Functions
IFS Function Cheatsheet
Master Excel’s IFS Function with Our Ultimate Cheatsheet InfographicTransform the way you handle complex logical conditi...
PDF
95.94 KB
Functions
VLOOKUP Cheatsheet
Master Excel’s VLOOKUP Function with Our Essential Cheatsheet InfographicTake your spreadsheet skills to the next level...
PDF
404.32 KB
Functions
XLOOKUP Cheatsheet
Master Excel’s XLOOKUP Function with Our Comprehensive Cheatsheet InfographicUnlock the full potential of your data anal...
PDF
568.2 KB
Cheatsheet
Excel Cheat Sheet for Data Analysts
Looking to upgrade your Excel skills and work faster like a true pro? This comprehensive infographic is your go-to Excel...
PDF
774.55 KB