Hyperlinks automate Excel worksheets by making the opening of other Office documents and Excel workbooks and worksheets just a mouse click away. It doesn't matter whether these documents are located on your hard drive, a server on your LAN (Local Area Network), or Web pages on the Internet or a company's intranet.
Instead of entering the records of a data list directly in the table, you can use Excel's data form to make the entries. The only problem with using the data form is that the command to display the form in a worksheet with a data list is not part of the Ribbon commands.
Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings.
The Selection and Visibility task pane enables you not only to change the layering of various graphic objects in the worksheet but also to control whether they are hidden or displayed.
If selecting gazillions of preset shapes available from the Shapes gallery doesn’t provide enough variety for jazzing up your worksheet, you may want to try adding some fancy text using the WordArt gallery opened by clicking the WordArt command button in the Text group of the Insert tab.
Clip Art is the name given to the over 150,000 ready made illustrations offered by Microsoft for use in its various Microsoft Office programs, including Excel 2007. Clip Art drawings are now so numerous that the images are classified into a bunch of different categories ranging from Abstract to Web Elements.
When creating a text box, you may want to add an arrow to point directly to the object or part of the chart you’re referencing.
Although Excel automatically embeds all new charts on the same worksheet as the data they graph (unless you create using the F11 trick), you may find it easier to customize and work with it if you move the chart to its own chart sheet in the workbook.
After creating a pivot table, you can create a pivot chart to display its summary values graphically in literally two really simple steps:
To modify the fields used in your pivot table, first you display the Field list by following these steps: