Skip navigation

Office of the Registrar

Course Info

CPDDU-0034 – Excel II: Advanced Calculations and Managing Data (CPDDU-0034_80824)

Excel II: Advanced Calculations and Managing Data

Take the next step on your calculated journey to Excel mastery! This mid-level workshop, taught by Microsoft Certificated software trainer Debbie Dalrymple, will explore customization, advanced formulas and calculations, specialty formatting, and data management with charts and tables. Level II is perfect for professionals who feel comfortable using Excel formulas and functions, but want more advanced knowledge for data management. Complete all three Excel workshops to increase your proficiency with this essential tool.

Required: Microsoft Office Excel 2016 loaded on your laptop.

Learning Outcomes
Upon completing this course, students will be able to:
  • Customize the Excel environment.
  • Create advanced formulas.
  • Analyze data by using functions and conditional formatting.
  • Organize and analyze datasets and tables.
  • Visualize data by using basic charts.
  • Analyze data by using PivotTables, Slicers, and PivotCharts.
This course offers 6 CE hours

Three sessions
Tuesdays, October 1, 8, and 15, 2019
6:00 PM – 8:00 PM
DU Campus

Cost: $225
Discounts (use code when registering):
DU Affiliates (alumni, faculty, staff): 10% off - code: CPDUCOL10
Students: 15% off - code: CPDUCOL15

Instructor:
Debbie Dalrymple
is Microsoft certified in both network engineering as well as Excel and Word, and began her career in computer training in 1992. Starting her training career at Computer Learning Center in Washington DC working with DOS and early Windows applications, she has transitioned to the latest Windows software that we know today. Throughout the past two and a half decades Debbie has been training students and providing technical support and consulting services in a variety of industries such as architecture, law, federal government, pharmaceutical and the oil Industry as well as extensive non-profit work. In her free time, she uses Excel to track and analyze various other areas of her life, including vegetables grown on her urban farm and miles ridden on her bike.
Course Details
Location: University ParkMode of Study: In-personPlaces Left: 30Waitlist Places Left: 10Fee: $225

Sessions

Days of the WeekStart DateEnd DateTimeVenueInstructor
Tuesday1st October 201915th October 201906:00PM - 08:00PMN/AN/A