Partnering for CPA Practice Success (PCPS) has just received the results from its 2000 Member Survey. The survey was distributed to the full PCPS membership — about 6,500 firms.The goal of the survey was to gather information about management and practice issues facing firms in the profession.

They call accountants bean counters, but while you have to be good at math to be an accountant, counting is only the means to a more important end: ensuring that financial information is truthful. An accountant's work can range from an audit, which is a formal analysis of an organization's financial statements, to the day-to-day reckonings of a bookkeeper making sure a small business pays its suppliers and gets paid by its customers.

Bookseller Barnes & Noble has found a novel way to sell books - allow authors to host training courses based on book content.

Have you ever wanted to automatically save your spreadsheets so you don't lose your work? With Excel 2000 this feature is included and will save all workbooks automatically at specified intervals, but it's not installed by default.

Secretary of the Army Louis Caldera announced today that the Army has awarded a $453 million contract to PricewaterhouseCoopers to provide distance education for an estimated 80,000 soldiers over the next five years.This program will enable soldiers to obtain college degrees and professional certifications using computers and online courses while they serve in the Army."This cutting edge, cyberspace program will provide unprecedented educational opportunities for our soldiers," said Caldera. "It reinforces the Army's long-term commitment to investing in its people.

Create an Excel Chart with the Push of a Button.To quickly create a chart, using only your keyboard, select the data range you want to create a chart for and then press F11. Excel automatically creates the chart for you. Select an Entire Range of Cells in Excel.In Excel, if you want to quickly select the entire range of cells you're working on, press CTRL+SHIFT+ASTERISK(*).

Are you scrambling to get all your needed CPE hours before 2000 ends? Check out these inexpensive on-line CPE resources. If you need assistance or have questions about CPE requirements and more, check out the AccountingWEB CPE Page. On-line training is booming in corporate America. On-line CPE costs less, and is increasingly becoming more sophisticated. There are plenty of companies providing on-line training that is cost effective and interactive at the same time.

A question was recently submitted by Barry Shrut, who wanted to know if there is a way he can revise a protected workbook when the password left with a departed employee. This tip may do the trick!Although you can't make changes to protected cells in a workbook when you don't have the password, you can copy the entire workbook to a new workbook file and the protection will not carry over to the new file.Select the occupied cells in the current worksheet.

Occasionally you may want to produce a column of text and a column of numbers with dots separating the text and the numbers. Here are two methods for producing dot leaders in Excel - one of them may work for you.Method One: This method produces dots that go from the left edge of the cell to one space before the number. The dots are in the same cell as the number.