Excel 2007
Posted on 25 July 2009
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 Chart Types – Advanced
Posted on 01 September 2008
Excel Chart Types – Basic
Posted on 31 August 2008
Sudoku solver in Excel VBA
Posted on 23 August 2008
Translate
LATEST POSTS
- Prevent Users Ctrl Break (ing) Your VBA Code During Execution
- Multiple Scale Chart – Adding Customized Scale to Each Category in a Chart
- The Content Aggregator Called Excel
- Table Formula in Excel (Something I didn’t Know Till Yesterday)
- Multithreaded VBA – An Approach To Processing Using VBScript
- Named Range – A Few Quickies
- So How Many Of These Excel Shortcuts Do You Know, Punk ?
- Volatility Chart in Excel – Lessons in Chart Design From NY Times
- An Excel Chart’s Journey Across Versions
- A Big Thank You
- Square Bubble Heatmap Chart
- VBA IF Function – Using IF, ELSE:, ELSEIF, IF THEN in VBA code
- Treemap Add-In For Excel – Treemap Software Demo
- Data Validation List in Excel – Create Drop Down List Using Data Validation in Excel
- Data Validation in Excel – How to Use Data Validation Feature in Excel
- Treemap in Excel – Coming Soon
- VBA Select Case – Using VBA Select Case Statement in Excel
- Control Chart in Excel Using VBA – Six Sigma Control Chart Code & Software
- One Axis Frequency Distribution Chart in Excel (Download & Template)
- Custom Format to Catch Numbers Appearing as Text
