Q: I work on very large, complex documents—100 or more pages—and they seem to take forever to open on the screen. Is there some way to speed up the display process? A: If you’re willing to occasionally and temporarily forgo their display of graphics and some typographic dingbats (bullets and
Advertisement
TOPICS
Information management and technology assurance
Community Service in Down Economic Times
The stress of economic hardship can cloud corporate priorities. As a result, corporate citizenship activities may suffer at a time when the help is most sorely needed. Accounting firms and other businesses may lose sight of the fact that these volunteer activities make a positive difference in the community at
CPAs in an Aging Society: When Alzheimer’s Disease Affects a Client
Jack is agitated. He has been a client for 10 years, and is now 80 years old. He lost his wife of 40 years a year ago. At your last meeting six months ago, Jack was engaged and paid close attention. Today, he is easily distracted. While he has
Get Results: Improve Your Accounting Firm Processes Using Lean Six Sigma
Poor processes directly affect client service and client satisfaction. You see it in delays in completing jobs, responding to client requests, or when a partner fails to communicate a piece of client-related information, causing an unnecessary mistake down the line. Inefficient processes can result in your firm’s inability to bill
Use the Spike to Remove, Store and Move Parts of a Document to Different Locations
Q: One of the old-timers in my firm told me about a Word function called the Spike. He says it works like Clipboard, but even better. How does it work? A: Years ago most business offices had an old-fashioned paper holder on some desks. It consisted of a long nail-like
Return the Run Menu to Its Start Position
Q: What happened to the Run menu? I recently upgraded from my beloved XP to Windows 7, and when I went to access one of my favorite tools, Run, I discovered it was gone, busted, missing. What’s going on? I want my Run back. A: Worry not. It’s there.
To Create Macros in Word 2007, Initiate the Developer Tab in the Ribbon
Q: I just loaded Word 2007, and now I want to create macros. But I can’t find a way to access the macro tools. Please help. A: They are there. But to access them, you first have to load a tab that, by default, is missing in the Ribbon—the Developer
It’s Time to Split
Q: I have a large Excel worksheet, and I find it difficult to compare data in different parts of the worksheet. Is there a good option for achieving this goal? A: Excel 2007 and 2010 contain two Split tools, which allow you to quickly split the Excel worksheet horizontally, vertically,
How to Prevent Selected Paragraphs From Getting Separated in a Document
Q: Certain paragraphs in documents I prepare need to be next to each other. But when I edit the document, sometimes it repaginates, and those sections slip apart. How do I guarantee that they will remain together? A: In Word 2007, be sure you’re in the document and in the
Shortcuts
Outlook: For a fast way to enter future dates and times in Outlook forms, tab to the New Appointment date and time fields, and, if the date is three weeks in the future, go to Start time and type 3 w (with or without a space between 3 and w)
Technology Is a Cornerstone of Successful CPA Firms
High-performing firms include technology in their strategic plans and leverage those tools to help them succeed in areas such as client service, practice management and staffing, according to a survey by Opinion Research Center commissioned by CCH. The survey included quantitative interviews with 100 partners at firms ranging in size
Guidelines Aimed at Thwarting ID Theft, Security Breaches Unveiled
Responding to concerns about identity theft and security breaches linked to portable devices, the AICPA and the Canadian Institute of Chartered Accountants have expanded Generally Accepted Privacy Principles to include protocols for securing personal information. The AICPA/CICA Generally Accepted Privacy Principles are recognized by the IRS and other organizations. The
Format Excel to Color Negative Percentages in Red
Q How do you format negative numbers, including percentages, to show as red in Excel? A There are a couple of possibilities, but your best option is to use Conditional Formatting. In Excel 2003, begin by selecting the cells you want to format. Then select Conditional Formatting from the Format
2009 Tax Software Survey
The JofA and The Tax Adviser conducted a survey of their readers to determine what aspects of their tax preparation software they like and what they dislike. The survey, which received 9,776 responses, was carried out in late June and early July 2009. Of the 13 products identified for the
Don’t Skimp on Scanners
Another tax season is coming and with it come renewed vows of “going paperless”—or at least going in that direction. The CPAs who have gone completely paperless—scanning in the beginning of the process, using triple monitors so the third screen replaces the physical source docs and essentially never touching a
IRS Expands Electronic Payment Options
With tax season about to start, practitioners should be aware of the various electronic payment options the IRS has introduced in recent years. EFTPS The IRS’ free Electronic Federal Tax Payment System (EFTPS) allows businesses and individuals to pay federal taxes via the Internet or over the phone. Tax payments
Create Keyboard Shortcuts to Insert Symbols in Word and Excel
Q I’m beginning to handle international business, which means I need to be able to use foreign currency symbols in both Word and Excel. How do I create a shortcut for various symbols? A Let’s start with Word, which is the easiest. In Word 2003, press Insert, Symbol, which
Hide Excel’s Sheet Tabs in Order to Expand Worksheet Display
Q I want my screen to display as much as possible of an Excel worksheet. I’ve gotten rid of my Ruler, Message Bar and Formula Bar. Now if I can only hide the tabs on the bottom of the page. Any ideas? A Excel displays the tabs by default, but
Protect Your E-Mailing and Internet Surfing When You Travel
Q My tech-savvy friends warn me about computer-privacy risks when I travel. They say that checking my e-mail while in a Wi-Fi-equipped coffeehouse or an airport is practically an invitation for an unscrupulous person to monitor my messages and even steal my data. Are there any practical ways to protect
Several Ways to Fix a Corrupt Word Document
Q I’ve got a Word document that appears to be corrupt. I suspect there’s a problem because, although I can open the file, it will not respond to several commands, such as Ctrl+F (Find and Replace). Is there some way I can repair it? A This is a tricky
Features
FROM THIS MONTH'S ISSUE
Data governance: How finance builds trust in data
Learn how finance can use data governance to improve data quality, strengthen internal controls, and build trust in business data.
From The Tax Adviser
July 31, 2026
Current developments in S corporations
July 31, 2026
