Course
Schedule
AJAX
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Week
Crystal Reports
DP Design
DigCameras
Dreamweaver
E-commerce
Excel
Exchange
ExpressionWeb
FileMaker
Fireworks
Flash
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PHP
Perl
PhotoElems
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Reporting
SQLServerAdm
Security
SharePoint
SharePtAdmin
SharePtDesign
Support
TCP/IP
UNIX
VB.NET
Visio
Vista Admin
Vista Intro.
Vista Trans.
Visual Basic 6
W2003 Policy
W2003 Server
W2008 Server
Win XP Intro.
Wireless Net.
Word
XML
|
Excel |
| ||
 | |||
|
Introduction to Excel (Prerequisite: Introduction to Windows or equivalent experience.) Use Excel to create spreadsheets for accounting, budgeting, expense tracking, and other applications. Learn to set up and format worksheets and enter labels, values, and formulas. Discover how to select data, restrict data entry, adjust column widths, and move around the worksheet. Other topics include using simple statistical functions, editing and deleting data, moving and copying cell contents, understanding absolute and relative references, setting up worksheet pages, and printing. Fee: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9379 | Mon., Sept. 29 | West County | Nancy Haupt |
| G9452 | Thurs., Oct. 9 | West County | Dawn Robinson |
| G9467 | Tues., Oct. 21 | West County | Mara Delcamp |
| G9581 | Mon., Nov. 3 | West County | Bill Barry |
| G9584 | Mon., Nov. 17 | UM-St. Louis | Nancy Haupt |
| G9638 | Wed., Dec. 10 | West County | Nancy Haupt |
| G9704 | Wed., Jan. 7 | West County | Dawn Robinson |
| G9788 | Tues., Jan. 20 | West County | Bill Barry |
| |||
| Excel 2007 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9423 | Mon., Oct. 13 | West County | Bill Barry |
| G9545 | Fri., Nov. 14 | West County | Mara Delcamp |
| G9718 | Tues., Jan. 6 | West County | Bill Barry |
| |||
|
Intermediate Applications of Excel (Prerequisite: Introduction to Excel or equivalent experience. You should know how to create formulas using the formula bar and understand absolute and relative references.) Further your skills with Excel by learning to design effective spreadsheets that others can use and interpret easily. Practice applying effective design techniques, including naming cells, protecting cells, and making your spreadsheets easy to read. Additional topics include working with multiple worksheets, creating templates, rounding data, using conditional functions, and applying conditional formatting. Fee: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9380 | Tues., Sept. 30 | West County | Sandy Lux |
| G9453 | Thurs., Oct. 16 | West County | Dawn Robinson |
| G9468 | Mon., Oct. 27 | West County | Mara Delcamp |
| G9582 | Mon., Nov. 10 | West County | Dawn Robinson |
| G9585 | Mon., Nov. 24 | UM-St. Louis | Nancy Haupt |
| G9639 | Tues., Dec. 16 | West County | Nancy Haupt |
| G9705 | Wed., Jan. 14 | West County | Dawn Robinson |
| G9789 | Thurs., Jan. 29 | West County | Bill Barry |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T9159 | Thurs., Oct. 9 & 16 | West County | Nancy Haupt |
| |||
| Excel 2007 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9424 | Tues., Oct. 14 | West County | Bill Barry |
| G9546 | Fri., Nov. 21 | West County | Mara Delcamp |
| G9719 | Mon., Jan. 12 | West County | Bill Barry |
| |||
|
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 using lookup tables and performing what-if analysis using Goal Seek and scenarios. Fee: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9481 | Wed., Oct. 1 | West County | Dawn Robinson |
| G9454 | Thurs., Oct. 23 | West County | Dawn Robinson |
| G9583 | Mon., Nov. 17 | West County | Bill Barry |
| G9640 | Mon., Dec. 22 | West County | Dawn Robinson |
| G9706 | Thurs., Jan. 22 | West County | Dawn Robinson |
| |||
| Two-Evening Class Meets 6:30-9:30pm (6 hours) | |||
| Code | Date | Location | Instructor |
| T9163 | Thurs., Oct. 23 & 30 | West County | Nancy Haupt |
| |||
| Excel 2007 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9425 | Tues., Oct. 21 | West County | Dawn Robinson |
| G9547 | Tues., Dec. 2 | West County | Dawn Robinson |
| |||
|
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: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9688 | Wed., Dec. 3 | West County | Dawn Robinson |
| |||
|
Special Topics in Excel: Data Manipulation (Prerequisite: Intermediate Applications of Excel or equivalent experience.) Learn the skills you need to do more with your Excel data. In this course, you'll discover ways to save time and increase your efficiency, whether you are working with one large spreadsheet or multiple tables. Find out how you can combine portions of several lists or tables into one consolidated table. Discover how to navigate with hyperlinks through multiple sheets of a workbook, multiple workbooks, or even to other programs. Save valuable time by accessing custom-made views of your spreadsheet. Topics include how to eliminate repetitive typing by creating, modifying, and printing comments for compressed notations on spreadsheets; use Group and Outline to quickly show and print totals in sections of your spreadsheet; and create styles to use in multiple spreadsheets. Fee: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9480 | Mon., Oct. 6 | West County | Dawn Robinson |
| G9641 | Tues., Dec. 16 | 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: $189 | |||
|
Excel 2003 | |||
|
One-Day Class Meets 8:30am-4:00pm (6.5 hours) | |||
| Code | Date | Location | Instructor |
| G9555 | Fri., Nov. 7 | West County | Dawn Robinson |
| |||
|
Accelerated Topics in Excel: Introduction to 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 discover how to create and design a PivotChart to view the summarized data in graphical format. Fee: $99 | |||
|
Excel 2003 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| G9587 | Thurs., Nov. 13 | West County | Dawn Robinson |
| G9707 | Mon., Jan. 26 | West County | Dawn Robinson |
| |||
| Excel 2007 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| G9654 | Mon., Dec. 1 | West County | Dawn Robinson |
| |||
|
Accelerated Topics in Excel: Intermediate PivotTables (Prerequisite: Excel PivotTables: Introduction or equivalent experience.) In this fast-paced course, discover the advanced features of PivotTables that will enhance your ability to view and analyze data. Learn to create PivotTables from multiple consolidation ranges, use macros to refresh your data, synchronize multiple tables, and set up interactive Web data summaries. You will create PivotTables from a large database to view specific data and work with calculation and date fields. Discover the tips and shortcuts that will make you more efficient and your PivotTables more effective in summarizing your data. Fee: $99 | |||
|
Excel 2003 | |||
| |||
| Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours) | |||
| Code | Date | Location | Instructor |
| G9588 | Thurs., Nov. 13 | West County | Dawn Robinson |
| G9708 | Mon., Jan. 26 | West County | Dawn Robinson |
| |||
| Excel 2007 | |||
| |||
| Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours) | |||
| Code | Date | Location | Instructor |
| G9655 | Mon., Dec. 1 | West County | Dawn Robinson |
| |||
|
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 | |||
|
Excel 2003 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| G9499 | Fri., Oct. 17 | West County | Bill Barry |
| |||
|
Excel Macros (Prerequisites: Significant Excel experience and Intermediate Applications of 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: $339 | |||
|
Excel 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9490 | Thurs., Oct. 9 & Fri., Oct. 10 | West County | Bill Barry |
| G9699 | Wed., Dec. 17 & Thurs., Dec. 18 | West County | Bill Barry |
|
| |||
