Office Software - Excel Software - Microsoft Software - QuickBooks Software - Visual Software - Comptuer Software - Web Software - Sharepoint Software - Photoshop Software - Mac Software - QuarkXPress Software - management Software - Project Software - Learn Software - email Software - Network Software - Linux Software - Unix Software - Work Software - Net Software - ASP Software - PHP Software - HTML Software - CMS Software - XML Software - Mobile Software -
Advice Adobe Support Tutoring Technology Support Tutoring Computers Teaching Education Design Online CDs Notebook Lessons Help Certification Training Assistance Technology Teaching
Microsoft Excel 2002 |
| Product Description : Microsoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Virtual Training Company author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To get started, simply click on one of the movie topics below. |
Microsoft Excel 2002IntroductionAbout ExcelOpen/ Save/Close Workbooks What’s Inside the Workbook Menus and Toolbars What’s on a Worksheet Getting Assistance from Excel Getting StartedSelect and Navigate CellsEnter 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 WorksheetsResize Rows and ColumnsInsert 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 ChartsCreate Page Headers and FootersSee a Print Preview 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 |
