Excel 2000 Advanced

Excel 2000 Advanced

Lesson 1: Working With Records And Filters, Opening Excel, Bringing Data From A Web Page Into Excel, Hiding Toolbars, Increasing Your Field Of View, The Sort Dialog Box, "Then by" Sorting, Using AutoFilter, Using Custom AutoFilter, Using The Data Form Dialog Box, Verifying A Record, Change A Record, Deleting A Record, Disabling AutoFilter, Removing Filters, Advanced Filter

Lesson 2: Protection Options And Scenarios, Adding Field Labels, Saving Your Workbook As A Template, Save A Template As A Workbook, Locking And Unlocking Cells, Hiding Proprietary Formulas, Protecting A Worksheet, Protecting A Worksheet, Protecting Cells, Unprotecting A Worksheet, Hiding Cell Contents, Display Hidden Contents, Password Protecting A Sheet, Removing Password Protection, The Scenario Manager, Creating Scenarios, Displaying Finished Scenarios, Creating A Summary Report, Opening A Text File, The Text Import Wizard Dialog Box, Using AutoFit

Lesson 3: Advanced Data Analysis Functions, Introduction, Auditing A Worksheet, Trace Precedents In Auditing A Worksheet, Trace Dependents In Auditing A Worksheet, Finding Spreadsheet Errors, Finding Formulas That Refer To A Specific Cell, Finding Cell References, Working With Conditional Formatting, Using Data Validation, Checking And Reviewing Data, Advanced Filter, AutoFilter, Custom AutoFilter, Removing Filters, Using Multi Level Sorts, Creating A PivotTable Report, Modifying A Pivot Table Report, Making A PivotTable Report Available On The Web, Creating A Data MapRunning A Web Query, Extracting Data, Querying A Spreadsheet

Lesson 4: Workgroup Functions, Opening An Existing File, Sharing Your Workbook, Mail A Workbook As An Attachment, Mail A Worksheet As The Body Of The Message, Routing Workbooks, Tracking Changes, Highlight Changes As You Work, Creating A Personal History Worksheet, Multiple User History Worksheet, History Of Changes For A Particular Range Of Cells, solving Conflicts, Prepare Multiple Copies Of Workbook To Merge, Merge All Copies Of The Same Workbook, Removing Comment Indicators, Remove A Workbook From Shared Use, Password Protecting A Workbook, Limit Viewing And Editing The Contents Of Sheet, Protect And Share A Workbook, Personal View & Print Settings Of Shared Workbook, Remove The Protection From A Shared Workbook, Removing Password Protection

Lesson 5: Business Problem Solving, Opening An Existing Document, Data Tables, One-Variable Data Tables, Adding A Formula To A One-Variable Data Table, Specifying Input Cells, Identifying A Reference Cell, Two-Variable Data Tables, Adding Formulas To A Two-Variable Table, Specifying The Column And Row Input Cell Boxes, Business Analysis Scenarios, Creating a Business Analysis Summary Report, Creating A PivotTable Report, Business Analysis PivotTable Report, Working With a Business Analysis PivotTable Chart Goal Seek, Entering Formula References In the Set Cell Box, Entering a Target Result in the To Value Text Box, Setting Up The "By Changing Cell" Box, Entering Formula References In the Set Cell Box, Entering Target Result in the To Value Cell Box, Setting Up The "By Changing Cell" Box, Installing Solver Add-In, Setting the Solver Target Cell Box, Limiting The Target Cell To A Specific Value, Using Guess Function For Adjustable Cells, Adding Constraints To Limit The Cell Value, Entering A Constraint Value, Creating A Report Using Solver, Viewing A solution, Forecast Function, Defining Excel Forecast Function, Analyzing Sales Trend