Excel

Technology

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.
Technology

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.
Technology

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.
Technology

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.
Technology

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.
Technology

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.
Technology

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.
Technology

First Look at Excel 2013

The "customer preview," or public beta version, of Office 2013 became available today. Excel expert David Ringstrom gives you a quick overview.
Technology

Automating Excel Chart Titles

In this, his latest article in our Excel Tips series, expert David Ringstrom shows you how you can further automate your chart with a self-updating title.
A&A

Farewell Peachtree Accounting, Hello Sage 50

After thirty-five years, the venerable software program known as Peachtree Accounting is adopting a new moniker - Sage 50 Accounting.
Technology

Microsoft Excel: Thirteen Double-Click Tricks

The impact of single-clicking on a menu or object in Microsoft Excel is generally intuitive, but double-clicking sometimes reveals hidden shortcuts. In this article I'll discuss a baker's dozen of techniques where double-clicking can save you time and effort.
Technology

Excel Tip: Calculating Straight-Line Depreciation

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Automatic Backup of Key Excel Workbooks

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Data Entry Shortcut

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Pasting Text into Excel 2010

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Using Today() versus NOW()

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Text Centering Trick

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Excel Tip: Text Boxes

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
Technology

Seven Quick Excel Tips

Here are seven quick Excel tips for: converting data, amortizing tables, spanning Excel across multiple monitors, filtering for blank rows in Excel 2010, recovering unsaved workbooks in Excel 2010, identifying duplicate values in Excel 2007/2010, and recovering damaged Excel workbooks.
Technology

Excel Tip: Table Feature Enables Effective Analysis

Excel 2007 and 2010 users often overlook the useful Table feature, which can streamline data analysis. The feature is a major overhaul of the List feature that has been on the Data menu of earlier Excel versions. This article will introduce you to the Table feature and show you how it can help you work faster.

Pages


Already a member? log in here.