Waimea Community Education

Microsoft Excel 201 (Intermediate)

Building on the lessons learned in Excel 101, this class focuses more on learning some key functions and utilizing some of Excel’s powerful data management abilities. The ability to construct a basic formula is a Pre-Requisite for this class but it is strongly advised that all students be at least familiar with the topics outlined in Excel 101.

Topics to be covered are:

Ø Creating and working with Names

Ø Filtering & Sorting Data

Ø Validation & creating Drop Down Lists

Ø Protection and Security Features

Ø Customizing and creating Toolbars

Ø Linking data

Ø Essential Functions: IF, VLOOKUP & HLOOKUP, SUBTOTAL, some Data & Text functions

Category: Microsoft
Price: $95
Materials Fee:
Dates:10/21/2008 - 11/11/2008
Day:Tuesdays
Time: 06:00 PM - 08:00 PM
In-Class Time: 8 hours
Duration:4 weeks

Location: Parker School

Instructor and related courses:

SoHo (Small office/Home office) Networking
Microsoft Outlook - December class
Microsoft Excel 202 (More Intermediate)
Microsoft Word
Microsoft Outlook - September class
Microsoft Excel 101 (Beginning)
Rick Casey