Excel Slow to Respond - Avoiding Mistakes that Make Excel Slow Down to a Crawl

Posted on 06 August 2009

Everyone hates it when excel becomes slow to respond. So here are some tips to avoid doing things that can slow down excel. Excel 2007 and later versions sport a much bigger grid which tends to amplify poor spreadsheet design. An Excel spreadsheet that seemed a bit slow in Excel 2000 would likely get bogged down to a crawl in Excel 2007 if you, like me, are using the same hardware. The key to understanding what makes excel slow lies ... Continue Reading

Comments     

Case Shiller Home Price Index and the Base Effect

Posted on 31 July 2009

The Case Shiller Home Price Indices are constant quality house price indices for the United States. A number of Case Shiller home price indices exist: A national home price index, a 20-city composite index, a 10-city composite index, and twenty individual metro area indices. These indices were developed by economists Karl Case and Robert Shiller. (wiki) The Case Shiller Index has been one of the most keenly watched indices over the past few months. It has been argued (and perhaps ... Continue Reading

Comments     

String Comparison Function in VBA

Posted on 30 July 2009

Here's a look at a few string comparison functions in VBA : Types of string comparisons in VBA Binary String Comparison (Case sensitive) in VBA For any formula if you want to compare two string in such a manner that each individual characters is compared with its counterpart in a case sensitive manner (Ex. “This” is not equal to “this” because ‘T’ is not equal to ‘t’), you can do either of the two things: 1. Declare the statement Option Compare Binary at the ... Continue Reading

Comments (2)

How to write a macro in Excel

Posted on 29 July 2009

How to write a macro in Excel? Here are a few quick tips: Excel Macro - How to Record Excel Macro - How to Edit Excel Macro - Improving speed of code Excel Macro - Examples Recording a macro in Excel How to record a macro in Excel 2007 and Excel 2010 In Excel 2007 (and Excel 2010), the "Record Marco" menu option is under the "View" ribbon. Click on the "Macros" button towards at ... Continue Reading

Comments     

Excel 2007 - Review Continues

Posted on 28 July 2009

Excel 2007 was, for me, the discovery of the month. This article continues the review that I started in the previous post. Though this post should have been written about two years back, inspiration only struck me this weekend. Named Range in Excel 2007 The named range is a definite improvement over 2003. A lot of features have again been bought forth in this version (or added anew) such as scope definition and being able to view the values (a great ... Continue Reading

Comments (3)

Excel 2007

Posted on 25 July 2009

Excel 2007 finally happened to me. Its not that I've never though of moving to Excel 2007 from the 2003 avatar of Excel, but you see, yours truly has never been accused of being an early adopter in the past, no sir never, and I've got a duty to protect that reputation. I bought my first phone after it had been on the market for a few years, bought my first car after it had been on road for a ... Continue Reading

Comments (10)