Useful Tip Sheets (Download for free)

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

Basic Formula Tips

Conditional Formatting Tips

Data Validation

Periodic Table of Excel Keyboard Shortcuts

Introduction to Pivot Tables

Pivot Table Advanced Data Model

Printing Summary Tipsheet

Printing Exercise Book

Recurring Data Sheet

Vlookup Creation