One Pager Excel Guides – Free

Useful Tip Sheets (Download for free)

This is a series of one page handouts I use in class. They summarize the main steps you need for each topic. You could print them out and have them handy for when you can’t remember all the steps to do something..

One Pager – Basic Formula Tips

Download it here free…

One Pager – Conditional Formatting

Download it here free…

One Pager – Data Validation

Download it here free…

One Pager – Periodic Table of Excel Keyboard Shortcuts

Download it here free…

One Pager – Pivot Table

Download it here free…

One Pager – Pivot Table Advanced Data Model

Download it here free… 

One Pager – Printing Summary Tipsheet

Download it here free… 

One Pager – Printing Exercise Book

Download it here free 

One Pager – Recurring Data Sheet

Download it here free…

One Pager – Vlookup Creation

Download it here free…