Exam 77-420 Microsoft Excel 2013

welcome to the Microsoft Offcial Academic Course (MOAC) program for Microsoft Offce 2013. MOAC represents the collaboration between Microsoft learning and John wiley & Sons, Inc. publishing company. Microsoft and wiley teamed up to produce a series of textbooks that deliver compelling and innovative teaching solutions to instructors and superior learning experi-ences for students. Infused and informed by in-depth knowledge from the creators of Microsoft Offce and windows, and crafted by a publisher known worldwide for the pedagogical quality of its products, these textbooks maximize skills transfer in minimum time. Students are challenged to reach their potential by using their new technical skills as highly productive members of the workforce.

Because this knowledgebase comes directly from Microsoft, architect of the Offce 2013 system and creator of the Microsoft Offce Specialist (MOS) exams (www.microsoft.com/learning/mcp/mcts), you are sure to receive the topical coverage that is most relevant to students’ personal and professional success. Microsoft’s direct participation not only assures you that MOAC textbook content is accurate and current; it also means that students will receive the best instruction possi-ble to enable their success on certifcation exams and in the workplace.

Table of Contents

Lesson 1: Overview
Lesson 2: Working with Microsoft Excel 2013
Lesson 3: Using Office Backstage
Lesson 4: Using Basic Formulas
Lesson 5: Using Functions
Lesson 6: Formatting Cells and Ranges
Lesson 7: Formatting Worksheets
Lesson 8: Managing Worksheets
Lesson 9: Working with Data and Macros
Lesson 10: Using Advanced Formulas
Lesson 11: Securing and Sharing Workbooks
Lesson 12: Creating Charts
Lesson 13: Adding Pictures and Shapes to a Worksheet
Appendix: Microsoft Office Specialist (MOS) Skills for Excel 2013: Exam 77-420