Exam 77-420 Microsoft Excel 2013

by Unknown

• ISBN13: 9780470133088
• ISBN10: 0470133082
• Edition: 1st
• Format: Paperback
• Copyright: 2013-08-12
• Publisher: Wiley

Summary

This Microsoft Excel 2013, Exam 77-420 book is the only Microsoft Official Academic Course (MOAC) textbook. This series includes a complete classroom instructional program. This Excel 2013 text is mapped to the Excel 2013 certification exam  objectives and is designed to re-enforce workforce skills. With  this book students learn to create and edit professional-looking spreadsheets for a variety of purposes and situations. It also covers such skills as charting, creating analytical, financial reports, data entry, developing budgets, formatting numerical (financial, statistical, etc.) reports, creating forms,  graphing, processing data, reporting, technical support, trending  and much more. The Microsoft Official Academic Course (MOAC) Office series also  offers OfficeGrader. This valuable tool corrects your  students tasked-based assignments. Students work on  real-world problems like the ones they will encounter in the  workforce ensuring they are ready for real professional  challenges. OfficeGrader allows for efficient and  consistent grading saving time for other important teaching  activities. Grading is easier than ever allowing faster assignment  turnaround to students. Excel 2013 certification can help students with classwork and differentiate job hunters in todays competitive job market.  Students who have earned certification can  broaden their employment opportunities in such fields as accounting, office administration, consulting, as executives and managers, help desk personnel, instructors/trainers, program/project managers, and sales careers.  

Author Biography

The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student—technical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.

Table of Contents

1.   Overview

2.   Working with Microsoft Excel 2013

3.   Using Office Backstage

4.   Using Basic Formulas

5.   Using Functions

CIRCLING BACK 1    

6.    Formatting Cells and Ranges

7.    Formatting Worksheets

8.    Managing Worksheets

9.    Working with Data and Macros

CIRCLING BACK 2    

10.   Using Advanced Formulas

11.   Securing and Sharing Workbooks

12.   Creating Charts

13.    Adding Pictures and Shapes to a Worksheet

14.    Creating PivotTables

Normal0falsefalsefalseEN-USZH-CNX-NONE<![endif]--><![endif]--><![endif]-->