Articles by David Ringstrom

Technology

Microsoft celebrates 25 years of Excel

Microsoft Excel has come a long way from its humble beginnings as a spreadsheet program for the Mac environment. This year, Microsoft is celebrating 25 years of Excel with a Facebook-based contest that encourages users to post their favorite Excel memory.
A&A

iPhone, Android Productivity Apps for Accountants

Spend a minute or two in the app store for your mobile device of choice, and you’ll uncover inane apps like iLickIt. Fortunately, there are some actual productivity-boosting tools starting to shoulder their way through the pack of apps for iPhones, iPads, and Android devices.
A&A

BlackBerry Productivity Apps for Accountants

If you’re like me, you’re still holding onto your BlackBerry with a death grip. However, you might also have app envy because, it seems, every week there are 500 new apps released for iPhone and Android. Fear not, as we’ve unearthed productivity apps for you.
Technology

Under the Radar Part 1: Five new features in Excel 2010

I have to admit, I was underwhelmed when Office 2010 was released. You’d think that an Excel expert would like nothing more than a shiny new version of Excel, but my initial experience with the new user interface in Excel 2007 left me feeling chastened.
Technology

Under the Radar Part 2: Five New Features in Excel 2010

I introduced you to five subtle changes that Microsoft added in Excel 2010 that I’ve found quite helpful in part one of this two-part series. In this second part of the series, I’ll discuss five more features that have boosted my productivity in Excel.
Technology

Microsoft Office Moves into the Cloud

Many businesses aren’t comfortable with having mission-critical applications and data residing in the Cloud, but this combination of low cost and high flexibility might cause skeptics to pause and consider the possibilities.
Technology

UPDATE: BlackBerry PlayBook Means Business

As iPhones continue to impinge on traditional BlackBerry territory, Research in Motion (RIM) is countering with a competitor to Apple’s famed iPad – a tablet known as the PlayBook will be released in early 2011.
Technology

New Spam Attack Attempts to Disable Security Software

A virulent new e-mail threat is causing significant problems for large businesses and individuals. The infected e-mail messages contain a link that, if clicked on, allows a worm to simultaneously exploit an infected user’s e-mail address book and attempt to disable the user's antivirus software.
A&A

Start-up Company Aims to Simplify Small Business Cash Flow Management

Two graduates from University of California-Berkley have launched what they hope will become Mint.com for small businesses.
Technology

What to do when Excel won't let you insert columns

From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows.
Technology

Office 2010 Has Arrived! Customize Your Ribbon!

Office 2010 is now in stores and at www.office.com, so anyone can upgrade to the latest version of Microsoft's flagship productivity suite. Office 2010 provides numerous refinements to the new user interface introduced with Office 2007.
Technology

Two Ways to Determine Your Top Customers in QuickBooks, Excel

Given the length of the Great Recession, your top customers today might not be the same folks who were your top customers even a couple months ago. In this article I'll demonstrate two ways that you can determine who your top customers are based on total sales.
Technology

Transform multiple-line cell contents into columns in Excel

Sometimes in Excel you may encounter a situation where each cell contains multiple lines of data. In this article I'll explain some simple techniques that can make quick work of transforming this data into columns.
Technology

Understanding the Undo Option in Excel

One of my favorite features in Excel is the Undo feature, which as you might expect, allows you to undo the last action that you carried out in Excel. Indeed, you can generally undo multiple steps in Excel. However, there are some caveats to this functionality, as well as a couple tricks you may not know.
Technology

Office 2007 Themes Standardize Document Look, Feel

It can be a significant challenge to ensure that your company's documents have the same look and feel, particularly when you're using Excel, Word, PowerPoint, and Outlook together. Fortunately Office 2007's Themes feature can simplify the process.
Technology

Excel Tip: Converting Numbers Formatted as <1> to -1

In this article I'll discuss two approaches you can use to convert text-based inputs to negative numbers. I'll also share a formatting technique you can use if you want to enclose negative numbers in such brackets instead of parentheses.
Technology

What's the FREQUENCY? Using Excel's FREQUENCY function

From time to time you may want to determine how items fall within specific ranges. For instance, a real estate portfolio manager may wish to know how many buildings fall within ranges of 250,000, 500,000, and one million square feet.
Technology

Some unlikely uses for Excel's SUMPRODUCT function

While you may not be aware of Excel's SUMPRODUCT function, those in the know often use it for its stated purpose: multiplying two ranges together and then summing the total. Although this is helpful, you might not be aware that SUMPRODUCT also can function like VLOOKUP or SUMIF on steroids.
Technology

Three tricks for formatting rows in Excel

I'm sure that you've worked with data sets in Excel where the information starts blurring together. In this article I discuss several techniques that I use avoid getting lost in the forest.
Technology

First Impressions of Excel 2010

As you may have heard, the next version of Microsoft's venerable Office suite recently entered "technical preview", or public beta. Excel 2010 seems to offer mostly refinements and only a few wholesale changes.

Pages


Already a member? log in here.