David Ringstrom

Member Since: Jan 6th 2014
Columnist
Likes: 0
Thanks: 1
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.
Author/Presenter/Spreadsheet Consultant Accounting Advisors, Inc.
Nov 22nd 2021
Identifying Duplicate Values in Excel Lists
A sure-fire way to make an accounting professional sigh is to hand over an Excel list peppered with duplicate values. Fortunately, there...
Excel
Sep 27th 2018
Why Excel 2019 is Already Obsolete
September 24, 2018 marked the first time a major Excel release has been rendered obsolete on the day of its general availability...
Excel
Jun 28th 2018
Dealing with Inventive Malware Exploits in Excel
History tends to repeat itself and malware creators are utilizing two particularly crafty methods to disperse malignant computer code to...
Excel
May 3rd 2018
Dealing With Excel's Ctrl Key Paradox
Generally, most keyboard tricks and shortcuts work consistently in Excel, but there's one aspect involving the Ctrl key and the mouse that...
Excel
Feb 27th 2018
Set Cloud-Based Reports to Open Automatically in Excel
As the world moves toward ever more cloud-based accounting systems we sometimes encounter disruptions in our normal workflows. For instance...
Excel
Jan 30th 2018
How to Use Excel to File Form 1040 and Related Schedules for 2017
Most of the provisions in the Tax Cuts and Jobs Act completely change the tax landscape for the 2018 tax year, while some changes...
Excel
Oct 31st 2017
Vanishing Excel Features and How to Handle Them
Excel users that subscribe to Microsoft's Office 365 platform have the benefit of being on the vanguard of new features that are being...
Excel
Oct 20th 2017
How to 'Heat Map' Columns of Numbers in Excel
It can often be difficult to get a measure of numbers in a spreadsheet, but Excel offers many data visualization techniques. In this...
Excel
Sep 5th 2017
Using an Excel Pivot Table to Assign Random Numbers
Periodically you may have a need to assign random numbers to an employee list, such as for raffle drawings or drug testing. In this article...
Excel
Aug 2nd 2017
Troubleshooting When Excel’s VLOOKUP Function Returns #N/A
Look-up functions such as VLOOKUP can be a godsend in Excel by improving spreadsheet integrity and efficiency. I’ve written about the...
Excel