Introducing the AccountingWEBinar Series
AccountingWEB is pleased to announce a series of live webinars aimed squarely at the needs of CPAs in public and private practice. This wide-ranging s...
Three Excel menus you may have overlooked
By David H. Ringstrom, CPASheet NavigationEveryone is familiar with using the arrow buttons in the lower left-hand corner of the Excel screen to push ...
Managing Excel Add-Ins
By David H. Ringstrom, CPAAdd-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core fun...
Buried gold: Excel's Form command
By David H. Ringstrom, CPAMany users are not aware that Excel has long had a feature that enables you to browse through a table of data one record at ...
Tricks for opening and closing multiple Excel files
By David H. Ringstrom, CPAFrom time to time you may find yourself immersed in a large project that involves several related Excel workbooks. In such c...
Tricks for hiding and unhiding Excel rows and columns
By David H. Ringstrom, CPAHiding and unhiding rows and columns in Excel can be a mundane task that many users take for granted. However, it can also b...
Free Microsoft Excel-based 1040 form available
By David H. Ringstrom, CPAJust in time for tax season, Glenn Reeves of Burlington, Kansas has created a free Microsoft Excel-based version of the 2008...
Quickoffice releases Excel editing capabilities for iPhone
Quickoffice, Inc., a global provider of mobile office productivity software, has announced the release of MobileFiles Pro, the first application to in...
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 2007: Use these three techniques to turbo charge filtering
By David Ringstrom, CPADid you know Excel 2007 has a hidden command that enables you to filter a list with just one mouse click? And that there are tw...
Excel 2003: Use these three techniques to turbocharge filtering
By David Ringstrom, CPADid you know that you can streamline the AutoFilter feature in Excel 2003 and earlier versions? And that there are two ways to ...
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...
