|
|||
Microsoft Excel 2002Introduction About Excel Open/ Save/Close Workbooks What's Inside the Workbook Menus and Toolbars What's on a Worksheet Getting Assistance from Excel Getting Started Select and Navigate Cells Enter Data Edit and Delete Data Undo and Redo Cut/Copy/Paste About the Office Clipboard Drag and Drop AutoFill More Ways to Enter Repetitive Data AutoCorrect Use a Data Entry Form Validate Data During Entry Working With Worksheets Resize Rows and Columns Insert and Delete Rows/Columns/Cells Rename Worksheets Move and Copy Worksheets Insert and Delete Worksheets Freeze and Split a Worksheet Open Multiple Windows Simple CalculationsCalculate Without a FormulaUse AutoSum to Write Formulas Formula Structure Create Formulas Edit Formulas AutoFill Formulas Relative and Absolute References Functions Use the Function Wizard Name Cells and Ranges Use Names in Formulas Using Advanced FunctionsAVERAGE/MAX/MINSUMIF and COUNTIF VLOOKUP PMT NOW/ TODAY/CONCATENATE IF and Nested Functions Organizing DataSort DataFilter Data with AutoFilter AND and OR Filters Calculate Filtered Records PivotTables Consolidate Data Subtotal a Worksheet Formatting CellsText FormattingAlign and Wrap Text Number Formats Date and Time Formats Custom Formats Borders and Shading Conditional Formatting Format Painter Styles AutoFormat a Table Transpose Tables and Merge Cells Format Several Worksheets Identically Save a File as a Template Charting DataAbout ChartsCreate a Chart Resize and Relocate a Chart The Chart Toolbar Chart Options Legends/Titles/Axes Series Orientation and Order Create 3-D Charts Explode a Pie Chart Add Data Labels and a Data Table Trendlines Secondary Axes Format Chart Elements Printing Data and ChartsSee a Print PreviewCreate Page Headers and Footers Set the Print Area Print a Selection Centering/ Margins/Gridlines Print on a Specific Number of Pages Print Multiple Worksheets/Copy/Collate Pages Print Row and Column Labels on Every Page Print Charts Sharing and Protecting DataShare Data Between WorkbooksCopying/Linking/Embedding Data Share Data with Other Programs Share a Workbook with Other Users Hide Worksheets Protect Cells Protect Worksheets and Workbooks Analyzing DataUse Goal Seek to Find AnswersUse Scenarios to Compare Alternatives Locate Worksheet Errors and Invalid Data Customizing ExcelCustomize Your ToolbarsCreate a Custom Toolbar Automate with Macros Record a Macro Edit a Macro Assign a Macro to a Toolbar Button Create a Hyperlink to Open Another File Graphics and The Drawing ToolbarInsert a PictureMove/Resize/Crop Draw Shapes and Lines Draw AutoShapes and Assign Macros Arrange and Group Drawing Objects Use Drawn Objects in Charts Create Text Boxes Create Worksheet Comments |