MS Excel

Excel - Intermediate & Advanced Topics

Where: 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

Where: 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!
Syndicate content