The site formerly known as Code For Excel and Outlook
September 2, 2011 by · 
Are you using the correct formula to calculate percentage? Did you know there are two different versions of the "percent of total" you can use to get a slightly different look at your data?
Continue Reading: Percentage Possible vs. Percentage of Total »
August 31, 2011 by · In How'd They Do That: Points to Reach Next Level (Simple) we reviewed a simple method for determining current ranking level, next ranking level, and the number of posts needed to reach that level.
In this post we'll go over the actual ranking system used at VBAX and how we can calculate current and next ranking level.
Continue Reading: How'd They Do That: Points to Reach Next Level (Actual) »
August 29, 2011 by · Ever see one of those ranking lists and wonder how to figure out how to calculate how many points are needed to reach the next level? Here's how.
Continue Reading: How'd They Do That: Points To Reach Next Level (Simple) »
July 27, 2011 by · I've updated a couple of add-ins for Excel 2010.
Once they are complete I will also be uploading Excel 2010 versions of Amazon Ad Link Generator and Random Data Generator. The other add-ins will follow as time permits.
March 21, 2011 by · The Google Static Maps API may be leveraged in Excel wherever you want local street maps of your area. Here I'll review some basic techniques for building links that let you display maps from Excel and VBA.
Continue Reading: Google Static Maps API in Excel »
Site last updated: February 8, 2012
Follow Me