Publisher's Note
In 2006, there was not a single trading day when the Dow Jones industrial average rose or fell by 2 percent or more. In the first quarter of 2009 alone, there were 21 such days. That's a staggering fact, housed at the core of these turbulent times.
Speaking of numbers, readers from all over the United States wrote in about the math challenge in last Thursday's Publisher's Note. If you don't recall it, here it is. Next Thursday, we'll shed light on this oddity. There's still time to step up to the plate.
Rob Nance
Publisher
AccountingWEB, Inc.
publisher@accountingweb.com
|
|
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
|
|
|
|
Gear Up Tax & Accounting Education - Conferences, Live Seminars, Self-Study CPE
Over 35 years of delivering practical information you can use, taught by the best in the business.
This summer, join us July 27 - August 2 for Windy City Week in Chicago - Register by June 16 for Early Bird Savings! Plus, save with a discounted $139 room rate (through 6/26) at the beautiful Crowne Plaza Chicago Metro Hotel. Select from: Compilation and Review, Forensic Accounting & Auditing Techniques, Accounting Update, Technology 2.0, Mid-Year Tax Update for Individuals (new!), Planning for Later Years in Life, Estates & Trusts Update, and IRS Audits, Appeals, and Collections.
Or opt for a fall getaway at Royal Flush in Las Vegas (Nov 30 - Dec 1) or Magic Week in Orlando (Dec 15 - 19)!
And don't miss out new Mid-Year Tax Update seminar...This hot new course is earning rave reviews from attendees, and is only available through July 2009!
Visit trainingcpe.thomson.com/GearUp or call 800.231.1860.
|
How automation and the internet make offering payroll hassle free and profitable for accountants
Accountants can now use the same kind of powerful processing center the payroll bureaus have kept to themselves for decades. The Internet has made technology used by large payroll service bureaus such as ADP within reach of accountants. Now, accountants can private label Payroll Service, control 100% of their client relationship, and make $30,000 to $50,000 per year in additional revenue.
|
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.
|
|
|
|
