Articles by David Ringstrom | AccountingWEB

Articles by David Ringstrom

Views Comments Date
Recovering Unsaved Excel Workbooks 477,930 Comments 03/15/13
Tricks for Hiding and Unhiding Excel Rows and Columns 433,375 Comments 04/17/09
Hide and Unhide Multiple Excel Worksheets with Ease 333,759 Comments 12/21/12
How to Reinstall Microsoft Office When You Don't Have a Disc or Download 270,032 Comments 10/31/13
Microsoft Excel: Inserting Rows and Columns with Ease 248,522 Comments 03/22/13
What To Do When Excel Worksheet Tabs Go Missing 212,216 Comments 09/20/13
Three Ways to Convert Text-Based Numbers to Values 205,583 Comments 06/28/13
Some unlikely uses for Excel's SUMPRODUCT function 166,415 Comments 03/23/10
Identifying Duplicate Values in an Excel List 150,472 Comments 02/08/13
Excel Tip: Calculating Interest 149,510 Comments 08/10/12
What to do when Excel won't let you insert columns 137,423 Comments 06/17/10
Excel Tip: Multiple criteria SUM, MIN, and MAX formulas 130,994 Comments 06/22/11
Three Ways to Fill Blank Cells within Excel Spreadsheets 119,761 Comments 01/18/13
How to Disable Worksheet Animation in Excel 2013 115,032 Comments 03/01/13
Resolving #VALUE! Errors in Microsoft Excel 102,750 Comments 05/31/13
First Impressions of Excel 2010 91,625 Comments 08/06/09
Transform multiple-line cell contents into columns in Excel 90,003 Comments 03/24/10
Automating Data Validation Lists in Excel 80,420 Comments 06/20/13
Managing Protected View in Excel 2010/2013 77,762 Comments 11/29/12
How to Resolve Duplicate Data within Excel Pivot Tables 70,858 Comments 02/13/14
What's the FREQUENCY? Using Excel's FREQUENCY function 70,581 Comments 03/23/10
Twenty-Five Ways to Use Excel's Name Box 65,791 Comments 09/26/13
Automating Excel Chart Titles 65,302 Comments 06/21/12
Three tricks for formatting rows in Excel 47,361 Comments 10/29/09
Conditionally Displaying Decimal Places in Excel: Part 1 45,122 Comments 11/14/13
Microsoft Excel: Taking the Pain Out of Freezing Panes 44,945 Comments 09/05/12
Excel Tip: Determining the Remaining Length of a Loan Using NPER 42,859 Comments 05/10/13
Identifying Largest and Smallest Values in an Excel List 42,116 Comments 12/05/12
Restoring Classic Print Preview in Excel 2010/2013 39,433 Comments 02/19/13
Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year 38,972 Comments 02/01/13
Creating a Series of Letters in Excel 38,290 Comments 04/03/13
Resetting the Last Cell in an Excel Worksheet 36,237 Comments 04/22/13
Tricks for Opening and Closing Multiple Excel Files 33,574 Comments 04/17/09
The Curious Case of Strikethrough in Word and Excel 32,261 Comments 12/12/13
Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year 30,666 Comments 01/23/14
Free spreadsheet-based Form 1040 available for 2010 tax year 30,421 Comments 01/25/11
Microsoft Excel: Thirteen Double-Click Tricks 26,219 Comments 05/09/12
Little Known Techniques for Opening Excel Files 26,109 Comments 10/05/12
Transposing Data in Excel Worksheets 24,574 Comments 09/10/12
Excel Tip: Automatic Backup of Key Excel Workbooks 24,574 Comments 04/25/12
Excel Tip: Use Conditional Formatting to Identify Unlocked Cells 22,404 Comments 04/19/13
Microsoft Excel: How to Automate Text File Links 21,925 Comments 07/26/13
Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014 21,924 Comments 01/09/14
Managing Excel Add-ins 21,890 Comments 08/03/12
Utilizing Excel's COUNTIF Function to Break Ties 21,852 Comments 12/13/12
Automate Excel Charts in Two Keystrokes 21,629 Comments 06/01/12
Microsoft Office 2013 Officially Released 21,254 Comments 02/01/13
How to Maximize Excel's Recent Items Menu 21,102 Comments 08/08/13
Mastering the Conversion of Minutes to Hours/Minutes in Excel 20,954 Comments 12/03/14
First Look at Excel 2013 20,314 Comments 07/16/12
Excel Tip: Pasting Text into Excel 2010 19,371 Comments 04/03/12
Sticker Shock Awaits Sage 50/Peachtree Payroll Service Users 18,772 Comments 04/16/13
Seven Quick Excel Tips 18,731 Comments 03/07/12
Microsoft Excel: Use Color to Identify Variances 18,644 Comments 11/16/12
Excel Tip: Determining Worksheet Cell Protection at a Glance 17,620 Comments 04/12/13
First Impressions of Excel for iPad 17,617 Comments 04/18/14
Conditionally Displaying Decimal Places in Excel: Part 2 17,490 Comments 11/23/13
Learn How to Highlight Rows in Excel Based on Duplicates 16,998 Comments 01/30/15
Identifying Duplicate Values in an Excel List, Part 2 16,728 Comments 08/23/13
How to Get Excel to Handle Social Security Numbers Properly 16,529 Comments 03/21/14
Is This Excel Worksheet Protected? 15,903 Comments 07/12/12
Intuit's New QuickBooks Online Accountant Brings the Cloud – and Its Benefits – to Accountants 15,631 Comments 11/10/11
Excel: The Indispensable NCAA Bracket Tool 15,547 Comments 03/14/14
Overcome a Nuance of Excel's Subtotal Feature 15,424 Comments 05/24/13
Business vs. Personal: Controlling What People See on Your Facebook Pages 15,088 Comments 03/15/11
Two Ways to Determine Your Top Customers in QuickBooks, Excel 15,013 Comments 06/08/10
Managing Excel Add-Ins 14,828 Comments 04/17/09
Restoring "Shrink One Page" in Word 2010 and 2013 14,767 Comments 10/24/13
Farewell Peachtree Accounting, Hello Sage 50 14,644 Comments 05/18/12
Excel Tip: Table Feature Enables Effective Analysis 14,243 Comments 02/02/12
Excel Tip: Calculating Straight-Line Depreciation 14,202 Comments 04/30/12
Free Microsoft Excel-Based 1040 Form Available 12,987 Comments 02/03/09
Using Clip Art in Excel Charts 12,934 Comments 06/28/12
Understanding the Undo Option in Excel 12,682 Comments 03/23/10
Worlds Colliding: Convert a Digital Photo into an Excel Spreadsheet 12,143 Comments 08/02/13
Excel Text Transformation Tricks 12,140 Comments 01/07/09
Homeland Security Warns of Java Vulnerability 12,105 Comments 01/14/13
Trapping Errors within Excel Formulas 12,103 Comments 10/25/12
When Excel Dates Mysteriously Shift by 4 Years 11,978 Comments 09/04/14
Microsoft Adds Key Features to Excel for iPad 11,600 Comments 09/10/14
What to Do When Sparklines Are Disabled 11,555 Comments 03/28/14
Timesaving File Menu Tricks in Excel 2010/2013 11,218 Comments 09/16/14
Maximizing Excel's Alt-Down Arrow Keyboard Shortcut 10,989 Comments 08/04/14
Use Excel to File Your 2014 Form 1040 and Related Schedules 10,861 Comments 01/23/15
Office 2007 Themes Standardize Document Look, Feel 10,154 Comments 03/23/10
How to Improve Spreadsheet Integrity with VLOOKUP 10,102 Comments 02/21/14
Farewell, Lotus 1-2-3 9,946 Comments 05/17/13
iPhone, Android Productivity Apps for Accountants 9,760 Comments 01/18/11
Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF 9,742 Comments 10/27/14
Creating a "Chainsaw" List of Excel Worksheet Functions 9,430 Comments 09/06/13
Exploring the Nuances of Excel's SUM Function 9,347 Comments 08/07/14
Eliminate a Common Spreadsheet Design Flaw 9,140 Comments 07/12/13
Freezing a Middle Row in Excel While Scrolling Above/Below 9,091 Comments 11/04/14
Automating Excel Spreadsheet Report Titles 8,905 Comments 11/02/12
Under the Radar Part 1: Five new features in Excel 2010 8,567 Comments 11/30/10
Creating Excel's Equivalent of MAXIF 8,384 Comments 06/05/14
Under the Radar Part 2: Five New Features in Excel 2010 8,319 Comments 11/30/10
Buried Gold: Excel's Form Command 8,224 Comments 04/17/09
Excel 2007: Use these three techniques to turbo charge filtering 8,190 Comments 11/18/08
BlackBerry Productivity Apps for Accountants 8,126 Comments 01/18/11
Excel Filtering 101 8,095 Comments 10/14/08
Microsoft Reveals New Office 2013 Pricing Scheme 7,857 Comments 09/21/12
Microsoft Outlook: Disabling the Send without a Location Prompt 7,856 Comments 11/21/12
Microsoft to Fully Embrace Open Document Standards 7,662 Comments 08/17/12
Excel Tip: Using Today() versus NOW() 7,634 Comments 03/30/12
Yes, Microsoft Excel Is Talking to You 7,628 Comments 08/27/12
Excel 2003: Use These Three Techniques to Turbocharge Filtering 7,402 Comments 10/28/08
Excel Tip: Converting Numbers Formatted as <1> to -1 7,348 Comments 03/23/10
First Impressions of Windows 8 7,095 Comments 11/09/12
Speed Up Microsoft Excel's Help Window 7,020 Comments 08/15/13
Office 2010 Has Arrived! Customize Your Ribbon! 6,971 Comments 06/16/10
New Spam Attack Attempts to Disable Security Software 6,878 Comments 09/13/10
Stealth Price Increase Awaits QuickBooks 2008 Users 6,730 Comments 05/19/11
How You Can Determine the First Sunday in a Month in Excel 6,627 Comments 12/09/14
Why You Need a Solid State Drive for Your Computer 6,181 Comments 06/12/14
UPDATE: BlackBerry PlayBook Means Business 6,166 Comments 09/30/10
Embed Frequently Used Lists into Excel 6,157 Comments 06/19/14
Excel Tip: Text Boxes 6,137 Comments 03/28/12
Excel Tip: Hide an Excel Worksheet in Plain Sight 6,115 Comments 12/08/08
Microsoft Office 2013 Crosses RTM Threshold 6,035 Comments 10/12/12
Three Excel Menus You May Have Overlooked 6,025 Comments 04/17/09
Microsoft celebrates 25 years of Excel 5,759 Comments 01/18/11
Provisioning Your Home Accounting Office 5,482 Comments 03/13/09
Excel Tip: Data Entry Shortcut 5,435 Comments 04/08/12
Improving the Integrity of Excel's SUM Function 5,401 Comments 06/13/13
The End Is Near for Windows XP 5,285 Comments 05/02/13
Deloitte Buys Boutique Mobile App Firm 5,158 Comments 01/13/12
The 7 Characters You Can’t Use in Excel Worksheet Tab Names 5,071 Comments 04/02/15
Here is How You Can Find Circular References in Microsoft Excel 5,021 Comments 03/26/15
Microsoft Office Moves into the Cloud 4,884 Comments 11/08/10
Understanding How to Use Circular References in Microsoft Excel 4,780 Comments 03/11/15
Excel Puzzler: MAXIF Without Using an Array Function 4,700 Comments 06/09/14
Two Things You Can’t Avoid: Apps and Taxes 4,686 Comments 02/17/11
Excel Tip: Text Centering Trick 4,235 Comments 03/29/12
Internet Explorer Opens Doors to Hackers 4,177 Comments 05/01/14
My Quixotic Pursuit of Microsoft Excel for the Android Platform 4,105 Comments 02/18/15
Quick Steps to Take in Advance of Google's Privacy Policy Changes 4,043 Comments 03/01/12
Excel 2007: Five Ways to Streamline Excel’s User Interface 3,732 Comments 01/07/09
Add Contacts or Meetings to Contact Manager or CRM with Two Keystrokes 3,483 Comments 02/06/09
Start-up Company Aims to Simplify Small Business Cash Flow Management 3,471 Comments 07/06/10
Excel 2003: Six Ways to Streamline Excel's User Interface 3,146 Comments 01/07/09
Excel Chart Advisor Prototype Simplifies Graphs 2,896 Comments 10/07/08
QuickBooks 2009 splashes on the scene with plenty of new features 1,428 Comments 10/21/08
Whither Conficker? 1,166 Comments 06/18/09
Premium content is currently locked