Modifying the Ribbon in Excel 2007

Thursday, March 27, 2008

I have recently found a need to modify the Ribbon interface in Excel 2007. I thought it would be much harder than it actually is. Rather than going through a tutorial of my own, I thought that I would post some excellent Ribbon modification tools and tutorials.

Before doing this, you need to understand that Office 2007 files are really just archives (.zip files) of several XML files. So, if you want to explore the file you can just change the file extension to .zip and then extract the files from the archive. Windows Explorer can do this. Open Windows Explorer, find...

Continue Reading

Analyze Google AdSense Data Using Pivot Tables

Sunday, March 16, 2008

Webmasters who use Google’s AdSense service to place ads on their site know that the analytical tools that AdSense supplies are pretty weak. Fortunately, it is easy to get report data from the site and into Excel where we can use all of the analytical tools that Excel provides. The purpose of this post is to demonstrate how webmasters can use PivotTables to analyze AdSense data. There are many reports that you can create in AdSense, and they are all candidates for analysis within Excel, but I will be demonstrating how to use pivot tables to analyze the "This month, by...

Continue Reading

Testing a String for Proper Case

Saturday, March 8, 2008

Have you ever needed to check a string in a worksheet cell to see if it is in proper case? By "proper case" I mean that the first letter of each word in the string is capitalized and the other characters are lowercase. For example, you may have a list of people’s names (maybe for a mailing list) and you need to be sure that the names are written properly (e.g., John Smith, not john Smith or John sMith). It seems that this should be easy in Excel, but it isn’t obvious (at least there is no easy, built-in function that you can use to validate the string). In this post I...

Continue Reading