This course accurately and creatively provides an introductory audience with an understanding of the needed information to pass the Microsoft Office Specialist Certification Series. Its uniqueness and accuracy of content stands out among other courseware, (Procert, November 2011) learners learn the commands in practical, real world applications. Perfect for office workers, professionals, and learners who want to know both how and when to best apply Microsoft Excel. This online course is supported by an instructor and is available for year-round open enrollment.
Upon successful completion of this program, learners will be able to:
* Create and Manipulate Data
* Format Data and Content
* Create and Modify Formulas
* Share and Protect Workbooks
Students who enroll in the Complete Guide to Microsoft Excel 2010 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 2010 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.
The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life.
Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that I wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test results
This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
This program does not require any additional purchases of supplementary materials.