MS Excel
Excel - Intermediate & Advanced Topics
Submitted by AndyWhere: CPCD
When:
02/14/2012 - 1:00pm - 3:00pm
We'll be focusing on functionality that will save you time and headaches in this 2-hour course.
The topics:
- Pivot Tables - Quickly summarize, slice, dice, and simplify huge amounts of data
- V-Lookup - Match fields in different tables to connect information
- Filters - Collapse your data to view items that only meet certain criteria
- Macros - Record a series of keystrokes so that you don't have to constantly repeat yourself
- Graphs/Charts - We'll have time to cover many of the most popular styles
Excel - Formulas and Functions
Submitted by AndyWhere: CPCD
When:
01/19/2012 - 1:00pm - 3:00pm
Learn how to harness the power of Excel in this 2-hour course. This class will be hands-on with real office examples of how to use many formulas and functions. The first portion of the course will be spent on basic formula creation. After learning the fundamentals, we'll move on to more complex formulas and functions.
Formulas and functions will include:
- Add, Subtract, Multiply and Divide
- Auto Sum
- Minimum and Maximum
- Average
- Count
- If
- Exact
- Proper
- Concatenate and more!
