Using Formulas in Excel:
• Relative and Absolute Cell References 
• Basic Mathematical Operators 
• Formulas and Multiple Cell References 
• The Formula Auditing Bar 
• Fixing Formula Errors 
• Displaying And Printing Formulas 

Using Functions in Excel:
• Inserting Functions 
• Using Functions And Autofill To Perform Difficult Calculations 
• The IF Function 
• Working With Nested Functions 

Working with Names and Ranges:
• Defining And Using Range Names 
• Selecting Nonadjacent Ranges 
• Auto Calculate? 

Working with Array Formulas:
• Basic Array Formulas 
• Using Functions With Array Formulas 
• Using The IF Function In Array Formulas 

Working with Lists:
• Creating Lists 
• Modifying Lists 
• What Is The Total Row?

  Table and Chart Practice:
• Table and Chart Basics 

Working with Records and Fields:
• Adding Fields By Inserting Columns 
• Adding Records By Inserting Rows 
• Adding Records With A Data Form 
• Finding And Deleting Records 

Working with Lists and Filters:
• Sorting A List 
• What Is An Autofilter 
• Custom Autofilters 
• Using An Advanced Filter 
• Copying Filtered Records 

Using Excel in Word:
• Inserting Excel Data In Word 
• Modifying Excel Data After Insertion 
• Linking Excel Data In Word 
• Linking An Excel Chart In Word 

Using Excel with Other Programs and Files:
• Using Outlook To Send Excel Data 
• Opening An Excel File In A Different Format 
• Importing Data From A Text File 
• Importing Data From A Database