Microsoft Excel Part III

February 2, 2013

Time: 1:30 PM - 5:30 PM
Contact Name: Achievement and Learning Center
Contact Phone: 410-837-5383
Contact E-mail: alc@ubalt.edu
Related URL: http://www.ubalt.edu/academics/academic-support/achievement-and-learning-center/index.cfm

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 II or equivalent knowledge of Excel