All UB Events

  • Switch to List View
  • Events RSS

Microsoft Excel Part III

October 13, 2012

Time: 9:00 AM - 1:00 PM
Contact Name: Achievement and Learning Center
Contact Phone: 410-837-5383
Contact E-mail: alc@ubalt.edu
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