the complete guide to microsoft excel 2013 syllabus

7/26/2019 The Complete Guide to Microsoft Excel 2013 Syllabus

1/8

The Complete Guide to Microsoft Excel 2013 Syllabus

This course accurately and casually provides an introductory audience with anunderstanding of the needed information to pass the Microsoft Oce SpecialistCertication Series. Its uniqueness and accuracy of content stands out among othercourseware !"rocert #ovem$er %&''( Students learn the commands in practicalreal world applications. "erfect for oce wor)ers professionals and students whowant to )now $oth how and when to $est apply Microsoft *+cel.

Course Prerequisites, Students who enroll in the Complete -uide to Microsoft*+cel %&' should have $asic computer s)ills including how to turn on thecomputer how to use an Internet $rowser and how to select commands from amenu or tool$ar. Students should )now how to save les and send attachments $yemail as well.

Taret !udie"ce, The Complete -uide to Microsoft *+cel %&' is for students toimprove their level and $readth of )nowledge with Microsoft *+cel functions inpreparation for ta)ing the Microsoft Certication *+am. The course includes $othrecall and authentic assessments to measure student understanding at anincreasingly advanced level. Students will $e wor)ing hands/on with the commandsand completing sample pro0ects to reinforce learning. This course does not rely ona$stract learning $ut on the program in conte+t.

The primary instruction is related to $usiness applications of *+cel as Microsoft*+cel is used in most wor)places. #early every $usiness has a use for MicrosoftOce programs from inter/oce memos composed on Microsoft 1ord to Salespresentations created with Microsoft "ower"oint to 2udget spreadsheets compiled inMicrosoft *+cel. 3 secondary target group is teachers who can use Microsoft Ocefor $oth teacher preparation and record/)eeping as well as in student assignments.4astly home users may nd many uses for Microsoft Oce similar to those used inthe wor)place. Microsoft Oce is a u$iquitous product with great possi$ilities. Thiscourse aims to e+pose users to those possi$ilities.

Students for *+am 55/6%&, Microsoft *+cel %&' or *+am 55/6%5 and 55/6%7Microsoft *+cel *+pert %&' should have the equivalent of si+ months of hands/oncomputer e+perience $efore ta)ing the e+am. These e+am candidates should $eprocient at le management. in addition students should $e a$le to readilyidentify and use the commands for at least 7&8 of the e+am o$0ectives inpreparation for ta)ing the timed e+am. 3mongst the s)ills necessary students

should $e especially e9ective at entering information and analy:ing data.Successful students will have mastered how to create and edit formulas auditequations insert and format visual data presentations and present information incharts and ta$les.

Microsoft Certi#catio"This course is also an e+am study guide for the following certication tests,Excel 2013 Core: Exam 77-420

Microsoft Excel 2013 Certification Training Course Syllaus !age 1of 8
http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/mos2013.htmlhttp://www.microsoft.com/learning/en-us/exam-77-420.aspxhttp://www.microsoft.com/learning/en-us/exam-77-420.aspxhttp://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/mos2013.html


2/8

Excel 2013 Ex"ert !art 1: Exam 77-427Excel 2013 Ex"ert !art 2: Exam 77-42#

http://www.microsoft.com/learning/en-us/exam.aspx?ID=77-427http://www.microsoft.com/learning/en-us/exam.aspx?ID=77-428http://www.microsoft.com/learning/en-us/exam.aspx?ID=77-427http://www.microsoft.com/learning/en-us/exam.aspx?ID=77-428


3/8

This course teaches the follo$i" Exam %%&'20( Microsoft Excel 2013)b*ecti+es1,0 Create a"d Ma"ae -or.sheets a"d -or.boo.s

1,1 Create -or.sheets a"d -or.boo.s'.'.' Create #ew 2lan) 1or)$oo)s'.'.% Create #ew 1or)$oo)s ;se Templates

'.'. Import 3d0ust Aow @eight and Column 1idth'..? Insert 1atermar)s'..5 Insert @eaders and .> Aepeat @eaders and .5 Congure 1or)$oo)s to "rint'.>.7 Save


4/8

2,1 5"sert 6ata i" Cells a"d 4a"es%.'.' 3ppend =ata to 1or)sheets%.'.%


5/8

6.%. =emonstrate @ow to 3pply The CO;#T .'.6 =emonstrate @ow to ;se uic) 3nalysis

,2 ormat ! Chart>.%.' 3dd 4egends>.%.% Aesi:e Charts and -raphs>.%. Modify Chart and -raph "arameters>.%.6 3pply Chart 4ayouts and Styles>.%.> "osition Charts and -raphs

,3 5"sert a"d ormat !" )b*ect>..' Insert Te+t 2o+es>..% Insert Smartart>.. Insert Images>..6 3dd 2orders to O$0ects>..> 3dd Styles and *9ects to O$0ects

>..? Change O$0ect Colors>..5 Modify O$0ect "roperties>..7 "osition O$0ects

This Course Teaches the ollo$i" Exam %%&'2% a"d '28 Microsoft ExcelExpert 2013 )b*ecti+es1,0 Ma"ae a"d Share -or.boo.s

1,1 Ma"ae Multiple -or.boo.s'.'.' Modify *+isting Templates'.'.% Merge Multiple 1or)$oo)s'.'. Manage Bersions Of 3 1or)$oo)'.'.6 Copy Styles Copy Macros


6/8

'.%.6 Aestrict *diting'.%.> Control Aecalculation'.%.? "rotect 1or)sheet Structure'.%.5 Mar) 3s


7/8

.%.6 =emonstrate @ow to ;se The TA3#S"OS*


8/8

55, 5"termediate Guide to Microsoft Excel 2013&30 hours

a. 4egs *ggs and "igs, Trou$leshooting formulas and data /> hours >

$. "iggy -oes to Mar)et, ;se and modify T*GT formulas /> hours >

c. #ame that Tune, Create use and trou$leshoot #amed Aanges /> hours >

d. Sound 3dvice, Create and use 4oo)up Ta$les use I< functions /> hours >e. *+cel In "rint, ;se page 4ayout and "age Set up to modify print settings/> hours

>

f. *+cel Online, ;se and modify Spar)lines and hyperlin)s /> hours >

555, !d+a"ced Guide to Microsoft Excel 2013&30 hours

a. 1or)s for MeK Create and modify Ta$les and apply uic) Styles /6 hours 6

$. 1or) Smarter #ot @arder, ;se Sort hours >

d. 1hat =id Jou See !"ivot Charts( Create and modify "ivot Charts and

Slicers/> hours

>

e. 1or)ing Overtime, Create drop/down lists and use =ata Balidation /6hours

6

f. "repare to Share, ;se reviewing tools and permissions/6 hours 6

g. 1or)ing with Macros, Create and use Macros/6 hours 6


the complete guide to microsoft excel 2013 syllabus

Documents