Data With a Click


I’m preparing a memo for clients that contains definitions of many technical terms. Although I must include those definitions somewhere in the memo for nonaccountants, I don’t want the definitions to get in the way of the flow of the text; nor do I want them stuck at the end, thus making readers flip back and forth to read them. Can I add a button that, when pressed, will take a reader to the definition?

A hyperlink would be perfect for the job. A hyperlink is like a super bookmark that automatically sends a reader to a specific location either in the same document, another document or in Excel or PowerPoint. For example, if your Word memo needs to refer to data in an Excel spreadsheet, a hyperlink will do the trick. Here’s how it works in Word:

Place your memo in one document and all the definitions in another. Open both documents and click on Windows, Arrange All . That places both documents on the screen—one above the other (see screenshot below).

Now go to the definitions page and highlight the first definition, right-click on it and drag the text to the place in the memo where you want it to be available. Then release the mouse button, and this screen will appear (see screenshot below).


Now click on Create Hyperlink Here and the hyperlink (see screenshot below) will appear.

When readers come to the term “technical terms,” they just need to hold down the Ctrl key and click on the hyperlink and the definition pops up.

To create links in Excel or PowerPoint, the process is slightly different. If the data you want to display with the hyperlink are in Excel, you must define the data with either a range or a name (see screenshot of defined data with the name “QuarterSales”).

Then copy the name, switch to the Word document, click on Edit and then on Paste as Hyperlink (see screenshot below).

That immediately pastes the hyperlink into the document (see screenshot).

To do it in PowerPoint, copy the slide, switch to the document and click on Edit and then on Paste as Hyperlink.


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.