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

    Registering for the exam

    You can reserve a time to take the exam at Albers' Brown Paper Tickets page. There is no charge to register for an exam session, but please register for one session only - if you are signed up for multiple sessions only the earliest session will be accepted. The exams are held in Pigott 328.

    You must register with Certiport.com prior to your test date. It is essential that you input your student ID during the Certiport registration process. Failure to input your student ID may cause a delay in processing your test results.

    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 AlbersExcel@seattleu.edu, to arrange a testing time through the Learning Center.

    You will also need to purchase a voucher at the SU Campus Store prior to your test date.

    Study Resources

    There are four resources available to help: a practice exam, two study tools, and a physical book. 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 on their own computers at GMetrix.net. If you use a Mac or do not have Office 2010 on your own computer, you can access GMetrix by visiting http://vlab.seattleu.edu, 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 code: 60628-ALBERS-79023

    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):

    • Course 10296: Beginner Skills in Microsoft Excel 2010
    • Course 10393: Intermediate Skills in Microsoft Excel 2010
    • Course 10283: What's New in Microsoft Excel 2010

    Excel Courses Enrollment code: HLR8L7AS3SJDYV

     Lynda.com

    Lynda.com provides video-based tutorials with downloadable exercise files for you to follow along and perform the same tasks. Sign in with your Seattle University username and password at the Seattle University Lynda Portal.

    Recommended viewing on Lynda.com

    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 AlbersExcel@seattleu.edu.

    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