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
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in
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
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:
Freezing the top row in your dataset is very helpful when you have to scroll a long way down to get the right data.
This video was originally featured on the Excel Nerds Instagram Page. On that page we post smaller bite size tips &
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
In this post I’ll show you a quick excel shortcut for calculating a rate of change. Rate of change is defined as the