All UB Events

  • Switch to List View
  • Go to July 2014
  • Events RSS

Excel 3

October 26, 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/alc

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).