Advertisement
TOPICS

Security Issues Top List of Technology Concerns

Considering the fact that much of the data used by CPAs is personal information, it’s no surprise that security issues top their list of concerns when it comes to technology, according to the AICPA’s 20th annual Top Technology Initiatives survey. For the seventh consecutive year, participants rated “information security management”

Excel Can Print an Entire File Even With a Mix of Worksheet Orientations

Some of the worksheets in my Excel files are in landscape orientation and some are portrait. To maintain the orientations when I print the entire file, I print each worksheet separately, which is time-consuming. Is there some way to do the task in one print order? Obviously you never tried

Discover the Power and Convenience of Office Clipboard

When I copy something in Word, say, with Ctrl+C, and then move on to edit and even copy material in some other part of my document, is there a way to retrieve the snippets I copied for later use? Absolutely. The tool you need to exploit is the Office Clipboard,

How to Recognize a Safe Program Update Invitation

When I boot up my Windows XP computer, I keep getting a pop-up above my system tray that says: Updates are ready for your computer. Click here to install these updates. How do I know this is not some kind of virus? There is no indication who is sending them.

A Path to Financial Stability

A sound business strategy is important no matter what the state of the economy. As you work with clients to determine the best methods of surviving the recession, be sure to discuss the following critical points for seizing opportunities to refocus, contain expenses and reassure customers.  Take a fresh look

Inventory Your Keyboard Shortcuts and Clear Out the Useless Ones

Help! Something happened to my shortcut keys in Word. They got all botched up. I know how to reset them, so that’s not my question. But what I discovered when I started to reset them was that I have way more shortcuts than I thought I had— and for tasks

Engage the Option: Click Inside a Word to Select the Entire Word

When I used Word 2003, I could italicize a whole word by putting the cursor anywhere in the word and then pressing Ctrl+I. But when I do that in Word 2007, nothing happens. What’s up? Word 2007 can do it, but you have to tell it to. Here’s how: Click

A Fast Way to Launch an E-mail

There are a handful of people I communicate with by e-mail a half-dozen times a day. Each time I want to send them a note I have to set up a new e-mail and either click for their address or type it in. There has to be a better, faster

Keeping It Together

Retirement, health issues for an owner, the desire to grow—all of these are reasons firms engage in mergers or acquisitions. Most firms decide to merge or acquire only after considerable analysis of financial and professional outcomes. Last month we gave general advice for ensuring a merger or acquisition goes smoothly.

Proposed Changes to Privacy, Security Guidance Available

The AICPA released two proposals that would alter guidance for CPAs providing attestation services, advisory services or both that address IT-enabled systems including electronic commerce systems and privacy programs.             The guidance relates to providing services with respect to system security, availability, processing integrity, confidentiality and privacy.             The AICPA

Out, Out Nasty Ins Key

I can’t tell you how many times I accidentally pressed the Insert (Ins) key and innocently typed over a complex paragraph that I worked on for more than an hour. Thanks for the blessed Ctrl+Z keystrokes, which undid my accidental erasures. Isn’t it about time the Insert key was removed

Excel Shortcuts

Ctrl+1: Displays the Format Cells dialog box. Ctrl+2: Applies or removes bold formatting. Ctrl+3: Applies or removes italic formatting. Ctrl+4: Applies or removes underlining. Ctrl+5: Applies or removes strikethrough. Ctrl+6: Alternates between hiding objects, displaying objects and displaying placeholders for objects. Ctrl+7: Displays or hides the Standard toolbar. Ctrl+8: Displays

One-Size Security Doesn’t Fit All

“Protect Your Wireless Network—And Your Business” (Nov. 08, page 88) suggested a number of steps to protect wireless networks from outside monitoring and other unauthorized access. As an international consultant and a contributing editor for Wiley’s Computer Security Handbook, 5th Edition, I differ with some of the recommended measures. Several measures

Change the Way Dates Appear in a Document

I know the shortcut for entering a date in Word is Alt+Shift+D, but I don’t know how to change the way the date is displayed. I want the date format to be March 19, 2009, not 3/19/09. You can change the default by clicking on Insert, Date and Time, which

The Safe and Easy Way to Unplug a Memory Stick

I’ve been told to never, never, ever unplug a USB device, like a memory stick, until the Safely Remove Hardware icon gives the OK. And that’s my problem: Some days the icon is in my toolbar, and other days it’s missing. What’s going on? What can I dop? So what

A 2009 Tuneup for Your Firm’s Succession Planning

The pending retirement of the baby boomer generation and the unrelenting challenge of finding and keeping talented staff can have grave consequences for firms that fail to develop a succession strategy. With the AICPA’s 2008 PCPS Succession Survey showing that only 35% of multiowner firms had a written succession plan,

Help! I’ve Run Out of USB Ports

My computer has only three built-in USB ports, and all are in use. But now I want to plug in several other USB devices, such as a remote hard drive and a memory stick. What are my options? You can buy a component called a hub that contains one male

Be an “Energy Star”

For many business owners 2008 was a record year for energy costs. The Obama administration, while pledging to reduce greenhouse gas emissions 80% by 2050, has said that ‘energy efficiency’ is the cheapest, cleanest and fastest energy ‘source.’ Consider the following tips to make your business more energy efficient.            

Quick Way to Copy Comments to Multiple Excel Cells

When I review a client’s numbers in an Excel spreadsheet, I frequently add comments in many of the cells, and many of the comments are the same—such as “Looks Good!” Is there any way I can copy them, in one fell swoop, so I don’t have to type the same

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.