Albers School of Business and Economics
Student Resources

Excel Certification

  • Earning a Microsoft Specialist Certification can help differentiate you in today's competitive job market and broaden your employment opportunities. All Albers undergraduate students are required to pass EXCEL 2010 Level I Certification in order to progress in your BABA or BAE program. For more information about the requirements and how to prepare for the certification exam, visit Microsoft's Exam Details page

    Four Steps to Sign up for the Exam

    • Reserve a time slot
    • Register with Certiport
    • Buy a voucher
    • Prepare for the Exam

    Reserve a time slot

    You can reserve a time to take the exam at Albers' Brown Paper Tickets page - registration is required whether it is your first time or a retake. There is no charge to register for an exam session, but please register for only one session at a time - if you are signed up for multiple sessions at once, all of your registrations will be cancelled. If you do not pass the exam you may then register for another session. The exams are held in Pigott 328.

    Register with Certiport

    You must register with prior to your test date. It is essential that you input your student ID in the "Student/Employee ID" field during the Certiport registration process. Failure to input your student ID may cause a delay in processing your test results. Please complete the Microsoft registration as well at the end of the Certiport registration process.

    If you have a disability that might interfere with your performance on this test, you will need to arrange support services first with Certiport. In addition, contact, to arrange a testing time through Disabilities Services.

    Buy a Voucher

    Vouchers can be purchased at the SU Campus Store or online, the voucher at the bookstore includes one retake if necessary. Please purchase your voucher prior to your test date.

    Prepare for the exam

    There are five resources available to help: a workshop, two online study tools, a physical book, and a practice exam that simulates the actual exam. Utilizing this study material is highly recommended as the exam is very difficult.

    GMetrix SMS

    GMetrix SMS 3.2 simulates the exam environment and includes two modes, Training and Testing:

    • Testing mode is the most accurate representation of Microsoft's Excel certification exam, it is a timed test and no feedback is given until the test is completed. After the practice test is completed your results are displayed with a score for each of the major topic areas (listed below). Use these results as guideline to which areas you should focus on.
    • Training mode gives feedback immediately after each question so you can try again on incorrect answers, and it provides the option of viewing the correct answer for each question.

    You may take any of the practice or training tests as many times as you want, it is recommended that students complete all three practice tests at least once. Students who complete all three practice tests are usually successful on their first attempt to pass the official exam.

    GMetrix can be found on all computers in the computer labs and Lemieux Library. Windows users with Office 2010 installed can also download the exam software to their own computers at If you use a Mac or do not have Office 2010 on your own computer, you can access GMetrix by visiting, downloading the VMWare client if necessary, and connecting to the Seattle University Virtual Lab desktop. GMetrix is found under Albers Applications. Enter the code below to access a full-length practice test.

    GMetrix access codes

    You will need to email from your SeattleU email account to get a GMetrix access code, or you can visit the Albers Front Desk in person to request a code.

    Excel Workshop

    There will be two voluntary two-day workshops offered each quarter to help you prepare for the EXCEL certification exam. Additional preparation and review hours outside of the workshop hours are necessary for success. The fee for the workshop is $50, and the workshops for Winter 2015 are scheduled:

    • Two Thursdays, April 9th and 16th, 2 p.m. - 5 p.m.
    • Two Saturdays, April 25th and May 2nd, 10 a.m. - 1 p.m.

    Both workshops will take place in Pigott 328 and will be presented by Liz Wick, Albers Tech Support Specialist. She has achieved the Microsoft Office Certified Master level.

    To sign-up for the workshop you should first go to Pigott 318 and tell the front desk staff that you want to sign-up for the EXCEL Workshop . You will be given a short form to fill in your Name and ID number, and circle either the Friday or the Saturday workshop. Second, go to Pigott 319 to give either a check or credit card information to the Albers Budget Manager who is generally available between 8:30 -12 p.m. and 1 - 3:30 p.m. You must give her your check or credit card information in person.

    Microsoft IT Academy

    Seattle University is member of the Microsoft IT Academy program, which provides on-line software training. Microsoft Internet Explorer (version 8.0+) is recommended for logging on to IT Academy. Click the link above, select "Organizational account", and sign in with your Seattle University email and password.

    IT Academy access code: 7612-ALBERS-9007

    Once you have logged in, you can automatically add the following courses to your "My Courses" list by clicking the dropdown link next to your name, select "Redeem enrollment code" and enter the Enrollment code listed below. (You can also manually search for and add these recommended courses individually):

    Excel Courses Enrollment code: HLR8L7AS3SJDYV

    • Course 10296: Beginner Skills in Microsoft Excel 2010
    • Course 10393: Intermediate Skills in Microsoft Excel 2010
    • Course 10394: Advanced Skills in Microsoft Excel 2010
    • Course 10283: What's New in Microsoft Excel 2010 provides video-based tutorials with downloadable exercise files for you to follow along and perform the same tasks demonstrated in the videos. Sign in with your Seattle University username and password at the Seattle University Lynda Portal.

    Click recommended viewing on to see a list of the most relevant Lynda courses, or search for "Excel 2010" to see all available Excel 2010 courses.

    Official Course Text

    The SU Campus Store offers the Wiley Microsoft Excel 2010 textbook for $93, specifically designed to walk through subjects tested on the Excel exam (ISBN: 978-0-470-90767-2)

    Frequently Asked Questions

    Q. How many times can I take the Excel certification exam?

    A. You can take the exam as many times as necessary to pass… BUT, you will need a unique voucher number each time. The voucher you buy through the Seattle University Bookstore includes one free retake voucher if necessary. You must use the retake voucher within 30 days of your initial exam.

    Q. How much does a test taking voucher cost?

    A. You can purchase your exam voucher at the SU Campus Store. The voucher with one free retake costs approximately $99 plus sales tax. If you purchase your voucher on the Certiport website, it will cost $115.

    Q. How long do I have to pass the exam and when will the registration hold be put on my account?

    A. Transfer students have until the end of their first quarter at Seattle U to pass the exam before a registration hold will be put on their account. Freshmen have to pass the exam before they complete 45 credits at Seattle University. If at the end of the quarter a student has not passed the exam, a hold will be put on their account and affect their ability to register for the following quarter. For example, fall transfers who have not passed the exam by the end of the fall quarter will not be able to register for spring classes.

    If you have any further questions, please email

    Skills measured on the Excel Exam
    (Exam 77-882)

    Major topic Area


    Additional Preparation Resources

    1-Managing the Worksheet Environment
    1.1-Navigate through a worksheet
    1.2-Print a worksheet or workbook
    1.3-Personalize environment by using Backstage
    A fast way to navigate between Excel worksheets
    Print a worksheet or workbook
    Video: Backstage view in Excel 2010  
    2-Creating Cell Data  
    2.1-Construct cell data
    2.2-Apply AutoFill
    2.3-Apply and manipulate hyperlinks
    Move or copy cells and cell contents
    How to use the auto fill options button in Excel
    Create, select, edit, or delete a hyperlink  
    3-Formatting Cells and Worksheets  
    3.1-Apply and modify cell formats
    3.2-Merge or split cells
    3.3-Create row and column titles
    3.4-Hide and unhide rows and columns
    3.5-Manipulate Page Setup options for worksheets
    3.6-Create and apply cell styles
    Quick start: Format a worksheet
    Merge and unmerge cells
    Print row and column headings or labels on every page  
    4-Managing Worksheets and Workbooks
    4.1-Create and format worksheets
    4.2-Manipulate window views
    4.3-Manipulate workbook views 
    Insert or delete a worksheet
    View two or more worksheets at the same time
    Create, apply, or delete a custom view  
    5-Applying Formulas and Functions
    5.1-Create formulas
    5.2-Enforce precedence
    5.3-Apply cell references in formulas
    5.4-Apply conditional logic in a formula (<,>,=)
    5.5-Apply named ranges in formulas
    5.6-Apply cell ranges in formulas
    Overview of formulas
    Get to know Excel 2010: Create formulas
    Creating conditional formatting formulas  
    6-Presenting Data Visually
    6.1-Create charts based on worksheet data
    6.2-Apply and manipulate illustrations
    6.3-Create and modify images by using the Image Editor
    6.4-Apply Sparklines
    Insert a picture or clip art
    Change the brightness, contrast, or blurriness of a picture
    Sparklines: Use tiny charts to show data trends  
    7-Sharing worksheet data with other users
    7.1-Share spreadsheets by using Backstage
    7.2-Manage comments
    Use a shared workbook to collaborate
    Save a document to your OneDrive from Office 2010
    Annotate a worksheet by using comments  
    8-Analyzing and Organizing Data
    8.1-Filter data
    8.2-Sort data
    8.3-Apply conditional formatting
    Quick start: Filter data by using an AutoFilter
    Quick start: Sort data in a worksheet
    Manage conditional formatting rule precedence