Excel 2003

Tips, Tools, and Timesavers

 

Course Length

Three hours

 

Prerequisites

Excel 2003 Introduction or equivalent experience

 

Course Description

This course highlights many hidden features for editing, formatting, printing, customizing, and working with Excel 2003. The tips and shortcuts included will give a “back door” approach to accomplishing tasks quickly and efficiently.

 

Course Topics

  • Create multiple lines in a cell

  • Enter telephone numbers, social security numbers, and zip codes

  • Use a screen tip to display cell contents

  • Fill cell(s) the width of a column

  • Fill nonadjacent cells with the same entry

  • Use the pick list to enter text in a cell

  • Extend list formatting

  • Reverse the AutoFill action

  • Automatically fill down a column

  • Quickly select a large range

  • Specify where to move the cell pointer after enter

  • Print all worksheets with consecutive page numbers

  • Select adjacent and nonadjacent sheets

  • Select the same range on several sheets

  • Select cells with special criteria

  • Toggle between displaying values and formulas

  • Move data without replacing

  • Transpose rows and columns

  • AutoFit multiple columns or rows

  • Copy formats multiple times

  • Add a double underline

  • Rotate cell contents

  • Specify conditional formatting

  • Keep a watch on important cells

  • Calculate a grand total using the AutoSum button

  • Change the AutoCalculate function

  • Search for a function

  • Enter a natural language formula

  • View the range finder

  • Jump to or select to the last filled cell

  • Use data validation

  • Add a picture to the bars of a column chart

  • Drag and drop cells between sheets in the same workbook

  • Zoom selected cells

  • Protect part of a worksheet

  • Close all open workbooks without exiting excel

  • Open multiple workbooks simultaneously

  • Save multiple files in a workspace

  • Print selected cells

  • Print a group of sheets

  • Change default font and file location

 

What Participants Receive

Each participant receives a guide containing step-by-step instructions, practice exercises, and a laminated reference card.

 

 

 

 

[Home   |     Services   |   Courses   |   Instructors  |  References  |  Contact Us]