TOIT Training

Excel Power Functions

Overview
Curriculum
  • 8 Sections
  • 48m Duration
Collapse All
Syntax, Criteria and Wildcards
DATEDIF
EDATE and EOMONTH
CONVERT
INDEX and MATCH
INDEX MATCH MATCH
OFFSET and COUNTA
SUMPRODUCT

Ask any Excel expert to name their favorite Excel functions, and you’ll receive a variety of suggestions. But with over 500 Excel functions to choose from, it’s guaranteed you’re missing out on some powerhouse functions that can make your work easier. This course explores ten functions that can increase your productivity and simplify your spreadsheets. 

While you probably know the basic functions, Excel expert and Microsoft trainer Barbara Evers will guide you through incorporating functions into your workbooks that will help you analyze your data and get better answers to your questions. Along the way, you’ll also learn some great tools such as using wildcards in functions, how and where to get help, and nesting functions. You’ll also learn the Evaluate Formula tool, which will help you explain or audit complex functions. 

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: