Excel

Technology

Improving the Integrity of Excel's SUM Function

My unscientific observation is that the SUM function is the most widely used function within Excel spreadsheets. This function makes it easy to add up multiple cells at once without laboriously adding multiple cells together individually.
Technology

Resolving #VALUE! Errors in Microsoft Excel

It's a frustrating experience when a simple Excel spreadsheet displays #VALUE! in a worksheet cell rather than the expected result. Many times the problem is obvious, but sometimes the culprit is harder to track down.
Technology

Overcome a Nuance of Excel's Subtotal Feature

Many users rely on the Subtotal feature in Excel to instantly insert totals, averages, counts, or other statistics into a list. As you'll see, the feature is easy to use – until you want to copy or format just the total rows.
Technology

Farewell, Lotus 1-2-3

IBM recently announced that Lotus 1-2-3 will no longer be available for purchase. Most readers of this article will likely have one of two reactions: "What is Lotus 1-2-3?" or "Lotus 1-2-3 was still on the market?"
Technology

Resetting the Last Cell in an Excel Worksheet

It's frustrating when Excel acts as if the active area of a worksheet is significantly larger than the actual area where you have data. Suddenly your scroll bars move you into uncharted areas, such as column TX or row 5,000.
Technology

Excel Tip: Use Conditional Formatting to Identify Unlocked Cells

Excel expert David Ringstrom explains how you can use conditional formatting to identify all unlocked cells within a worksheet range.
Technology

Excel Tip: Determining Worksheet Cell Protection at a Glance

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

Creating a Series of Letters in Excel

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

Clever Canadian Accountant Creates Interactive Game Using Excel

Cary Walkin, a CA and video game enthusiast in Canada, found a novel way of using Excel for something other than number crunching. Walkin, who is also an MBA candidate at the Schulich School of Business, created a video game using nothing but Excel.
Technology

Microsoft Excel: Inserting Rows and Columns with Ease

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

Recovering Unsaved Excel Workbooks

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

How to Disable Worksheet Animation in Excel 2013

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

Restoring Classic Print Preview in Excel 2010/2013

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

Identifying Duplicate Values in an Excel List

Excel expert David Ringstrom, CPA, explains how to identify duplicate values in worksheets using any version of Excel.
Tax

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

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

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.
AccountingWEB Life

AccountingWEB's 2012 Most-Read Articles

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

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

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.

Pages


Already a member? log in here.