Excel tips | AccountingWEB.com

Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year

02/03/2012 - 12:23 - 3219 reads

Glenn Reeves of Burlington, Kansas, recently released his fifteenth annual spreadsheet-based version of the U.S. Individual Tax Return, commonly known as Form 1040. Since 1997, Reeves has pursued this "labor of love," which means he allows any taxpayer to download and use the spreadsheet for free.

Excel Tip: Table Feature Enables Effective Analysis

02/02/2012 - 17:47 - 756 reads

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.

Everything you need to know about Excel range names

07/19/2011 - 00:13 - 5915 reads

Are you familiar with the range names feature in Excel? It is one of the most powerful tools that even the most basic Excel user can easily master. Name a cell or a block of cells and then work with those cells in formulae and searches throughout the workbook.

Excel Tip: Multiple criteria SUM, MIN, and MAX formulas

06/22/2011 - 16:02 - 3352 reads - 1 comment

Most Excel users are familiar with the SUM, MIN, and MAX functions in Excel. Used in their traditional fashion, you provide a range of cells to the function to derive a result. However, in certain cases you may wish to use this functions based on multiple criteria.

Free spreadsheet-based Form 1040 available for 2010 tax year

01/25/2011 - 14:57 - 17473 reads

Glenn Reeves of Burlington, Kansas, has created a free Microsoft Excel-based version of the 2010 U.S. Individual Tax Return, commonly known as Form 1040.

New Excel spreadsheet discussion board

01/20/2011 - 13:27 - 3956 reads

Sift Media, owner of AccountingWEB, has launched a new Excel spreadsheets discussion area at USBusinessForums. More than 3,000 members have joined USBusinessForums, which includes over 500 threads spanning topics such as general business, accounting, e-business, financial matters, and marketing.

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

11/30/2010 - 15:00 - 3970 reads

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.

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

11/30/2010 - 14:19 - 3310 reads

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.

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

06/17/2010 - 18:28 - 9479 reads

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

Sales/Tax by shipping state in Excel – The power of pivot tables, Part 1

04/13/2010 - 11:51 - 5374 reads - 1 comment

This is the first of two articles wherein Chuck Vigeant demonstrates several ways of approaching Sales and Tax by Shipping State within Excel – one without a pivot table, and one with a pivot table.