Course
Schedule
ACT
ASP
ASP_NET
Access DB
Acrobat
ActiveDir
Apache Server
C# Prog.
C++ Prog.
CSS (HTML)
Cisco Routers
Cisco Week
ColdFusion
Crystal Reports
DHTML
DP Design
DigCameras
Dreamweaver
Excel
Exchange
FileMaker
Fireworks
Flash
FrontPage
HTML
IIS Web Server
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Macromedia
Networks
ObjectOProg.
Oracle
Outlook
PHP
PageMaker
Perl
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Optimize
SQL Server
Scanners
Security
TCP/IP
UNIX
VB.Net
Visio
Visual Basic
W2003 Policy
W2003 Server
Win XP Admin.
Win XP Intro.
Wireless Net.
Word
XML
|
Excel |
| ||
 | |||
|
Introduction to Excel (Prerequisite: Introduction to Windows or equivalent experience.) Use Excel to create spreadsheets for use in accounting, budgeting, expense tracking, and other applications. Learn to set up and format worksheets and enter labels, values, and formulas. Other topics include using built-in Excel functions, editing and deleting data, moving and copying cell contents, setting up worksheet pages, printing, and understanding absolute and relative references. Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6201 | Mon., Aug. 1 | West County | Dawn Robinson |
| F6268 | Tues., Aug. 16 | UM-St. Louis | Erin Delanty |
| F6287 | Wed., Aug. 31 | West County | Dick Koerper |
| F6358 | Fri., Sept. 23 | West County | Erin Delanty |
| F6400 | Thurs., Oct. 6 | West County | Dawn Robinson |
| F6459 | Wed., Oct. 19 | West County | Dawn Robinson |
| F6449 | Mon., Oct. 31 | West County | Erin Delanty |
| F6543 | Wed., Nov. 16 | UM-St. Louis | Dawn Robinson |
| F6522 | Tues., Nov. 29 | West County | Bill Barry |
| F6650 | Thurs., Dec. 22 | West County | Dick Koerper |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T6154 | Tues., Oct. 25 & Nov. 1 | West County | Dick Koerper |
| |||
|
Intermediate Applications of Excel (Prerequisite: Introduction to Excel or equivalent experience.) Further your skills with Excel by learning to design effective spreadsheets that others can use and interpret easily. Design techniques covered in this class include naming cells, adding comments to your spreadsheets, and protecting cells. Additional topics include creating templates, rounding data, using conditional functions and formatting, and minimizing errors. Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6202 | Tues., Aug. 2 | West County | Dawn Robinson |
| F6282 | Mon., Aug. 22 | UM-St. Louis | Bill Barry |
| F6392 | Thurs., Sept. 8 | West County | Dick Koerper |
| F6367 | Fri., Sept. 30 | West County | Erin Delanty |
| F6445 | Fri., Oct. 14 | West County | Dawn Robinson |
| F6460 | Thurs., Oct. 20 | West County | Dawn Robinson |
| F6556 | Mon., Nov. 7 | West County | Erin Delanty |
| F6545 | Thurs., Nov. 17 | UM-St. Louis | Dawn Robinson |
| F6634 | Tues., Dec. 13 | West County | Bill Barry |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T6055 | Thurs., Aug. 4 & 11 | West County | Bill Barry |
| T6225 | Tues., Nov. 8 & 15 | West County | Dick Koerper |
| |||
|
Advanced Applications of Excel (Prerequisite: Intermediate Applications of Excel or equivalent experience.) Further your knowledge of Excel by learning advanced functions and database management techniques, including sorting and filtering data, using database statistical functions, and adding subtotals. Get the most out of your Excel applications by linking data between worksheets and workbooks. Other topics include creating PivotTables and PivotCharts, using lookup tables, and performing what-if analysis using Goal Seek and scenarios. < Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6203 | Wed., Aug. 3 | West County | Dawn Robinson |
| F6397 | Thurs., Sept. 15 | West County | Dawn Robinson |
| F6479 | Fri., Oct. 7 | West County | Erin Delanty |
| F6461 | Fri., Oct. 21 | West County | Dawn Robinson |
| F6569 | Mon., Nov. 14 | West County | Julia Otto |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T6226 | Tues., Nov. 22 & 29 | West County | Dick Koerper |
| |||
|
Creating Charts with Excel (Prerequisite: Intermediate Applications of Excel or equivalent experience.) Learn to use Excel to create powerful graphic presentations, including bar graphs, pie charts, exploded pies, line graphs, scatter plots, and three-dimensional graphs. Discover how to scale and format graphs, properly select data ranges, add titles and labels, set up legends, use grids and color, and make other graphic enhancements. Learn to select the appropriate graph type for your data and to alter that graph for your specific needs. Other topics include principles of graphing, printing graphs, and effective spreadsheet design to aid in graphing. Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6225 | Thurs., Aug. 25 | West County | Dawn Robinson |
| F6472 | Fri., Oct. 28 | West County | Dawn Robinson |
| F6701 | Wed., Jan. 4 | West County | Dawn Robinson |
| |||
|
Special Topics in Excel: Formulas and Functions (Prerequisite: Intermediate Applications of Excel or equivalent experience.) Extend your use of Excel functions and formulas. Look at commonly used Text and Data Functions, including changing the case of text, combining text cell contents (e.g., first and last names), and comparing cell contents. Work with Date and Time Functions and Logical Functions. Other topics will include using simple form fields to select items from a list (note that this will not cover creation of custom forms, as that requires VBA), using the formula editing toolbar to check your data and solve formula errors, and working with arrays. Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6218 | Thurs., Aug. 18 | West County | Bill Barry |
| F6470 | Wed., Oct. 5 | West County | Dawn Robinson |
| F6604 | Mon., Dec. 5 | West County | Dawn Robinson |
| |||
|
Accelerated Topics in Excel: PivotTables (Prerequisite: Intermediate Applications of Excel or equivalent experience.) In this quick-paced, introductory course, you will learn how to save time extracting, organizing, and summarizing meaningful data from Excel spreadsheets or other sources by creating interactive PivotTables and PivotCharts. In this course, you will learn to summarize large amounts of information in a few steps using Excel's PivotTable and PivotChart Wizard. You will learn how to create and customize a PivotTable, view subsets of data, and show or hide details. You will also learn how to create and design a PivotChart to view the summarized data in graphical format. Fee: $89 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| F6290 | Wed., Aug. 17 | West County | Dick Koerper |
| F6401 | Mon., Oct. 3 | West County | Dick Koerper |
| F6564 | Mon., Nov. 21 | West County | Dick Koerper |
| |||
|
Accelerated Topics in Excel: Importing Access Data (Prerequisites: Intermediate Applications of Excel or equivalent experience.) Learn to apply the powerful analysis and reporting capabilities of Excel to your Access database records. This course will show how to import Access data into an Excel spreadsheet so that you can filter and query data, do math calculations, create charts, and construct PivotTables for displaying results. Learn to troubleshoot the transfer of data, and discover valuable tips for making the process more efficient. Previous knowledge of Access is not required. Fee: $89 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| F6295 | Thurs., Aug. 4 | West County | Bill Barry |
| F6674 | Wed., Dec. 14 | West County | Bill Barry |
| |||
|
Excel Macros (Prerequisites: Significant Excel experience and Intermediate Excel or equivalent experience. Students should have a solid knowledge of Excel, a strong background using conditional statements, and substantial experience working with spreadsheets before taking this class.) In this two-day class, discover the power of macros by using Visual Basic for Applications to automate your Excel applications. Visual Basic terminology, such as procedures, methods, properties, and objects, will be introduced and used to create and edit Excel macros. Learn to record, edit, and run macros. Understand how to modify recorded macros and write original macros using Visual Basic in order to customize your interface and create dialog boxes for input and messages. Additional topics include using control structures, such as conditionals and loops. Fee: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6271 | Thurs., Aug. 11 & Fri., Aug. 12 | West County | Bill Barry |
| F6391 | Mon., Sept. 26 & Tues., Sept. 27 | West County | Bill Barry |
| F6584 | Tues., Nov. 15 & Wed., Nov. 16 | West County | Bill Barry |
| |||
|
Excel Forms (Prerequisite: Excel Macros or equivalent experience.) Learn how you can use Excel to create effective forms for print and the Web. Reproduce printed forms with Excel, using its formatting features, formulas, and the drawing toolbar. Enhance data entry by giving forms protected areas, comments, and data validation. Find out how you can set up a form in Excel to include simple interactivity and then publish the form to the Web. This class will also build on topics learned in the Excel Macros class to automate forms with VBA. Fee: $179 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| F6172 | Fri., July 29 | West County | Julia Otto |
| F6491 | Tues., Oct. 4 | West County | Julia Otto |
| F6692 | Wed., Dec. 14 | West County | Julia Otto |
|
| |||
