A stacked chart in Excel allows users to take advantage of the best of both worlds: a column chart that shows period-over-period totals and a pie chart that can show what made up those totals. It can be a very useful chart, but knowing how to struct ...
Often times in a data set you'll have to handle with errors that can wreck your data, especially if you need to do any analysis on it. There are several ways that you can handle errors so that they don't show up in your data. IFERROR The first met ...
If you're looking up data, often times just using a VLOOKUP function can be enough to get you your desired result. Sometimes, however, it doesn't do enough, especially if you're looking for a partial match. While you can set VLOOKUP to pull an appro ...
Retrieving the maximum and minimum values is done relatively easily in Excel using the MIN() and MAX() functions, but what if you wanted to extract the five largest or smallest values? Two lesser-known functions can help you achieve this: SMALL and ...
If you've got a big Excel file (e.g. more than 10 mb) and you don't have tens of thousands of rows, you may want to see what you can do about bringing that size down. If you have lots of data, you may want to consider linking it using PowerPivot, al ...
One of the challenges sometimes with sending your spreadsheet to someone, whether it's to review or to make changes to it, is that it contains sensitive information. So I've created a template and add-in that will help you accomplish that. You can ...
There are a lot of ways you can speed up data entry and analysis in Excel, and while most people know about copying and pasting and how to undo actions, there are some useful ones that many users aren't familiar with. This list will go over five l ...
In my previous post I went over advanced filters in Excel. This time around I'll go over how to achieve the same result using just a formula. No macros, no VBA, just through a not-so-simple formula that can dynamically update based on your selections ...
There are many ways you can filter data in Excel, and in this post I'll cover the Advanced Filter. Using the Advanced Filter will allow you to set a criteria in place for your filter and then put the results in a separate section or tab. The benefit ...
With the stocks markets tanking earlier this month, I thought it'd be interesting to track their historical performance and put into perspective just how badly things have been going lately. For those that don't know, one of my side jobs is writing a ...
