AccountingWEB

AccountingWEB Special Newswire - Special Edition

by
Jan 2nd 2001
Sift Media
Blogger
Share this content

The AccountingWEB Special Bonus Newswire

The Best Tips of the Year 2000

January 3, 2001

Members Logon to https://www.accountingweb.com for full access to all our resources.

Don't know your Logon Membership Details?

Go to https://www.accountingweb.com/forgotten_login.html

* * This week's newswire is sponsored by PPC * *

http://www.ppcnet.com

***ACCOUNTINGWEB'S BEST TIPS OF THE YEAR 2000***

During 2000 we found that a large part of our audience was thirsty for time-saving tips. AccountingWEB responded by providing a variety of tips for using Excel and the other Microsoft applications, as well as tips for managing time, business communication, using the Internet, checking spelling and grammar, studying for the CPA exam, working from a home office, and lots more.

Here is our gift to you - the top tips of 2000 - described below with links to each tip.

1. Excel Tip: Great Shortcut for Data Entry
2. Alphabetize a Column of First and Last Names by Last Name
3. Copy Formatting from One Excel Worksheet to Another
4. Excel Tips for Working With Multiple Sheets
5. Dealing with Rounding Errors in Excel
6. Use Microsoft Outlook to Track Your Chargeable Hours
7. Desktop Yoga Helps Energize Workers
8. Time Management Tip That Really Works!
9. Tips for Passing the CPA Exam
10.Top 20 Favorite Excel Tips

For a complete archive of all of the money-saving and time-saving tips on AccountingWEB, be sure to bookmark our Self-Improvement page located at https://www.accountingweb.com/self_imp and check back frequently for updates. Access to the tips area is free to all AccountingWEB members - some areas will simply require you to enter your AccountingWEB member name and password to enter. And if you're not a member yet, now is the perfect time to join!

We encourage our readers to submit their own favorite tips that we will gladly share with other AccountingWEB readers..

Gail Perry, Managing Editor
AccountingWEB, Inc.
mailto:[email protected]

* * * * * * * * * * * * * * * * * * * *
1. Excel Tip: Great Shortcut for Data Entry
* * * * * * * * * * * * * * * * * * * *
Control where your cellpointer goes when you press the Enter key with this quick tip for entering data in your Excel worksheet.
https://www.accountingweb.com/item/33957/101

* * * * * * * * * * * * * * * * * * * *
2. Alphabetize a Column of First and Last Names by Last Name
* * * * * * * * * * * * * * * * * * * *
How often do you look at a spreadsheet that contains first and last names in the same column, and try to figure out how to alphabetize that column by last name? Here's the secret!
https://www.accountingweb.com/item/22509/101

* * * * * * * * * * * * * * * * * * * *
3. Copy Formatting from One Excel Spreadsheet to Another
* * * * * * * * * * * * * * * * * * * *
Have you ever taken the trouble to format a worksheet - adding bold to your titles, centering column headings, changing the number format to currency in some rows and comma format in others, changing the width of columns - and then wished you could just snap your fingers and take all that formatting over to another worksheet?
https://www.accountingweb.com/item/25354/101

SPECIAL OFFER

Unleash the Power of Excel in Your Practice! PPC's "Business Solutions" [product code EBSE] is the Excel answer to your Excel question! You'll get 30 ready-to-use templates plus a unique guidebook exclusively from PPC! Now just $156 for book & CD-ROM. Call 800-323-8724 or email mailto:[email protected]t.com and mention offer Z0101 for immediate shipping. Also get QuickBooks Solutions [product code QAS] - PPC's top-seller in 2000 - for just $138 - a 15% savings!
Practitioners Publishing Co. http://www.ppcnet.com

* * * * * * * * * * * * * * * * * * * *
4. Excel Tips for Working With Multiple Sheets
* * * * * * * * * * * * * * * * * * * *
When we posted our 10 favorite tips for working with multiple sheets in Excel, several AccountingWEB members added their own favorite tips. Feel free to add your suggestions to the collection!
https://www.accountingweb.com/item/25932/101

* * * * * * * * * * * * * * * * * * * *
5. Dealing with Rounding Errors in Excel
* * * * * * * * * * * * * * * * * * * *
Have you ever experienced the frustration of displaying a worksheet without full decimal places and having Excel round the numbers for presentation purposes, but if you look closely at the calculations, the displayed numbers don't quite add up?
https://www.accountingweb.com/item/28220/101

* * * * * * * * * * * * * * * * * * * *
6. Use Microsoft Outlook to Track Your Chargeable Hours
* * * * * * * * * * * * * * * * * * * *
Keep track of time spent on telephone calls and time spent working on particular clients with Outlook. At the end of a billing cycle, print out the results, or copy and paste the information into another Microsoft Office document.
https://www.accountingweb.com/item/34710/101

SPECIAL OFFER

Unleash the Power of Excel in Your Practice! PPC's "Business Solutions" [product code EBSE] is the Excel answer to your Excel question! You'll get 30 ready-to-use templates plus a unique guidebook exclusively from PPC! Now just $156 for book & CD-ROM. Call 800-323-8724 or email mailto:[email protected] and mention offer Z0101 for immediate shipping. Also get QuickBooks Solutions [product code QAS] - PPC's top-seller in 2000 - for just $138 - a 15% savings!.

Practitioners Publishing Co. (A Thomson Company), P.O. Box 966, Ft. Worth, TX 76106. Complete tax/accounting libraries at http://www.ppcnet.com and CPE at http://www.ppcuniversity.com
Ask for PPC catalog if not receiving.

* * * * * * * * * * * * * * * * * * * *
7. Desktop Yoga Helps Energize Workers
* * * * * * * * * * * * * * * * * * * *
Whether you're getting psyched up for tax season, launching a long audit engagement, preparing year-end reports, or studying for finals and the CPA exam, these tips will help you make it through those long hours of sitting still.
https://www.accountingweb.com/item/27421/101

* * * * * * * * * * * * * * * * * * * *
8. Time Management Tip That Really Works!
* * * * * * * * * * * * * * * * * * * *
If you're like the rest of us, you're constantly looking for more hours in the day. Here's a time management tip that really works!
https://www.accountingweb.com/item/15774/101

* * * * * * * * * * * * * * * * * * * *
9. Tips for Passing the CPA Exam
* * * * * * * * * * * * * * * * * * * *
While you're busy studying the material you expect to see on the actual tests, don't forget that there are outside factors that influence your performance on the exam.
https://www.accountingweb.com/item/28092/101

* * * * * * * * * * * * * * * * * * * *
10. Top 20 Favorite Excel Tips
* * * * * * * * * * * * * * * * * * * *
One of our AccountingWEB workshops this past fall featured Gail Perry, AccountingWEB's managing editor and author of "Excel 2000 Answers", who shared some of her favorite Excel tips with the group. AccountingWEB will present another of Gail's interactive Excel workshops on Thursday, January 11.
https://www.accountingweb.com/item/31660/101

* * * * * * * * * * * * * * * * * * * *
Subscription Information
========================
To subscribe to this Newswire, send a message to
[email protected]
and in the BODY of the message type:
SUBSCRIBE ACCOUNTINGWEB-US-NEWSWIRE
To remove yourself from this mailing list, send a message to
[email protected]
and in the body of the message type:
UNSUBSCRIBE ACCOUNTINGWEB-US-NEWSWIRE

Copyright (C) 2001 AccountingWEB, Inc. All rights reserved. May be reproduced in any medium for non-commercial purposes as long as attribution is given.

AccountingWEB Inc, P.O. Box 68748, Indianapolis, IN 46268-0748
Phone 317-876-7525
https://www.accountingweb.com

AccountingWEB:
"To inform, to enrich, to enlighten, to entertain."

Tags:

Replies (0)

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.