George Mason University OCPE Programs

This nationally recognized Microsoft Excel 2007 online training course contains three modules with multiple lessons in each. Students need to achieve 70% of all possible points to be able to continue on to the following module. This course also includes a final project which must be completed and submitted to the instructor. Students will need to have Microsoft Excel 2007 installed on their computer prior to taking this course. This program is offered in partnership with Gatlin Education Services.

TOPIC HIGHLIGHTS

Beginning Guide to Microsoft Excel 2007

Make a Rainfall Graph
Create a Price Sheet
Calculate Revenue

Intermediate Guide to Microsoft Excel 2007

Mail Merge with Excel
Create a Time Sheet
Calculate Revenue

Advanced Guide to Microsoft Excel 2007

Absolute and Relative References
Create Filters, Subtotals, Use the Lookup Function
Analyze Data with a PivotTable

CERTIFICATE REQUIREMENTS

A 70% or better must be achieved in order to receive a Certificate of Completion.

COURSE OBJECTIVES

Be introduced to the spreadsheets needed for a business or department

Understand the Autofill function

Learn how to merge and center cells, link worksheets, consolidate data, and calculate revenue from several worksheets

Work with different scenarios found in the workplace

Understand how to use the PivotTable to Auto format and analyze data

Know how to filter and outline data, and use the VLookup function

PDF BROCHURE

Please click here to download the PDF brochure for the Gatlin online courses offered by OCPE.

This brochure and the registration form for this course require Adobe Reader. Click here to download the latest version of Adobe Reader.

WHO SHOULD ATTEND

A basic understanding of computer skills, Internet connection, and e-mailing capabilities are required.

This course is intended for students who want to learn how to effectively use Microsoft Excel 2007.

INSTRUCTORS

Elizabeth Ann Nofs
Elizabeth Ann Nofs is co-founder and creative director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced by WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the Guide is a breakthrough in producing gender balanced training with outstanding student completion, retention, and mastery rates.

She is the author of 38 computer certification guides including: The Complete Guide to Microsoft Office 2007 (2007), The Complete Computer Guide (2005), The Comma Method of Computer Training (2003), and The Comma Teachers Edition (2003).

Elizabeth received her BA in biology from the University of Michigan, Ann Arbor. She is a Microsoft Certified Professional.

Clair E. Dickson, Student Services
Clair earned her BS in secondary English at Eastern Michigan University in Ypsilanti, Michigan and is certified to teach English and history at the high school level. She also meets all of the standards for teaching with technology as outlined by COATT (Consortium for Outstanding Achievement in Teaching with Technology). Clair is considered "highly qualified" to teach computer courses, including Microsoft Office^® 2003 and 2007, Windows XP^® and Windows Vista^®.

Clair Dickson is currently working on a master's degree in educational media and technology through Eastern Michigan University's online distance learning program. The program explores ways to infuse technology into the learning experience so that learning is interactive.

PC REQUIREMENTS

This course cannot be taken on a Mac computer. Technical requirements include but are not limited to having Internet access with a 56K modem, but it is highly recommended that students have DSL or high speed cable Internet access; 64 MB system RAM; 200 MB free hard disk space memory or sufficient storage; reliable e-mail account access, CD-ROM/DVD capabilities, and a reliable Internet provider.

Students will need the following products already installed on their computer prior to taking this course: Windows Vista Business edition or Windows XP, Microsoft Excel 2007, Adobe Acrobat Reader (free version), and Flash Player.

FAQ

1. How do I register for a Gatlin online course?

Gatlin does not offer courses directly to the public. It offers courses through George Mason University and other colleges and universities. Please contact our office at 703-993-2113 or click here for more information or to register for a course.

2. How much do Gatlin online courses cost?

To view the prices for all Gatlin courses that are offered by George Mason University, please click here.

3. Why do I have to take Gatlin courses through a participating school?

That is the only way Gatlin Education Services offers its courses. They do not deal directly with the public.

4. Do I have to travel to register for or to attend a Gatlin online course?

All Gatlin courses are delivered entirely online, so you do not have to go to a class or travel to a school. Please contact our office at 703-993-2113 or click here for more information or to register for a course.

5. How long does it take to complete a Gatlin course?

All of our Gatlin courses are asynchronous. You can start and finish the course at your own pace. Most courses are designed to be completed within 180 days. You may request an extension if you think you will need more time to complete a course. Please contact us at 703-993-2113 or click here if you have any questions or if you would like to register for a course.

6. Do I have to buy additional materials?

Please refer to the green Included Materials box located on the upper right hand side of this page. If materials are included in this course, they will be shipped by Gatlin to you via UPS ground service after you have registered for a course.

7. Can I get financial aid for Gatlin courses?

George Mason University offers financial assistance through the Sallie Mae Training Loan Program for qualifying students. Call 703-993-2113 for more information. GES also provides a loan opportunity for students (www.collegeloanapplication.com).

8. What happens when I complete the course?

If you obtain a final passing grade of 70% or greater in a course, we will award you a George Mason University certificate of completion.

9. Who will be my instructor?

Each student is paired up with a George Mason University, OCPE, Gatlin facilitator for one-on-one interaction. The facilitator will be available (by e-mail or by telephone) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

10. What are the system requirements in order to take an online course?

Please see the "PC requirements" section listed for individual courses.

11. When can I start the course?

You can register for a course at any time.

	Skip Navigation If you can't find what you are looking for, please call us at 703-993-2109. Home >> Programs >> Online >> Gatlin >> MS Excel