Study Prep for MOS Certifications?

[jwatson1]

https://www.gcflearnfree.org/topics/office2016/

I'm not sure if this is what you're looking for, but at least they're free.

Most helpful answer yet, but I am not looking to become an excel master, I only want to pass the MOS certification. I hactually hate MS office and only doing this for the credit

[SolarKat]

Does your employer have an employee Skillsoft program? (For military members/AD dependents, there used to be a Skillport access program. Don't know if they still offer this - hubs retired in 2011.)

Anyway, if you can't get it via employer, you have a couple of options. Join IEEE as a student, and then join the IEEE Computer Society as a student. (You can add this to your general membership either at the time of signup or later on.) That gets you access to IEEE Skillsoft education. Or join the Association for Computing Machinery...they just changed their membership categories so double check to see which gets you Skillsoft access (ACM Learning Center). Why Skillsoft? Because they have full training programs for a cr@pton of certifications...here's the Skillsoft Certification Catalogue.

ETA - for folks wanting Lynda access but their library doesn't have it...the premium LinkedIn subscription includes Lynda access. Also, for TESU students, we all got memberships to the NJ State Library. I didn't poke in detail, but it seems that with this, we might be able to participate in "LibraryLinkNJ" which *does* include Lynda. (See this page - it seems access to Lynda requires registering & using at set times, I didn't read it).

[sanantone]

Most helpful answer yet, but I am not looking to become an excel master, I only want to pass the MOS certification. I hactually hate MS office and only doing this for the credit

If you look at the link I posted, the course goes over the same topics as the certification test. It's a version older than 2016, but there is not much of a difference between the two. I took a 2010 course using Microsoft Office 2007.

You're focused way too much on study materials that are specifically made for the MOS certifications when all you need are the skills in Excel and Access to pass. Focus on learning the content that is covered by the exam rather than whether or not a study source is specifically targeting the exam.

[dfrecore]

If you look at the link I posted, the course goes over the same topics as the certification test. It's a version older than 2016, but there is not much of a difference between the two. I took a 2010 course using Microsoft Office 2007.

You're focused way too much on study materials that are specifically made for the MOS certifications when all you need are the skills in Excel and Access to pass. Focus on learning the content that is covered by the exam rather than whether or not a study source is specifically targeting the exam.

EXACTLY!

And yes, if you want to pass the MOS certification exam, becoming very good at Excel is one way to do that! I could probably pass right now because I've spent the last 20 years using Excel, almost on a daily basis. Since the exam is a hands-on test, where you have to DO some things with Excel, just knowing the answers to some questions isn't enough. You need to know what you're doing with the program, in order to move quickly enough through all of the material to pass.