Excel Power Functions

Modules: 8
Seat Time: 48 minutes
Versions Available: Standard HD SCORM, reseller HTML
Teacher: Barbara Evers Learner: Christina Tankersley
Produced by: Bigger Brains

What You'll Learn

After this Excel Power Functions course you will be able to:

Locate the syntax of an Excel function and explain the basics of function syntax design.
Describe how Excel functions use True/False evaluations based on criteria.
Write an Excel function that uses wildcards.
Describe the syntax and write an Excel function using the following functions:

DATEDIF
EDATE
EOMONTH
CONVERT
INDEX + MATCH
OFFSET
COUNTA
SUMPRODUCT

Create nested functions using multiple Excel functions in one cell calculation.
Determine anniversary dates using EDATE, DATEDIF, and EOMONTH.
Convert units using the CONVERT function (e.g., miles to kilometers).
Find a value in a large array of data using the combination of INDEX and MATCH.
Debug or trace through an Excel formula using the “Evaluate Formula” feature or the Excel Formula Beautifier online tool.
Create a rolling average using the OFFSET function or OFFSET and MATCH.
Calculate totals and subtotals using SUMPRODUCT and describe how this can be used as an alternative to pivot tables.

Modules include:

01: Introduction (6:04)
02: DATEDIF (4:45)
03: EDATE and EOMONTH (7:34)
04: CONVERT (4:32)
05: INDEX and MATCH (6:31)
06: INDEX MATCH MATCH (5:48)
07: Rolling Averages (6:29)
08: SUMPRODUCT (6:12)

Pricing

This course is included in the Bigger-Brains online subscription for individuals or organizations, or can be purchased in SCORM format for use in your own LMS (Learning Management System)