The purpose of the Microsoft Excel: Working with Large Datasets Course is to provide participants with an overview of the various formulas and functions that Microsoft Excel offers to manage data and get to the desired outcome efficiently. Participants must bring a laptop or other device to the class so they can actively engage in the exercises.

Program Level: Basic

Prerequisites: None

Advanced Preparation: N/A

Instructional Method: Group-Live

Instructor: Ryan Day

Recommended CPE Credit: 2.0 Hours

Field of Study: Computer Software and Applications

Course Objectives:

At the end of the course, participants will be able to:

  • Execute Microsoft Excel functions such as VLOOKUP, COUNT, IF, SUM, AVERAGE, and CONCATENATE;
  • Create pivot tables for organizing data;
  • Utilize cell formatting and data filters; and,
  • Perform data reviews.

Program Policies

NASBA Statement:

The University of Colorado is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.