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
|
|
|
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 >>
|
|
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 >>
|
|
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.
|
|
|
|