02/07/2012 - 10:19 - 548 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.
Read more
02/03/2012 - 12:23 - 1614 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.
Read more
02/02/2012 - 17:47 - 714 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.
Read more
02/01/2012 - 13:08 - 680 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.
Read more
12/09/2011 - 14:01 - 2843 reads
If you or your clients use QuickBooks Pro, Premier, or Enterprise, you'll find that QuickBooks 2012's new features will help you gain new insights into financials, get more organized, and save time and steps.
Read more
12/08/2011 - 14:50 - 3944 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.
Read more
07/19/2011 - 00:13 - 5906 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.
Read more
06/22/2011 - 16:02 - 3352 reads -
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.
Read more
01/25/2011 - 14:57 - 17439 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.
Read more
01/20/2011 - 13:27 - 3947 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.
Read more
01/18/2011 - 17:22 - 3200 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.
Read more
11/30/2010 - 15:00 - 3967 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.
Read more
11/30/2010 - 14:19 - 3307 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.
Read more
06/17/2010 - 18:28 - 9449 reads
From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows.
Read more
06/16/2010 - 17:23 - 4983 reads
Office 2010 is now in stores and at www.office.com, so anyone can upgrade to the latest version of Microsoft's flagship productivity suite. Office 2010 provides numerous refinements to the new user interface introduced with Office 2007.
Read more
06/08/2010 - 10:59 - 4620 reads
Given the length of the Great Recession, your top customers today might not be the same folks who were your top customers even a couple months ago. In this article I'll demonstrate two ways that you can determine who your top customers are based on total sales.
Read more
04/13/2010 - 11:51 - 5374 reads -
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.
Read more
04/13/2010 - 09:26 - 4415 reads -
This is the second of two articles wherein Chuck Vigeant explores the ability to generate a Sales by Shipping State report in Excel.
Read more
03/24/2010 - 10:56 - 11484 reads -
Sometimes in Excel you may encounter a situation where each cell contains multiple lines of data. In this article I'll explain some simple techniques that can make quick work of transforming this data into columns.
Read more
03/23/2010 - 21:18 - 5209 reads
One of my favorite features in Excel is the Undo feature, which as you might expect, allows you to undo the last action that you carried out in Excel. Indeed, you can generally undo multiple steps in Excel. However, there are some caveats to this functionality, as well as a couple tricks you may not know.
Read more
