|
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.
|