Congratulations! You have successfully unlocked

THE EXCEL VAULT

Enjoy

The Vault

The most common Microsoft Excel keyboard shortcuts

Excel keyboard shortcuts (compact)

Every Microsoft Excel keyboard shortcut

Excel keyboard shortcuts (full)

Every Microsoft Word keyboard shortcut

Microsoft Word keyboard shortcuts

Every Microsoft PowerPoint keyboard shortcut

Microsoft PowerPoint keyboard shortcuts

Every Microsoft Outlook keyboard shortcut

Microsoft Outlook keyboard shortcuts

Cheat Sheet - 9 powerful Excel TEXT functions

Cheat Sheet - 15 Smart Ways To Manage Figures

Cheat Sheet - AVERAGE Functions in Excel

Cheat Sheet - Getting Started With VBA (18 pages)

Excel Design Blueprint

30 Excel Power Tips

Checklist - 7 steps to perfect formulas

Checklist - 15 classic mistakes that destroy spreadsheets

Checklist - 21 Fatal formula fails

Cheat Sheet - Flash Fill

Cheat Sheet - Sparklines

Cheat Sheet - How to handle duplicates in Excel

Cheat Sheet - AVERAGEIF and AVERAGEIFS functions

Cheat Sheet - COUNTIF and COUNTIFS functions

Cheat Sheet - SUMIF and SUMIFS Excel functions

Cheat Sheet - Formulas quick start guide for beginners

Cheat Sheet - How to count anything and everything in Excel (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)

Cheat Sheet - Highlighting a row using conditional formatting

Cheat Sheet - IF formulas in Excel

Cheat Sheet - How to display leading zeroes in Excel

Cheat Sheet - How to write percentage formulas in Excel

Cheat Sheet - VLOOKUP formulas in Excel

Cheat Sheet - HLOOKUP formulas in Excel

Cheat Sheet - LOOKUP formulas in Excel

Cheat Sheet - Using the MATCH and INDEX functions in Excel

Cheat Sheet - How to combine MATCH and VLOOKUP for a powerful Excel combo

Cheat Sheet - 9 ways to round numbers in Excel

Checklist - 18 point checklist for Pivot Tables

Cheat Sheet - Sorting - everything you ever wanted to know

Checklist - How to do Excel tables the modern way

Cheat Sheet - Clever tab navigation in Excel

Cheat Sheet - How to get headings to repeat and rows/columns to freeze in Excel

Cheat Sheet - How to use the Consolidate tool in Excel

Cheat Sheet - How to create drop-down lists in Excel

Cheat Sheet - 3 ways to get a degree symbol in Excel

Cheat Sheet - How to transpose data in Excel

Custom Date Format

Cheat Sheet - How to build any any date sequence in Excel

Cheat Sheet - A better alternative to Merge and Center in Excel

Cheat Sheet - How to use the MAX and MIN functions in Excel

Goal Seek: Reverse Engineering in Excel

Cheat Sheet - How to create Charts in Excel 2016/365

Cheat Sheet - How to create Pie Charts in Excel 2016/365

Cheat Sheet - How to create Line Charts in Excel 2016/365

Cheat Sheet - How to change the scale of charts in Excel 2016/365

Cheat Sheet - How to create Combo Charts in Excel 2016/365

Cheat Sheet - How to create Waterfall Charts in Excel 2016/365

Cheat Sheet - How to create Map Charts in Excel 2016/365

Cheat Sheet - How to create Funnel Charts in Excel 2016/365

Cheat Sheet - How to create Histogram Charts in Excel 2016/365

Cheat Sheet - How to create Box & Whisker Charts in Excel 2016/365

Cheat Sheet - How to create Treemap Charts in Excel 2016/365

Cheat Sheet - How to create Sunburst Charts in Excel 2016/365

Cheat Sheet - How to create Surface Charts in Excel 2016/365

Cheat Sheet - How to create Stock Charts in Excel 2016/365

Cheat Sheet - How to create Scatter Charts in Excel 2016/365

Cheat Sheet - How to create Radar Charts in Excel 2016/365

Cheat Sheet - 21 Quickfire Word Tips

Cheat Sheet - How to create custom styles in Word

Cheat Sheet - How to copy styles from one Word document to another

Cheat Sheet - How to use Tracking and Comments in Word 2016/365

Cheat Sheet - How to create multilevel numbered lists (that work) in Word

Cheat Sheet - How to create multilevel caption numbering (that work) in Word

Cheat Sheet - How to create a Table of Contents in Word

Cheat Sheet - How to build a back-of-book index in Word

Cheat Sheet - How to create section breaks and column breaks in Word

Web
Analytics Made Easy - StatCounter