High Impact Excel | AccountingWEB

High Impact Excel: Tips and Tricks for All Excel Users

About The Instructor
David Ringstrom, CPA is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. He teaches dozens of webinars each year and speaks at conferences on Excel, along with writing freelance articles about spreadsheets that appear internationally. Webinar attendees are often amazed by how much ground David can cover in a short period of time. He is quite fond of saying, "Either you work Excel, or it works you!"

Articles by David Ringstrom

Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...
Posted 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...

Past Webinars

Took place on 12/18/14
In this presentation Excel expert David Ringstrom, CPA focuses exclusively on how to perform repetitive tasks more efficiently in Excel.
Took place on 11/18/14
In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets.
Took place on 10/30/14
Many Excel users have a love-hate relationship with workbook links.
Took place on 10/09/14
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards.
Took place on 09/24/14
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards.