AccountingWEB.com - Excel

Three tricks for formatting rows in Excel

Thu, 29 Oct 2009 15:33:41 +0000

By David H. Ringstrom, CPA

First Impressions of Excel 2010

Thu, 06 Aug 2009 14:36:42 +0000

As you may have heard, the next version of Microsoft's venerable Office suite recently entered "technical preview," or public beta. While Excel 2007 introduced some dramatic changes, Excel 2010 seems to offer mostly refinements and only a few wholesale changes. Thus Excel 2007 users should have an easy time transitioning to Excel 2010, but anyone still using Excel 2003 or earlier will need to make the transition to the Ribbon-based user interface.

Introducing the AccountingWEBinar Series

Fri, 17 Apr 2009 18:42:35 +0000

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 Excel

Microsoft Outlook

Microsoft Word

Microsoft Access

Intuit QuickBooks

Sage Peachtree Accounting

XML/XBRL

Each webinar will involve a 50 minute presentation by AccountingWEB staff writer David H. Ringstrom, CPA.

Three Excel menus you may have overlooked

Fri, 17 Apr 2009 17:22:57 +0000

By David H. Ringstrom, CPA

Sheet Navigation

Everyone 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

Fri, 17 Apr 2009 16:43:15 +0000

By David H. Ringstrom, CPA

Add-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 Features

Excel ships with several add-ins that you can manually enable.