Excel libraries

Cheatsheets, templates, guides and more to master Excel

All Resources

35 Excel Formulas Master Guide
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
Advanced Lookup Functions Guide
Cheatsheet
Advanced Lookup Functions Guide
EXCEL LOOKUP FUNCTIONS12 complex, production-ready scenarios from HR, Sales, Finance, Inventory, Operations, and Analyti...
PDF 274.34 KB
The Only Excel Pivot Guide You'll Ever Need
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
XLOOKUP Complete Guide
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
50 Excel Formulas for HR & Finance Professionals
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
Excel Data Cleaning Tips, Tricks & Formulas
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
Top 100 Excel Tips & Tricks
Cheatsheet
Top 100 Excel Tips & Tricks
Top 100 Excel Tips & TricksCategories Covered:Keyboard ShortcutsData ManagementPivot TablesProductivity HacksFormula...
PDF 110.98 KB
Excel Lookup Formulas Unleashed
Cheatsheet
Excel Lookup Formulas Unleashed
Excel Lookup Formulas Unleashed - Complete Reference GuideThis guide covers every major Excel Lookup & Reference for...
PDF 156.42 KB
100 Most Asked Excel Interview Questions
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
Excel Progress Map
Cheatsheet
Excel Progress Map
Excel Progress Map12 practical fixes to clean, analyze, and control data faster.
PDF 1.81 MB
Complete Pivot Table Guide
Cheatsheet
Complete Pivot Table Guide
Complete Pivot Table GuideTransform Raw Data into Insights
PDF 1.43 MB
Top 8 Excel Formulas
Cheatsheet
Top 8 Excel Formulas
Top 8 Excel FormulasEssential Formulas Every Professional Must Know
PDF 1.47 MB
Top 50 Excel Shortcuts
Cheatsheet
Top 50 Excel Shortcuts
Top 50 Excel ShortcutsEssential Keyboard Shortcuts Every Excel User Must Know
PDF 1.16 MB
Excel for HR - Complete Guide
Cheatsheet
Excel for HR - Complete Guide
Excel for HR - Complete GuideHR Functions, Errors, Shortcuts & Tips
PDF 705.16 KB
Excel for Finance - Complete Guide
Cheatsheet
Excel for Finance - Complete Guide
Excel for Finance - Complete GuideFinancial Functions, Errors, Shortcuts & Tips
PDF 717.42 KB
10 Excel Hacks That Save Hours
Cheatsheet
10 Excel Hacks That Save Hours
10 Excel Hacks That Save HoursWork Smarter, Not Harder
PDF 1016.71 KB
Top 50 Excel Tips
Cheatsheet
Top 50 Excel Tips
Top 50 Excel TipsFormulas, Shortcuts & Productivity Hacks
PDF 1.39 MB
XLOOKUP vs FILTER Comparison
Cheatsheet
XLOOKUP vs FILTER Comparison
XLOOKUP vs FILTER ComparisonSingle Result vs Multiple Results
PDF 1.12 MB
Periodic Table of Project Management Functions
Cheatsheet
Periodic Table of Project Management Functions
Periodic Table of Project Management FunctionsEssential Excel Functions for Project Managers
PDF 984.7 KB
Periodic Table of Data Analysis Functions
Cheatsheet
Periodic Table of Data Analysis Functions
Periodic Table of Data Analysis FunctionsEssential Excel Functions for Data Scientists & Analysts
PDF 983.38 KB
Periodic Table of Sales & Marketing Functions
Cheatsheet
Periodic Table of Sales & Marketing Functions
Periodic Table of Sales & Marketing FunctionsEssential Excel Functions for Revenue Growth
PDF 1009.26 KB
Periodic Table of Financial Functions
Cheatsheet
Periodic Table of Financial Functions
Periodic Table of Financial FunctionsEssential Excel Functions for Financial Analysis
PDF 950.78 KB
Periodic Table of HR Functions
Cheatsheet
Periodic Table of HR Functions
Periodic Table of HR FunctionsEssential Excel Functions for Human Resources Management
PDF 1.21 MB
EOMONTH/EDATE Mastery
Functions
EOMONTH/EDATE Mastery
EOMONTH/EDATE MasteryMonth-End Calculations & Date Shifting
PDF 1.33 MB
Power Query M Mastery
Cheatsheet
Power Query M Mastery
Power Query M MasteryEssential M Functions for Data Transformation
PDF 1.41 MB
SUBSTITUTE Mastery
Functions
SUBSTITUTE Mastery
SUBSTITUTE Mastery
PDF 1.4 MB
TRIM/CLEAN Mastery
Functions
TRIM/CLEAN Mastery
TRIM/CLEAN MasteryRemove Whitespace & Non-Printable Characters
PDF 1.31 MB
ROUND Functions Mastery
Functions
ROUND Functions Mastery
ROUND Functions MasteryControl Precision in Calculations
PDF 1.29 MB
IS Functions Mastery
Functions
IS Functions Mastery
IS Functions MasteryISNUMBER, ISTEXT, ISBLANK & Data Validation
PDF 1.36 MB
Periodic Table of Excel Shortcuts
Cheatsheet
Periodic Table of Excel Shortcuts
Periodic Table of Excel ShortcutsEssential Keyboard Shortcuts for Excel Mastery
PDF 1.48 MB
Ultimate Excel Formulas Cheatsheet
Cheatsheet
Ultimate Excel Formulas Cheatsheet
Ultimate Excel Formulas CheatsheetComplete Reference Guide for All Essential Functions
PDF 1.39 MB
Periodic Table of Excel Functions
Cheatsheet
Periodic Table of Excel Functions
Periodic Table of Excel FunctionsInteractive Visual Guide to All Excel Functions
PDF 1.42 MB
Top 50 Excel Formulas
Cheatsheet
Top 50 Excel Formulas
Top 50 Excel FormulasComplete Essential & Advanced Formula Reference
PDF 1.47 MB
MATCH Function Mastery
Functions
MATCH Function Mastery
MATCH Function MasteryFind Positions & Build Dynamic References
PDF 1.29 MB
TEXTJOIN Mastery
Functions
TEXTJOIN Mastery
TEXTJOIN MasteryAdvanced Text Concatenation with Delimiters
PDF 1.7 MB
SEQUENCE Mastery
Functions
SEQUENCE Mastery
SEQUENCE MasteryGenerate Dynamic Number Sequences & Arrays
PDF 1.48 MB
SUM Functions Guide
Functions
SUM Functions
SUM Functions GuideMaster all SUM functions for powerful data analysis
PDF 1.47 MB
CONCATENATE Mastery
Functions
CONCATENATE Mastery
CONCATENATE MasteryMaster Text Joining & String Manipulation
PDF 1.8 MB
COUNTIFS Mastery
Functions
COUNTIFS Mastery
COUNTIFS MasteryMaster Multi-Criteria Conditional Counting
PDF 1.76 MB
SUMIFS Mastery
Functions
SUMIFS Mastery
SUMIFS MasteryMaster Multi-Criteria Conditional Summing
PDF 1.04 MB
UNIQUE with FILTER Functions
Cheatsheet
UNIQUE with FILTER Functions
UNIQUE with FILTER FunctionsCombine UNIQUE and FILTER for powerful data extraction
PDF 1.04 MB
FILTER Function Mastery
Functions
FILTER Function Mastery
FILTER Function MasteryExcel 365's Revolutionary Dynamic Filtering
PDF 1.13 MB
INDEX and MATCH Mastery
Functions
INDEX and MATCH Mastery
INDEX MATCH MasteryThe Most Powerful & Flexible Lookup Combination
PDF 1.48 MB
XLOOKUP Mastery
Functions
XLOOKUP Mastery
XLOOKUP MasteryMaster Excel 365's Most Powerful Lookup Function
PDF 978.33 KB
12 Dashboard Formulas
Cheatsheet
Dashboard Formulas
12 Dashboard FormulasBuild Interactive Business Dashboards
PDF 1.13 MB
IF Function
Cheatsheet
IF Function Complete Guide
IF Function Complete GuideMaster Excel's Most Powerful Logic Function
PDF 986.33 KB
VLOOKUP Mastery
Cheatsheet
VLOOKUP Guide
VLOOKUP MasteryFrom Basic to Advanced VLOOKUP Techniques
PDF 1.06 MB
12 Data Validation Techniques
Cheatsheet
Data Validation Guide
12 Data Validation TechniquesControl Data Entry & Prevent Errors
PDF 1.06 MB
Logical & Error Functions
Functions
Logical & Error Functions
12 Logical & Error FunctionsMaster Decision Making & Error Handling
PDF 987.41 KB
Date & Time Functions
Functions
Date & Time Functions
14 Date & Time FunctionsMaster Temporal Analysis & Date Calculations
PDF 1.06 MB
8 Lambda Functions
Functions
8 Lambda Functions
8 Lambda FunctionsCreate Custom Functions & Advanced Calculations
PDF 986.43 KB
5 Levels of Excel Mastery
Cheatsheet
5 Levels of Excel Mastery
5 Levels of Excel MasteryFrom Beginner to Expert - Your Complete Roadmap
PDF 1.06 MB
excel-pivot-table-formulas-guide
Functions
Pivot Table Formulas Guide
Master GETPIVOTDATA and pivot table calculations with this Guide
PDF 1.05 MB
hidden-excel-shortcuts
Cheatsheet
Hidden Excel Shortcuts
List of 25 Hidden Excel Shortcuts
PDF 976.56 KB
top-20-excel-formulas
Functions
Top 20 Excel Formulas
Most Powerful Formulas in Excel including 365 version
PDF 1.06 MB
21-advanced-excel-functions
Cheatsheet
21 Advanced Excel Functions
Master the top 21 Advanced Functions in Excel with this simple guide.
PDF 1.06 MB
excel-dynamic-functions-guide
Functions
Dynamic Functions Guide
Learn FILTER, UNIQUE, SEQUENCE and SORT function with this simple guide.
PDF 1.06 MB
sumifs-wildcard-tutorial
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
Excel Shortcuts Cheatsheet
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
SWITCH Function Cheatsheet
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
IFS Function Cheatsheet
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
VLOOKUP Cheatsheet
Functions
VLOOKUP Cheatsheet
Master Excel’s VLOOKUP Function with Our Essential Cheatsheet InfographicTake your spreadsheet skills to the next level...
PDF 404.32 KB
XLOOKUP Cheatsheet
Functions
XLOOKUP Cheatsheet
Master Excel’s XLOOKUP Function with Our Comprehensive Cheatsheet InfographicUnlock the full potential of your data anal...
PDF 568.2 KB
Excel cheatsheet for data analysis
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