Archive for the ‘Excel Hints’ Category

How to Import XML Data into Excel

Posted on January 2nd, 2012 by Joseph Harris

This article is a quick primer on using XML data in your workbooks. XML is a simple way to automate some types of data loads in Excel. What is XML? XML stands for “extensible markup language”. XML is a structured way of formatting information so that it may be read by different systems. To see an example [...]

How to Create Heatmaps in Excel

Posted on April 2nd, 2011 by Joseph Harris

Starting with Excel 2007, a feature was added called “Color Scales”. Color scales can be used in many ways but by far my favorite is to use this functionality to create heatmaps. Heatmaps are 2 dimensional representations of 3 dimensional data. You can think of them as bar charts where you are looking down on [...]

Excel to PowerPoint Converter

Posted on June 5th, 2010 by Joseph Harris

Subsidium Business Analytics has released its Excel to PowerPoint converter. We though we would take it for a spin to see how it works and if it is worth the money. Purchase and Install The Excel to PowerPoint converter cost $4.99 so my expectation was low. I purchased the add-in and an automatic download began. [...]

Vlookup the Last Occurence of an Item – Excel

Posted on March 18th, 2009 by Joseph Harris

The title of this post is slightly misleading. We will not be using vlookup to return the corresponding result of the last condition, but rather we will be mimicking vlookup to pull the last item. Consider the following data: George Smith Tom Thompson George Kenny Dan Jackson Sally Richards George Daniels A vlookup of the [...]

Scrolling Excel Charts – Scroll Bar Graphs

Posted on March 13th, 2009 by Joseph Harris

There are many times when you may have a lot of data that does not look right when graphed all together. 300 data points is probably too many for a small chart. So what is the solution…scrolling charts! I will show you in this article how to create a scrolling chart without using dynamic ranges. [...]

#VALUE! Error in Microsoft Excel

Posted on March 3rd, 2009 by Joseph Harris

The #VALUE error is an error that is seen almost as often as #N/A. In short, the VALUE error occurs when a formula refers to a cell that contains a different than expected format. In this article, I will discuss the main causes of #VALUE! and some possible solutions. The top 3 causes of #VALUE! [...]