This advanced Excel course continues on where the beginning Excel course left off. Further expand your knowledge and gain a full understanding of how to use this powerful computing tool. This course will teach you how to create complex formulas, pivot tables and simple macros.
Course highlights include:
- Analyze data using automated tools
- Learn how to format worksheets, graphs and charts
- Create PivotTables and PivotChart reports
- Understand how to properly use filters
- Find and correct Errors
- Learning formulas and functions
- Combine data from multiple sources
- Automate repetitive tasks using macros
- Track and manage changes
- Define, modify and use named ranges
- Collaborate with colleagues, share workbooks
Notes: Beginning Excel (CC205) or equivalent knowledge base is required as a prerequisite for this class. The textbook and certificate of completion are included with the course fee.
Please note that this course covers the additional material needed to pass the Microsoft Excel Expert certification test. As a means to provide certification, a Microsoft test voucher can be purchased at a cost of $85.
Course Time: 12 Hrs., CEU's: 1.2
Course |
Dates |
Day/Time |
Cost |
|
CC206 |
4/14/08 to 5/5/08 |
Mon, 4:30-7:30 p.m. |
$120 |
View all courses 
