Contact Us  |   ##mail##
In the Zone: Tax Zone
March 24, 2010    
Featured Sponsors
The Workplace Fitness Challenge
QuickBooks 2010 on Demand
Become an Excel Power User
Editor's Note
Gail Perry, CPA, Managing Editor Lazarus Long, in Robert Heinlien's Time Enough for Love, said, "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something." We could say the same thing about finding ways to make our time spent in Excel quicker and easier. For some, the goal is the steps circumvented, the sense of conquering the obstacles presented by the program. For others, progress is measured by minutes shaved off a project, time that can be devoted to other activities. However you measure it, time saved is, well, time saved. We hope you'll find that the minutes you spend reading these Excel tips will save precious time that you can devote to other endeavors.

Best wishes,
Gail Perry, CPA
Managing Editor
The Workplace Fitness Challenge
Workplace Fitness The days are long gone when our teachers herded us off to gym class and we took a break from the school day to do our sit-ups, shoot hoops, learn how to handle a tennis racket, and get pummeled in dodge ball. But just because we've traded our school books for a desk and a computer, that doesn't mean we can't get back in shape and stay in shape, all while doing our jobs. Take the AccountingWEB Workplace Fitness Challenge!
Office 2007 Themes standardize document look, feel
It can be a significant challenge to ensure that your company's documents have the same look and feel, particularly when you're using Excel, Word, PowerPoint, and Outlook together. Fortunately, Office 2007's Themes feature can simplify the process.
Understanding the Undo option in Excel
One of my favorite features in Excel is the Undo feature, which as you might expect, allows you to undo the last action that you carried out in Excel. Indeed, you can generally undo multiple steps in Excel. However, there are some caveats to this functionality, as well as a couple tricks you may not know.
QuickBooks 2010 on Demand
QuickBooks 2010 on DemandCo-authored by AccountingWEB's Gail Perry, QuickBooks 2010 on Demand is a task-based reference book, designed to appeal to the QuickBooks user who wants the answer to questions in a hurry.
We're giving away 25 copies to readers who post questions or answers in our Q&A during March. Entry is easy - Post in our Q&A section and become one of 25 winners of QuickBooks 2010 on Demand. Winners will be selected at random and names of winners will be posted on AccountingWEB in April. Share your curiosity, Share your knowledge.
Excel Tip: Converting numbers formatted as <1> to -1
In this article I'll discuss two approaches you can use to convert text-based inputs to negative numbers. I'll also share a formatting technique you can use if you want to enclose negative numbers in brackets instead of parentheses.
Some unlikely uses for Excel's SUMPRODUCT function
While you may not be aware of Excel's SUMPRODUCT function, those in the know often use it for its stated purpose: multiplying two ranges together and then summing the total. Although this is helpful, you might not be aware that SUMPRODUCT also can function like VLOOKUP or SUMIF on steroids.
What's the FREQUENCY? Using Excel's FREQUENCY function
From time to time you may want to determine how items fall within specific ranges. For instance, a real estate portfolio manager may wish to know how many buildings fall within ranges of 250,000, 500,000, and one million square feet.
Transform multiple-line cell content into columns in Excel
Sometimes in Excel you may encounter a situation where each cell contains multiple lines of data. In this article I'll explain some simple techniques that can make quick work of transforming this data into columns.
Become an Excel Power User
David RingstromSpreadsheet expert David H. Ringstrom, CPA enjoys sharing his favorite Excel tips and tricks. He's fond of saying "Either you work Excel, or it works you!" David contributes articles on Excel to Microsoft Professional Accountant's Network newsletter, speaks at conferences, and provides Excel training nationwide. David is a staff writer for AccountingWEB, as well as owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm. View all of David's upcoming webcasts.
Kaplan Weekly Quiz
KaplanAre you prepared for the CPA exam? Test your knowledge and keep your skills sharp by taking the weekly CPA Exam Quiz, brought to you by Kaplan Schweser CPA Review and AccountingWEB Education & Careers Zone. New questions will be posted for each section weekly. Take this week's quiz.
Career Information
Captain Excel
QuickBooks 2010 on Demand
White Paper Leads
To change your e-mail address, your password information, modify subscriptions, and update your personal profile information, please log in to to manage your account.

Unsubscribe from IN THE ZONE: Technology Zone

Copyright © 2010, AccountingWEB, Inc. All rights reserved., P.O. Box 2252, Westerville, OH 43086-2252

The AccountingWEB Portfolio includes: | | |