Spreadsheets
Microsoft Excel
| Course Title: |
Excel Introduction  |
Outline  |
| Description: |
Learn to create, edit, save, and print spreadsheets. Learn keyboard and mouse techniques in Excel, how to use the toolbars, formula fundamentals, entering text and numeric information, formatting cells, borders and shading, worksheet editing, introduction to functions, and an introduction to charts. |
| Audience: |
Designed for individuals with little or no prior experience with Excel. |
| Prerequisite: |
Windows Introduction. |
| Course Title: |
Excel Level II |
Outline |
| Description: |
Learn a variety of functions and formulas to increase your effectiveness in Excel. Create customized reports using filter, data form, and multi-sheet referencing. |
| Audience: |
Designed for individuals familiar with the basics of Excel. |
| Prerequisite: |
Excel Introduction. |
| Course Title: |
Excel Level III |
Outline |
| Description: |
Analyze data and create "What-if" and "Best Case/Worst Case" reports by using the Solver, Goal Seek. OLE, pivot tables, and the Scenario Manager. Record macros to streamline your work and make your spreadsheets more interactive. |
| Audience: |
Designed for experienced users of Microsoft Excel. |
| Prerequisite: |
Microsoft Excel Level II. |
| Course Title: |
Excel Macros |
Outline |
| Description: |
This class will help you automate and improve spreadsheets in Microsoft Excel with VBA. Learn how to write macros to populate cells, respond to user events, and automate spreadsheets. |
| Audience: |
Designed for individuals that want to create macros in Microsoft Excel. |
| Prerequisite: |
Microsoft Excel Level II. |
Quattro Pro
| Course Title: |
Quattro Pro Introduction
|
Contact NWCLC |
| Description: |
An introduction to spreadsheets with Quattro Pro. Topics include: creating worksheets, entering text, date and numeric values, formatting, building formulas, using menus and the Speed Bar, building graphs, as well as saving and printing worksheets. |
| Audience: |
Designed for new users of Quattro Pro. |
| Prerequisite: |
Windows Introduction. |
| Course Title: |
Quattro Pro Level II |
Contact NWCLC |
| Description: |
Learn a variety of functions and formulas to increase your effectiveness with Quattro Pro. Create customized reports using filters, sub-totals and multi-sheet referencing. |
| Audience: |
Designed for individuals with some experience with Quattro Pro. |
| Prerequisite: |
Quattro Pro Introduction. |
Back to Course Categories
