Microsoft Excel 2003
Class 1: Introduction and Beyond
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual with CD containing exercises, 144 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This is a comprehensive introduction to Excel. Students learn their way around the Excel Screen, learn how to create, edit, and format a worksheet, prepare a worksheet or workbook for printing, and how to calculate data using basic formulas. |
Understanding the Excel Interface
- Understanding Excel’s Interface
- Investigating the Default Bars at the Top of Your Screen
- Task Pane
- Workbook Components
- Worksheet Components
- Navigating in Excel
- Moving Around in Workbooks
- Moving Around in Worksheets
- Adding and Editing Data in a Workbook
- Managing Data in Cells
- Managing Cells
- Managing Rows and Columns
- Organizing Worksheets
- Saving and Managing Workbooks
- Moving and Copying Data
- Copy and Paste
- Cut and Paste
- Selecting Contiguous and Noncontiguous Ranges
- Using the Office Clipboard
- Using the Mouse to Drag and Drop or Fill Data
Formatting a Worksheet and Using Graphics
- Using the Format Cells Dialog Box
- Using the Formatting Toolbar
- Font Formatting
- Using the Different Cell Formats
- Cell Alignment
- Centering Text Across Selected Text
- Applying Cell Borders and Patterns
- Formatting Shortcuts
- Creating and Modifying Styles
- The Format Painter
- Formatting Worksheets
- Using AutoFormats
- Formatting Backgrounds
- Excel and Graphics
- Understanding the Drawing Toolbar
- Adding and Editing Graphics in a Worksheet
Editing Tools, Comments, and Hyperlinks
- Using Excel’s Editing Tools
- Using the Spelling Tool
- Using AutoCorrect
- Using Find And Replace
- Using Automated Features to Maintain Accuracy and Consistency
- Converting Text to Columns
- Comments and Hyperlinks
- Working with Comments
- Hyperlinks in Excel
Formulas Basics—Performing Calculations
- Parts of a Formula
- Using Arithmetic Operators
- Order of Operation
- Cell References versus Literal Values
- Understanding Relative Cell References
- Understanding Absolute Cell References
- Using the Sum Function
- AutoSum Button
- Using AutoFill
- Auto Calculate
- Using Other Summary Functions
- 3D (External) References
Sorting and Filtering List Data
- Sorting Data, Based on Single and Multiple Columns
- Using AutoFilters
Working with Views
- Working with Views
- Freezing Panes and Splitting Worksheets
- Using Multiple Windows to View and Edit Data
- Creating Workspaces
- Understanding Custom Views
Printing your Worksheet or Workbook
- Controlling Page Layout
- Orienting a Page and Repeating Rows and Columns
- Adding Headers and Footers
- Setting Margins
- Managing Page Breaks
- Printing
- Printing Selections
- Printing Multiple Copies and Specific Pages