Excel

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.

QuickBooks 2012: What’s New and Improved

12/09/2011 - 14:01 - 2849 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.

5 Things CPAs Should Know about Excel Macros

10/27/2011 - 15:33 - 617 reads

Macros are programming code that you can add to your Excel spreadsheets to automate repetitive tasks. Macros can be as simple as a single line of code to carry out a task, such as typing your company’s name.

Continuing Education

Free spreadsheet-based Form 1040 available for 2010 tax year

01/25/2011 - 14:57 - 17470 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.

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.

Two ways to determine your top customers in QuickBooks, Excel

06/08/2010 - 10:59 - 4622 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.

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.

Welcome Visitor!

Already have an account? Sign in:

Forgotten your password?

Join us

Connect with us