Excel tips
Excel text transformation tricks
By David H. Ringstrom, CPAData arrives on your desk from multiple sources, and in many cases it's not quite in the format that you need. For instance,...
Excel 2007: Five ways to streamline Excel’s user interface
By David H. Ringstrom, CPAIt's easy to get caught up in the day-to-day use of Excel 2007 and overlook minor tweaks that can make a significant differe...
Excel 2003: Six ways to streamline Excel's user interface
By David H. Ringstrom, CPAIt's easy to get caught up in the day-to-day use of Excel 2003 and overlook minor tweaks that can make a significant differe...
The far side of Excel - Fireside treats for long winter nights
As you sit by your roaring log fire, idly fondling the shiny new notebook computer that Santa bought you, here are some suggestions for trying out a f...
AccountingWEB Webinar: Creating error proof spreadsheets
In today's fast-paced business world, spreadsheet users don't always have the luxury of double-checking every element of their work, particularly in c...
Excel Tip: Hide an Excel Worksheet in Plain Sight
By David Ringstrom, CPAAs you’re probably aware, it’s simple to hide a worksheet in Excel 2007: right-click on the worksheet tab, and then choose ...
Excel Tip: Add visuals to your headers and footers
Since Excel XP it has been possible to insert a picture into a custom header or footer. Our sister site, AccountingWEB.co.uk investigated some potenti...
Excel Filtering 101
By David Ringstrom, CPAFiltering is a powerful, but often overlooked feature in Excel that enables you to hide unneeded data within a list. In Excel 2...
ExcelZone's Five Minute Pivot Table Tips - Index
ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables. If you want to try out each tip for yourself, Excel ex...
