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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0544 Mon., Nov. 9West CountyMara Delcamp
G0661 Thurs., Dec. 3West CountyBill Barry
G0734 Fri., Jan. 8West CountyBill Barry
G0807 Tues., Feb. 16UM-St. LouisMara Delcamp
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0521 Fri., Nov. 6West CountyNancy Haupt
G0670 Thurs., Dec. 10West CountyBill Barry
G0713 Mon., Jan. 11West CountyBill Barry
G0865 Tues., Feb. 23West CountySandy Lux

Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T0249 Thurs., Nov. 12 & 19West CountyNancy Haupt
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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0545 Mon., Nov. 16West CountyMara Delcamp
G0662 Fri., Dec. 11West CountyBill Barry
G0735 Fri., Jan. 15West CountyBill Barry
G0808 Tues., Feb. 23UM-St. LouisMara Delcamp

Two-Evening Class Meets 6:30-9:30pm (6 hours)
Code Date Location Instructor
T0200 Thurs., Nov. 5 & 12West CountyBill Barry
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0522 Fri., Nov. 13West CountyNancy Haupt
G0671 Thurs., Dec. 17West CountyBill Barry
G0714 Tues., Jan. 19West CountyBill Barry
G0866 Wed., Feb. 24West CountySandy Lux
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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0663 Fri., Dec. 18West CountyBill Barry
G0736 Thurs., Jan. 21West CountyMara Delcamp
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0523 Fri., Nov. 20West CountyNancy Haupt
G0715 Wed., Feb. 3West CountyBill Barry
G0867 Thurs., Feb. 25West CountySandy Lux
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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0737 Fri., Jan. 29West CountyMara Delcamp
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0524 Mon., Nov. 23West CountyBill Barry
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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0739 Wed., Jan. 27West CountyMara Delcamp
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0817 Mon., Feb. 15West CountyMara Delcamp
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  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0664 Wed., Dec. 16West CountyBill Barry
Excel 2007  [Table of Contents]

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0887 Fri., Mar. 5West CountyBill Barry
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  [Table of Contents]

Half-Day Class Meets 8:30am-11:30am (3 hours)
Code Date Location Instructor
G0535 Thurs., Nov. 12West CountyBill Barry
Excel 2007  [Table of Contents]

Half-Day Class Meets 8:30am-11:30am (3 hours)
Code Date Location Instructor
G0878 Fri., Feb. 26West CountyBill Barry
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  [Table of Contents]

Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)
Code Date Location Instructor
G0536 Thurs., Nov. 12West CountyBill Barry
Excel 2007  [Table of Contents]

Half-Day Afternoon Class Meets 1:00-4:00pm (3 hours)
Code Date Location Instructor
G0879 Fri., Feb. 26West CountyBill 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  [Table of Contents]

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G0765 Wed., Jan. 6 & Thurs., Jan. 7West CountyBill Barry
Excel 2007  [Table of Contents]

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G0698 Mon., Dec. 7 & Tues., Dec. 8West CountyBill Barry