In this video we dive in to the top three mistakes by those new with Microsoft Excel: 1. Not structuring data properly and
In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings
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
This quick video will show you a shortcut you can use to calculate the rate of change over time
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:
In this video we’ll cover how to delete extra columns and rows in Excel using the keyboard shortcuts! View this post on
Freezing the top row in your dataset is very helpful when you have to scroll a long way down to get the right data.