Skip to Main Content

Data Management: 4 Analytics

Data Management sessions presented to cover strategies for using Microsoft Excel.


Thu Nov. 14  Be sure to upload the exercise files below to use during class session.

Lesson 4:  Data Analytics.  (1.75 hours)  (Formulas & Functions)

  Make the most of numerical data with formulas and functions.  This lesson covers formula basics and references, building functions with a focus on the IF and VLOOKUP functions.  Topics covered include Cell reference, Simple vs advanced formulas, Copy, Validate, Wizard, Logical operators, and Advanced functions.


Webinar Link:



Live Webinar classes will be held on Monday and Thursdays from 1-3pm.  Instruction will take about an hour followed by a review and questions session.(2pm-3pm as needed)

Carpenter Library | Atrium Health/Wake Forest University School of Medicine | Contact Us