How to Remove Text from a Cell in Excel
One of the most frustrating problems in Excel is when you want to remove text from a cell. The SUBSTITUTE function is
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.
How to Use Index & Match (Video)
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
Common Errors in Excel (Video)
In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero
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
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