Exploring: Microsoft Office 2013, Volume 1 (Subscription)

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. This book covers introductory Word, Excel, Access, and PowerPoint, with an additional Windows 8 chapter.   Move students beyond the point-and-click.   The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.   Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. NOTE: This is just the spiral bound book with access card  that includes the online. content that used to be on the CD/DVD.    ALERT:  If the student wants access to MyITLab, they would need to order the package ISBN that includes the book and the MyITLab access card. There are many packages that include MyITLab so the student should request the ISBN from their Instructor before purchasing. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.   One of the packages 013381016X / 9780133810165 Exploring Microsoft Office 2013, Volume 1 & MyITLab -- Access Card -- for Exploring Microsoft Office 2013 Package   Package consists of 0133142671 / 9780133142679 Exploring Microsoft Office 2013, Volume 1 0133775143 / 9780133775143 MyITLab without Pearson eText -- Access Card -- for Exploring Microsoft Office 2013 (Replacement Card)  

Table of Contents:
Windows 8 Chapter One Getting Started with Windows 8 Objectives          Case Study Cedar Grove Elementary School   Windows 8 Fundamentals     Understanding the Start Screen     Configuring the Start Screen     Running Windows 8 Apps     Closing Apps     Understanding the Desktop     Managing Windows 8 Apps and Windows   Hands-On Exercise 1: Windows 8 Fundamentals   Windows Programs and Security Features                Identifying Windows Accessories     Working with Security Settings and Software   Hands-On Exercise 2: Windows Programs and Security Features     Windows Search and Help     Performing a Search     Using Targeted Searches     Getting Help   Hands-On Exercise 3: Windows Search and Help   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Microsoft Office 2013 Chapter One Office Fundamentals and File Management: Taking the First Step   Objectives          Case Study Spotted Begonia Art Gallery Windows 8 Startup     Logging In with Your Microsoft Account     Identifying the Start Screen Components     Interacting with the Start Screen     Accessing the Desktop   Hands-On Exercise 1: Windows 8 Startup   Files and Folders                  Using File Explorer     Working with Folders and Files     Selecting, Copying, and Moving Multiple Files and Folders   Hands-On Exercise 2: Files and Folders   Microsoft Office Software     Identifying Common Interface Components     Getting Office Help   Hands-On Exercise 3: Microsoft Office Software   The Backstage View Tasks                Opening a File     Printing a File     Closing a File and Application   Hands-On Exercise 4: The Backstage View Tasks   Home Tab Tasks                   Selecting and Editing Text     Using the Clipboard Group Commands     Using the Editing Group Commands   Hands-On Exercise 5: Home Tab Tasks   Insert Tab Tasks                    Inserting Objects   Review Tab Tasks                 Reviewing a File   Page Layout Tab Tasks       Using the Page Setup Dialog Box   Hands-On Exercise 6: Insert Tab Tasks, Page Layout Tab Tasks, and Review Tab Tasks   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter One Introduction to Word: Organizing a Document Objectives          Case Study Swan Creek National Wildlife Refuge   Introduction to Word Processing                  Beginning and Editing a Document     Customizing Word   Hands-On Exercise 1:     Introduction to Word Processing   Document Organization     Using Features That Improve Readability     Viewing a Document in Different Ways   Hands-On Exercise 2: Document Organization   Document Settings and Properties              Preparing a Document for Distribution     Modifying Document Properties   Hands-On Exercise 3: Document Settings and Properties   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Microsoft Office Word 2013 Chapter Two Document Presentation: Editing and Formatting Objectives          Case Study Phillips Studio L Photography   Text and Paragraph Formatting     Applying Font Attributes     Formatting a Paragraph   Hands-On Exercise 1: Text and Paragraph Formatting   Document Appearance     Formatting a Document     Applying Styles   Hands-On Exercise 2: Document Formatting Objects                Inserting and Formatting Objects   Hands-On Exercise 3: Objects   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Three Document Productivity: Working with Tables and Mail Merge Objectives          Case Study Traylor University Economic Impact Study   Tables       Inserting a Table     Formatting a Table   Hands-On Exercise 1: Tables   Advanced Table Features                 Managing Table Data     Enhancing Table Data   Hands-On Exercise 2: Advanced Table Features   Mail Merge     Creating a Mail Merge Document     Completing a Mail Merge   Hands-On Exercise 3: Mail Merge   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Four Collaboration and Research: Communicating and Producing Professional  Papers Objectives          Case Study Literature Analysis     Research Paper Basics       Using a Writing Style and Acknowledging Sources          Creating and Modifying Footnotes and Endnotes     Exploring Special Features   Hands-On Exercise 1: Research Paper Basics   Document Tracking     Reviewing a Document     Tracking Changes     Hands-On Exercise 2: Document Tracking   Online Document Collaboration     Using SkyDrive     Sharing and Collaborating on Documents   Hands-On Exercise 3: Online Document Collaboration   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Microsoft Office Excel 2013 Chapter One Introduction to Excel: What Is a Spreadsheet? Objectives          Case Study Ok Office Systems      Introduction to Spreadsheets        Exploring the Excel Window     Entering and Editing Cell Data   Hands-On Exercise 1: Introduction to Spreadsheets   Mathematics and Formulas             Creating Formulas     Using Auto Fill     Displaying Cell Formulas   Hands-On Exercise 2: Mathematics and Formulas   Workbook and Worksheet Management     Managing Worksheets     Managing Columns and Rows   Hands-On Exercise 3: Workbook and Worksheet Management   Clipboard Tasks     Selecting, Moving, Copying, and Pasting Data   Hands-On Exercise 4: Clipboard Tasks   Formatting              Applying Alignment and Font Options     Applying Number Formats   Hands-On Exercise 5: Formatting   Page Setup and Printing                    Selecting Page Setup Options     Previewing and Printing a Worksheet   Hands-On Exercise 6: Page Setup and Printing   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Two  Formulas and Functions: Performing Quantitative Analysis Objectives          Case Study Townsend Mortgage Company   Formula Basics      Using Relative, Absolute, and Mixed Cell References in Formulas     Correcting Circular References   Hands-On Exercise 1: Formula Basics   Function Basics     Inserting a Function     Inserting Basic Math and Statistics Functions     Using Date Functions   Hands-On Exercise 2: Function Basics   Logical, Lookup, and Financial Functions                    Determining Results with the IF Function     Using Lookup Functions     Calculating Payments with the PMT Function   Hands-On Exercise 3: Logical, Lookup, and Financial Functions   Range Names        Creating and Maintaining Range Names     Using Range Names in Formulas   Hands-On Exercise 4: Range Names   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Three Charts: Depicting Data Visually Objectives          Case Study Computer Job Outlook             Chart Creation Basics          Selecting the Data Source     Choosing a Chart Type     Moving, Sizing, and Printing a Chart   Hands-On Exercise 1: Chart Creation Basics   Chart Elements     Adding Chart Elements     Formatting Chart Elements   Hands-On Exercise 2: Chart Elements   Chart Design and Sparklines            Applying a Chart Style and Colors     Modifying the Data Source     Creating and Customizing Sparklines   Hands-On Exercise 3: Chart Design and Sparklines   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Four  Datasets and Tables: Managing Large Volumes of Data Objectives          Case Study Reid Furniture Store   Large Datasets      Freezing Rows and Columns     Printing Large Datasets   Hands-On Exercise 1: Large Datasets   Excel Tables            Designing and Creating Tables     Applying a Table Style   Hands-On Exercise 2: Excel Tables   Table Manipulation     Sorting Data     Filtering Data   Hands-On Exercise 3: Table Manipulation   Table Aggregation     Using Structured References and a Total Row   Hands-On Exercise 4: Table Aggregation   Conditional Formatting      Applying Conditional Formatting     Creating a New Rule   Hands-On Exercise 5: Conditional Formatting   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Microsoft Office Access 2013 Chapter One Introduction to Access: Finding Your Way Through an Access Database Objectives          Case Study Managing a Business in the Global Economy   Databases Are Everywhere!     Understanding Database Fundamentals     Using an Existing Database   Hands-On Exercise 1: Databases Are Everywhere!   Sorts and Filters                    Sorting Table Data on One or Multiple Fields     Creating, Modifying, and Removing Filters   Hands-On Exercise 2: Sorts and Filters   Access Versus Excel, and Relational Databases       Knowing When to Use Access or Excel to Manage Data     Understanding Relational Power   Hands-On Exercise 3: Access Versus Excel, and Relationship Databases   Access Database Creation     Creating a Database   Hands-On Exercise 4: Access Database Creation   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise     Chapter Two Tables and Queries in Relational Databases: Designing Databases and Extracting Data Objectives          Case Study Bank Audit   Table Design, Creation, and Modification     Designing a Table     Creating and Modifying Tables   Hands-On Exercise 1: Table Design, Creation, and Modification   Multiple-Table Databases                Sharing Data     Establishing Table Relationships   Hands-On Exercise 2: Multiple-Table Databases   Single-Table Queries          Creating a Single-Table Query     Specifying Query Criteria for Different Data Types     Understanding Query Sort Order     Running, Copying, and Modifying a Query     Using the Query Wizard   Hands-On Exercise 3: Single-Table Queries   Multitable Queries              Creating a Multitable Query     Modifying a Multitable Query   Hands-On Exercise 4: Multitable Queries   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions Objectives          Case Study Housing Slump Means Opportunity For College Students        Calculations and Expressions          Creating a Calculated Field in a Query     Formatting and Saving Calculated Results   Hands-On Exercise 1: Calculations and Expressions   The Expression Builder and Functions         Creating Expressions with the Expression Builder     Using Built-In Functions in Access   Hands-On Exercise 2: The Expression Builder and Functions   Aggregate Functions          Adding Aggregate Functions to Datasheets     Creating Queries with Aggregate Functions   Hands-On Exercise 3: Aggregate Functions   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Four Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries Objectives          Case Study Coffee Shop Starts New Business       Form Basics            Creating Forms Using Form Tools     Using Form Views     Working with a Form Layout Control     Sorting Records in a Form   Hands-On Exercise 1: Create and Modify forms   Report Basics         Creating Reports Using Report Tools     Using Report Views     Modifying a Report     Sorting Records in a Report   Hands-On Exercise 2: Report Basics   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Microsoft Office PowerPoint 2013 Chapter One Introduction to PowerPoint: Creating a Basic Presentation Objectives          Case Study Be a Trainer   Introduction to PowerPoint     Using PowerPoint Views     Typing a Speaker Note     Saving As a Slide Show   Hands-On Exercise 1: Introduction to PowerPoint   Presentation Creation     Planning a Presentation     Assessing Presentation Content     Reviewing the Presentation   Hands-On Exercise 2: Presentation Creation   Presentation Enhancement     Inserting Media Objects     Adding a Table     Using Animations and Transitions     Inserting a Header or Footer   Hands-On Exercise 3: Presentation Enhancement   Navigation and Printing     Running and Navigating a Slide Show     Printing in PowerPoint   Hands-On Exercise 4: Navigation and Printing   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Two Presentation Development: Planning and Preparing a Presentation Objectives          Case Study The Wellness Education Center   Templates               Creating a Presentation Using a Template     Modifying a Presentation Based on a Template   Hands-On Exercise 1: Templates   Outlines                   Creating a Presentation in Outline View     Modifying an Outline Structure     Printing an Outline   Hands-On Exercise 2: Outlines   Data Imports          Importing an Outline     Reusing Slides from an Existing Presentation   Hands-On Exercise 3: Data Imports   Design     Using Sections     Examining Slide Show Design Principles     Modifying a Theme     Modifying the Slide Master   Hands-On Exercise 4: Design   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Three Presentation Design: Illustrations and Infographics Objectives          Case Study Illustrations and Infographics Mini-Camp   Shapes     Creating Shapes     Applying Quick Styles and Customizing Shapes   Hands-On Exercise 1: Shapes   Smartart and Wordart     Creating SmartArt     Modifying SmartArt     Creating WordArt     Modifying WordArt   Hands-On Exercise 2: SmartArt and WordArt   Object Manipulation     Modifying Objects     Arranging Objects   Hands-On Exercise 3: Object Manipulation   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Chapter Four PowerPoint Rich Media Tools: Enhancing with Multimedia Objectives          Case Study Engagement Album   Pictures                    Inserting a Picture     Transforming a Picture     Using the Internet as a Resource   Hands-On Exercise 1: Pictures   Video        Adding Video     Using Video Tools   Hands-On Exercise 2: Video   Audio        Adding Audio     Changing Audio Settings   Hands-On Exercise 3: Audio   Photo Albums       Creating a Photo Album     Setting Photo Album Options   Hands-On Exercise 4: Photo Albums   Chapter Objectives Review         Key Terms Matching       Multiple Choice Practice Exercises            Mid-Level Exercises        Beyond the Classroom  Capstone Exercise   Application Capstone Exercises Word Excel Access PowerPoint Glossary Index