excel tips | Excel & VBA

Excel 2007 – Review Continues

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 ...

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 ...

Comments (10)

Excel Chart Types – Advanced

Posted on 01 September 2008

Here are a few more chart types. These can be used to represent multi-dimentional data. Download the file with advanced excel chart types here.

Comments

Excel Chart Types – Basic

Posted on 31 August 2008

These are some basic chart types in Excel. You can play around with these by downloading the file here. Stephen Few, Data visualization Guru and author, mentions a few rules for creating charts on his website PerceptualEdge. Some good reads are: Practical rules for using colors in charts Godin’s Silly Rules for Great Graphs Stephan has, over the years, written on many facets of presenting data ...

Comments

Sudoku solver in Excel VBA

Posted on 23 August 2008

Update: You can download the Sudoku Solver in Excel with brute force here (latest version) here. For the uninitiated, Sudoku is a grid of 9x9 cells where each cell can and must have a value from 1 to 9 such that no number must be repeated in a row, column or any of the 9 groups of 3x3 grids. And not onto the circumstances behind this sudden urge to develop a sudoku solver. ...

Comments