TUTURIAL excel 2003

Excel Basics

• 1: Identifying basic parts of the Excel window
• 2: Create, open and save workbooks
• 3: Enter, edit and delete data
• 4: Moving, Copying and Deleting Cell Contents
• 5: Creating Simple Formulas
• 6: Creating Complex Formulas
• 7: Using functions

Worksheet Layout and Management

• 8: Working with multiple worksheets
• 9: Inserting and Deleting Rows and Columns
• 10: Changing Column Width and Row Height
• 11: Inserting and Deleting Cells
• 12: Text and Cell Alignments
• 13: Formatting Numbers
• 14: Applying Font, Color and Borders to Cells

Charting, Printing and Page Setup

• 15: Creating a Chart
• 16: Moving, Resizing, and Deleting Charts
• 17: Editing Charts
• 18: Formatting a Chart
• 19: Defining Page Setup Options
• 20: Print Management

Advanced Excel Topics

• 21: Using AutoFilter
• 22: Sorting Lists
• 23: Inserting, Viewing, and Editing Comments
• 24: Inserting Hyperlinks
• 25: Grouping Worksheets
• 26: Applying and Modifying Cell Formats
• 27: Creating New Workbooks from Templates