Objective
Benefits
Requirements
Microsoft Office Excel 2007 Certification Self-study Guide
Microsoft Office Excel 2007 Certification Exam
Fee
Objective
The objective of the National Bookkeepers Association’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
Excel Users:
Obtain employment
Earn a higher wage
Become more marketable
Become more productive
Differentiate yourself from other bookkeepers, accountants, and office managers
Provide credibility and proof of knowledge and skills
Develop greater bookkeeping, accounting, and Excel knowledge and skills
Small Business Owners:
Provide assurance of the Excel user's knowledge, skills, and experience
Increase employee productivity and effectiveness in the work place
Develop employee confidence and promote an atmosphere of loyalty and allegiance
Help expedite the hiring process
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
NBA'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@nationalba.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: