Excel Windows 5: Database & Analysis Tools

Course Code: EXCW5-3 Time: 7 hours

Prerequisites: Excel Windows 5: Intermediate

Databases and Lists What is a Database External Database File Excel Data List Data Forms Entering Data Form Data Locating Data with the Data Form Comparison Operators Sorting a List Push Button Sorting Default Sort Assumptions Custom Sort Orders Filtering a List What is a Filter? AutoFilter Using Advanced Filter Some Definitions Subtotals Setting Up Tables to be Subtotaled Outline Controls Outlines Auto Outline Manual Outlines Database Functions A Few Definitions DSUM() DGET() DCOUNT() DCOUNTA()

Analysis Tools Add-Ins Data Tables Some Definitions One Input Data Tables Two Input Data Tables PivotTables Some Definitions Auditing Workbooks Some Definitions Go To Special Auditing Tools The Auditing Toolbar Goal Seek Solver Array Formulas Some Definitions Working with Array Constants Scenarios Views and Reports The Scenario Manager The View Manager Reports The Goody Box AutoSum Stuff Fill Handle Stuff Right-Click Stuff

Return to Course Listing | Home Page