Click here if this e-mail does not display correctly
April 17, 2009

Editor's Note
AccountingWEB's resident Excel expert, David Ringstrom, has put together a Webinar series that is sure to delight Excel users. To whet your appetite, David has provided us with a series of Excel Tips articles that appear below. Reserve your place at the seminars today - discounts are available if you buy in bulk. Meanwhile, if you have Excel questions, post them in our Questions and Advice section or simply e-mail them to me and I'll get them posted.

Best regards,
Gail Perry, CPA
Managing Editor
editor@accountingweb.com



I Heart Accountants AICPA


Archives

Visit AccountingWEB's complete archives by following the links below:

E-Newsletters, Supplements, and Audio Features

Kaplan Weekly CPA
Review Quiz







Featured links
CPE Webinars - get the full season for $499! Click here for course list.
Play AccountingWEB's Dollar Bill Game for cash and prizes!
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 Excel, Microsoft Outlook, Microsoft Word, Microsoft Access, Intuit QuickBooks, Sage Peachtree Accounting, and XML/XBRL. more >>
Managing Excel Add-Ins
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. more >>
CPE Webinars by David Ringstrom, CPA
Save big money when you register for multiple sessions


For information on more upcoming webinars, visit the links below:

Creating Error Proof Spreadsheets
Thursday, April 23

Excel Speed Tips
Tuesday, April 28

Mastering Excel Pivot Tables
Tuesday, May 12

SQL for Excel Users
Tuesday, May 19

Excel 2007: Filtering and Formatting Data
Thursday, June 4

Easing the Transition to Excel 2007
Thursday, June 11

Automating Excel-based Financial Statements
Thursday, June 18

And Many More... Click here to see the full season.
Three Excel menus you may have overlooked
Here are three little Excel menus you might not know about - a menu for quickly accessing various worksheets, a menu for moving rows and columns, and another menu for hiding and unhiding worksheets. more >>
Tricks for hiding and unhiding Excel rows and columns
Hiding and unhiding rows and columns in Excel can be a mundane task that many users take for granted. However, it can also be a time consuming procedure if carried out frequently. In this article I'll show you the best ways to manage hidden rows and columns in your worksheets, which will include a couple of features that many Excel users have never tried. more >>
Tricks for opening and closing multiple Excel files
From time to time you may find yourself immersed in a large project that involves several related Excel workbooks. In such cases it can be tedious to manually open each Excel file when you need everything available at once. Excel has long had a helpful solution to this problem that is hidden in plain sight. more >>
Buried gold: Excel's Form command
Many 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. 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. more >>
Advertise in the Excel Zone E-Newsletter
Contact Diane Williams, Sales Manager
866-688-1678 x 17 or e-mail dwilliams@accountingweb.com

Has Outlook blocked your images?
If you need to right-click one of the images in this e-newsletter to see the pictures it's easy to set up AccountingWEB.com as a 'safe sender' so you don't have to do this every time you receive an e-newsletter. Select the Actions-Junk Mail menu and pick either the 'Add Sender' or 'Add Sender's Domain' option.
You are currently subscribed as ##email## to the HTML e-mail version.
To unsubscribe from IN THE ZONE: Excel Zone, follow the link provided by e-mail.
If you experience any problems, please Contact Us

Click Here to swap to the 'Text-Only' version, change your e-mail address, your password information, modify subscriptions, and update your personal profile information.

Please allow up to ten (10) business days for unsubscribe orders to be processed. Thank you for your patience.

Copyright 2009 AccountingWEB, Inc. All rights reserved.

AccountingWEB.com
P.O. Box 2252, Westerville, OH 43086-2252
"Your Profession. Your Community."

Powered by


The AccountingWEB Portfolio includes:

AccountingWEB.com | AccountingWEB.co.uk | AccountingWEB.nl