Course Outline:
- Spreadsheet Concepts
- The Excel Window & Task Pane
- Working With Menus & Commands
- Getting Help
- Working With Cell Ranges
- Worksheet Navigation & Data Entry
- Editing & Deleting Data
- Using AutoFill & Creating Custom Lists
- Creating, Saving & Opening Workbooks
- Understanding & Using SmartTags
- Inserting & Deleting Rows & Columns
- Column Widths & Row Heights
- Working With Fonts, Lines & Shading
- Changing Number & Date Formats
- Format Painter & AutoFormat
- Cut, Copy & Paste Techniques
- Creating Simple Calculations
- Moving & Copying Formulae
- Using AutoSum
- Statistical Functions
- Using the Insert Function feature
- Relative & Absolute Cell References
- Changing Page Setup
- Headers & Footers
- Print Preview & Printing Options
At the end of the course the user will be conversant with all the fundamental functions of Excel and will be capable of producing a variety of Worksheets.
|