Excel, Level 3

This course presents advanced features of Microsoft's flagship spreadsheet program. Dynamic Data Exchange helps increase the ease of use for complex worksheets. A must for a well-rounded understanding of Excel.

Prerequisite: Excel, Level 2

Outline:

Review

Data Tables

• =VLOOKUP function
  
• Using the lookup
  
• How the =VLOOKUP works
  
• Multiple option lookups
  

  Advanced Financial Functions

• =PMT, payment
  
• =PV, present value
  
• =FV, future value
  
• =NPV, net present value
  

  Managing Multiple Worksheets

  Dynamic Data Exchange

• Creating formulae between worksheets
  
• Creating formulae between workbooks
  

Return to DGL homepage