+ Can I take the advanced training without taking the fundamentals training first?

Most people will need to start at the fundamentals level even if they have been using Excel for some time. The fundamentals course covers a wide range of material, and it is likely that you have gaps in your knowledge if you have not received formal training.

Here are the skills you need before skipping the fundamentals course:

Setting up Workbooks and Worksheets

  • Setting and customizing the print area
  • Hiding and grouping rows or columns
  • Using headers and footers
  • Altering workbook/worksheet views

Managing Data Ranges and Cells

  • Cutting/Copying data and using special paste functions
  • Presenting data with custom currencies, dates, or time formatting
  • Creating and filtering/sorting tables

Formulas and Functions

  • Using formulas such as SUM, COUNT, AVERAGE, MAX, etc.
  • You should also be able to modify these with "IF"
  • Using formulas to manipulate text such as LEFT, UPPER, etc.

Charts and Objects

  • Creating charts and selecting data
  • Using Quick Analysis features
  • Modifying chart layouts and elements
  • Inserting/formatting objects (text boxes, shapes, etc.)

This curriculum is based off the Microsoft Office Specialist Excel exam, which you can read about here.

+ If I attend a training course, will I be able to access the digital training resources?

Those who have previously attended a training course will receive a discount code for 50% off digital training materials. Many of the practice tests and study guides are shared between the courses, but the Digital Training package offers many more tutorial videos.

+ How do I get a Microsoft Office Specialty Certificate?

Alt + F11 will offer a proctor a certification exam one week after the Fundamentals Training Course, or with special arrangements. Please contact us for scheduling information, and remember to purchase the Examination Fee, which is not included in the course registration.

You may also locate and contact a testing center in your area which offers the appropriate test. The fees and testing schedule may vary.

To take the certification exam, please locate and contact a testing center in your area which offers the appropriate test. The fees and testing schedule may vary.

There are multiple testing sites in the Seattle area, including North Seattle Community College, Bellevue Community College, some King County Libraries, and more.

The Seattle Pacific University testing center is only available to enrolled students.

Still have questions?