Click here if this e-mail does not display correctly
May 7, 2009


Publisher's Note
A recent United States Postal Service states that 98 percent of consumers bring their mail in each day, and that 77 percent of customers sort through and organize their mail immediately.† As with most self-produced surveys, these results strike me as being a bit inflated.† However, it makes me think of how accountants treat their mail during busy season.† For those immersed in the rigors of the January-April tax season, Iíve heard tales of some accountants amassing Paul Bunyan-like stacks of mail.† Do you have any tales to share on this subject?

Rob Nance
Publisher
AccountingWEB, Inc.

publisher@accountingweb.com



Manufacturing in a Lean, Flat World

Summer Internships

Windows 7 RC Now Available to Us Mortals

Obama Proposes International Tax Reform


Questions & Advice

Working around #N/A

An #N/A (missing data) populates a vlookup answer cell if the information is not found in the lookup table for an exact match (and I don't want to use a fuzzy TRUE match). This error message (the #N/A) prevents that cell from being useable (columns won't add and I haven't figured out how to eliminate it with IF statements buried in the vlookup statement either). Any suggestions how to work around this dreaded missing data issue?

Add your input!

Merging Cells in MS Excel 2003

I am in the process of organizing some meeting notes using MS Excel 2003. I am using the merge cell function for my type- written notes. The problem I am having is the spreadsheet does not show the full text that I have typed in. I have utilized the autofit row height function with no luck. Can someone help me figure out how to get the full text to show on the spreadsheet?
Share your suggestions!



Archives

Visit AccountingWEB's complete archives, and current quiz by following the links below:

E-Newsletters, Supplements, and Audio Features

This week's CPA review

Featured links
Get straight to your point, with Checkpoint®
Why most accountants need a new firm website
Mastering Excel Pivot Tables - CPE Webinar
Top News

Will multinational corporations survive the coming tax changes?

Why are business groups, including the U.S. Chamber of Commerce, spitting nails after President Obama's announcement of tax changes on Monday May 4th? more >>
Why the secrecy? Public disclosure of taxes not a new idea
CFOs divided over need for IFRS
Get straight to your point, with Checkpoint®

For more than 10 years, accounting, auditing and tax professionals have been turning to Checkpoint®, the revolutionary, easily-searchable online system, to get straight to their answers.

Checkpoint brings together the most trusted information on the most powerful research system available, integrating unparalleled expert guidance, primary source materials and analysis.

Plus, Checkpoint is completely customizable to meet your specific research needs, so you see exactly what you want, and reach your answers faster and easier than ever before.

Try Checkpoint now at NO COST for 30 days. Call 1.800.950.1216 or visit ria.thomsonreuters.com today.
Featured Articles
A Conversation with John Sharbaugh of the Texas Society of CPAs

When you're born in Hershey, Pennsylvania and grow up in a town close enough that you can small the chocolate whenever the wind blows, you just know that the future can only be bright. Of course, John Sharbaugh attributes his successful career in association management more to his education and his penchant for preparation than to having chocolate in his DNA, but a case could be made either way. more >>
IRS breaks records with e-file activity this Spring
Third promoter of Wesley Snipes's tax strategy faces prison
WHY MOST ACCOUNTANTS NEED A NEW FIRM WEBSITE

Is there any reason presently why your clients should visit your website regularly?
Did YOU visit your firm's website recently?
Have you acquired any new clients lately from your website?

If the answers to these questions are "NO" - you need Emochila's help. Click here to learn more and request your free trial.
Firm/State/People News
BBD team will head to Kentucky to rebuild housing for the elderly

On Sunday May 31, nearly half the personnel of Briggs, Bunting & Dougherty LLP (BBD), a CPA firm in Philadelphia, Pennsylvania, will be making the nine-hour drive to Salyersville, Kentucky to begin a community service project that will entail working four full days remodeling homes for the elderly. more >>
States turn federal tax credits into cash for would-be homebuyers
University of Texas accounting program tops rankings once again
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:

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

Many more...click here to see the full season
Advertise in the Weekly News Analysis E-Newsletter
Many advertising opportunities are available
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 unsubscribe from this newsletter, 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