Description

Microsoft Excel training in Excel 2007 from Gatlin International is the convenient way to gain the skills you need. We know that there are numerous Excel courses for you to choose from but we feel that, once you've compared our Excel course to the competition, you'll agree that Microsoft Excel training from Gatlin International is in a league of its own. Our Excel training program is a comprehensive, performance-based certification preparation program designed to validate business computer skills using Microsoft Excel 2007 software. Our Excel course is an interactive online program will prepare you to take Microsoft Certification Exam 77-602. Students will not only gain basic knowledge of the software, but also how to use the auditing toolbar to trace errors, calculate revenue, filter data, and use the VLookup function. The Microsoft Excel 2007 course has continuous assessment for goal-based learning. The course contains three modules with multiple lessons in each. A student needs 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 enrolled in our Microsoft Excel training will need to have Microsoft Excel 2007 installed on their computer prior to taking this course.

Course Objectives

By completing the Microsoft Excel 2007 course, students will:
• Be introduced to the spreadsheets they will need for a business or department.
• Understand the Autofill function.
• Learn how to merge and center cells, link worksheets and 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. Microsoft Excel training from Gatlin International is the obvious choice for students and busy working professionals alike. With our open enrollment policy, you can begin the Excel course and start learning today!

Outline

In the following outline you will see the major topics covered in our Microsoft Excel training course.

I. Beginning Guide to Microsoft Excel 2007
a. Make a Rainfall Graph
b. Create a Price Sheet
c. Calculate Revenue

II. Intermediate Guide to Microsoft Excel 2007
a. Mail Merge with Excel
b. Create a Time Sheet
c. Calculate Revenue

III. Advanced Guide to Microsoft Excel 2007
a. Absolute and Relative References
b. Create Filters, Subtotals, Use the Lookup Function
c. Analyze Data with a PivotTable

Demo

Click here to view a demo of the course.

Additional Info

Languages

English

Course Length

35.00 hours

Duration of Access

3 months

Instructor

Elizabeth Ann Nofs
Elizabeth Ann Nofs is co-founder and the 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 with 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 B.A. degree 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 met 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.

Prerequisites/Audience

Students enrolling in the Microsoft Excel training should possess a basic understanding of computer skills, Internet connection, and emailing capabilities are required.

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

Requirements/Materials Included

The Excel 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 you have DSL or High Speed Cable Internet Access; 64 MB system RAM; 200 MB free hard disk space memory or sufficient storage; reliable email account access, CD-ROM/DVD capabilities, and a reliable Internet provider.

You will need the following products already be loaded on the computer in order to take this course: Windows Vista Business edition or Windows XP, Microsoft Excel 2007, Adobe Acrobat Reader (free version), and Flash Player.

GES will provide the following materials:
• Beginning Guide to Microsoft® Excel 2007
• Intermediate Guide to Microsoft® Excel 2007
• Advanced Guide to Microsoft® Excel 2007