Goal: Take your Excel knowledge to the next level. Understand how to manage large spreadsheets, analyze data with advanced charts and conditional formatting, utilize functions, manage and protect workbooks and create simple macros.
Topics: filtering data; creating named ranges and constants; learning advanced chart design (dual-axis, area charts, editing labels, and adding trend lines); using conditional formatting; functions (textual, date, lookup); removing duplicates in data; protecting workbooks with passwords; and creating basic macros.
Prerequisites: completion of Excel Part 2 or equivalent knowledge of Excel
To Register: Check with the ALC for Workshop space availability, then submit the Workshop Registration Form with the course fee ($10 UB students, $30 UB staff and alumni, $45 general public) to the ALC by fax (410.837.6244), mail (University of Baltimore, Achievement and Learning Center, AC 113, 1420 N. Charles St., Baltimore, MD 21201), or in person (AC 113).
- Contact Name:
- Achievement and Learning Center
- Contact Email:
- Contact Phone:
Appropriate accommodations for individuals with disabilities will be provided upon request 10 days prior to a campus event and 30 days prior to an event requiring travel.