Table of Contents:

• Introduction


• Advanced Functions
  
  
  
  • Overview
  
  
  • Help with Functions
  
  
  • Logical Functions
  
  
  • Nested If Statements
  
  
  • Using "And" and "Or"
  
  
  • The COUNTIF Function
  
  
  • The SUMIF Function
  
  
  
  


• More Excel Functions
  
  
  
  • Overview
  
  
  • Financial Functions
  
  
  • Text Functions
  
  
  • Lookup Functions
  
  
  
  


• Conditional Formatting and Sparklines
  
  
  
  • Overview
  
  
  • Applying Conditional Formats
  
  
  • Managing Conditional Formats
  
  
  • Creating Sparklines
  
  
  • Modifying Styles
  
  
  
  


• Managing Data
  
  
  
  • Overview
  
  
  • Data Validation
  
  
  • Working with Tables
  
  
  • Sorting a List
  
  
  • Filtering Data
  
  
  
  


• Pivot Tables
  
  
  
  • Overview
  
  
  • What is a Pivot Table?
  
  
  • Create and "Pivot" the Data
  
  
  • Filtering Data
  
  
  • Sorting Data
  
  
  • Filtering with Slicers
  
  
  • Adding a Pivot Chart
  
  
  
  


• Analyzing Data
  
  
  
  • Overview
  
  
  • Auditing and Error Checking
  
  
  • Using the Scenario Manager
  
  
  • Using Goal Seek
  
  
  
  


• Importing and Exporting Data
  
  
  
  • Overview
  
  
  • Word/Excel Transfer
  
  
  • Importing Text Files
  
  
  • Excel/Access Transfer
  
  
  
  


• Conclusion