You can't easily tell at a glance if a cell is locked or not, but Excel expert David Ringstrom shows you how to add a visual aid. As an added bonus, the technique also makes it far easier to lock and unlock worksheet cells.
By its very nature as a spreadsheet, it's easy to create a series of numbers in Excel. But most users don't realize that you can configure Excel to create a series of letters in a similar fashion. Excel expert David Ringstrom explains how.
Spreadsheet users frequently insert rows and columns into spreadsheets, but for most users, it's a multiple-step process. Excel expert David Ringstrom explains how you can create your own custom shortcut to insert rows or columns with a single keyboard shortcut or mouse click.
It's every spreadsheet user's worst nightmare – you've worked on a workbook for a period of time, and then accidentally close it without saving. Or the power goes out, or Excel crashes . . . the list of spreadsheet hazards goes on and on.
Excel 2013 has arrived, and for the most part, it's much like Excel 2007 and 2010, but with some spiffy new features, such as Recommended Charts and Pivot Tables, Flash Fill, Quick Analysis, Power View, and more.
Excel 2010 introduced a new "Backstage View" where print preview became embedded into the File menu. Excel 2013 continues this tradition, but you can get your "old-school" print preview functionality back with a few quick steps.
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.
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.
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.
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.
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.
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.
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.