Portland Community College | Portland, Oregon Portland Community College

CCOG for CEU 3203 Spring 2024

View archive version »
Course Number:
CEU 3203
Course Title:
Advanced Excel
Credit Hours:
Lecture Hours:
Lecture/Lab Hours:
Lab Hours:

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