Posted on 04 March 2010
Anytime I write VBA code that runs for more than a split second, one of my worries remains that someone will ctrl + break it. You see, I am a very strong supporter of P.E.T.A. (People for Ethical Treatment of Algorithms) and believe that any code, no matter how long it takes (or in my case how badly written it is), must be allowed the dignity to complete. And for those who believe in killing poor little VBA code(s) with ...
Posted on 22 February 2010
Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the stock market.
(Average Listing Price for US states, week ending Feb 17, 2010. Source : www.trulia.com)
(SNP performance, Feb 19, 2010. Source : www.finviz.com/map.ashx)
Inspired by the last ball win over the South Africans yesterday night, I wondered if some of that action could be captured in ...
Posted on 10 February 2010
Looks like I am not the only one suffering from browse fatigue. Excel guru Dick Kusleika
recently made the shift from Firefox to Chrome and he wasn't very impressed. I myself have been fiddling around with various browsers lately. Right before my earlier computer gave up the ghost
and I shifted on to the new one, I had been hell bent on squeezing out the last remaining ounce ...
Posted on 03 February 2010
So how do you fit multiple scales on a single excel chart? No, we are not referring about the primary and secondary scales on an Excel chart here, we are talking about adding a customized scale for each category in the chart.
Take for example the receipts portion of the U.S. federal budget - a data set with multiple categories such as individual income, social security, excise, estate and other taxes & duties.
Posted on 31 January 2010
So you have been toiling away on a spreadsheet that must reach the CEO's desk before the end of the day. Your boss has been after your life to get this done as fast as possible with his frantic phone calls and a rather sharp pitchfork that he uses on special occasions like these. A gazillion formulas, allocations and calculations later, with your body screaming for some coffee, you allow yourself a break. As you return to your desk with ...
Posted on 28 January 2010
Table formulas were something that I discovered recently. Actually our reader m-b commented that he prefers to convert a range to a table and then employ table formulas instead of named ranges
. That got me curious enough to explore them further and here's what I learnt.
A Table in Excel
A table is a feature in Excel that makes it easier to format and analyze a set of data points in a spreadsheet. Tables were introduced in Excel 2007 as an ...