Articles by David Ringstrom | AccountingWEB

Articles by David Ringstrom


Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year

It's not just the IRS that's been madly updating forms for the 2012 filing season. Right on schedule, Glenn Reeves of Kansas has released his sixteenth spreadsheet-based version of the US Individual Tax Return, commonly known as Form 1040.

Microsoft Office 2013 Officially Released

The latest incarnation, or rather incarnations, of Microsoft's flagship productivity suite were released on January 29, 2013. The plural reference is a nod toward both the web-based Office 365 version as well as the new Office 2013 desktop versions.

Three Ways to Fill Blank Cells within Excel Spreadsheets

Periodically, you may have a need to fill in gaps within an Excel spreadsheet. One way to do so is to manually fill in each cell, but in this article, I'll show you three easy alternatives.

Homeland Security Warns of Java Vulnerability

IMPORTANT ALERT: Computer security sites across the Internet lit up last week with the news that hackers are actively exploiting vulnerabilities in the ubiquitous Java software that resides on many computers.

Hide and Unhide Multiple Excel Worksheets with Ease

It's easy to hide worksheets in Excel, but unhiding multiple worksheets within a given workbook can be a tedious exercise. Users who don't know otherwise are relegated to unhiding worksheets one at a time.

Utilizing Excel's COUNTIF Function to Break Ties

If two items on a list share the same value, MATCH/INDEX will return the same name for both items. Excel expert David Ringstrom describes how to use the COUNTIF function to create a tiebreaker in such situations.

Identifying Largest and Smallest Values in an Excel List

Excel guru David Ringstrom explains how to rank a series of items within an Excel spreadsheet using the LARGE and SMALL functions.

Managing Protected View in Excel 2010/2013

Excel expert David Ringstrom, CPA, explains Protected View and how you can adjust this security measure to suit your needs.

Microsoft Outlook: Disabling the Send without a Location Prompt

Outlook often tries to be helpful and alert you when you've left the Location field blank within a meeting request. David Ringstrom explains how you can eliminate getting a prompt.

Microsoft Excel: Use Color to Identify Variances

Accountants are often tasked with identifying variances that exceed specific tolerances. Rather than trying to eyeball columns of numbers, you can use Excel's Conditional Formatting feature to make such variances leap out on the screen.

First Impressions of Windows 8

On October 26, 2012, Windows 8 officially became the latest version of Microsoft’s flagship operating system. In today’s article, I’ll describe my initial experiences with Windows 8 in hopes that it will aid your eventual transition.

Automating Excel Spreadsheet Report Titles

Many users tire of retyping report titles such as "For the Period Ended October 31, 2012" month after month. Excel expert David Ringstrom explains a couple of techniques you can use to simplify, and even automate, such date-based report titles.

Trapping Errors within Excel Formulas

Sometimes a formula you craft will return an error, such as #DIV/0! or #N/A. Many users overcome this by using combinations of the IF, ISERROR, and ISNA worksheet functions. However, using these functions in concert can result in complex formulas.

Microsoft Office 2013 Crosses RTM Threshold

Microsoft Office 2013 has crossed an important threshold referred to in the industry as Release to Manufacturing (RTM). This means the development team has finalized the flagship suite and beta testing is complete.

Little Known Techniques for Opening Excel Files

David Ringstrom, an expert in Excel, explains hidden techniques you can use to give you more control when opening unfamiliar spreadsheets.

Microsoft Reveals New Office 2013 Pricing Scheme

Earlier this week, Microsoft unveiled a major pivot in how it plans to market its flagship productivity suite in the future. In his latest article, David Ringstrom provides an overview of upcoming options.

Transposing Data in Excel Worksheets

Excel expert, David Ringstrom, CPA, shows you how you can transform a list of data into a columnar list.

Microsoft Excel: Taking the Pain Out of Freezing Panes

Freezing or unfreezing worksheet panes typically involves multiple mouse clicks, but Excel expert David Ringstrom shows you a way to carry out this task with a single keystroke.

Yes, Microsoft Excel Is Talking to You

From time to time, you may need to compare a set of figures or text in an Excel spreadsheet to a paper document, and doing so can be time consuming and error-prone. Expert David Ringstrom offers a better approach.

Microsoft to Fully Embrace Open Document Standards

After years of hegemony, Microsoft has finally acknowledged that the world wants to be able to save documents in open formats that are freely shareable with other software applications.


Premium content is currently locked