Guest articles

Inserting Fields to Calculate Percentage in Excel with Pivot Tables

With a PivotTable, you can insert additional data fields that you have already used and change the calculation function by which you create new calculated columns.Insert an additional data field, Quantity field as an example.Stage 1 – Add field to Data area. Select any cell in Pivot Table area. Right-click, and from the shortcut menu, select Wizard, Layout (in Excel 97, there is no need to select Layout). Drag the Quantity field to the data area.
Tax

CPAs Predict More Audits of Small Businesses

Accountants say a recent restructuring announced by the IRS could mean more audits of small companies and their owners.The IRS is adding 2,200 new positions to its audit operations in 2005, reversing declines over the last several years. IRS audit personnel decreased by more than 25 percent between 1996 and 2002, the Associated Press reported."The feeling out there is that they have lost money over the years and they're trying to regroup," said Theodore Kravitz, CPA, with New York-based accounting firm ERE LLPP.
Practice

Leveraging Tax Season Discussions to Nurture Relationships

By: Terri M. Sommella, President, Sommella Market StrategiesThis time of year, partners spend many hours a day talking to clients, prospects and referral sources. Did you know that busy season discussions can be leveraged to enhance your effectiveness as an advisor and nurture existing relationships? By incorporating a few open-ended questions into busy season conversations, you can elevate the value of the dialog. Open-ended questions usually begin with newspaper reporter's questions: Who, what, when, where, and why.
Education & Careers

Selling on the Inside: Attitude and Aptitude

By, Troy WaughBecoming an insider and selling to owners, board members and top management takes a unique combination of both attitude and aptitude. An attitude that you, as a businessperson, have the expertise and stature to converse with these top officers is crucial. But attitude is not enough. With a proper sense of self-worth you can start the conversation, but it takes real know-how to hold the attention of top officers.Attitude
Education & Careers

Study Reveals Financial Performance Higher for Companies with Women at the Top

A new study released today by Catalyst demonstrates that companies with a higher representation of women in senior management positions financially outperform companies with proportionally fewer women at the top. These findings support the business case for diversity, which asserts companies that recruit, retain, and advance women will have a competitive advantage in the global marketplace.

How to Walk Your Talk: Leadership and Sponsorship in Action

If you work in an organization, you’ve heard this complaint repeatedly. Leaders and managers say they want change and continuous improvement but their actions do not match their words. The leaders’ exhortations to employees ring false when their subsequent actions contradict their words.
Community News

Planning a Spring Get-Away or Partner Retreat? Think Spa

Every year, spas become more relevant to everyday Americans, as more and more people -- and more and more different types of people -- embrace spas to improve the way they look and feel. Spa Finder is at the very center of this unfolding story, representing the largest network of spas in the world and interacting with the largest audience of spa consumers.
Practice Management

Tips for Small Businesses to Protect Assets This Tax Season

Increased federal and state scrutiny of tax records in 2003 and budget deficits signal changes ahead for the recordkeeping practices of America's small businesses, according to Fiducial, an international provider of professional business and financial services. Fiducial says small businesses must pay close attention to recordkeeping this year, as the IRS steps up its auditing and enforcement efforts to reduce tax fraud and do its part to offset large budget deficits.

Ten Tips For Successful Salary Negotiations

Be persuasive: It's hard to force your boss to increase your compensation, and trying to do so can potentially damage your working relationship. On the other hand, it's much easier to persuade him that it might benefit the organization to pay you more, and that doing so will likely improve the way you deal with each other going forward. Aim high, and be realistic: Many researchers have found a strong correlation between people's aspirations and the results they achieve in negotiation. At the same time, you want to suggest ideas to which your boss can realistically say yes.
Practice Management

Brand Reputation Outranks Financial Performance as Measure of Success

Corporate reputation is a more important measure of success than stock market performance, profitability, and return on investment, according to a survey of some of the world's leading CEOs and organization leaders. Only the quality of products and services edged out reputation as the leading measure of corporate success.The World Economic Forum sent a written survey in December to all 1,500 delegates to the 34th Forum currently underway in Davos, Switzerland.
Technology

IT Departments Failing to Take E-mail Archiving Seriously

Over 52 percent of organizations using Microsoft Exchange are not archiving e-mail -- and another 28 percent don't plan to archive, according to a survey by C2C Systems and Osterman Research, a market research firm that helps organizations understand the markets for messaging, directory and related products and services. The C2C/Osterman survey found that only 19 percent of companies were using an e-mail archiving system with indexing, search and retrieval features.
Practice Management

Leverage Up The Value Ladder

By, Troy A. Waugh, CPA MBA
Practice Management

How to Avoid Getting Burned by Document Forgery

An increasingly common form of fraud involves forging signatures on checks, wills, business forms, property deeds and other important documents.
Education & Careers

Your New Year's Resume Checkup

By Deborah Walker, CCMCLike millions of people coast to coast, you may have resolved to start 2004 with renewed job-search enthusiasm. If it has been a while since you brushed up your old resume, you’ll want to begin your job search with a New Year’s resume check up. These five questions will help you focus your resume for even better results in the new year. Has your career objective changed since your last job search? More specifically, are you attempting to change your industry or profession?
A&A

Report Says Top Execs Failing to Pay Off Company Loans

Many top executives are failing to pay back money they borrowed from their employers before the Sarbanes-Oxley Act stopped the practice 18 months ago, according to a new report.The Corporate Library’s study, released Friday, says the average outstanding loan is $4.7 million for the 44 companies that disclosed the information. The Union Pacific Corp.
Technology

WhitePages.com Smart Tag Now Available on MS Office 2003 and XP

W3 Data, Inc., a leading provider of online directory assistance services and operators of the WhitePages.com Network, announced that their white pages directory search application and contact database has been incorporated into Microsoft Office System's Office 2003 and Office XP.The WhitePages.com Smart Tag provides users of Office 2003 and Office XP with the time-savings task of automatically inserting contact information into their documents and programs -- turning their desktops into a .NET connected smart client.Accessible via free download (at

The Best Shortcut Keys in Microsoft Excel

Ctrl+ZUndoCtrl+C Enter, Ctrl+V Ctrl+XCopy, Paste, Multiple Paste, CutCtrl+F, Ctrl+HFind, Find&ReplaceCtrl+P, Ctrl+S, Ctrl+F4, Alt+F4Print, Save, Close, Close Excel
Community News

Survey: Workers Put Off by Favoritism, Hypocrisy

When employers play favorites among employees or look the other way on some questionable behaviors, they are doing more harm than they realize in an already ethically challenged society. They are setting a tone of unethical leadership within an organization.With most of the attention these days focused on high-level accounting frauds, a recent survey shows that most employees find hypocrisy and favoritism to be the most egregious of workplace ethical breaches.
Technology

The Value of a Marketing Plan

By Noah B.
Tax

Top Ten Most Often Missed Business Tax Deductions

Calling the millions of dollars that is overpaid to the Internal Revenue Service (IRS) each year, "a widespread epidemic", the Tax Recovery Group (TRG) is releasing their list of the top ten most often missed business tax deductions. Failing to utilize these deductions accounts for the majority of businesses overpaying their taxes, which, according to statistics, businesses throughout the country overpay their taxes to the sum of millions of dollars each year.

Pages