Work smarter with Smart Tags: this Office XP feature acts as your very own personal robot. .Picture this: You type a name into a document and a tiny icon instantly appears next to it. When you pass your cursor (1) The symbol used to point to some element on screen. On Windows, Mac and other graphics-based screens, it is also called a "pointer," and it changes shape as it is moved with the mouse into different areas of the application. over the icon, a menu unfolds that offers you options such as' Insert the person's address and phone number, send him or her an e-mail or schedule a meeting. The icon even gives you the opportunity to tell the software never to interrupt you with these suggestions again. If you've upgraded to Microsoft's latest office suite, XP, chances are you've seen the icons, called Smart Tags (1) A browser plug-in that recognizes words and phrases on Web pages and automatically turns them into links to advertisers or dictionary/encyclopedia definitions. Although users like smart tags, Web site publishers dislike them, because they make it easy for the user to jump off , popping up uninvited un·in·vit·ed adj. Not welcome or wanted: uninvited guests. uninvited Adjective not having been asked: uninvited guests in your documents and spreadsheets. The goal of this article is to introduce you to the new technology and show you how, if you wish to use them, they can improve your productivity. Or, if you object to such high-tech intrusion, we'll show you how to get rid of them. PERSONAL ROBOT Like the Personal Computer, the Personal Robot is one that will change the use of robots from being large, expensive, and hard to use, to being small, inexpensive, and easy to use. Smart Tags are all about providing quick access to information. They recognize text, numbers, actions and objects that frequently could be enhanced with more facts. When triggered, they act like personal robots that will cruise' far and wide to seek data in your computer or, if you're connected, on your network or the Internet. Say you're in Word and you type Jennifer M. Mueller. XP instantly recognizes the words as someone's name and triggers a Smart Tag--the letter "i" inside a small square--into action. It looks like exhibit 1, below, on the screen. [ILLUSTRATION OMITTED] If you decide the targeted words don't need further attention--such as adding an address or sending that person an e-mail--you simply ignore the tag, type on and it will disappear. But if you hover An option in Microsoft Internet Explorer that removes the permanent underline from hypertext links. The underline displays automatically and only when the cursor is placed over (hovers over) the link. Hover is available in Tools/Internet Options/Advanced/Underline links. over the icon, a down arrow will appear and if you click on it, the menu in exhibit 2, at right, will unfold unfold - inline . [ILLUSTRATION OMITTED] You don't have to do anything to launch the Smart Tag function. It's automatically turned on when you install Office XP. Smart Tags are not limited to Word; they operate in Excel, Outlook, PowerPoint and FrontPage. * Paste. This function is evoked e·voke tr.v. e·voked, e·vok·ing, e·vokes 1. To summon or call forth: actions that evoked our mistrust. 2. in Word, PowerPoint, Excel, Outlook and FrontPage. In those applications a Smart Tag will appear when you paste text or other objects. It will offer various formatting choices, depending on the application, such as keeping the style of the source from which the information was copied or matching it to that of the destination. * AutoCorrect. It's been available in earlier versions of Office applications--Word, PowerPoint and Outlook. A Smart Tag appears when AutoCorrect makes an automatic fix, offering to undo To restore the last editing operation that has taken place. For example, if a segment of text has been deleted or changed, performing an undo will restore the original text. Programs may have several levels of undo, including being able to reconstruct the original data for all edits it and even change the AutoCorrect settings on the fly, so to speak. Before Smart Tags, a user who was unhappy about an AutoCorrect change had to go into the setup menu to alter the default. * AutoFit in PowerPoint. Smart Tags appear when a user enters text into a placeholder place·hold·er n. 1. One who holds an office or place, especially: a. One who acts as a deputy or proxy. b. One who holds an appointed office in a government. 2. on a slide and offers formatting options such as fitting the text to the size of the placeholder or splitting the text between two slides. * AutoFill in Excel. It's triggered when you click and drag Using a pointing device, such as a mouse, to latch onto an icon on screen and move it to some other location. When the screen pointer is over the icon of the object, the mouse button is clicked to grab it. The button is held down while the object is moved ("dragged") to its destination. data from one cell to others. The Smart Tags menu offers to copy the contents, fill in the series, fill in the format only, or fill in the series without formatting. * Error Checking in Excel. It appears when a cell contains a formula error or invalid reference and offers help on the type of error in the cell and error-checking and debugging (programming) debugging - The process of attempting to determine the cause of the symptoms of malfunctions in a program or other system. These symptoms may be detected during testing or use by real users. options. Office XP contains quite a few more Smart Tag functions, but they're "asleep" arm need to be awakened a·wak·en tr. & intr.v. a·wak·ened, a·wak·en·ing, a·wak·ens To awake; waken. See Usage Note at wake1. [Middle English awakenen, from Old English in order to work. Smart Tags for recognizing names, addresses, dates, times and stock symbols can be awakened by checking the boxes for the particular tags in the AutoCorrect dialog box A movable window that is displayed on screen in response to the user selecting a menu option. It provides the current status and available options for a particular feature in the program. (more on this later). For example, if Jennifer M. Mueller's e-mail and postal addresses were in your Outlook Contacts file and you clicked on Insert Address in her Smart Tag menu, the text in exhibit 3, at right, would appear. Exhibit 3 Jennifer M. Mueller Auburn University 301 Lowder Business Building Auburn, AL 36849 Clicking on Send Mail produces the fully addressed e-mail form in Outlook shown in exhibit 4, below. [ILLUSTRATION OMITTED] If you want to mark a calendar date, click on Schedule a Meeting and you produce Outlook's partially filled-in appointment-creation screen as shown in exhibit 5, below. [ILLUSTRATION OMITTED] Within Excel, the Smart Tag technology recognizes stock ticker Stock ticker A letter designation assigned to securities and mutual funds that trade on US financial exchanges. symbols and, at your command, retrieves a stock quote, a company report, recent company news via the Internet from MSN (1) (MicroSoft Network) A family of Internet-based services from Microsoft, which includes a search engine, e-mail (Hotmail), instant messaging (Windows Live Messaging) and a general-purpose portal with news, information and shopping (MSN Directory). Money Central or even a refreshable stock price (see exhibit 6, at right). Thus, CPAs doing financial planning Financial planning Evaluating the investing and financing options available to a firm. Planning includes attempting to make optimal decisions, projecting the consequences of these decisions for the firm in the form of a financial plan, and then comparing future performance against can prepare spreadsheets that track both trading and news activity. Likewise, auditors could develop spreadsheets that list their public audit clients and easily retrieve daily company news. [ILLUSTRATION OMITTED] A caveat to using the stock symbol Smart Tag: It's limited in the information it can retrieve, and the various functions are rather clumsy and take several steps. For a more efficient way to perform these functions, see "The Limits of Smart Tags," page 76. EVEN SMARTER TAGS So far we've illustrated how to work with the built-in, default versions of Smart Tags. More specialized spe·cial·ize v. spe·cial·ized, spe·cial·iz·ing, spe·cial·iz·es v.intr. 1. To pursue a special activity, occupation, or field of study. 2. and powerful ones are available but may require a subscription fee. Various companies have partnered with Microsoft to create Smart Tags for a variety of information needs. Although some Smart Tags are very specific to certain industries, several can help CPAs in public and industry accounting. All are available for download from the Internet. Here are some of the more popular ones: * BridgeInSight. When you type an InSight vehicle symbol (for example, us; IBM (International Business Machines Corporation, Armonk, NY, www.ibm.com) The world's largest computer company. IBM's product lines include the S/390 mainframes (zSeries), AS/400 midrange business systems (iSeries), RS/6000 workstations and servers (pSeries), Intel-based servers (xSeries) ) into Word or Excel, Smart Tags provide continually refreshed re·fresh v. re·freshed, re·fresh·ing, re·fresh·es v.tr. 1. To revive with or as if with rest, food, or drink; give new vigor or spirit to. 2. stock price data on the company that vehicle symbol represents: stock history, analytical charts and Bridge Financial News headlines. BridgeInSight provides information from more than 200 exchanges in over 100 countries (http://insight.bridge.com). * WestCiteLink. By typing a law citation in a Word document, the Smart Tag can retrieve the full text, the history for a case or statute, and other cases and statutes. It can also provide a table of authorities and convert the citation to a Westlaw hyperlink A predefined linkage between one object and another. See hypertext. hyperlink - anchor (www.westlaw.com/citelink). * LexisNexis. Three types of Word Smart Tags work with LexisNexis. The Legal Case Name tag can search for a case name, news articles, law reviews and verdict information. The Person Name tag adds to Outlook Contacts results of searches for a legal biography, property records, judgments and liens, bankruptcy records or addresses. And the Address tag adds to Outlook Contacts results of searches for addresses of people, property records, judgments, liens and bankruptcy records (http://support.lexisnexis.com/ Indownload). * Euro Currency Converter (1) A device that changes one set of codes, modes, sequences or frequencies to a different set. See A/D converter. (2) A device that changes current from 60Hz to 50Hz and vice versa. . This Microsoft product tracks 12 European currencies and the euro. Its conversion function works in Word, Excel and Outlook. The Smart Tag menu then provides various conversion options (http://office.microsoft.com/downloads/2002/Eurost.aspx). In addition, there also are downloadable City Name Smart Tags for general news and weather about a city provided by MSNBC MSNBC Microsoft/National Broadcasting Company (www.msnbc.com) and flight, hotel and other travel information from Expedia (www.expedia.com). Microsoft's eServices Web site (http://office.microsoft. com/Services) offers links to more than 20 downloadable Smart Tags, some of which are free. CLOSE TO HOME Smart Tags also can link to your own company or client information. Microsoft provides a free Smart Tag software development kit complete with code samples in Visual Basic or Visual C++. However, if you aren't proficient pro·fi·cient adj. Having or marked by an advanced degree of competence, as in an art, vocation, profession, or branch of learning. n. An expert; an adept. in those programs or would prefer not to write code, Keylogix (www.activedocs.com) has developed software (ActiveDocs) that lets you customize Smart Tags through a wizard format. The process is analogous to developing a Web site using FrontPage rather than manually coding the HTML HTML in full HyperText Markup Language Markup language derived from SGML that is used to prepare hypertext documents. Relatively easy for nonprogrammers to master, HTML is the language used for documents on the World Wide Web. . The wizard takes you through a series of steps to define the location of the data, the data fields and the Smart Tag menus. Distracted dis·tract·ed adj. 1. Having the attention diverted. 2. Suffering conflicting emotions; distraught. dis·tract by Smart Tags popping up in documents? With a few exceptions, most Smart Tags can be disabled in the AutoCorrect dialog box. To get there, go to Tools and AutoCorrect Options. Select the Smart Tags tab to see a listing that includes those you have downloaded or developed. Clear the check boxes of any Smart Tags you wish to disable To turn off; deactivate. See disabled. (see exhibit 7, page 73). [ILLUSTRATION OMITTED] If you decide to keep Smart Tags, several other settings may help suit your preferences. One formats how the recognized information is visually tagged. In Excel, you may choose either to have the action icon appear whenever you point to the recognized cell, or in addition to the icon, you may want to flag the cell with color to identify it easily. In Word, recognized text will be marked with a faint dotted underline underline an animal's ventral profile; the shape of the belly when viewed from the side, e.g. pendulous, pot-belly, tucked up, gaunt. that remains visible at all times. You may decide to have the action icon appear when you point to recognized text. For details on how to evoke e·voke tr.v. e·voked, e·vok·ing, e·vokes 1. To summon or call forth: actions that evoked our mistrust. 2. those defaults, see "Smart Tags Available in Office XP," below. In both Word and Excel, you can choose whether to save or embed em·bed also im·bed v. em·bed·ded, em·bed·ding, em·beds v.tr. 1. To fix firmly in a surrounding mass: embed a post in concrete; fossils embedded in shale. the Smart Tags in the document or workbook work·book n. 1. A booklet containing problems and exercises that a student may work directly on the pages. 2. A manual containing operating instructions, as for an appliance or machine. 3. . If you choose not to embed them, Smart Tags will not tag previously recognized information when the file is reopened. You may adjust this setting by clicking on the Save Options button beneath the Smart Tags tab within the AutoCorrect dialog box. Finally, at any time, you may remove all Smart Tags from the document or workbook or choose to recheck the document or workbook for any recognized information. That may be useful before sending the document to someone else or when checking one you did not create. If you have not already upgraded to Office XP, the new Smart Tag technology may persuade you to take the step. If, however, you're already on the XP track, check out Smart Tags; they are well worth a test-drive. You may find the tags put valuable information right where you need it--in a specific document or spreadsheet. Key to Instructions To help readers follow the instructions in this article, we use two different typefaces This is a list of typefaces. Serif Here you can find a graphical version of this table.
Boldface See boldface font. type identifies the names of icons, agendas, URLs and application commands. Sans serif Short horizontal lines added to the tops and bottoms of traditional typefaces, such as Times Roman. Contrast with sans-serif.  type indicates instructions and commands that users
should type and file names.
Smart Tags Available in Office XP
Smart Tag Recognizes
Address In Word:
* Any address
AutoCorrect Options In Word and PowerPoint:
* Any fix made by AutoCorrect
AutoFill Options In Excel:
* Click and drag from one cell
to another
AutoFit Options In PowerPoint:
* Text typed into a placeholder
* Text pasted into a placeholder
Date In Word:
* Any date
Error checking In Excel:
* Invalid cell formula
Paste Options In Word, FrontPage,
PowerPoint and Excel:
* Pasted text
* Pasted objects
Person In Word:
* Any person's name
Stock ticker symbol In Excel:
* Stock ticker symbol
Telephone numbers In Word:
* Any telephone number
Smart Tag Actions
Address * Add to contacts
* Display a map
* Display driving directions
* Remove Smart Tag
* Evoke Smart Tag Options
AutoCorrect Options * Undo the change
* Create an exception
* Change AutoCorrect Options
AutoFill Options * Copy cells
* Fill in cells
* Fill in formatting only
* Fill in without formatting
AutoFit Options * AutoFit text to placeholder
* Stop fitting text to placeholder
* Split text between two slides
* Continue on a new slide
* Change to two-column layout
* Control AutoCorrect Options
Date * Schedule a meeting
* Show my calendar
* Remove Smart Tag
* Evoke Smart Tag Options
Error checking * Help on this error
* Show calculation steps
* Ignore error
* Edit in formula bar
* Error checking Options
* Show formula auditing toolbar
Paste Options Available actions depend on
what is pasted, application
pasting from, and application
pasting to
When pasting text into Word,
* Keep source formatting
* Match destination formatting
* Keep text only
* Apply style or formatting
Person * Send mail
* Schedule a meeting
* Open a contact
* Add a new contact
* Insert an address
* Remove Smart Tag
* Evoke Smart Tag Options
Stock ticker symbol * Insert refreshable stock price
* Stock quote on MSN Money
* Company report on MSN Money
* Recent news on MSN Money
* Remove Smart Tag
* Evoke Smart Tags Options
Telephone numbers * Add to contacts
* Remove Smart Tag
* Evoke Smart Tag Options
Smart Tag To disable
Address In Word:
* Select Tools menu
* Select AutoCorrect Options
* Click on Smart Tags tab
* Clear Addresses check box
AutoCorrect Options In Word and PowerPoint:
* Select Tools menu
* Select AutoCorrect Options
* Click on AutoCorrect tab
* Clear Show AutoCorrect
Options buttons check box
AutoFill Options In Excel:
* Select Tools menu
* Select Options
* Click on Edit tab
* Clear Show Paste Options
buttons check box
AutoFit Options In PowerPoint:
* Select Tools menu
* Select AutoCorrect Options
* Click on AutoCorrect As You
Type tab
* Clear AutoFit check boxes
Date In Word:
* Select Tools menu
* Select AutoCorrect Options
* Click on Smart Tags tab
* Clear Dates check box
Error checking In Excel:
* Select Tools menu
* Click on Error Checking tab
* Clear Enable background error
checking check box
Paste Options In Word, FrontPage,
PowerPoint and Excel:
* Select Tools menu
* Select Options
* Click on Edit tab
* Clear Show Paste Options buttons
check box
Person In Word:
* Select Tools menu
* Select AutoCorrect Options
* Click on Smart Tags tab
* Clear Person Names check box
Stock ticker symbol In Word:
* Select Tools menu
* Select AutoCorrect Options
* Click on Smart Tags tab
* Clear Smart Tag Lists check box
Telephone numbers In Word:
* Select Tools menu
* Select AutoCorrect Options
* Click on Smart Tags tab
* Clear Telephone Numbers check box
Note: Smart Tags that are available in Word work in Outlook if Word
is the e-mail editor.
The Limits of Smart Tags Sometimes Smart Tags aren't all that smart. For the time being at least, Smart Tags can recognize only some stock symbols. They can't recognize most symbols of mutual funds. Also, the information returned about a stock is limited both in what can be retrieved and how it is displayed. Fortunately, there's a work around: You can download a free add-in function for Excel as an alternative, accomplishing the task of inserting refreshable stock-related information into a spreadsheet. Both the function and the data are available from MSN MoneyCentral at http://officemicrosoftcom/downloads/2002/Msnsqaspx. The function is defined as follows: = MSNStockQuote(Symbol, "Property", "CountryCode") [ILLUSTRATION OMITTED] For example, if the ticker symbol Ticker Symbol An arrangement of characters (usually letters) representing a particular security listed on an exchange or otherwise traded publicly. When a company issues securities to the public marketplace, it selects an available ticker symbol for its securities which investors for the Fidelity Capital and Income mutual fund is typed into cell A1 as FAGIX, and you wish to return the last price to the neighboring neigh·bor n. 1. One who lives near or next to another. 2. A person, place, or thing adjacent to or located near another. 3. A fellow human. 4. Used as a form of familiar address. v. cell, B1, the function would be entered into B1 as =MSNStockQuote(A1, "Last Price", "US"). When you download and install the add-in function, an optional toolbar A row or column of on-screen buttons used to activate functions in the application. Many toolbars are customizable, letting you add and delete buttons as required. Toolbars may be fixed in position or may float, which means they can be dragged to a more convenient location in the becomes available in Excel with buttons for entering it into a cell through a wizard. The spreadsheet in the screenshot See screen shot. below illustrates the toolbar and the function that is entered into D3. [ILLUSTRATION OMITTED] The add-in function can retrieve 25 types of refreshable information-including last price, day's high, size of last sale, earnings per share and price-earnings (P/E P/E See: Price/earnings ratio ) ratio. JENNIFER M. MUELLER, PhD, is an assistant professor at Auburn Auburn (ô`bərn). 1 City (1990 pop. 33,830), Lee co., E Ala.; inc. 1839. The city's economy centers around Auburn Univ.; there is some manufacturing. 2 City (1990 pop. 24,309), seat of Androscoggin co. University's School of Accountancy in Alabama. Her e-mail address See Internet address. e-mail address - electronic mail address is jmueller@business.auburn.edu. |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion