Articles by David Ringstrom

Technology

Exploring the Nuances of Excel's SUM Function

The SUM function may be the most used—and abused—of all worksheet functions. Although it's far better than manually adding cells together, there are some importance nuances.
Technology

Maximizing Excel's Alt-Down Arrow Keyboard Shortcut

Alt-Down Arrow is one of the most versatile Excel keyboard shortcuts, giving users an easy means to speed through repetitive data entry, and more. Learn its three main uses.
Technology

Embed Frequently Used Lists into Excel

You can create a list of days of the week or months of the year in Excel—but there's more. This is part of the Custom Lists feature, and you can use it to add your own lists. It's easier than you probably thought.
Technology

Why You Need a Solid State Drive for Your Computer

Are you using yesterday's computer? Replace your conventional disk drive with a solid state drive. You'll spend more time getting work done and less time waiting for your computer.
Technology

Excel Puzzler: MAXIF Without Using an Array Function

Special AccountingWEB Article: A recent piece addressed the lack of MAXIF in Excel. A clever reader uncovered an alternative buried deep in Excel. Can you uncover it too? Test your Excel skills!
Technology

Creating Excel's Equivalent of MAXIF

Excel doesn't have a MAXIF function, but you can easily adapt the MAX function. Learn how to write a special type of formula known as an array formula that will do the trick instead. Just take it step by step.
Practice

Internet Explorer Opens Doors to Hackers

Reading this article with Internet Explorer? Stop! It has a security flaw so major that the government is issuing warnings, and Windows XP users are especially vulnerable.
Practice

First Impressions of Excel for iPad

Four years after the first iPad spreadsheet, users finally have a Microsoft-sanctioned solution. I immediately saw its limitations, but Excel for iPad has certain strengths too.
Technology

What to Do When Sparklines Are Disabled

Readers are confused about Excel's Sparklines; explanations and a simple trick make this powerful spreadsheet feature work.
Practice Management

How to Get Excel to Handle Social Security Numbers Properly

Almost every accountant handles Social Security numbers and almost every Excel spreadsheet screws them up. Here's how to fix them.
Technology

Excel: The Indispensable NCAA Bracket Tool

Sports enthusiasts should know that Excel isn't just for accountants: it's for anyone running a Final Four betting pool.
Technology

How to Improve Spreadsheet Integrity with VLOOKUP

Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.
Technology

How to Resolve Duplicate Data within Excel Pivot Tables

An attendee from my recent pivot table webinar posed a question that I hadn’t encountered before.
Technology

Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year

Although the IRS is still madly preparing for the 2013 filing season, one man remains ahead of the curve. Glenn Reeves has released his seventeenth spreadsheet-based version of the US Individual Income Tax Return, commonly known as Form 1040, which taxpayers can download and use for free.
Technology

Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014

It’s a new year, which brings the promise of fresh starts, and resolutions to work smarter. Keyboard shortcuts are one of the best ways to both save time and reduce wear and tear on your wrists when working in Microsoft Excel.
Technology

The Curious Case of Strikethrough in Word and Excel

Excel expert David Ringstrom, CPA, describes a couple of ways that you can streamline access to the strikethrough feature – and pretty much any feature – in both Word and Excel.
Technology

Conditionally Displaying Decimal Places in Excel: Part 2

Excel expert David Ringstrom, CPA, describes how to use Excel's Conditional Formatting feature to handle just about every imaginable situation.
Technology

Conditionally Displaying Decimal Places in Excel: Part 1

In Part 1 of his two-part series, Excel expert David Ringstrom describes how to add decimal places on demand by way of using a custom number format.
Technology

How to Reinstall Microsoft Office When You Don't Have a Disc or Download

From time to time, you may need to reinstall Microsoft Office because you purchased a new computer or you're trying to resolve a program error. Or, in Excel 2010 and later, you may need to move between the 32-bit and 64-bit versions.
Technology

Restoring "Shrink One Page" in Word 2010 and 2013

Long-time Word users may recall a handy feature in Word 2007 and earlier called Shrink One Page. This feature may appear to have vanished from Word 2010 and 2013, but you can easily resurrect it.

Pages


Already a member? log in here.