Excel 2003 Tips & Shortcuts

Are you using the fastest methods to accomplish tasks in Excel 2003? Could you use some of Excel's advanced features to automate certain tasks? Would you like your spreadsheets to look more professional?

Course Outline

Are you using the fastest methods to accomplish tasks in Excel 2003? Could you use some of Excel's advanced features to automate certain tasks? Would you like your spreadsheets to look more professional?

Attend this course if you want to:

• Save time by using Excel's shortcut menus.

• Freeze a portion of your worksheet so that it remains visible as you scroll.

• Split the screen to display non-adjacent areas of your worksheet simultaneously.

• Name a cell or range of cells that you use often.

• Add a comment to a cell to make a note to yourself or other users.

• Collapse dialog boxes to easily display and select worksheet data.

• "Float" menu options and formatting palettes for quick access to common tools.

• Use the AutoCalculate functions to quickly sum, average, or count.

• View the formulas in a worksheet, rather than formula results.

• Quickly enter a series of data (e.g., days of the week, years, numbers).

• Find and replace specific data in a worksheet.

• Learn how to enter fractions in a cell, display cell contents on more than one line, and enter the current date or time.

• Automatically sum the data in a column, row, or table.

• Use hyperlinks to jump to another cell, file, or Web page.

• Use Smart Tag Actions to send a message to a recent Outlook mail recipient or to find stock quotes and company information.

• Change the default location in which Excel files are stored.

• Recover worksheet data after a crash.

• Save multiple workbooks in a workspace.

• Discover several "solutions templates" available from Microsoft.

This course can ALSO be taught one-on-one or as a private, dedicated virtual classroom - call 877-313-8881 for more information.

Additional Details

Pre-Requisites

Comfortable with basic Excel capabilities.

Certificates offered

Certificate of completion

Cancellation Policy

If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.

Map & Reviews

Elert & Associates Technology Training
[ View Provider's Profile ]

Reviews

 

   

Please note that I attended this course via Webinar so the facility rating is not applicable. Also not applicable is the Break Times rating since the course was only an hour and a half. I suggest you add an N/A column to your rating sheet.

Reviewed by Nina P. 2011