David Ringstrom

Member Since: Jan 6th 2014

Columnist

Recognition

Thanks: 1

Bio

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.

David Ringstrom, CPA

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

Jul 26th 2017

Office 365: More Frequent Builds, More Frequent Bugs

Historically, major changes to Microsoft Excel would arrive every three years or so, but since then everyone using it would say Excel 2007...

Excel

Jun 30th 2017

Two Ways to Disable Excel’s Pivot Table Drill-Down Feature

One of the benefits of pivot tables is that you can quickly summarize a large list of data into a concise summary with just a few mouse...

Excel

Jun 23rd 2017

How to Deal With Excel 2016’s New Persistent Clipboard

If you’ve used Microsoft Excel for any length of time you’ve probably realized that it has had a completely different relationship with the...

Excel