Tag: Excel
Excel: Search and Replace
February 29, 2012
Read about nested formulas to replace characters in a string. Step up your use of advanced Excel!
Excel – Using the CELL function
August 17, 2011
There are a number of useful options if you type =CELL( into excel.
Excel: Dynamic Summing To-Date
June 14, 2011
You can set a SUM or AVERAGE formula to dynamically sum only to-date, so that it updates dynamically at period-end.
Excel: Using SMALL to sort the Winners
May 11, 2011
A few old trusties are used in this little demo worksheet: INDEX, MATCH, VLOOKUP. The one we are interested in, however, is SMALL.
Excel: Choose Function
February 17, 2011
Let's say customers have to be grouped in buckets according to their last name.
Excel: Named Constants
December 9, 2010
There's no need to waste a precious cell for a value that hardly ever changes, like VAT. Use a named constant instead:
Excel: Reversing a List
November 9, 2010
It has always come as a surprise that Excel lacks a reverse method, because everything from LISP in 1956 to Perl/Ruby/Python today has one, usually applicable to both strings and lists!
Excel: Maintenance-free Drop-down Lists
October 8, 2010
Drop down lists save both typing and typos. There are a few ways of creating them, but I prefer to create dynamic lists. That way, list items can be added on the fly, and will appear in the list from the moment they are inserted.