Excel | AccountingWEB.com

AccountingWEB Readers Find Time Management a Challenge

02/07/2012 - 10:19 - 569 reads

Few readers think time management is their strong suit, with the vast majority of respondents to a recent survey – 87.3 percent – saying they're either "OK, not great" at it or "could use some improvement." It's no wonder. During tax season, most accountants feel the tensions of too much work and too little time.

Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year

02/03/2012 - 12:23 - 3178 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 - 755 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.

On the Horizon: A New Version of Microsoft Office

02/01/2012 - 13:08 - 700 reads

Microsoft announced that the next version of its flagship productivity suite has entered the "technical preview" phase of its development cycle. This program allows Microsoft customers to test and provide feedback on what's currently known as Office 15.

Three Irreverent Time Management Strategies for the Digital Era

12/08/2011 - 14:50 - 3955 reads

Getting through your to-do list faster isn't what time management is about – at least not anymore. After all, this is the digital era! Rather than managing our existing time as if it was finite, we need to find ways to multiply it and make our lives better.

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

Microsoft celebrates 25 years of Excel

01/18/2011 - 17:22 - 3203 reads

Microsoft Excel has come a long way from its humble beginnings as a spreadsheet program for the Mac environment. This year, Microsoft is celebrating 25 years of Excel with a Facebook-based contest that encourages users to post their favorite Excel memory.