Excel 2010 Training and Certification Program

ABOUT | REGISTER | PRE-WORK | WORKSHOP | CERTIPREP | CERTIFICATION EXAM

ABOUT 


The Whitman Technology Services and Undergraduate offices have teamed up with a local firm to offer a Microsoft Excel training and certification program to Whitman students. 

Participation in the program requires a $75 fee, which will be refunded if the student successfully passes the certification exam.


IMPORTANT: Participation in the Excel Training and Certification Program requires Microsoft Windows and Microsoft Excel 2010. If you are a Mac user, please refer to theTechnology Requirements section below for details on your options for participating in the program.

The schedule for the program is as follows: 


January 18-22: Registration
January 23-25: Self-paced pre-work (beginning topics in Excel 2010)
January 26: All-day workshop (intermediate Excel 2010 topics)
8:30am-4:30 pm (Lender Auditorium, Whitman)
January 28-February 7: Self-paced exam prep (Certiprep)
February 8: Date 1 for Certification Exam (Covers beginning and intermediate topics in Excel)
February 9: Date 2 for Certification Exam (Covers beginning and intermediate topics in Excel)
February 15: Date 3 for Certification Exam (Covers beginning and intermediate topics in Excel)
 

Technology requirements for the program:

  • A computer capable of running Windows 7 with Internet Explore and Microsoft Office 2010

For Existing Microsoft Windows Users: If you have a windows-based computer already, you can download Microsoft Office 2010 for no additional charge at http://whitman.onthehub.com. If you have not already accessed the OnTheHub site, please click on Sign In, then click Register to register for access using your syr.edu email address. Please note that the self-paced pre-work must be completed in Internet Explorer.

For Mac OS Users: The self-paced pre-work,  workshop excercises and certification exam prep software all require access to a computer capable of running Microsoft Windows with Internet Explorer 7 or higher and Microsoft Office 2010. Please note that any of the computers in the labs at Whitman can be used to do the self-paced pre-work, and a  limited number of loaner laptops will be available for the certification exam prep software,  but you will need your own computer for the workshop.

Mac users will need to use Apple's Bootcamp software or VMWare's Fusion software to install and run Windows. 

  1. First, access whitman.onthehub.com to download  Windows 7 and Microsoft Office 2010 Professional Plus. If you have not already accessed the OnTheHub site, please click on Sign In, then click Register to register for access using your syr.edu email address.
  2. You can run Windows using VMWare Fusion (software also available from Whitman.onthehub.com) – download the version appropriate to your version of Mac OS X. Once you download and install the appropriate version of VMWare Fusion on your computer, you may find this video is a helpful guide to installing VMWare Fusion and Windows: http://www.youtube.com/watch?v=dtnmPTMCveU

REGISTER


The $75 fee is refundable upon successfully passing the Microsoft Office Specialist: Microsoft Excel 2010 certification exam.


SELF-PACED PRE-WORK


This training focuses on a particular version of Microsoft Excel - 2010. This version is only available for Microsoft Windows and as such Microsoft Office 2011 (Mac version) can not be used for the training program.

The pre-work consists of a Microsoft IT Academy training module that covers the basics of Microsoft Excel. The training is self-paced and we expect it to take 2-3 hours to complete.

You must complete this training module before attending the workshop.

The module is web-based and requires Internet Explorer 7 or higher to run. An email invitation will be sent to all participants from Microsoft IT Academy detailing how to access the module on the Microsoft IT Academy website at the conclusion of the registration period.

back to top >

WORKSHOP


An all-day workshop will be held Saturday, January 26 in Lender Auditorium at the Whitman School of Management. The Excel 2010 workshop will be presented by professional trainers on intermediate topics on Excel.


Topic

Time

Breakfast (Coffee/Danish provided by Whitman) 8:30-9:00
Introduction of Facilitators; Expectations for the Day 9:00-9:10
Lesson 1:  Formatting Cells & Worksheets 9:10-9:35
Lab 1 9:35-10:05
Lab 1—Review 10:05-10:20
Lesson 2:  Applying Formulas and Functions 10:20-10:50
Lab 2 10:50-11:20
Lab 2—Review 11:20-11:35
Lesson 3:  Analyzing and Organizing Data 11:35-12:00
Lunch - On Your Own 12:00-1:00
Lab 3 1:00-1:20
Lab 3—Review 1:20-1:30
Lesson 4:  Presenting Data Visually 1:30-2:00
Lab 4 2:00-2:30
Lab 4—Review   2:30-3:00
Lesson 5 & 6:  Graphic Objects & Misc 3:00-3:30
Lab 5 & 6 3:30-3:45
Lab 5—Review 3:45-4:00
Wrap Up & Questions 4:00-4:30

back to top >

CERTIPREP


Students who have registered will be given access to Certiport's Certiprep software, a test preparation and self-paced learning tool for getting ready for the Microsoft Office Specialist: Excel 2010 exam.

All test candidates must register an account with Certiport. Each person will only ever need one Certiport login username. If you forget your password, click the Forgot Password link in the top-right corner of the Web page. If you are unsure whether you have previously registered, please call (888)999-9830.

Complete the General Registration process by entering the required information on each screen. The final step in the registration process allows you to Choose a Purpose for registering at Certiport.com. As a test candidate, please select theTake an exam option and click the Next button. This action will register you as a Test Candidate and display a summary screen.  Click the Finish button and Certiport will automatically take you to your personalized Test Candidate page.

This Certiport login will be needed when starting the exam.  The proctor will verify each test candidate’s identification and login prior to starting the exam.

To access Certiprep , you will need the following:

  • A Certiport.com account
  • A Certiprep licenses key, included in the email you received from Whitman Technology Services after registration
  • The Certiprep client software (Windows only)*

Please click here to download the User Guide for Certiprep and follow the instructions in the User Guide to download and install the software, get registered, and start preparing for the exam!

*Alternatively, there are laptops available for checkout from the Whitman 210 comupter lab with the certiport software pre-installed.

back to top >

CERTIFICATION EXAM


The certification exam will be held in room 009 at the Whitman School. You must bring your registration printout when checking in for the exam.

If you believe that you need accommodations for a disability, please contact the Office of Disability Services(ODS), located in Room 309 of 804 University Avenue, or call (315) 443-4498 for an appointment to discuss your needs and the process for requesting accommodations. ODS is responsible for coordinating disability-related accommodations and will issue students with documented Disabilities Accommodation Authorization Letters, as appropriate. Since accommodations may require early planning and generally are not provided retroactively, please contact ODS as soon as possible.  

The Excel 2010 exam is offered through a partnership with Certiport. Please refer to the link below for information on Certiport’s policy and procedure for requests for accommodations: http://www.certiport.com/PORTAL/desktopdefault.aspx?page=common/pagelibrary/Disabilities.htm

The exam dates and times are:

Session 1: Friday, February 8, 1:30-2:30pm
Session 2: Friday, February 8, 3:00pm-4:00pm
Session 3: Saturday, February 9, 1:30-2:30pm
Session 4: Saturday, February 9, 3:00pm-4:00pm
Session 5: Friday, February 15, 1:30-2:30pm 
Session 6: Friday, February 15, 3:00-4:00pm 

To register for an exam session, go to http://whitman.syr.edu/training

back to top >