Of related interest: Computer Literacy Certificate
Microsoft Excel’s newest version is taught in this 12-hour course. This class is designed for the beginning Excel user. The student will learn how to enter and edit worksheet data, work with multiple sheets and use shortcuts to carry out some of Excel’s powerful capabilities. Applying various functions and presenting an attractive layout with fonts and formatting are additional topics that are covered. The text used is Microsoft Office User Specialist approved courseware. Prerequisite: Beginning Windows 95 (5305/5805).
Note: This course is also offered at our West Mesa Center lab.
CEU Hours Awarded: 1.2
| AA Sep 15, 17, 22, 24 TTh 6:00p-9:00p |
AB Sep 21, 23, 25 MWF 8:00a-12:00p |
AC Oct 5, 7, 9 MWF 8:00a-12:00p |
| AD Nov 16, 18, 20 MWF 8:00a-12:00p |
BA Sep 17, 22, 24 ThT 1:00p-5:00p |
BB Dec 10, 15, 17 ThT 1:00p-5:00p |
In this intense fast-paced 8-hour course you will be exposed to the basics of creating, editing, and saving worksheets. Additionally, the fundamentals of changing page appearance, footers, and headers as well as creating formulas and functions to calculate and return values, format data, create charts, and working with worksheets in a workbook will be covered. Prerequisite: Beginning Windows 95 (5305/5805).
CEU Hours Awarded: 0.8
| AA Oct 12, 14 MW 1:00p-5:00p |
BA Sep 22, 24 TTh 8:00a-12:00p |
BB Oct 6, 8 TTh 1:00p-5:00p |
Excel has rapidly become the most popular program for financial, statistical, and mathematical computations. This Windows 95 version offers increased computing power while providing ever more simplified methods of obtaining the desired calculations. This 12-hour course examines basic concepts needed for the beginning spreadsheet user. The design of a spreadsheet is the first task. Following that are lessons in moving information, building formulas, formatting numbers as part of spreadsheet design, and improving the appearance with formatting techniques. The beginner will also be introduced to fundamental functions. Prerequisite: Beginning Windows 95 (5305/5805).
CEU Hours Awarded: 1.2
| CA Sep 28, 30, Oct 2 MWF 1:00p-5:00p |
CB Sep 28, 30, Oct 3 MW 6:00p-9:00p Sat 9:00a-4:00p |
In this 12-hour intermediate Excel course learn how to organize workbooks and chart data, use DataMaps to illustrate geographic data, create, modify, and print charts, and make quick forms by using existing templates. Additionally, exercises will allow you to work with functions to create complex formulas, annotate workbooks to explain data, create database templates to make data entry easier, use and scale charts to enhance presentation reports. The text used is Microsoft Office User Specialist approved courseware. Prerequisite: Beginning MS Excel for Office 97 (5724/5824).
CEU Hours Awarded: 1.2
| AA Nov 9, 11, 13 MWF 8:00a-12:00p |
AB Nov 16, 18, 20 MWF 1:00p-5:00p |
DA Dec 8, 10, 15, 17 TTh 6:00p-9:00p |
In this intense quick-paced 8-hour course, you will learn how to create range names to simplify writing formulas, work with functions to create complex formulas, annotate and format worksheets to explain data and ensure consistency. Additionally, participants will create and modify charts, set data validation charts, build error alerts and use data maps to illustrate geographic data. Prerequisite: Beginning Excel for Office 97 (5724/5824). If you prefer more in-depth explanations and more exercises in your training, it is suggested you take the 12-hour Intermediate Excel for Office 97 (5725).
CEU Hours Awarded: 0.8
| AA Dec 7, 9 MW 1:00p-5:00p |
BA Nov 10, 12 TTh 8:00a-12:00p |
Intermediate topics of spreadsheet use are covered in this 12-hour course. The student is introduced to logical functions, scenarios, goal seeking, and advanced charting techniques. The powerful features of outlining are explored, as is using the workbook feature of Excel to link sheets. Prerequisite: Beginning Microsoft Excel for Windows 95 (5324).
CEU Hours Awarded: 1.2
| CA Nov 9, 11, 13 MWF 8:00a-12:00p |
In this 12-hour class the experienced user will learn advanced features which will allow masterful utilization of Microsoft Excel for Office 97. You will learn to sort and filter data to display and control information. Use of data table to calculate projections and use pivot tables to reorganize data will be featured. Additionally, learn to consolidate data from several worksheets into one worksheet and then link the worksheets for customized viewing. We will cover ways to automate repetitive tasks by creating and editing macros. The text used is Microsoft Office User Specialist approved courseware. Prerequisite: Intermediate Excel (7.0) for Office 97(5325).
CEU Hours Awarded: 1.2
| AA Nov 30, Dec 2, 4 MWF 1:00p-5:00p |
AB Dec 14, 16, 18 MWF 8:00a-12:00p |
In this 12-hour course, you will learn the advanced features of this powerful spreadsheet program. Features covered include: data series, the RND function, consolidating Worksheets for data summarization, displaying precedent and dependent information, applying the View Manager, using the Report Manager, and displaying geographical data in a data map. Prerequisite: Intermediate Excel (7.0) for Windows 95(5325).
CEU Hours Awarded: 1.2
| CA Dec 3, 8, 10 ThT 1:00p-5:00p |