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.
We thought it might be fun to share with you a list of our top ten, most-read articles of 2012. Overall, it looks like technology topics are of the most interest to you and your colleagues, followed by career and tax-related stories. Enjoy!
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.
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.
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.
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 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.
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.
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.