Microsoft Excel 2000 Advanced Course Outline


What Microsoft Excel 2000 Advanced Covers...

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
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 Pivot Table 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