| |
| |
| Office | |
| |
| |
| |
| Introduction to Microsoft Office 2013 Features | |
| |
| |
| |
| Note Form | |
| |
| |
| |
| Use File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
| Using File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
| Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
| Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
| Enter, Edit, and Check the Spelling of Text in an Office 2013 Program | |
| |
| |
| |
| Entering and Editing Text in an Office 2013 Program | |
| |
| |
| |
| Checking Spelling | |
| |
| |
| |
| Perform Commands from a Dialog Box | |
| |
| |
| |
| Performing Commands from a Dialog Box | |
| |
| |
| |
| Using Undo | |
| |
| |
| |
| Create a Folder and Name and Save a File | |
| |
| |
| |
| Creating a Folder and Naming and Saving a File | |
| |
| |
| |
| Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App | |
| |
| |
| |
| Inserting a Footer, Inserting Document Info, and Adding Document Properties | |
| |
| |
| |
| Printing a File and Closing a Desktop App | |
| |
| |
| |
| Memo | |
| |
| |
| |
| Open an Existing File and Save It with a New Name | |
| |
| |
| |
| Opening an Existing File and Saving It with a New Name | |
| |
| |
| More Knowledge Read-only | |
| |
| |
| |
| Sign In to Office and Explore Options for a Microsoft Office Desktop App | |
| |
| |
| |
| Signing In to Office and Viewing Application Options | |
| |
| |
| |
| Perform Commands from the Ribbon and Quick Access Toolbar | |
| |
| |
| |
| Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar | |
| |
| |
| More Knowledge Customizing the Ribbon | |
| |
| |
| |
| Minimizing and Using the Keyboard to Control the Ribbon | |
| |
| |
| |
| Apply Formatting in Office Programs | |
| |
| |
| |
| Changing Page Orientation and Zoom Level | |
| |
| |
| More Knowledge Zooming to Page Width | |
| |
| |
| |
| Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles | |
| |
| |
| |
| Using Format Painter | |
| |
| |
| |
| Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste | |
| |
| |
| |
| Compress Files and Use the Microsoft Office 2013 Help System | |
| |
| |
| |
| Compressing Files | |
| |
| |
| |
| Using the Microsoft Office 2013 Help System in Excel | |
| |
| |
| |
| Install Apps for Office and Create a Microsoft Account | |
| |
| |
| |
| Installing Apps for Office | |
| |
| |
| |
| Creating a Microsoft Account | |
| |
| |
| Summary, GO! Learn It Online | |
| |
| |
| Guide to Chapter Assessments | |
| |
| |
| Glossary | |
| |
| |
| Word Introduction to Microsoft Word 2013 | |
| |
| |
| |
| Creating Documents with Microsoft Word 2013 | |
| |
| |
| |
| Flyer | |
| |
| |
| |
| Create a New Document and Insert Text | |
| |
| |
| |
| Starting a New Word Document | |
| |
| |
| More Knowledge Word's Default Settings Are Easier to Read Online | |
| |
| |
| |
| Inserting Text from Another Document | |
| |
| |
| |
| Insert and Format Graphics | |
| |
| |
| |
| Formatting Text by Using Text Effects | |
| |
| |
| More Knowledge Clear Existing Formatting | |
| |
| |
| |
| Inserting Pictures | |
| |
| |
| |
| Wrapping Text around a Picture Using Layout Options | |
| |
| |
| |
| Resizing Pictures and Using Live Layout | |
| |
| |
| |
| Moving a Picture | |
| |
| |
| |
| Applying Picture Effects | |
| |
| |
| |
| Applying Artistic Effects | |
| |
| |
| |
| Adding a Page Border | |
| |
| |
| |
| Insert and Modify Text Boxes and Shapes | |
| |
| |
| |
| Inserting, Sizing, and Positioning a Shape | |
| |
| |
| |
| Typing Text in a Shape and Formatting a Shape | |
| |
| |
| |
| Inserting a Text Box | |
| |
| |
| |
| Sizing and Positioning a Text Box and Formatting a Text Box Using Shape Styles | |
| |
| |
| |
| Preview and Print a Document | |
| |
| |
| |
| Adding a File Name to the Footer by Inserting a Field | |
| |
| |
| |
| Adding Document Properties and Previewing and Printing a Document | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Create a Flyer in Word Web App | |
| |
| |
| Activity Creating a Flyer in the Word Web App | |
| |
| |
| |
| Information Handout | |
| |
| |
| |
| Change Document and Paragraph Layout | |
| |
| |
| |
| Setting Margins | |
| |
| |
| |
| Aligning Text | |
| |
| |
| |
| Changing Line Spacing | |
| |
| |
| |
| Indenting Text | |
| |
| |
| |
| Adding Space Before and After Paragraphs | |
| |
| |
| |
| Create and Modify Lists | |
| |
| |
| |
| Creating a Bulleted List | |
| |
| |
| |
| Creating a Numbered List | |
| |
| |
| More Knowledge To End a List | |
| |
| |
| |
| Customizing Bullets | |
| |
| |
| |
| Set and Modify Tab Stops | |
| |
| |
| |
| Setting Tab Stops | |
| |
| |
| |
| Modifying Tab Stops | |
| |
| |
| |
| Insert a SmartArt Graphic and an Online Video | |
| |
| |
| |
| Inserting a SmartArt Graphic | |
| |
| |
| |
| Sizing and Formatting a SmartArt Graphic | |
| |
| |
| |
| Inserting an Online Video | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Create a Handout in the Word Web App | |
| |
| |
| Activity Creating a Handout in the Word Web App | |
| |
| |
| GO! with Microsoft Office 365 | |
| |
| |
| Activity Using the Exchange Online Outlook Meeting Tool to Collaborate | |
| |
| |
| Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
| Guide to Chapter Assessments | |
| |
| |
| Glossary | |
| |
| |
| Skills Review | |
| |
| |
| Mastering Word | |
| |
| |
| Rubric | |
| |
| |
| GO! Think | |
| |
| |
| Excel Introduction to Microsoft Excel 2013 | |
| |
| |
| |
| Creating a Worksheet and Charting Data | |
| |
| |
| |
| Sales Report with Embedded Column Chart and Sparklines | |
| |
| |
| |
| Create, Save, and Navigate an Excel Workbook | |
| |
| |
| |
| Starting Excel, Navigating Excel, and Naming and Saving a Workbook | |
| |
| |
| More Knowledge Creating a New Workbook by Using a Template | |
| |
| |
| |
| Enter Data in a Worksheet | |
| |
| |
| |
| Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell | |
| |
| |
| |
| Using Auto Fill and Keyboard Shortcuts | |
| |
| |
| |
| Aligning Text and Adjusting the Size of Columns | |
| |
| |
| |
| Entering Numbers | |
| |
| |
| |
| Construct and Copy Formulas and Use the SUM Function | |
| |
| |
| |
| Constructing a Formula and Using the Sum Function | |
| |
| |
| |
| Copying a Formula by Using the Fill Handle | |
| |
| |
| |
| Format Cells with Merge & Center, Cell Styles, and Themes | |
| |
| |
| |
| Using Merge & Center and Applying Cell Styles | |
| |
| |
| |
| Formatting Financial Numbers | |
| |
| |
| |
| Changing the Workbook Theme | |
| |
| |
| More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands | |
| |
| |
| |
| Chart Data to Create a Column Chart and Insert Sparklines | |
| |
| |
| |
| Charting Data and Using Recommended Charts to Select and Insert a Column Chart | |
| |
| |
| |
| Using the Chart Tools to Apply Chart Styles | |
| |
| |
| |
| Creating and Formatting Sparklines | |
| |
| |
| |
| Print a Worksheet, Display Formulas, and Close Excel | |
| |
| |
| |
| Creating a Footer and Centering a Worksheet | |
| |
| |
| |
| Adding Document Properties and Printing a Workbook | |
| |
| |
| |
| Printing a Section of the Worksheet | |
| |
| |
| |
| Changing Page Orientation and Displaying, Printing, and Hiding Formulas | |
| |
| |
| More Knowledge Inserting a Watermark | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Create a Sales Report with an Embedded Column Chart Using the Excel Web App | |
| |
| |
| Activity Creating a Sales Report with Embedded Column Chart Using the Excel Web App | |
| |
| |
| |
| Inventory Valuation | |
| |
| |
| |
| Check Spelling in a Worksheet | |
| |
| |
| |
| Checking Spelling in a Worksheet | |
| |
| |
| |
| Enter Data by Range | |
| |
| |
| |
| Entering Data by Range | |
| |
| |
| |
| Construct Formulas for Mathematical Operations | |
| |
| |
| |
| Using Arithmetic Operator | |
| |
| |
| |
| Using the Quick Analysis Tool | |
| |
| |
| |
| Copying Formulas Containing Absolute Cell References | |
| |
| |
| More Knowledge Calculate a Percentage if You Know the Total and the Amount | |
| |
| |
| |
| Edit Values in a Worksheet | |
| |
| |
| |
| Editing Values in a Worksheet | |
| |
| |
| |
| Formatting Cells with the Percent Style | |
| |
| |
| |
| Format a Worksheet | |
| |
| |
| |
| Inserting and Deleting Rows and Columns | |
| |
| |
| More Knowledge Hiding Rows and Columns | |
| |
| |
| |
| Adjusting Column Widths and Wrapping Text | |
| |
| |
| |
| Changing Theme Colors | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Calculate the Value of an Inventory in the Excel Web App | |
| |
| |
| Activity Creating an Inventory Valuation Report in the Excel Web App | |
| |
| |
| GO! with Microsoft Office 365 | |
| |
| |
| Activity Using the Exchange Online Outlook Meeting Tool to Collaborate | |
| |
| |
| Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
| Guide to Chapter Assessments | |
| |
| |
| Glossary | |
| |
| |
| Skills Review | |
| |
| |
| Mastering Excel | |
| |
| |
| Rubric | |
| |
| |
| GO! Think | |
| |
| |
| Access Introduction to Microsoft Access 2013 | |
| |
| |
| |
| Getting Started with Microsoft Access 2013 | |
| |
| |
| |
| Student Advising Database with Two Tables | |
| |
| |
| |
| Identify Good Database Design | |
| |
| |
| |
| Using Good Design Techniques to Plan a Database | |
| |
| |
| |
| Create a Table and Define Fields in a Blank Desktop Database | |
| |
| |
| |
| Starting with a Blank Desktop Database | |
| |
| |
| |
| Assigning the Data Type and Name to Fields | |
| |
| |
| More Knowledge Create Fields by Entering Data | |
| |
| |
| |
| Renaming Fields and Changing Data Types in a Table | |
| |
| |
| |
| Adding a Record to a Table | |
| |
| |
| More Knowledge Renaming or Deleting a Table | |
| |
| |
| |
| Adding Additional Records to a Table | |
| |
| |
| |
| Importing Data from an Excel Workbook into an Existing Access Table | |
| |
| |
| |
| Change the Structure of Tables and Add a Second Table | |
| |
| |
| |
| Deleting a Table Field in Design View | |
| |
| |
| |
| Changing a Field Size and Adding a Description | |
| |
| |
| |
| Viewing the Primary Key in Design View | |
| |
| |
| |
| Adding a Second Table to a Database by Importing an Excel Spreadsheet | |
| |
| |
| |
| Adjusting Column Widths | |
| |
| |
| |
| Printing a Table | |
| |
| |
| |
| Create a Query, Form, and Report 510 | |
| |
| |
| |
| Creating a Query by Using the Simple Query Wizard 510 | |
| |
| |
| |
| Creating and Printing a Form 512 | |
| |
| |
| |
| Creating, Modifying, and Printing a Report 514 | |
| |
| |
| |
| Close a Database and Exit Access 516 | |
| |
| |
| |
| Closing a Database and Exiting Access 517 | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Export an Access Table to an Excel Spreadsheet, Save to SkyDrive, Edit a Record, and Save to Your Computer | |
| |
| |
| Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to SkyDrive, Editing a Record in SkyDrive, and Saving to Your Computer | |
| |
| |
| |
| Student Workshops Database | |
| |
| |
| |
| Use a Template to Create a Database | |
| |
| |
| |
| Using a Template to Create a Database | |
| |
| |
| |
| Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form | |
| |
| |
| |
| Appending Records by Importing from an Excel Spreadsheet | |
| |
| |
| |
| Organize Objects in the Navigation Pane | |
| |
| |
| |
| Grouping Database Objects in the Navigation Pane | |
| |
| |
| |
| Create a New Table in a Database Created with a Template | |
| |
| |
| |
| Using the Table Tool to Create a New Table | |
| |
| |
| |
| Entering Records into a New Table | |
| |
| |
| |
| Print a Report and a Table | |
| |
| |
| |
| Viewing Reports and Printing a Report | |
| |
| |
| |
| Printing a Table | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Export an Access Table to an Excel Spreadsheet, Save to Google Drive, Add a Record, and Save to Your Computer | |
| |
| |
| Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Drive, and Saving to Your Computer | |
| |
| |
| GO! with Microsoft Office 365 | |
| |
| |
| Activity Using the Exchange Online Outlook Meeting Tool to Collaborate | |
| |
| |
| Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
| Guide to Chapter Assessments | |
| |
| |
| Glossary | |
| |
| |
| Skills Review | |
| |
| |
| Mastering Access | |
| |
| |
| Rubric | |
| |
| |
| GO! Think | |
| |
| |
| PowerPoint Introduction to Microsoft PowerPoint 2013 | |
| |
| |
| |
| Getting Started with Microsoft PowerPoint | |
| |
| |
| |
| Company Overview | |
| |
| |
| |
| Create a New Presentation | |
| |
| |
| |
| Creating a New Presentation and Identifying Parts of the PowerPoint Window | |
| |
| |
| |
| Entering Presentation Text | |
| |
| |
| |
| Applying a Presentation Theme | |
| |
| |
| |
| Edit a Presentation in Normal View | |
| |
| |
| |
| Inserting a New Slide | |
| |
| |
| |
| Increasing and Decreasing List Levels | |
| |
| |
| |
| Adding Speaker's Notes to a Presentation | |
| |
| |
| |
| Displaying and Editing Slides in the Slide Pane | |
| |
| |
| |
| Add Pictures to a Presentation | |
| |
| |
| |
| Inserting a Picture from a File | |
| |
| |
| |
| Applying a Style to a Picture | |
| |
| |
| |
| Applying and Removing Picture Artistic Effects | |
| |
| |
| |
| Print and View a Presentation | |
| |
| |
| |
| Viewing a Slide Show | |
| |
| |
| |
| Using Presenter View | |
| |
| |
| |
| Inserting Headers and Footers on Slide Handouts | |
| |
| |
| |
| Inserting Slide Numbers on Slides | |
| |
| |
| |
| Printing Presentation Handouts | |
| |
| |
| More Knowledge Print a Presentation in Grayscale | |
| |
| |
| |
| Printing Speaker Notes | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Create a Company Overview Presentation in the PowerPoint Web App | |
| |
| |
| Activity Create a Company Overview Presentation in the PowerPoint Web App | |
| |
| |
| |
| Itinerary Presentation | |
| |
| |
| |
| Edit an Existing Presentation | |
| |
| |
| |
| Changing Slide Size | |
| |
| |
| |
| Inserting Slides from an Existing Presentation | |
| |
| |
| More Knowledge Inserting All Slides | |
| |
| |
| |
| Displaying and Editing the Presentation Outline | |
| |
| |
| |
| Deleting and Moving a Slide | |
| |
| |
| |
| Finding and Replacing Text | |
| |
| |
| |
| Format a Presentation | |
| |
| |
| |
| Applying a Theme Variant | |
| |
| |
| |
| Changing Fonts and Font Sizes | |
| |
| |
| |
| Changing Font Styles and Font Colors | |
| |
| |
| |
| Aligning Text | |
| |
| |
| |
| Changing Line Spacing | |
| |
| |
| |
| Changing the Slide Layout | |
| |
| |
| |
| Use Slide Sorter View | |
| |
| |
| |
| Deleting Slides in Slide Sorter View | |
| |
| |
| |
| Moving a Single Slide in Slide Sorter View | |
| |
| |
| |
| Selecting Contiguous and Noncontiguous Slides and Moving Multiple Slides | |
| |
| |
| |
| Apply Slide Transitions | |
| |
| |
| |
| Applying Slide Transitions to a Presentation | |
| |
| |
| |
| Setting Slide Transition Timing Options | |
| |
| |
| More Knowledge Applying Multiple Slide Transitions | |
| |
| |
| |
| Displaying a Presentation in Reading View | |
| |
| |
| More Knowledge Present a Presentation Online | |
| |
| |
| GO! with Office Web Apps | |
| |
| |
| Objective Create an Itinerary Presentation in the PowerPoint Web App | |
| |
| |
| Activity Creating an Itinerary Presentation in the PowerPoint Web App | |
| |
| |
| GO! with Microsoft Office 365 | |
| |
| |
| Activity Using the Exchange Online Outlook Meeting Tool to Collaborate | |
| |
| |
| Summary, GO! Learn It Online, GO! For Job Success | |
| |
| |
| Guide to Chapter Assessments | |
| |
| |
| Glossary | |
| |
| |
| Skills Review | |
| |
| |
| Mastering PowerPoint | |
| |
| |
| Rubric | |
| |
| |
| GO! Think | |
| |
| |
| Index | |