Picture of hands typing on a laptop with graphing software on screen

Microsoft Excel Classes

Microsoft Excel

Microsoft Office Specialist Certification Class

Learn the core functions of Microsoft Excel in this 7-week certification prep course available free to Idaho Falls Public Library patrons. At the end of the course, you will be ready to sit for the Microsoft Office Specialist Excel 2016 certification exam (77-727). The exam is free for our patron students.

June 4 Registration Update: We’ve had dozens of students sign up in the last 48 hours. We’re sending welcome messages as quickly as possible and are focusing first on those who sign up for our classroom study format (since classes started today). We will message our online/self-study students right after. If you haven’t received an email yet, check your spam folder for messages from “Russ Nash”. No welcome email there? Watch for a reply in the next day or so. We look forward to meeting each of you!

Classroom Study

This course is available in two formats. The first is a 45-minute class taught in our library computer room. This format is best for those who like the structure of a class or who are completely new to Microsoft Excel.

In this format, you would attend class twice/week on Tuesdays and Thursdays at 12pm or 8pm during one of the following sessions.

Session 1

  1. June 5 – Overview
  2. June 7 – Working with Excel 2016
  3. June 12 – Using Office Backstage
  4. June 14 – Using Basic Formulas
  5. June 19 – Using Functions
  6. June 21 – Formatting Cells and Ranges
  7. June 26 – Formatting Worksheets
  8. June 28 – Managing Worksheets
  9. July 3 – Data and Macros
  10. July 5 – Using Advanced Formulas
  11. July 10 – Securing Workbooks
  12. July 12 – Creating Charts
  13. July 17 – Pictures and Shapes

Session 2

  1. July 24 – Overview
  2. July 26 – Working with Excel 2016
  3. July 31 – Using Office Backstage
  4. August 2 – Using Basic Formulas
  5. August 7 – Using Functions
  6. August 9 – Formatting Cells and Ranges
  7. August 14 – Formatting Worksheets
  8. August 16 – Managing Worksheets
  9. August 21 – Data and Macros
  10. August 23 – Using Advanced Formulas
  11. August 28 – Securing Workbooks
  12. August 30 – Creating Charts
  13. September 4 – Pictures and Shapes

 Click here to download our class flyer (pages 3-4)

Online, Self-Paced Study

Our second format is a self-paced, online format that allows you to study from the convenience of home or work. This format is best for those who have limited time, who are already familiar with the basics of Microsoft Excel 2016 (or with an older version), and who are independent, self-motivated learners. Learn more about our self-study resources.


  • Idaho Falls Public Library card
  • Email account
  • Personal computer
  • Internet access
  • Microsoft Excel 2016
  • Headphones or earbuds (if you study in our computer lab)


  • Attend weekly lab sessions on Tuesdays at 5pm to practice for the MOS exam and ask questions. We hold our labs in our library computer room.

Scroll down for information on signing up and getting started.


Once your complete your studies, you will be ready to take the Microsoft Office Specialist (MOS) Excel 2016 certification exam (77-727). Why certify?

  • It’s free, if taken through the library
  • It helps you demonstrate your knowledge to an employer
  • It could improve your resume and work prospects with prospective employers

You will learn more about the certification exam during class.

Get Started

Getting started is simple. Follow the steps below:

  1. Do you have an Idaho Falls Public Library card? (No? Learn how to sign up)
  2. Enroll in our Community Education Program.
  3. Create free, online accounts with Microsoft and Certiport.
  4. Create free, online accounts with Lynda.com and the Learning Express Library.
  5. Accept our invitation to enroll in our Microsoft Imagine Academy.
  6. Complete your recommended online coursework.
  7. Attend weekly lab sessions to ask questions and practice for the exam.
  8. Let us know when you’re ready for the exam by scheduling a testing time.

For more information about Microsoft Word certification classes, please call 208-612-8329.