Excel | AccountingWEB



Excel Tip: Table Feature Enables Effective Analysis

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

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.

Free spreadsheet-based Form 1040 available for 2010 tax year

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.

Microsoft celebrates 25 years of Excel

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

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

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

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

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.

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

This is the second of two articles wherein Chuck Vigeant explores the ability to generate a Sales by Shipping State report in Excel.

Office 2007 Themes Standardize Document Look, Feel

It can be a significant challenge to ensure that your company's documents have the same look and feel, particularly when you're using Excel, Word, PowerPoint, and Outlook together. Fortunately Office 2007's Themes feature can simplify the process.

Microsoft releases pricing for retail versions of Office 2010

Microsoft is departing from its standard pricing model for its Office 2010 software product by eliminating upgrade pricing. Instead, packaged versions will be licensed for two or three computers, while discounts will be available if a user unlocks a preinstalled version of Office 2010.

First Impressions of Excel 2010

As you may have heard, the next version of Microsoft's venerable Office suite recently entered "technical preview", or public beta. Excel 2010 seems to offer mostly refinements and only a few wholesale changes.

Introducing the AccountingWEBinar Series

AccountingWEB is pleased to announce a series of live webinars aimed squarely at the needs of CPAs in public and private practice. This wide-ranging series will cover the following topics:Microsoft ExcelMicrosoft OutlookMicrosoft WordMicrosoft AccessIntuit QuickBooksSage Peachtree AccountingXML/XBRLEach webinar will involve a 50 minute presentation by AccountingWEB staff writer David H. Ringstrom, CPA.

Three Excel Menus You May Have Overlooked

By David H. Ringstrom, CPASheet NavigationEveryone is familiar with using the arrow buttons in the lower left-hand corner of the Excel screen to push worksheet tabs back and forth across the screen. However, try right-clicking on these buttons instead, and you'll see a menu similar to Figure 1. Simply click on a sheet name to instantly activate that worksheet. 

Managing Excel Add-Ins

By David H. Ringstrom, CPAAdd-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core functionality, while others allow third-party products to add features to Excel's environment. In this article I'll discuss how to enable some of Excel's hidden features, as well as give you some pointers on what to do when third-party add-ins vanish from Excel.Hidden FeaturesExcel ships with several add-ins that you can manually enable. Some of these include: 

Buried Gold: Excel's Form Command

By David H. Ringstrom, CPAMany users are not aware that Excel has long had a feature that enables you to browse through a table of data one record at a time. As shown in Figure 1, the Form command provides an easy way to navigate through a table of data. This command is easy to access in Excel 2003 and earlier versions, but is deeply buried in Excel 2007. In this article I'll show you how to use the Form command to make quick work of reviewing a list of records. 

Tricks for Opening and Closing Multiple Excel Files

By David H. Ringstrom, CPA

Tricks for Hiding and Unhiding Excel Rows and Columns

Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set.

Free Microsoft Excel-Based 1040 Form Available

By David H. Ringstrom, CPAJust in time for tax season, Glenn Reeves of Burlington, Kansas has created a free Microsoft Excel-based version of the 2008 U.S. Individual Tax Return, commonly known as Form 1040. The spreadsheet includes both pages of Form 1040, as well as these supplemental schedules: 

Quickoffice releases Excel editing capabilities for iPhone

Quickoffice, Inc., a global provider of mobile office productivity software, has announced the release of MobileFiles Pro, the first application to include editable Office functionality for the iPhone and iPod Touch.


Premium content is currently locked