See how a Course Works: Intro to Online Learning
Description
Microsoft Excel Training from Gatlin International
Microsoft Excel training from Gatlin International makes learning more affordable and more convenient. This course accurately and creatively provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. Students learn the commands in practical, real world applications. Perfect for office workers, professionals, and students who want to know both how and when to best apply Microsoft Excel.
When you use Approved Courseware for the Microsoft Office Specialist programs, such as Microsoft Office Specialist 2007, you know you’re using high quality study materials. In order for courseware to receive the Approved Courseware distinction, it must go through a rigorous review to ensure it meets the skill standards set forth by Microsoft.
The Microsoft Excel 2007 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Certified Application Specialist (MCAS). MCAS certification is the globally recognized standard for validating expertise with the Microsoft Office 2007 suite.
Microsoft Excel certification helps you differentiate yourself in today's competitive job market, broaden your employment opportunities, and garner greater earning potential. Excel certification can also help you advance in your current job. Mastering more skills increases your effectiveness and efficiency. Research indicates that Office-certified professionals are more confident and productive with Microsoft Office programs.
Certification proves a certain level of advanced competency with the programs in question. Employers don’t have to wonder if the skills stated on the resume are honest and without exaggeration. This can lead to further employment opportunities and increased pay.
Microsoft Approved Courseware
When you use Approved Courseware for the Microsoft Certified Application Specialist and Microsoft Office Specialist programs to help prepare for Microsoft Office certification exams, you know you're using the very best study materials available.
In order for courseware to receive the Approved Courseware distinction, it must go through a rigorous review to ensure it meets the skill standards set forth by Microsoft. This is the first online Microsoft Excel 2007 certification training course approved by Microsoft.
By completing the Microsoft Excel training program, you'll:
- Create and Manipulate Data
- Format Data and Content
- Create and Modify Formulas
Get the skills you need to succeed with Microsoft Excel training from Gatlin International.
Outline
Microsoft Excel Training Outline
- I. Beginning Guide to Microsoft Excel 2007
- Hello, Excel! Enter data and use basic text formatting
- It All Adds Up: enter data, labels and formulas
- A Question of Balance: Use and audit formulas from Excel’s formula library
- II. Intermediate Guide to Microsoft Excel 2007
- The Table is Set: Create Format and sort a list
- Working Overtime: Use drop down lists and conditional formatting
- Legs, Eggs, and Pigs: Troubleshooting formulas and data
- III. Advanced Guide to Microsoft Excel 2007
- Sounds Good to Me: Create formulas that calculate, compare, and format text
- Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
- What Happened? (Pivot Tables) Create and modify Pivot Tables
Additional Info
- Languages
- English
- Course Length
- 80.00 hours
- Duration of Access
You have 6 months to complete this course.
- Instructor
Clair Dickson has a B.S. in Secondary English Education from Eastern Michigan University. She currently works as an online course facilitator in a lab setting, working with students taking courses towards their high school diploma. She also completed her Graduate Certificate in Educational Media and Technology through Eastern Michigan University Online, doing all of the work online.
She earned the Microsoft Office 2007 Master certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2007. In addition, she has Microsoft Word 2003 Expert level certification. She has used every version of Office since 1995 and still enjoys finding new ways to use the software.
In her spare time, Clair writes short crime stories and chases after her young son.
Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides. 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.
She’s the author of 44 books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005) and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training.
Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.
- Prerequisites/Audience
Students who enroll in the Complete Guide to Microsoft Excel 2007 should have basic computer skills, including how to turn on the computer, how to use an Internet browser, and how to select commands from a menu or toolbar. Students should know how to save files and send attachments by email as well.
The Complete Guide to Microsoft Excel 2007 is for students to improve their level and breadth of knowledge with Microsoft Excel functions in preparation for taking the Microsoft Certification Exam. The course includes both recall and authentic assessments to measure student understanding at an increasingly advanced level. Students will be working hands-on with the commands and completing sample projects to reinforce learning. This course does not rely on abstract learning, but on the program in context.
The primary instruction is related to business applications of Excel, as Microsoft Office is used in most workplaces. Nearly every business has a use for Microsoft Office programs, from inter-office memos composed on Microsoft Word to Sales presentations created with Microsoft PowerPoint to Budget spreadsheets compiled in Microsoft Excel. A secondary target group is teachers, who can use Microsoft Office for both teacher preparation and record-keeping as well as in student assignments. Lastly, home users may find many uses for Microsoft Office, similar to those used in the workplace. Microsoft Office is a ubiquitous product with great possibilities. This course aims to expose users to those possibilities.
Students for the certification exams should have the equivalent of six months of hands-on computer experience before taking the exam. These exam candidates should be proficient at file management. In addition, students should be able to readily identify and use the commands for at least 80% of the exam objectives in preparation for taking the timed exam. Amongst the skills necessary, students should be especially effective at entering information and analyzing data. Successful students will have mastered how to create and edit formulas, audit equations, insert and format visual data presentations and present information in charts and tables.
- Requirements/Materials Included
In order to take our online programs, you must have access to a computer and the Internet (high-speed Internet access is recommended). You can access the program contents from any Web-enabled computer.
You will need the following Microsoft products already installed on your computer in order to take this program: Word, Excel, PowerPoint and Outlook 2007.
Hardware requirements:
- IBM-compatible (PC) computer
- Processor: 1 GHz 32-bit (x86) or 64-bit (x64)
- RAM: 1 GB of system memory
- Hard Drive: 40 GB with at least 15 GB of available space
- 128 MB of graphics memory
- DVD-ROM drive
- Audio output
- Adobe Acrobat Reader
- Flash Player
- Certification
This course is also an exam study guide for the following certification tests:
