17 August 2019

Microsoft Office Specialist 2019 - Part 1: Word Associate

Since one of the local test centre does not provide Office 2019 certification. I found a test centre which provides the latest Office 2019 certification and it is in their house who is the Authorised Test Centre.

I am not going to go into details as this is not about the person's house at the home is the only place in London including the Central London as this is about the Word Associate.

Now, lets get down to this:

Word Associate has the same exam format as Office 2016 like it said from the Microsoft, but in a twist. You may have project which only have one task which you have to look out for. I really enjoyed the exam to be honest with you and a score above 900 points.

The exam is easy because again I learn from Word 2013 & 2016, but there will be new task as the Office has new features so again watch out for it.

Exam required:
MO-100: Microsoft Word (Word and Word 2019)


27 July 2019

Microsoft Office Specialist 2019 & 365 Certification

Since I have achieve the Microsoft Office Specialist 2016 Master.
Now the MOS Office 365/2019 Specialist has just been release this month (July 2019).

Links so far from Microsoft Website:

Associate Tier:
Microsoft Office Specialist: Word Associate (Word and Word 2019)
Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)
Microsoft Office Specialist: PowerPoint Associate (PowerPoint and PowerPoint 2019)
Microsoft Office Specialist: Outlook Associate (Outlook and Outlook 2019)

Expert Tier:
Microsoft Office Specialist: Microsoft Word Expert (Word and Word 2019)
Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019)
Microsoft Office Specialist: Microsoft Access Expert (Access and Access 2019)

The MOS Certification has been change, now there are Certification Path and 1 is the prerequisite:
The 1st Path is known as the MOS: Associate which contains the core exams which now called the Associate. One you obtain the Associate Certificate then you have to complete the 2nd Path: Expert stages, now include Access as the Expert credentials along side with Word and Expert which will work and achieve towards MOS: Expert which is the Master equivalent.

One the Certiport website this will show you the certification path:
https://certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Office-365-and-Office-2019

I have 2 exhibits from my Certification planner showing the Microsoft Office Specialist 2019 path:

Microsoft Office Specialist: Associate (Office 365 and Office 2019):
Pass 3 of 4 Exams to awarded as the Associate




Microsoft Office Specialist: Expert (Office 365 and Office 2019):
Pass 2 of 3 Expert Exams and Associate to awarded as the Expert. 



18 July 2019

Microsoft Office Specialist 2016 Master & the Grand Slam Champion

After the long journey of the Office 2016 and passing all 7 exams. I am not just got the MOS Master of 2016, but capture the Grand Slam for the 2nd time.

I thought I will spend over a year of completing 2 Grand Slam Masters of Microsoft Office Specialist (2013 and 2016) but it turns out it was less than a year.

I am still made history in the Test Centre as I am the only person who pass and achieved all exams in the centre.

Why do I call it historic?
This is because before I sit in all the exams, the test centre were only offer Microsoft Word Core & Expert 2013 and Excel Core 2013 only. This was because students usually takes those exams to prove the skills and stands out for job opportunities. When I willing to take all of the 2013 series, the Examiner has to download all of them as I was the only person who will take them.

The when I become the Grand Slam an MOS Master 2013, they decide to introduce MOS 2016 exams in the test centre. Basically mean that I open the doors to new test takers who want to achieve the not just the Expert status but soon to be Masters just I did.

During the MOS Masters journey I have learned a lot form the exams and skill set which was set before me, I even gained more confident withing my abilities to utilise my work and troubleshoot better than before.

Now I have complete the journey. I can now enjoy Microsoft Office 2019 and Office 365 package as my reward.


15 July 2019

Microsoft Office Specialist 2016 - Part 5: Word 2016 Double

I cannot believe this that I have done Word Double, you heard it! Double! - 2 exams in one day: The Core and the Expert

1st - Word Core 2016 (77-725):
This was easy and a warm up for the Expert. The test is consist on formatting image, insert word and excel document. Learn how to modify styles and do bullet points. I am almost score a perfection on this one with over 900 score.

2nd - Word Expert 2016 (77-726):
This was tricky but I new the skill from the 2013 Expert but few queries on the exams but managed to do it. I slay the Expert with over 800 points on the test..

Now I capture the Word Double, I not just awarded the MOS Master 2016 and earn the Grand Slam.

Exams required:
77-725: MOS Microsoft Word 2016 Core (Core Document Creation, Collaboration and Communication)
77-726: MOS Microsoft Word 2016 Expert (Creating Documents for Effective Communication)


 

05 July 2019

Microsoft Office Specialist 2016 - Part 4: Excel 2016 Double

What a Excel Double it is, from the Walk in the park dead simple to the hard as 'God Mode' it is.

1st - Excel Core 2016 (77-727):
This was easy as I learn expert formulas from Excel Expert 2013 with an outstanding score.
It was matter of mastering formulas, charts and formats. I learn to adapt to SUMs, average and VLOOKUPs.
Did some practice to refresh my skills from the previous version which gave me more skill set for Excel.

2nd - Excel Expert 2016 (77-728):
Unlike the easy core skills, the Expert is one pain of the bane!
I have to learn about Cube which is completely new to me. This one took me alot of learning.
I even have to learn about the 'GetPivotData' formula which I manage to get the hang of. The condition formula which is the bane of all as you have to do the nest condition with the AND and OR function.
I had some issues with the exam which causes delay in rescheduling but after few attempts I finally passed.
On the test day before I passed I though I did not do well as there were more inconsistent formulas which I attempt to do and when the time run out I thought to myself, "there always be next time" and I thought I failed because of this.
But when when I got to the score results, I was shocked that I have passed the exam. Maybe because I did the formula correctly and require more correct answers to score enough to pass.
I am very happy that I have passed but Excel Expert will always be hard ones because of new advanced formulas to learn.

The only thing remaining is Microsoft Word, complete the double and I not just get the Master Certification but also the Grand Slam Champion.

Exams required:
77-727: MOS - Microsoft Office Excel 2016 (Core Data Analysis, Manipulation, and Presentation)
77-728: MOS - Microsoft Office Excel 2016 Expert (Interpreting Data for Insights)