 Excel
2003, Introduction
(12
hours) Total Cost $195 (includes all books and materials)
Create a basic worksheet by entering text and values; work with cells
and cell data by using a variety of moving and copying techniques. Perform
calculations on data by using formulas, including functions; change
the appearance of worksheet data by using a variety of formatting techniques.
Work with multiple worksheets by formatting, repositioning, copying
and moving, and adding and deleting worksheets within a workbook. Create
and modify charts and set the page display and printing options.
CMP
E19 541
August 25 & 27, Monday & Wednesday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP
E19 543
August 18 - 27, Monday & Wednesday
6:00 p.m. - 9:00 p.m.
SSC Room 3236
Excel
2003, Intermediate
(12
hours) Total Cost $195 (includes all books and materials)
Prerequisite: Excel Introduction or prior knowledge
Use Excel templates and user-defined templates to create templates and workbooks, use a variety of techniques to sort and filter data. Re-use and share data by importing and exporting and saving to the Web. Use various functions and auditing features to create advanced formulas and audit worksheets. Use PivotTables, PivotCharts, and other analysis tools to analyze data. Use Web features and comments to collaborate with others.
CMP
E39 041
September 2 & 4, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP E39 042
September 15 - 24, Mondays & Wednesdays
6:00 - 9:00 p.m.
SSC Room 3236
Excel 2003, Advanced
(12 hours) Total Cost $195 (includes all books and materials)
Prerequisite: Excel Introduction and Intermediate
Customize your workbook by applying conditional formatting, adding data validation criteria customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data. Work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query. Collaborate with other Excel users by protecting your workbook, sharing your workbook; merge multiple copies of the same workbook, and tracking changes. Chart non-adjacent data, modify chart items, and create a trendline, use multiple graphic objects to enhance your worksheet.
CMP E24 041
October 7 & 9, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP E24 141
October 14 & 16, Tuesdays & Thursdays
9:00 a.m. - 4:00 p.m.
UCC Room 5180
Excel 2007, Introduction
(12 hours) Total Cost $195 (includes all books and materials)
Create a basic worksheet by entering text and values; work with cells and cell data by using a variety of moving and copying techniques. Perform calculations on data by using formulas, including functions; change the appearance of worksheet data by using a variety of formatting techniques. Work with multiple worksheets by formatting, repositioning, copying and moving, and adding and deleting worksheets within a workbook. Create and modify charts and set the page display and printing options.
CMP E19 641
August 19 - 28, Tuesdays & Thursdays
6:00 - 9:00 p.m.
UCC Room 5180
CMP E19 643
August 18 & 20, Monday & Wednesday
9:00 a.m. - 4:00 p.m.
UCC Room 5180
Excel 2007, Intermediate
(12 hours) Total Cost $195 (includes all books and materials)
Prerequisite: Excel Introduction or equivalent knowledge
Use Excel templates and user-defined templates to create templates and workbooks, use a variety of techniques to sort and filter data. Re-use and share data by importing and exporting and saving to the Web. Use various functions and auditing features to create advanced formulas and audit worksheets. Use PivotTables, PivotCharts, and other analysis tools to analyze data. Use Web features and comments to collaborate with others.
CMP E39 141
September 2 - 11, Tuesday & Thursday
6:00 - 4:00 p.m.
SCC Room 3228
CMP E39 143
September 23 & 25, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SCC Room 3228
|
