Category Archives: Workbook/Reference Lessons

Introduction to Power Pivot Here’s a helpful guest lesson about an incredibly useful Excel add-in called Power Pivot. Thanks to Nick Williams from Acuity Training for creating this helpful post!!! Power Pivot is an Excel add-in which can used to perform … Continue reading

Posted on by cobainbc15 | 2 Comments

Excel 2016: IFS Function

The following post was created by Kasper Langmann as a guest post for Excel Exposure.  If you’d like to see more of his work, check out Spreadsheeto for more Excel tutorials. Follow along with this workbook that he created specifically for Excel … Continue reading

Posted in Workbook/Reference Lessons | 3 Comments

What-If Analysis

Another helpful Excel guide from Acuity Training’s Nick Williams. What-if analysis is a useful way of being able to test out various scenarios in Excel.  You can look at these things two different ways. The first way is to change … Continue reading

Posted in Workbook/Reference Lessons | 9 Comments

Excel Shortcuts Cheat Sheet

Our friends over at have provided a handy Excel Shortcut info-graphic going over some popular Excel shortcuts.  Hope you enjoy:

Posted in Workbook/Reference Lessons | 6 Comments

VBA Important Tips

Thanks to Nick Williams at Acuity Training for this guest post! The lesson will go over the following tips:   1) Loop Through Code 2) Variable Scope 3) Error Checking 4) Immediate Window   VBA Tip #1 – Loop Through … Continue reading

Posted in Workbook/Reference Lessons | Comments Off on VBA Important Tips

Video Lesson: Error Checking & Data Monitoring

Error Checking and Data Monitoring in Excel In the following video tutorial, I go over the following items in detail: – Explanation and example of major error types in Excel: #DIV/0 — #VALUE! — #REF! — #NAME? — #NUM! — … Continue reading

Posted in Data Input & Manipulation, Workbook/Reference Lessons | 8 Comments

Video Lesson: Advanced Pivot Tables – Round 2

Advanced Pivot Tables Round 2 This lesson picks up right where the last Pivot Table lesson left off. In this tutorial, you will learn: How to use multiple levels of data within row or column labels. Expand / collapse all … Continue reading

Posted in Workbook/Reference Lessons | Tagged , , , | 28 Comments

Video Lesson: Creating and Designing Charts

Excel has very powerful charting capabilities, which many users do not take full advantage of. This lesson goes over a few of the types of charts using some example data.  Here is a quick summary of what is in the … Continue reading

Posted in Workbook/Reference Lessons | 20 Comments

Video Lesson: Beginner’s Introduction to Excel

One video that I have been meaning to do is a lesson focused on those of you who have never (or rarely) used Excel, and needed an introduction to the program and how it works.  I’ve created this lesson in … Continue reading

Posted in Workbook/Reference Lessons | Tagged , , , , , | 196 Comments

Video Lesson: Five Powerful Excel Tips

Make sure to download the most recent Master Workbook to follow along! I’ve noted the time that each section starts in the video, but you may want to let it load completely first as I’ve had errors skipping around early. … Continue reading

Posted in Quick Tips, Workbook/Reference Lessons | Tagged , , , , , , , | 10 Comments