Excel 97 Training

Excel 97 Module 1 (Core) Course Outline The Fundamentals      Starting Excel      Understanding the Excel Program Screen      Using Menus and Toolbars      Filling Out Dialog Boxes      Keystroke and Right Mouse Button Shortcuts      Opening and Saving a Workbook      Moving the Cell Pointer      Navigating a Worksheet      Entering Labels in a Worksheet      Entering Values in a Worksheet and Selecting a Cell Range      Calculating Value Totals with AutoSum      Entering Formulas      Using AutoFill      Previewing and Printing a Worksheet      Closing a Workbook and Exiting Excel Editing a Workbook      Entering Date Values and using AutoComplete      Editing, Clearing, and Replacing Cell Contents      Cutting, Copying, and Pasting Cells      Moving and Copying Cells with Drag and Drop      Working with Absolute and Relative Cell References      Using the Paste Special Command      Inserting and Deleting Cells, Rows, and Columns      Using Undo, Redo, and Repeat      Checking Your Spelling      Finding and Replacing Information      Advanced Printing Options      File Management      Inserting Cell Comments Getting Help from Excel      Getting Help from the Office Assistant      Getting Help by Contents      Getting Help with the Help Index      Finding Help Formatting a Worksheet      Formatting Fonts with the Formatting Toolbar      Formatting Values      Adjusting Row Height and Column Width      Changing Cell Alignment      Adding Borders      Applying Colors and Patterns      Using the Format Painter      Using AutoFormat      Creating a Custom Number Format      Creating, Applying, and Modifying a Style      Formatting Cells with Conditional Formatting      Merging Cells, Rotating Text, and using AutoFit Creating and Working with Charts      Creating a Chart      Moving and Resizing a Chart      Formatting and Editing Objects in a Chart      Changing a Chart's Source Data      Changing a Chart Type and Working with Pie Charts      Adding Titles, Gridlines, and a Data Table      Formatting a Data Series and Chart Axis      Annotating a Chart      Working with 3-D Charts      Selecting and Saving a Custom Chart      Using Fill Effects      Mapping Data      Modifying a Map Managing Your Workbooks      Switching Between Sheets in a Workbook      Inserting and Deleting Worksheets      Renaming and Moving Worksheets      Working with Several Workbooks and Windows      Splitting and Freezing a Window      Referencing External Data      Creating Headers, Footers, and Page Numbers      Specifying a Print Area and Controlling Page Breaks      Adjusting Page Margins and Orientation      Adding Print Titles and Gridlines      Changing the Paper Size and Print Scale      Protecting and Hiding a Worksheet      Viewing a Worksheet and Saving a Custom View      Working with Templates      Consolidating Worksheets