Monday, September 26, 2011

Sparklines

Application: Excel 2010

Sparklines are small charts that fit into one cell to visually summarize trends alongside data. Sparklines can be shown as a line, column, or win/loss format. When Sparklines are created, the Sparklines tools become available so that colors, placement, and styles can be modified.
Adding Sparklines
1.    In Excel, select an empty cell.
2.    Click the Insert tab. In the Sparklines group, select Line, Column, or Win/Loss.
3.  The Create Sparklines dialog box will appear. In the Data Range field, enter the cells to be used in the Sparkline calculation. In the Location Range field, enter the cell where the Sparkline is to be placed.
4.  Click OK.

Monday, September 19, 2011

Microsoft Office 2010 Tip of the Week

Application: Excel, Outlook, PowerPoint, Word 2010

New in Office 2010 is the Backstage View. The File tab replaces the Office Button. The Backstage view is a place to create, manage, and save files and to set options for the application. Each application will offer specific features in Backstage View to adjust settings.

Backstage options
·     Info tab: for adjusting permissions; viewing document properties (status, categories, last modified and printed dates, etc.), using the document inspector.
·  Save & Send: offers multiple options for sharing and sending documents via email, PDF or as an XPS, or save to SharePoint.
·  Options tab: application specific features to adjust settings.

Monday, September 12, 2011

Bookmarks within a document

Application: Word 2010
When Word documents are lengthy it can be useful to use bookmarks to aid in navigation of the document. For example, if a document contains a table of contents, it can be convenient to make it interactive. Each entry in the table of contents can be bookmarked with the corresponding area of the document. This feature can be used with table of contents, headings, key words, or pictures and images in the document.

1. Select the information to apply the bookmark.
2. On the Insert tab, select Bookmark.
3. The bookmark dialog box will open. Enter a name for the bookmark (with no spaces).
Hyperlinking the Bookmark
1. Select the heading, table of contents entry, keyword, picture or image that will go to the bookmark.
2. Right-click and select Hyperlink. The Insert Hyperlink dialog box will open. In the Link to section, be sure that Place in this Document is selected.
3. Select the bookmark name.
4. Click OK.
For more information, see the Microsoft Office article Add or delete bookmarks.