CCOG for CEU 3917 Fall 2025
- Course Number:
- CEU 3917
- Course Title:
- Microsoft Excel Power Calculations
- Credit Hours:
- 0.3-4
- Lecture Hours:
- 0
- Lecture/Lab Hours:
- 0
- Lab Hours:
- 0
Course Description
Utilize the function palette, defining advanced functions such as vlookup, payment, net workdays, taking advantage of cell and range names, how to use conditional formatting and Sparklines, how to protect data and save a chart as a template.
Intended Outcomes for the course
Understand how to find and use advanced functions
Streamline formulas using cell and range names
Use conditional formatting and Sparklines in addition to charts to create dynamic visual
displays of data
Protect formulas and general cell data from editing
Use special tools such as cell comments, custom views, scenartios, goal seek and track
changes