David Ringstrom | AccountingWEB

Content by David Ringstrom

on 04/02/15
Comedian George Carlin became famous in 1972 for a monologue that delineated the seven words you can never say on television. With homage to the esteemed Mr. Carlin, in this article I’ll...
on 03/26/15
In a recent article I explained the concept of circular references and how users sometimes intentionally or unintentionally incorporate such types of formulas into spreadsheets. In that article I...
on 03/11/15
If you’ve used Microsoft Excel for any length of time then most likely you’ve inadvertently created a formula that results in a circular reference. This means that the formula you created...
on 02/18/15
In a move that I can’t imagine occurring during Steve Ballmer’s reign, Microsoft has released Android versions of Microsoft Excel. I don’t have an Android phone, or the inclination...
on 01/30/15
As you may be aware, Excel’s Conditional Formatting feature allows you to identify duplicates in a column. This technique requires some tech savvy in certain versions of Excel, but only a...
on 01/23/15
The brinksmanship between Congress and the Internal Revenue Service seems to ratchet up every year with the ever-present “will they or won’t they” approach to tax legislation. Yet...
on 12/09/14
I was recently asked if there was an easy way to determine the first Sunday in a month. As you might expect, it can be tedious to manually determine the first Sunday of each month in an expense...
on 12/03/14
Working with time values in Excel often gives users fits. This is because Excel stores times as a decimal portion of a day. Thus 12 hours is the same as 0.5. Three and a half-hours is represented as...
on 11/04/14
Reader Fiona posed an interesting question on my article regarding taking the pain out of freezing panes in Excel. She asked: "I want to freeze a row in the middle of a sheet but have the rows...
on 10/27/14
Saving Excel spreadsheets as PDF files has gotten incrementally easier over the years, but can still require more effort than necessary. When saving a document as a PDF, many users go through several...
on 09/16/14
You probably don't want to think about how many times you access the File menu in Excel 2010 or 2013. Personally I think Excel 2010 has the best possible File menu arrangement, other than having...
on 09/10/14
Earlier this year I wrote about my mixed feelings on Excel for iPad's debut. My closing sentence for that article read "The early iterations of Microsoft products tend to have rough edges...
on 09/04/14
If you've attended any of my free High Impact Excel webinars then you've probably heard me say that Excel is fraught with nuances. Sometimes the most mundane tasks, such as copying and...
on 08/07/14
My unscientific observation is that the SUM function is likely the most used—and abused—of all worksheet functions in Excel. Although the SUM function is far better than manually adding...
on 08/04/14
Alt-Down Arrow is one of my favorite keyboard shortcuts in Excel. First off, it gives me an easy means to speed through repetitive data entry within a column. Second, it allows me to access Excel...
on 06/19/14
As you're most likely aware, it's easy to instantly create a list of days of the week or months of the year. Simply type either the first three letters or the full name of a day or month in a...
on 06/12/14
I’ve been tracking solid state drives (SSD) for years now, always thinking they were beyond my financial grasp. I finally chose to make the leap recently, thanks in part to a brief mention of...
on 06/09/14
Recently I lamented that Excel has functions like SUMIF, COUNTIF, and AVERAGEIF, but that it didn’t have the equivalent of a MAXIF function. I then described a valid technique that involves...
on 06/05/14
Periodically in Excel you may want to perform an analysis based on specific criteria. For instance, if I wanted to sum only the data in Figure 1 based on the month being equal to January, SUMIF has...
on 05/02/14
During my recent High Impact Excel: Macro Edition webinar—which we've posted online for free viewing—an attendee asked if it’s possible to use the Macro Recorder to automate...

Pages