Articles by David Ringstrom

Tax

Use Excel to File Your 2014 Form 1040 and Related Schedules

Another step in our quest to show that there is no problem that can't be solved by a well-designed spreadsheet.
Technology

How You Can Determine the First Sunday in a Month in Excel

To determine the first Sunday, it’s a simple matter of using the WEEKDAY and CHOOSE functions together.

Mastering the Conversion of Minutes to Hours/Minutes in Excel

Understanding the decimal concept and Excel’s time-based number formats will help you grasp time-based values.
Technology

Freezing a Middle Row in Excel While Scrolling Above/Below

Would you like to freeze a row in the middle of an Excel spreadsheet but have the rows above it and below it scroll together? It's possible—as we show in this reader-requested article.
Technology

Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF

Many users go through several mouse clicks instead of choosing PDF as the file type in the Save As dialog box. However, this technique can be streamlined even further with a single mouse-click.
Technology

Timesaving File Menu Tricks in Excel 2010/2013

In Excel 2013, frequent actions like Opening and Saving files require time-consuming extra mouse clicks. Here are a few tricks you can use to take back a tiny portion of your day.
Technology

Microsoft Adds Key Features to Excel for iPad

Our Excel expert takes a fresh look at Excel for iPad and happily discovers that in the past months Microsoft has added some key elements. Mobile spreadsheet users are now in a much better place.
Technology

When Excel Dates Mysteriously Shift by 4 Years

Sometimes the most mundane tasks, such as copying and pasting a series of dates from one workbook to another, can send you down a mysterious rabbit hole where things become frustrating.
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.

Pages


Already a member? log in here.