David Ringstrom, CPA

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.
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
May 30th 2017
Filtering Grand Total Amounts Within Excel Pivot Tables
Anyone who has worked with pivot tables has likely found it easy to filter rows or columns within the pivot table, and as you’ll see in...
Excel
May 23rd 2017
How to Recover Damaged Excel Workbooks
It’s often a user’s worst nightmare to find that an important workbook suddenly won’t open, mostly due to the fact that such files are...
Excel
Apr 5th 2017
Conditionally Displaying Decimal Places in Excel: Part 3
Over the years, I’ve been asked how to conditionally use decimal places with numbers. In Part 1 of this series, I used a custom number...
Excel
Mar 13th 2017
How to Reset an Excel Spreadsheet for Data Entry
From time to time you may want to remove words or numbers from Excel worksheet cells while keeping formulas intact. This can happen when a...
Excel
Mar 2nd 2017
Keyboard and Mouse Shortcuts to Use Within Excel Worksheets
Working in Excel can sometimes feel like a “death by a thousand cuts” experience when you aren’t aware of subtle timesavers. In this...
Excel
Feb 10th 2017
Three Approaches for Counting Data Instances in Excel
Most of your spreadsheets likely entail summing amounts for various reasons. However, sometimes we need to count the number of instances,...
Excel
Feb 1st 2017
The Nuance of Grand Totals in Excel-based Pivot Tables
If you have experience with pivot tables in Microsoft Excel, your emotions have probably swung from one extreme to another. First there’s...
Excel
Jan 13th 2017
How to Use Excel to File Form 1040 and Related Schedules for 2016
It remains to be seen if 2017 will be a sea-change year for the US tax code, but you can still count on using Microsoft Excel to compute...
Excel