Excel Level 2 - Excel Formulas & Functions Intermediate (online)

For employees of Duke University and Duke University Health System.
NOTE - Formulas & Functions Intermediate skills are also covered in the day-long Excel 2016 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.