Course Description:

MS Excel

Introduction to Excel
This class is for those already familiar with Windows and who are just starting with Excel. You do not have to spend hundreds of dollars or take days out of the office to get top-quality Excel training. You will learn everything about Excel and its powerful electronic spreadsheets. This class guides you through all common commands to create, revise, format, and print different worksheets. 

Intermediate Excel
Enhance your spreadsheet knowledge now. Students will gain a better understanding of how to use complex formulas and functions critical to development of advanced spreadsheets. Learn how to customize screen displays, toolbars, Excel defaults, protecting worksheets, and file maintenance. Experience the power of macros for automating tasks. Create and modify charts. 

Advanced Excel Database and Analysis Tools
Master the concept of databases, manipulating data and sorting of data using a variety of criteria. Apply filtering techniques to control data output. Learn to subtotal, contract and expand database displays. Acquire complex calculation and analysis tools. Define array formulas and array constants. Create and edit simple arrays.