Email a Friend
Print
Add to Outlook
Event Information
Date
2/17/2009 - 2/19/2009
Time
6:00 PM - 8:30 PM
Venue
Carmichael Hall
Cost
85
Audience
General Audience
Additional Information
Exploit the strengths of Excel by using even more advanced formulas and functions to evaluate and analyze numerical data and text. This course is intended for individuals who are experienced with using basic Excel formulas. Topics for this course include: Master Intermediate Techniques using Formulas and Functions and Automating Tasks in Excel.
Master Intermediate Techniques using Formulas and Functions
· Manipulating text
· Working with Dates and Times
· Counting and Summing techniques
· Running Totals
· Financial formulas
· Create mega-formulas form Simple formulas
· Explore R1C1 referencing system
Automating Tasks in Excel
· Plan and Create a Macro
· Run a Macro
· Edit VBA Code in a Macro
· Customize Toolbars in Excel
· Assign Shortcuts to Macros
· Use Personal Macro Workbook
