Read more
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.
List of contents
Lesson 1: Overview
Lesson Skill Matrix
Key Terms
Software Orientation
Starting Excel
Opening Excel
Working in the Excel Window
Using Onscreen Tools
Navigating the Ribbon
Introducing Office Backstage
Using the Microsoft Office FILE Tab and Backstage View
Changing Excel's View
Change Excel's View
Splitting a Window
Workplace Ready: Large Workbooks
Opening a New Window
Working with an Existing Workbook
Opening an Existing Workbook
Opening a Workbook from Your SkyDrive
Navigating a Worksheet
Navigating Data with the Go To Command
Working with Excel's Help System
Using the Help System
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Lesson 2: Working with Microsoft Excel 2013
Lesson Skill Matrix
Key Terms
Creating Workbooks
Creating a Workbook from Scratch
Switching Between Open Workbooks
Saving Workbooks
Naming and Saving a Workbook
Workplace Ready: Organization File Conventions
Saving to Your Skydrive
Saving a Workbook Under a Different Name
Saving a Workbook in a Previous Excel Format
Saving in Different File Formats
Entering and Editing Basic Data in a Worksheet
Entering Basic Data in a Worksheet
Changing Column Width
Editing a Cell s Contents
Deleting and Clearing a Cell s Contents
Using Data Types to Populate a Worksheet
Entering Labels and Using AutoComplete
Entering Numeric Values
Entering Dates
Filling a Series with Auto Fill
Filling Cells with Flash Fill
Cutting, Copying, and Pasting Data
Copying a Data Series with the Mouse
Moving a Data Series with the Mouse
Copying and Pasting Data
Cutting and Pasting Data
Editing a Workbook s Properties
Assigning Keywords
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Lesson 3: Using Office Backstage
Lesson Skill Matrix
Key Terms
Software Orientation
Accessing and Using Backstage view
Printing With Backstage
Printing and Previewing a Document
Using Quick Print to Print a Worksheet
Setting the Print Area
Printing Selected Worksheets
Printing Selected Workbooks
Applying Printing Options
Changing a Printer
Changing the Excel Environment
Customizing the Quick Access Toolbar
Customizing the Ribbon
Customizing the Excel Default Settings
Resetting Default Settings, Ribbon, and Quick Access Toolbar
Accessing and Using Excel Templates
Selecting a Template from the New Tab
Searching for Additional Templates
Workplace Ready: Job Interview Hint
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Lesson 4: Using Basic Formulas
Lesson Skill Matrix
Key Terms
Software Orientation
Understanding and Displaying Formulas
Understanding Order of Operations
Building Basic Formulas
Creating a Formula that Performs Addition
Creating a Formula that Performs Subtraction
Creating a Formula that Performs Multiplication
Creating a Formula that Performs Division
Using Cell References in Formulas
Using Relative Cell References in a Formula
Using Absolute Cell References in a Formula
Workplace Ready: Absolute Cell References for Payroll Tracking
Using Mixed Cell References in a Formula
Using External Cell References
Using Cell Ranges in Formulas
Naming a Range
Changing the Size of a Range
Creating a Formula that Operates on a Named Range
Keeping Track of Named Ranges
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Lesson 5: Using Functions
Lesson Skill Matrix
Key Terms
Software Orientation
Exploring Functions
Displaying Dates and Times with Functions
Exploring Dates
Using TODAY
Using NOW
Workplac
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.
