MOS 2013 Study Guide for Microsoft® Excel®

Table of contents

1. Introduction
   1. Who this book is for
   2. How this book is organized
   3. Download the practice files
   4. Get support and give feedback
      1. Errata
      2. We want to hear from you
      3. Stay in touch
2. Taking a Microsoft Office Specialist Exam
   1. Microsoft Office Specialist certification
   2. Selecting a certification path
   3. Test-taking tips
   4. Certification benefits
   5. For more information
3. I. Exam 77-420: Microsoft Excel 2013
   1. 1. Create and Manage Workbooks and Worksheets
      1. 1.1 Create workbooks and worksheets
         1. Creating new workbooks and worksheets
         2. Reusing existing content
      2. 1.2 Navigate through worksheets and workbooks
         1. Locating data and worksheet elements
         2. Inserting hyperlinks
      3. 1.3 Format worksheets and workbooks
         1. Modifying page setup
         2. Inserting page elements
         3. Changing workbook themes and colors
         4. Modifying rows and columns
         5. Configuring data validation
      4. 1.4 Customize options and views for worksheets and workbooks
         1. Displaying different views of worksheets
         2. Displaying multiple parts of a workbook
         3. Hiding and displaying workbook content
         4. Customizing the Quick Access Toolbar
         5. Customizing the ribbon
         6. Working with macros
         7. Modifying workbook properties
      5. 1.5 Configure worksheets and workbooks to print or save
         1. Printing workbook content
         2. Saving workbooks
      6. Objective review
   2. 2. Manage Cells and Ranges
      1. 2.1 Insert data in cells and ranges
         1. Creating data
         2. Reusing data
      2. 2.2 Format cells and ranges
         1. Formatting cell structure
         2. Formatting cell content
         3. Applying number formats
         4. Copying formatting
      3. 2.3 Order and group cells and ranges
         1. Modeling data
         2. Creating named ranges
         3. Working with data groups and summaries
      4. Objective review
   3. 3. Manage Tables
      1. 3.1 Create tables
      2. 3.2 Modify tables
      3. 3.3 Filter and sort tables
      4. Objective review
   4. 4. Apply Formulas and Functions
      1. 4.1 Utilize cell ranges and references in formulas and functions
         1. Referencing cells and cell ranges in formulas
         2. Defining order of operations
      2. 4.2 Summarize data by using functions
      3. 4.3 Utilize conditional logic in functions
      4. 4.4 Format and modify text by using functions
      5. Objective review
   5. 5. Create Charts and Objects
      1. 5.1 Create charts
      2. 5.2 Format charts
      3. 5.3 Insert and format objects
         1. Adding pictures to sheets
         2. Adding text boxes to sheets
         3. Adding SmartArt graphics to sheets
      4. Objective review
4. A. About the Author
   1. Online Training Solutions, Inc. (OTSI)
      1. The team
5. Index
6. About the Author
7. Copyright