How to Split Cell Entry in Excel

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of...

Andre provides a set of formulas to chart the last rolling six months of data. Episode 1013 shows you...

Mike Girven pointed me to an excellent whitepaper by Charles Williams about calculation speed. In Episode 1011, an example contrasting different ways of entering running totals. One calculates 100 times faster than the...

Marcelo asks how to replicate all of the formatting on an existing chart. In Excel 2003, this was Chart, Custom Types, User Defined, Add. In Episode 1008, we take a look at the equivalent method...

William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version of conditional formatting. Episode 1007 shows you...

Glenn has a series of line charts showing monthly data for 2009. Most charts work fine, but the total chart shows the line dropping to zero for future months. Episode 1004 shows how to solve...

Add the Page Setup dialog launcher to your Excel 2007 Quick Access Toolbar. Episode 1003 shows you...

Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this...