|
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.
MS Excel 2007
Excel Level 1
Explore program applications and
features of Excel 2007. Learn to navigate, edit and view while creating and
applying functions and formulas, formatting cells and changing the appearance of
spreadsheets. This fundamental course provides users with a strong foundation to
operate the Excel application.
Excel Level 2
Develop and maintain Excel charts, multiple work sheets and workbooks. Insert
graphics, utilize templates and protect information in Excel 2007. Excel Level 2
builds on basic operations, enhancing them to new levels of creativity and
professional process.
Excel Level 3
Apply skills while acquiring
knowledge of advanced features designed to further enhance the functionality of
organized data. Learn how to create tables, pivot tables and macros, financial
functions, data auditing, and utilize advanced formatting and analysis tools.
| 
COMPUTER
SAVVY, INC.