Since I did a lot of study in Excel the
Specialist level was quite easy and tricky at the same time.
Easy as I know the formulas and learn how to do
Charts and Graphs.
Tricky as you have to make sure that you must not have typos or incorrect spelling on each field as this can cost you points and end up failing.
When I started the Expert stages the exams was very hard as you are expose to deeper formulas and Charts as you ever. I have to understand more of Data tools and how to filter out the data, how to link Spreadsheet to another, even the LOOKUPS, yes, VLOOKUP as that caught me out many years ago and now learned more of it.
Tricky as you have to make sure that you must not have typos or incorrect spelling on each field as this can cost you points and end up failing.
When I started the Expert stages the exams was very hard as you are expose to deeper formulas and Charts as you ever. I have to understand more of Data tools and how to filter out the data, how to link Spreadsheet to another, even the LOOKUPS, yes, VLOOKUP as that caught me out many years ago and now learned more of it.
You also have to understand nested formulas (formulas combined inside the main formula).
I am not going to write an example on this blog
because of NDA (Non-Disclosure Agreement) rules.
So I did so many attempts on both parts. I did
pass Part 1 weeks ago. I done so many retakes for Part 2 as I have to remember the
nested formulas.
I have finally passed Part 1 & 2 on the
Expert level.
Exams required:
Exams required:
77-420 - MOS: Microsoft Office Excel 2013
77-427 - MOS: Microsoft Office Excel 2013 Expert Part 1
77-428 - MOS: Microsoft Office Excel 2013 Expert Part 2
77-427 - MOS: Microsoft Office Excel 2013 Expert Part 1
77-428 - MOS: Microsoft Office Excel 2013 Expert Part 2
No comments:
Post a Comment