Q: I use Firefox as my default Internet browser instead of Windows’ default browser, Internet Explorer. Can I remove Explorer from my computer without creating a problem? A: Yes, many people prefer Firefox as their browser. It’s easy to remove Internet Explorer, and it won’t create a problem. However, unless
Information management and technology assurance
Make Hyperlinks in Excel Cells Invisible When the Worksheet Is Printed
Q: I insert hyperlinks in some cells of Excel reports that I eventually distribute to clients. However, those hyperlinks are for my information only: I don’t want them to appear in the reports. Is there some way I can hide the hyperlinks so they don’t show in the printed report?
How to Edit the Text That You Paste Into Spreadsheet Cells
Q: I frequently paste explanatory text into my Excel spreadsheets. But when I paste text that includes more than one paragraph, each paragraph gets popped into separate cells. How can I get them to stay in one cell? A: You’ve touched on a little-known peculiarity of Excel. If you copy
Data Security Remains Top Concern for CPAs, Survey Shows
Data security will remain the most pressing concern for CPAs and their clients over the next 12 to 18 months, according to the AICPA’s 21st annual Top Technology Initiatives Survey, which was unveiled this week. This is the eighth consecutive year the issue has made the top of the list.
Pin a Worksheet, Page or Even an App Like the Calculator to a Screen, and It Will Stay on Top
Q: For years I’ve been looking for an application that would place on my screen a spreadsheet table or an app like the Calculator, and it would remain there as I maneuvered from one worksheet to another or from one file to another. That way I could always instantly reference
Fortify Your Facebook Privacy Settings
Thousands of CPAs and many state CPA societies are using Facebook to help establish and maintain relationships. A search for “CPA” on Facebook yields more than 31,000 results. As more CPAs continue to embrace this venue, privacy concerns are on the rise. As a CPA, I use Facebook both professionally
Firm Up Your Data Security
Given the many threats organizations face in protecting critical information and processes, an information security policy is arguably one of the most important documents an organization can create. Consider these best practices for creating a new security policy and keeping an existing policy up to date. —By Ron Box, CPA/CITP/CFF,
Personalize Windows 7 With a Versatile Tweaking Tool
Q: Back in the old days—that is, when I was still using XP—I downloaded a neat freeware utility from Microsoft that let me tweak my computer’s settings in multiple ways. Is there anything like that for Windows 7? A: Yes, it’s called the Ultimate Windows Tweaker, and it works in
Alternatives for the Lost Compressed-Weekend Option in Outlook 2007
Q: Did Microsoft hide the compressed-weekend option in Outlook 2007, where Saturday and Sunday share one box in the calendar? A: No, it’s not hidden, it has been removed. However, there are some things you can do to partially compensate for the loss. For example, you can adjust your calendar
A One-Click Way to Close Multiple Applications—Free
Consider this scenario: You’ve got six applications open, and to apply a program’s upgrade or to shut down your computer for the night, you’ve got to close each of those open apps—one at a time. This means you first have to save any files that need saving and then click
Shortcuts
Excel: A quick way to copy the number in a cell that is immediately above the cell you’re in: Press Ctrl+” (that’s Ctrl plus the quote mark, which means you have to hold down the Shift key as well). That also copies the number’s formatting. Word: To format (bold, underline,
Jobs Key to Consumer Confidence
Job growth is at the heart of increasing consumer confidence and growing the economy, Quincy Krosby, chief market strategist for Prudential Financial, told AICPA Council members Tuesday in San Diego. “If we don’t bring the word ‘confidence’ in, small business owners will be afraid to hire. They are worried about
Sample Win-Win Compensation Agreement for Managers
Click here to download a sample win-win agreement spreadsheet, applicable to managers. Also read, “Retaining Top Talent Still a Requirement for Firms,” by Heidi Brundage, CPA, and Mark Koziel, CPA.
Shortcuts That Don’t Clutter the Desktop
Q: I love those handy icon shortcuts that launch applications and files. In fact, I’m so addicted to them I find it hard to resist adding just one more to my desktop. As a result, I end up with so much on the desktop that my shortcuts get lost in
Retaining Top Talent Still a Requirement for Firms
For years, finding and retaining staff were the top two concerns of management at public accounting firms. But when the economy soured, client retention quickly became the top issue for CPA firms of all sizes, according to the 2009 PCPS CPA Firm Top Issues Survey, a biennial survey of public
Employee Involvement: A New Blueprint for Success
When it comes to improving employee retention and increasing profitability, my firm, San Francisco-based Eichstaedt & Devereaux, believes that investing in and developing our future leaders builds the foundation for success. Instead of top-down firm management, we use a grass-roots employee involvement program to engage employees in the firm’s business.
Prevent Payroll Errors
Payroll mistakes can be costly. Laws taking effect this year, including the Paycheck Fairness Act and Working Families Flexibility Act, and initiatives such as the IRS’ National Research Program and OSHA’s recordkeeping National Emphasis Program, can result in fines and penalties for errors or noncompliance. The following tips can help
Just Ask, and Windows 7 Can Tell You What Day of the Week It Is
Q: It has always puzzled me that the little digital clock tucked into a corner in the extreme right side of the system tray only shows the time and the date. If I want to know what day of the week it is, which I would find very helpful, I’ve
A Quick Workaround to Create a Name and Address Format for Letters and Envelopes
Q: When I was using Office 2003, I could pull up the names and addresses of clients and business associates from Outlook’s Contacts, and then with just a few more clicks I could prepare the fully formatted data to address letters and envelopes. But I can’t find that feature in
Reader Correction
David Curbo, a CPA with Cannon & Co., Memphis, Tenn., corrected an error in the “Shortcuts” item in the January 2010 column (page 68), where I described a fast way to schedule future dates and times in Outlook’s calendar. I said that, while it would easily schedule future days and
Features
SPONSORED REPORT
Get your clients ready for tax season
Help clients avoid surprises with year-end planning strategies for managing taxable income, maximizing deductions, and adjusting to OBBBA changes affecting individuals and businesses.
