Microsoft Excel Expert Topics
Course Outline

CREATING POWERFUL DATABASES 
    Creating A Database 
        How To Create A Database Field 
        How To Add Records Manually 
        How To Add A New Record Using A Built-In Data Form 
    Managing Record In A Database 
        How To Search For A Record Using Data Form 
        How To Edit / Delete A Record Using A Data Form 
        How To Create A List 
        How To Find A Total In A List 
        How To Switch Functions In A List 
        How To Convert A List To A Range 
    Sorting Records 
        How To Perform A Simple Sort 
        How To Perform A Multiple Sort 
        How To Set Advanced Sort Options 
    Using The AutoFilter 
        How To Enable / Disable The AutoFilter 
        How To Apply / Remove The Criteria 
        How To Customize The Criteria 
        How To Use A Wildcard Symbol In The Filter Criteria 
    Using The Advanced Filter 
        How To Define The Criteria Range 
        How To Use The Advanced Filter Command 
    Using Simple Database Functions 
        How To Find The Sum Of Specific Records Using Insert Function Button 
        How To Find The Average Of Specific Records 
        How To Find The Maximum / Minimum Value Of Specific Records 
        How To Find The Number Of Records 
    Using The VLOOKUP Function 
        How To Use VLOOKUP To Find Data 
        How To Limit The Lookup Value For An Exact Match 
        How To Use The Closest Match For The Lookup Value
CREATING A PIVOTTABLE AND ANALYZING DATA 
    Creating A PivotTable 
        How To Create A PivotTable 
        How To Create A PivotTable From An Access Database 
    Updating A PivotTable 
        How To Update Information In A PivotTable 
        How To Add An Information Field To A PivotTable 
        How To Arrange Information In A PivotTable 
        How To Remove Information From A PivotTable 
        How To Create A Page In A PivotTable 
        How To Display Pages On Separate Sheets 
    Modifying A Calculated Field In A PivotTable 
        How To Change A Function For A Calculated Field 
        How To Insert A Calculated Field 
        How To Hide A Calculated Field 
        How To Delete Calculated Fields 
    Creating A Chart From A PivotTable 
        How To Create A Chart From A PivotTable 
    Exploring What-If Tables 
        How To Create A One Variable What-If Table 
        How To Create A Two-Variable What-If Table 
    Using Scenarios 
        How To Create Scenarios 
        How To Apply A Scenario 
        How To Edit Scenario 
        How To Delete A Scenario 
    Implementing Problem Solving 
        How To Use The Goal Seek Tool 
        How To Load Add-Ins 
        How To Use The Solver Tools
AUTOMATING ROUTINE TASKS WITH MACROS 
    Understanding Macros 
        How To Record A New Macro 
        How To Run A Macro From The Menu 
        How To Create A Run Macro Button On A Toolbar 
        How To Create A Macro Command Button On A Worksheet 
        How To Edit A Command Button 
    Editing A Macro 
        How To Edit Macro Coding 
        How To Rename A Macro 
        How To Delete A Macro 
    Using A Relative Reference Macro 
        How To Record A Relative Reference Macro 
        How To Run A Relative Reference Macro
INTEGRATING DATA WITH OTHER APPLICATIONS 
    Importing / Exporting Data 
        How To Use The Text Import Wizard 
        How To Export Data To Another File Type 
        How To Copy Data From Other Applications 
        How To Insert Objects 
        How To Export Data To An Excel Workbook From Another Application 
    Retrieving Data From A Database 
        How To Get Specific Information Using A Database Query 
        How To Edit A Database Query
WORKING WITH THE WEB 
    Creating Web Pages 
        How To Create A Web Page In Excel 
        How To Create An Interactive Web Page 
        How To Preview A Web Page 
        How To Publish A Web Page 
        How To Add A New FTP Site 
        How To Access Files In An FTP Site 
    Editing The Web Pages 
        How To Open And Edit A Workbook Web Page 
        How To Create A Hyperlink 
        How To Delete A Hyperlink