CCOG for CEU 3203 archive revision 201604
You are viewing an old version of the CCOG. View current version »
- Effective Term:
- Fall 2016 through Fall 2024
- Course Number:
- CEU 3203
- Course Title:
- Advanced Excel
- Credit Hours:
- 0.8
- Lecture Hours:
- 0
- Lecture/Lab Hours:
- 0
- Lab Hours:
- 0
Course Description
Learn to customize the ribbon; name cells and cell ranges to use in formulas/functions; link workbooks and save workspace; explore data validation options - rules, drop-down lists, etc.; set up advanced filters and discuss ways to use; analyze data with special tools - Scenario Manager, Goal Seek, etc.; make PivotTables and PivotCharts; create simple macros and discuss file types; protect workbook and set password; create and use templates.
Intended Outcomes for the course
.