Find the Difference Between Two DateTimes in Excel
Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding
Pivot Tables (Video)
A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
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
How to Make a Combo Chart in 2 Minutes
In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a
Learn the LEFT, RIGHT, and MID Functions in Excel
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings
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 Paste Special in Excel
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values
Using AUTOFILL in Excel – Part 2
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
Using AUTOFILL in Excel – Part 1
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the