TOIT Training

Excel Power Functions

Excel Power Functions
  • Overview
  • Curriculum
  • Reviews

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. 

  • 8 Sections
  • 48m Duration
Expand All

Syntax, Criteria and Wildcards

DATEDIF

EDATE and EOMONTH

CONVERT

INDEX and MATCH

INDEX MATCH MATCH

OFFSET and COUNTA

SUMPRODUCT

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Explaining the basics of function syntax design 
  • Using wildcards in an Excel formula 
  • Nesting functions 
  • Creating formulas with nested functions 
  • Debugging and evaluating functions 
  • Describing the syntax and writing Excel formulas for top 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:

Buy for group

Excel Power Functions
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)