Some CPA tax practitioners find they are able to garner new clients and better maintain ties with existing ones by blogging on tax topics. Beyond providing an electronic soapbox, they say, a blog can be a powerful way to disseminate information to existing clients while revealing to prospective ones the
Information management and technology assurance
Psst! Click (or Mouse Over) Here for a Hot Tip
Q: You know those little identifying messages that pop on the screen when I hover my cursor over some icons? Is there some way I can create a similar feature in Word or Excel so readers can get more information about some material in the document or financial statement? A:
Shortcuts in Word
Apply List Bullet style: Ctrl+Shift+L Apply or remove space above current paragraph: Ctrl+0 (zero) Make selected text all caps: Ctrl+Shift+A Double underline the selected text: Ctrl+Shift+D Toggle subscripting for selected text: Ctrl+ = Toggle superscripting for selected text: Ctrl+Shift+ +
CPAs Embrace Twitter
Twitter has taken the Internet by storm. Like LinkedIn and Facebook, Twitter hosts a growing community of CPAs and financial professionals, but unlike its social-networking peers, the microblogging Web site limits users’ messages, questions and conversations to 140 characters (including spaces). To put this limit into perspective, this paragraph has
In a Noncompete Bind?
If you find yourself out of a job in this downturn, keep in mind that restrictive covenants may limit your next move. If you are a party to such an agreement, you could face a costly lawsuit if you go to work for a competing company or firm or start
Cloud Computing, Social Networking Highlighted at AICPA TECH+ Conference
This year’s AICPA TECH+ Conference in Las Vegas proved that, while accountants are using more Web-based applications, security remains a top concern when moving client information online. It’s also apparent that most CPAs aren’t quite sure what to do on social media sites such as Facebook and Twitter. The following
New Law in New York May Affect Out-of-State CPAs
Editor’s note: This article originally appeared in the July 17 AICPA News Update. On July 26, 2009, a new law goes into effect in New York state that significantly changes the regulation and practice of public accountancy. The law includes many new or expanded provisions that affect CPAs practicing in New
FASB Introduces Disclosure Project
FASB introduced a project Wednesday that is intended to make financial statement disclosures more useful, organized and consistent, and less redundant. The project will focus on developing a framework for improved GAAP disclosures, according to FASB Chairman Robert Herz. The vision for the framework is for it to allow companies
CPA Firms Name Their Top Issues
For the first time in several years, staffing is not the most pressing concern for many CPA firms, according to information released in the PCPS CPA Firm Top Issues Survey. Instead, client retention dominates the list, suggesting that “the weakened economy has shifted CPAs’ concerns from staffing to client retention,”
Safe Password Practices
Editor’s note: This is a Web-exclusive exhibit for “Password Management Strategies for Safer Systems.” Advise users to never put their password on a Post-it Note or in another unsafe location. Tell users to always say “No” when Windows or any other software offers to save their password.
Supercharge Your Excel Sum Operations: Worksheets and Exhibits
Editor’s note: These are Web-exclusive exhibits for “Supercharge Your Excel Sum Operations.” Click here to download sample Excel worksheets. Each of the article’s four exhibits is an individual worksheet in a single downloadable Excel file. It includes: Exhibit 1: Sales by person using SUMIF Exhibit 2: Basic functioning of SUMPRODUCT
Social Media Panel Outlines Tips for Accountants
Do accountants need to be on social networking sites such as Facebook and Twitter, or is it OK for them to sit on the sidelines? That question was posed by Bill Sheridan, e-communications manager for the Maryland Association of CPAs, during a social media panel he moderated at the MD
Password Management Strategies for Safe Systems: Offense and Defense
Editor’s note: This is a Web-exclusive exhibit for “Password Management Strategies for Safer Systems.” Primary Security Risks Effective Countermeasures Failing to enhance password security in order to focus on searching for a “perfect” security system and obtaining more funding. Immediately improve password security procedures. Implementing new system security procedures or
Password Management Strategies for Safer Systems: Glossary of Key Terms
Editor’s note: This is a Web-exclusive exhibit for “Password Management Strategies for Safer Systems.” Term Definition Clear Text Unencrypted characters in, for example, a password. Crack To decode an encrypted password. Social Engineering A hacker’s use of a plausible pretext to intimidate or trick an employee into divulging a password
How Long Can You Hang in With Microsoft XP?
Q: I’m one of the Microsoft customers who opted not to “upgrade” to Vista. I don’t think I’m a dinosaur; I just have more important things to do than learn new software—especially when good, old reliable XP suits me just fine. So I’m hoping to stick with XP and Office
Put Some Zip in E-Mail Searches in Outlook
Q: Is there some way to speed up e-mail searches in Outlook? I get tons of mail, and I just don’t always have the time, or the patience, to sort them. Any ideas for a handy tool? A: Both Outlook 2003 and 2007 have very effective sorting tools. But when
A Fresh Approach for Compilation and Review
The AICPA’s Accounting and Review Services Committee (ARSC) has proposed the most significant changes to the professional literature for compilation and review engagements since the December 1978 issuance of SSARS no. 1, Compilation and Review of Financial Statements. The proposed Statements on Standards for Accounting and Review Services (SSARSs), issued
Password Management Strategies for Safer Systems
All of your business systems’ users have confidential passwords. Does that mean your system and its contents are safe? Definitely not. As this article explains, organizations that don’t ensure the ongoing security of their passwords are exposing themselves to fraud and potential liability by failing to protect confidential information. Recent
Use the Keyboard to Substitute for Excel’s Temperamental and Super-Sensitive Fill Handle
Q: I bet I’m not the only one who hates using the mouse to grab that little slippery fill handle in Excel. The idea is great—click on the tiny handle and drag it to fill cells in a variety of ways. But I can’t always maneuver the mouse with that
Boost Office Productivity With Dual Display Workstations
Q: I’ve been trying to convince my partners that we can boost productivity if we add a monitor to each desktop computer so each workstation will have dual displays. Most of the partners think it’s a waste of money. Since most of them read your Tech Q&A column, I figure
Features
FROM THIS MONTH'S ISSUE
Create interactive dashboards with Excel PivotCharts and slicers
Leave the static spreadsheets behind. This JofA Technology Q&A article with video walkthrough provides a step-by-step guide for creating interactive dashboards in Excel that decision-makers can use.
