Content by David Ringstrom

on 10/25/12
By David H. Ringstrom, CPAFrom time to time you may craft a formula that in some cases will return an error, such as #...
on 09/05/12
By David H. Ringstrom, CPAFreezing or unfreezing worksheet panes typically involves multiple mouse clicks, but I'll show you a way to carry out this task with a single keystroke. For the...
on 08/27/12
By David H. Ringstrom, CPAFrom time to time, you may need to compare a set of figures or text in an Excel spreadsheet to a paper document. Doing so can be time consuming and error-prone as...
on 08/10/12
By David H. Ringstrom, CPAMicrosoft Excel is an ideal tool for calculating the cost of borrowing money, but are you doing so in the most efficient manner? In this article, I'll describe...
on 06/21/12
Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.By David Ringstrom Recently, I described how...
on 04/03/12
Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series. By David Ringstrom, CPA From time to...
on 03/29/12
Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series. By David Ringstrom, CPA Need to center...
on 03/28/12
Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series. By David Ringstrom, CPA The lowly text...
on 06/22/11
By David H. Ringstrom, CPA Most Excel users are familiar with the SUM, MIN, and MAX functions in Excel. Used in their traditional fashion, you provide a range of cells to the function to...
on 06/16/10
By David H. Ringstrom, CPAOffice 2010 is now in stores and at www.office.com, so anyone can upgrade to the latest version of Microsoft's flagship productivity suite. Office 2010...
on 03/24/10
By David H. Ringstrom, CPASometimes in Excel you may encounter a situation such as that shown in Figure 1, where each cell contains multiple lines of data. It's not a huge task to...
on 03/23/10
By David H. Ringstrom, CPAWhile you may not be aware of Excel's SUMPRODUCT function, those in the know often use it for its stated purpose: multiplying two ranges together and then summing...
on 04/17/09
By David H. Ringstrom, CPAHiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just...
on 10/28/08
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 sum only the visible rows in your filtered...
on 10/14/08
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 2003 and earlier, this feature is known as...

Pages