Becoming a Certified Microsoft Office Specialist

Mike Splane 2016

 

What is Microsoft Office Specialist Certification? Time = 4:43

https://www.youtube.com/watch?v=bT6G6PVxqNA

 

Information About Taking the Exam

Signing up for the exam is a two-part process. First you go to Certiport to create your account and to search for a specific exam.

http://www.certiport.com/portal/desktopdefault.aspx?tabid=672&roleid=101

 

Then you pick a testing center to actually take the exam. Certiport has a search tool on their website to help you find a testing center near you. http://www.certiport.com/Locator

 

 

The exam is timed. IIRC I had 90 minutes to complete it. Even with the time it took me to figure out how to do unfamiliar tasks I still had plenty of time left over, about 20 minutes.

 

You have to do each task using the specific method they ask for, with no intermediate steps and without using shortcut keys. If you have to do some trial and error to figure out how to complete a task, press the RESET button when you have it figured out. Then, to earn full credit, go back and complete the task again, without using shortcut keys.

 

Review of the 2016 Excel Exam 12:57

Sample CMOS Test Questions

I have created a workbook to accompany these videos. Download it here.

http://bus91l.altervista.org/Data/CMOSPrep.xlsx

 

Worksheet Skills Graphics

Create a Chart Time = 3:33

https://www.youtube.com/watch?v=TZxcoUhCLjk

 

Format a Chart Time = 3:13

https://www.youtube.com/watch?v=Gksy2anwCqw

 

Insert and Format Objects Time = 4:55

https://www.youtube.com/watch?v=1kMGv_Kqnvo

 

Create a Trendline Time = 0:34

https://www.youtube.com/watch?v=o34x1h-Byw4

 

Apply Conditional Formatting Time = 1:00

https://www.youtube.com/watch?v=YSdQKNIniJU

 

Worksheet Skills Functions

Use the SUMIFS Function Time = 0:59 Not closed captioned.

https://www.youtube.com/watch?v=53KYJOD8Axs

 

Use the VLOOKUP Function Time = 1:03 Not closed captioned.

https://www.youtube.com/watch?v=YVemT_-k1zk

 

Data Validation Time = 1:11

https://www.youtube.com/watch?v=osqLK7mB8VU

 

Worksheet Skills Pivot Tables and Macros

Create a Pivot Table Time = 1:12

https://www.youtube.com/watch?v=gilhkjIGNVA

 

Create a Macro Time = 1:00

https://www.youtube.com/watch?v=WB6hMh8SxxY

 

Create a Macro Button Form Control Time = 0:57

https://www.youtube.com/watch?v=pPwabtDFufY

 

Worksheet Skills General Tasks

Protect a Worksheet Time = 1:23 Not closed captioned.

https://www.youtube.com/watch?v=ZzKDQRuOdGQ

 

Enable Background Error Checking Time = 0:41

https://www.youtube.com/watch?v=spL_M30M_u4

 

Use the Evaluate Formulas Tool Time = 1:40

https://www.youtube.com/watch?v=ZmmOa9Z2-Sc

 

Use the Watch Window Time = 0:52

https://www.youtube.com/watch?v=7wCQF_EhYOI

 

Iterative Calculation Time = 0:40

https://www.youtube.com/watch?v=dlmNzM69NSs

 

Trace Formula Precedents Time = 0:40

https://www.youtube.com/watch?v=JsZi-2bqU3c

 

Use the Scenario Manager Time = 1:22

https://www.youtube.com/watch?v=4-WT2u-EBx4

 

Workbook Skills

Track Changes Time = 0:44 Not closed captioned.

https://www.youtube.com/watch?v=lDgKL4wa-AQ

 

Customize Printer Settings

From 10:45 to 13:45 in this video.

https://www.youtube.com/watch?v=sB0nJlcjFBs

 

Change Document Settings Time = 1:00

https://www.youtube.com/watch?v=k_rHccYchZ8

File Tab -> Info -> Properties (top right) -> Select Advanced Properties

Fill in the fields listed on the Summary tab and on the Custom tab. Click Ok.

 

Sharing a Workbook Time = 0:46 Not closed captioned.

https://www.youtube.com/watch?v=x9FJ5UOi6K4

 

Mark a Workbook as Final and Save It. Time = 0:40

https://www.youtube.com/watch?v=mR4iV8Fs5hY

 

Encrypt a Workbook Time = 1:02 Not closed captioned.

https://www.youtube.com/watch?v=JJbWU0IZJW0

 

Customizing Excel

http://bus91L.altervista.org/Assignments/Customize.htm

 

 

 

Name _______________________________ Date___________ Section _______

Check for Understanding Excel Certification

Y/N I am prepared to take a general Excel skills test for employment purposes.

Y/N I understand how to sign up for the Certified Microsoft Office Specialist Exam.

Y/N I have watched the CMOS videos covering the topics I was not already clear on.

 

END OF DOCUMENT