Microsoft Excel Part III
December 7, 2012
Time: 1:30 PM - 5:30 PM
Contact Name: Achievement and Learning Center
Contact Phone: 410-837-5383
Contact E-mail: firstname.lastname@example.org
Related URL: www.ubalt.edu/alc
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.
Specific Topics: Filtering data; creating named ranges and constants; advanced chart design (dual-axis, area charts, editing labels, and adding trend lines); conditional formatting; functions (textual, date, lookup); removing duplicates in data; protecting workbooks with passwords; creating basic macros.
Prerequisites: completion of Excel Part II
or equivalent knowledge of Excel