Tips for Better Pivot Tables with a Large Data Set (Video)
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in
Improve Your Pivot Table Workflow in Excel
In this quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to
How to use the Substitute Function (Video)
If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:
How to Freeze the Top Row in Excel (Video)
Freezing the top row in your dataset is very helpful when you have to scroll a long way down to get the right data.
Filter Data Using Keyboard Shortcuts (Video)
This video was originally featured on the Excel Nerds Instagram Page. On that page we post smaller bite size tips &
Min and Max Functions in Excel
Very often in Excel you want to summarize a set of data to pull out insights. The MIN and MAX functions can help you do
How to Calculate the Rate of Change in Excel (Shortcut)
In this post I’ll show you a quick excel shortcut for calculating a rate of change. Rate of change is defined as the