Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Create a Desktop Shortcut To Open Files Quickly

While working at a client’s office, I sometimes create an Excel workbook that a user will enter data in every day. To make it easy to open the workbook, I add a shortcut to the user’s desktop (with their permission, of course). This makes it easy for the user to open the file, without trying to remember where it’s saved.

To quickly create a shortcut:

  1. Open Windows Explorer
  2. Select the folder that contains the Excel workbook
  3. Right-click on the Excel file
  4. In the popup menu, click Send To
  5. Click Desktop (create Shortcut)

    SendShortcut

  6. Close Windows Explorer.

A shortcut appears on the desktop, and you can move it to the spot where you want to store it.

To rename the shortcut

  1. Click on the shortcut to select it
  2. Press the F2 key on the keyboard, to select the name
  3. Type a new name and press Enter.

____________

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>