Excel Level 2 - Formulas & Functions Intermediate (online)

For employees of Duke University and DUHS. Continuing Education Credits (CEUs): 0.2
Duration: 2 hours 15 minutes

NOTE - Formulas & Functions Intermediate skills are also covered in the day-long Excel Level 2 Intermediate course.

In this short workshop, create and use Named Ranges and 3D formulas and functions in Excel reports. Learn to incorporate 3D functions in advanced Text functions to extract and concatenate text data, and control their text case in reports. Learn to use Vlookup, IF and CountIf functions.

Prerequisite: Excel Level 1 - Formulas & Functions Basics, or Excel Level 1 Introduction, or equivalent knowledge.

Format: Online course via WebEx. Two days before the class, the instructor will contact participants by email and provide login instructions.