Contact KRS: +27 (0) 21 681 2900 | enquiries@krs.co.za | Contact Us

Musings

Excel: Named Constants

9 Dec 2010 by Jasper Cook
Using Name Manager or Name, Define on Insert menu (Excel 21003), add its name e.g. vat, and in the Refers To window, type “=0.14”. Now it can be used in a formula, e.g. “=B12*vat”. [...]

Excel: Reversing a List

9 Nov 2010 by Jasper
If it’s a list that can’t be sorted, like an itinerary, the usual trick is to add an adjacent column of sequential numbers and sort on that. But that’s work, isn’t it? [...]

Are you getting value for your software development budget?

9 Nov 2010 by KRS
In 2009, the Standish Group published a study covering 40,000 software projects over a 10 year period. They discovered that 51% were “challenged” – over time, over budget or lacking critical features. [...]

Change is the only Constant!

9 Sep 2010 by KRS
Media tablets, 3D flat-panel TVs, and Cloud Computing are some of the technologies that have moved into the “Peak of Inflated Expectations”, according to Gartner’s August 2010 review. 1800 technologies were evaluated in producing their report. [...]