Excel is an electronic spreadsheet that performs numeric calculations rapidly and accurately. Participants will learn to recognize and use different elements of the Excel window; will plan and build worksheets, enter text, copy and move entries, and enter values and formulas. Emphasis will be placed on formatting worksheet values, selecting fonts and point sizes, inserting and deleting rows and columns, applying colors, patterns, and checking spelling.

Top of page

Registration Form

Participants will learn how to create macros, to automate frequently performed Excel tasks that require a series of steps. Participants will learn formulas and how to convert information to the visual format of a chart, plan, design, create, edit and enhance a chart, and add text annotations and arrows to a chart. In addition, students will practice planning, creating and editing a list; sorting and printing a list; as well as filtering lists using AutoFilters.

Participants will learn the importance of using formulas as a powerful data analysis tool. Topics include creating formulas with several operations, generating multiple totals with AutoSum, using the IF and PMT functions, and using statistical functions. Other Excel features covered will help students manage and print workbooks by freezing columns and rows, inserting and deleting sheets, hiding and protecting worksheet areas, numbering pages, and setting margins.

PREREQUISITE: This is now part of the Workshop Seminar

Program Cost:  $120.00

Program Length:  8 hrs

Required number of students:  min 6 max 16

TEXT BOOK INCLUDED

Please bring a writable CD

Participants will learn to create macros to automate frequently performed Excel tasks that require a series of steps. Topics include planning, designing, recording, running, and editing a simple macro. In addition, students will practice planning, creating and editing a list; sorting and printing a list; as well as, filtering lists using AutoFilters.

PREREQUISITE: CED-797 Excel -Level 3 or equivalent experience. Excel 2003 also applicable to Excel 2002 users

Program Cost:  $48

Program Length:  3 hrs

Required number of students:  min 6 max 16

Purchase required text prior to class (same text used in Levels 1-4)

Please bring a writable CD

Participants will learn advanced skills in Excel. Topics include advanced functions, advanced formatting, and summarizing data with PivotTables and Pivot Charts.

PREREQUISITE: CED-836 Excel -Level 4 or equivalent experience. Excel 2003 also applicable to Excel 2002 users

Program Cost:  $48

Program Length:  3 hrs

Required number of students:  min 6 max 16

Purchase required text prior to class (same text as Level 1)

Please bring a writable CD

Experience the new MS Office, the new ribbon task bar and the new innovations along with the 'old' tried and true functions. This electronic spreadsheet performs numeric calculations rapidly and accurately. Learn to recognize and use different elements of the Excel Windows, open existing files and enter data in a worksheet and how to use the help menu.

THIS IS NOW PART OF THE WORKSHOP SEMINAR

Program Cost:  $160

Program Length:  8 hrs

Required number of students:  min 6 max 12/16

TEXT BOOK INCLUDED

Please bring a writable CD