Loading...

Course Description

This intermediate Excel course moves into more advanced functionality to locate, calculate, summarize, and format data. Discover statistical formulas like SUMIFS DAVERAGE to better understand data and learn Excel techniques to work more efficiently. 

Course Outline

Participants will learn to use Excel to:

  • Group and format worksheets
  • Create and sort a static data consolidation by category \
  • Link workbooks and insert hyperlinks
  • Encrypt workbooks with a password
  • Use SUMIFS from the Math & Trig category
  • Use DAVERAGE 
  • Calculate NVP of a purchase 
  • Create DSUM formulas

 

 

 

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .