|
Objective
Benefits
Requirements
Microsoft Office Excel 2007 Certification Self-study Guide
Microsoft Office Excel 2007 Certification Exam
Fee
Objective
The objective of the NACPB’s Microsoft Office Excel 2007 Certification is to ensure you possess the knowledge and skills to accurately and productively use Microsoft Office Excel 2007 in a bookkeeping and accounting environment.
Benefits
The benefits of obtaining the Microsoft Office Excel Certification are as follows:
Public Bookkeeping and Accounting Firm Employees:
Develop greater Excel knowledge and skills
Become more accurate and productive
Provide credibility and proof of knowledge and skills
Differentiate yourself from other bookkeepers and accountants
Become more marketable
Obtain Employment
Earn a higher wage
Public Bookkeeping and Accounting Firm Owners:
Provides assurance of the employee's Excel knowledge and skills
Helps expedite the hiring process
Increase employee productivity and effectiveness in the work place
Develops employee confidence and promotes an atmosphere of loyalty and allegiance
Requirements
The Microsoft Office Excel 2007 Certification program includes an educational component comprised of the Microsoft Office Excel 2007 Step by Step Guide. The Guide is for Excel users who want to learn or enhance their Excel knowledge and skills and serve as the educational foundation for our Microsoft Office Excel 2007 Certification exam. The Guide can also be used as a learning and reference tool.
To earn the Microsoft Office Excel 2007 Certification, individuals must complete the following steps:
Individuals who meet these requirements receive our Microsoft Office Excel 2007 Certification certificate.
Microsoft Office Excel 2007 Certification Self-study Guide
Table of Contents
Chapter 1 - What's New in Excel 2007?
Chapter 2 - Setting Up a Workbook
Chapter 3 - Working with Data and Data Tables
Chapter 4 - Performing Calculations on Data
Chapter 5 - Changing Document Appearance
Chapter 6 - Focusing on Specific Data Using Filters
Chapter 7 - Reordering and Summarizing Data
Chapter 8 - Combining Data from Multiple Sources
Chapter 9 - Analyzing Alternative Data Sets
Chapter 10 - Creating Dynamic Lists with PivotTables
Chapter 11 - Creating Charts and Graphs
Chapter 12 - Printing
Chapter 13 - Automating Repetitive Tasks with Macros
Chapter 14 - Working with Other Microsoft Office System Programs
Chapter 15 - Collaborating with Colleagues
Microsoft Office Excel 2007 Certification Exam
NACPB's Microsoft Office Excel 2007 Certification exam is used to test the user’s Excel 2007 competency. The exam consists of 50 multiple choice questions. As you complete the Guide you may request access to the exam via email or telephone. You have 24 hours to take and submit the exam for grading and the exam is "open-book". You must receive an 80% in order to pass the exam. Test results are made available to you within 24 hours. If necessary, you must wait one full week to retake the exam. However, there is no additional fee to retake the exam. To request the exam, please email exams@nacpb.org or call 866-444-9989.
The Microsoft Office Excel 2007 Certification exam tests the following:
Fee
Member $79 (Register through our Members
Only Internet portal)
Nonmember $99
Microsoft Office Excel 2007 Certification fee includes: