|
|||
Microsoft Excel 97Introduction to Excel Play Me First Getting Started Interface Save Simple Printing Close & Exit Get Help Office Assistant The Basics Selection Techniques Enter Data Edit & Delete Data Cut, Copy & Paste Drag & Drop Undo & Redo The Fill Handle AutoCorrect Spelling Find & Replace Worksheet Controls Navigate A Document Zoom Control Insert Cells Delete Cells Resize Rows & Columns Hide & Unhide Insert & Delete Worksheets Move & Copy Worksheets Views Splits & Panes Text & Number FormatsText FormatsAlign & Text Wrap Special Alignment Effects Borders & Shading Number Formats Date & Time Formats Custom Formats Format Painter AutoFormat Conditional Formats Styles Simple Calculations & FunctionsBasic FormulaeOperators Relative References Absolute References Sum Function The Function Wizard If, And, Or Nested Ifs Lookup V & H Lookup Trends Analyses & DatabasesGoal SeekOne-Input Tables Two-Input Tables Scenarios Scenario Summaries Pivot Tables Create A Database Sort Data Filter Data Advanced Filtering Set Criteria Database Functions Optimizing TechniquesCustom ListsPaste Special Name Cells & Ranges Linking Consolidation Automatic Subtotals Validation Outlining Protect Cells Print Preview Headers & Footers Print Areas Customizing Toolbars Create A VBA Macro Edit A Macro ChartsChart DataCreate a Chart Chart Palette Text & Data Labels Axes & Gridlines Chart & Plot Area The Legend Edit The Series Custom Charts GraphicsInsert A PictureResize & Reposition Create A Graphic Shapes , Fills, Borders & Effects Lines - Colors, Sizes & Arrows Select, Layer & Group Snap To & Flip Text In Drawings WordArt Organization Chart |