- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
Learning Microsoft Office 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage readers and help them work independently. MARKET: Appropriate for Introductory Computing courses on Microsoft Office Applications or courses on Computer Concepts that include coverage of Office 2013.This book is also suitable for individuals interested in learning to use Microsoft Office 2013 effectively.
Contents
Office BasicsChapter 1 Using the Common Features of Microsoft Office 2013 2Lesson 1 - Microsoft Office 2013 Basics 4Lesson 2 - Saving, Printing, and Closing Microsoft Office Files 16Lesson 3 - Working with Existing Files 24Lesson 4 - Using Command Options 35Lesson 5 - Managing Program Windows 44Lesson 6 - Using Microsoft Of fi ce Help 57Lesson 7 - Managing Information Technology 64End-of-Chapter Activities 73Microsoft Word 2013Chapter 1 Getting Started with Microsoft Word 2013 78Lesson 1 - Creating Word Documents withHeaders and Footers 81Lesson 2 - Formatting Documents with Themes and Styles 93Lesson 3 - Editing and Correcting Documents 102Lesson 4 - Adjusting Alignment and Spacing 109Lesson 5 - Creating Letters and Envelopes 117Lesson 6 - Formatting Text with Fonts and Effects 132Lesson 7 - Formatting and Sorting Lists 141Lesson 8 - Inserting Pictures, Text Boxes, and Shapes 148Lesson 9 - Formatting Graphics Objects 159Lesson 10 - Working with SmartArt Graphics, Text Effects, and Page Borders 171End-of-Chapter Activities 179Chapter 2 Editing Documents and Working with Tables 184Lesson 11 - Checking Spelling and Grammar 187Lesson 12 - Moving a Selection 197Lesson 13 - Copying a Selection 203Lesson 14 - Inserting a Table 208Lesson 15 - Aligning Tables 218Lesson 16 - Drawing a Table 226Lesson 17 - Performing Calculations in a Table 234Lesson 18 - Improving a Document with Find and Replace and AutoCorrect 241Lesson 19 - Working with Templates and Different File Types 252End-of-Chapter Activities 264Chapter 3 Creating Reports and Newsletters 270Lesson 20 - Changing Case and Managing Document Properties 272Lesson 21 - Formatting a One-Page Report 279Lesson 22 - Managing Sources and Controlling Text Flow 290Lesson 23 - Working with Newsletter Columns 302Lesson 24 - Enhancing Paragraphs with Dropped Capitals, Borders, and Shading 310Lesson 25 - Using Format Painter, Highlights, Symbols, and Quick Parts 316Lesson 26 - Creating Letters and Labels with Mail Merge 324End-of-Chapter Activities 336Microsoft Excel 2013Chapter 1 Getting Started with Microsoft Excel 2013 340Lesson 1 - Touring Excel 343Lesson 2 - Worksheet and Workbook Basics 352Lesson 3 - Adding Worksheet Contents 362Lesson 4 - Worksheet Formatting 371Lesson 5 - More on Cell Entries and Formatting 380Lesson 6 - Working with Ranges 390Lesson 7 - Creating Formulas 397Lesson 8 - Copying and Pasting 403Lesson 9 - Techniques for Moving Data 410Lesson 10 - Sheet, Display, and Print Operations 417End-of-Chapter Activities 423Chapter 2 Working with Formulas and Functions 426Lesson 11 - Getting Started with Functions 428Lesson 12 - Using Excel Tables 437Lesson 13 - Working with the NOW Function and Named Ranges 445Lesson 14 - Working with IF Functions 451Lesson 15 - Working with Text Functions 461Lesson 16 - Using Frozen Labels and Panes 469Lesson 17 - Using Conditional Formatting and Find and Replace 474Lesson 18 - Rotating Entries and Resolving Errors 479Lesson 19 - Managing Worksheets and Performing Multi-Worksheet Operations 483Lesson 20 - Modifying Print Options 490End-of-Chapter Activities 500Chapter 3 Charting Data 504Lesson 21 - Building Basic Charts 506Lesson 22 - Showing Percentages with a Pie Chart 515Lesson 23 - Enhancing a Pie Chart 520Lesson 24 - Adding Special Elements to a Chart or Sheet and Updating a Chart 526Lesson 25 - Completing Chart Format ting 530Lesson 26 - Comparing and Analyzing Data 539Lesson 27 - Char t Printing and Publishing 546Lesson 28 - Using Charts in Other Files 550Lesson 29 - Making Special Purpose Charts 555End-of-Chapter Activities 561Chapter 4 Advanced Functions, PivotCharts, and PivotTables 564Lesson 30 - Working with Hyperlinks 566Lesson 31 - Using Advanced Sort 574Lesson 32 - Using Advanced Filtering 582Lesson 33 - Using Advanced Functions to Predict Trends 596Lesson 34 - Using Advanced Functions for Data Analysis 603Lesson 35 - Using LOOKUP Functions 614Lesson 36 - Working with PivotTables and PivotCharts 620Lesson 37 - Working with the Excel Data Model 630Lesson 38 - Working with PowerPivot and Power View 636End-of-Chapter Activities 641Microsoft Access 2013Chapter 1 Getting Started with Microsoft Access 2013 646Lesson 1 - Planning a Database 648Lesson 2 - Creating a Database with Access 655Lesson 3 - Modifying and Adding Data to a Table 666Lesson 4 - Modifying Fields in a Table 673Lesson 5 - Importing and Protecting Data 680Lesson 6 - Using Table Templates and Design View 690Lesson 7 - Creating Other Objects 702End-of-Chapter Activities 710Chapter 2 Working with Queries 714Lesson 8 - Managing Relationships Between Tables 716Lesson 9 - Finding, Replacing, and Sorting Data 726Lesson 10 - Filtering Data 732Lesson 11 - Creating a Query in Design View 737Lesson 12 - Creating a Multi-Table Query 745Lesson 13 - Using Criteria in a Query 751Lesson 14 - Using Comparison Operators 756Lesson 15 - Using Calculated Fields 761Lesson 16 - Summarizing Data in Queries 766End-of-Chapter Activities 771Chapter 3 Working with Forms and Reports 774Lesson 17 - Creating and Using a Form 776Lesson 18 - Working with a Form in Layout View 783Lesson 19 - Working with a Form in Design View 793Lesson 20 - Working with Form Sections 801Lesson 21 - Creating a Report 808Lesson 22 - Modifying a Report in Design View 819Lesson 23 - Creating Labels 825Lesson 24 - Creating a Lookup List 828Lesson 25 - Creating an Input Mask 836End-of-Chapter Activities 842Microsoft PowerPoint 2013Chapter 1 Getting Started with Microsoft PowerPoint 2013 844Lesson 1 - Get ting Started with PowerPoint 846Lesson 2 - Working with Slides 854Lesson 3 - Working with Headers, Footers, and Notes 862Lesson 4 - Inserting and Format ting Pictures 869Lesson 5 - Format ting Text 875Lesson 6 - Aligning Text 881Lesson 7 - Displaying the Presentation Outline 888Lesson 8 - Arranging Slides 892Lesson 9 - Adding Slide Transitions 897End-of-Chapter Activities 901Chapter 2 Working with Lists and Graphics 904Lesson 10 - Working with Lists 906Lesson 11 - Inserting Online Pictures 911Lesson 12 - Inserting Symbols and Text Boxes 916Lesson 13 - Drawing and Format ting Shapes 922Lesson 14 - Positioning and Grouping Shapes 932Lesson 15 - Creating WordArt 941Lesson 16 - Creating SmartArt Diagrams 946Lesson 17 - Creating a Photo Album 954End-of-Chapter Activities 959Chapter 3 Enhancing a Presentation 962Lesson 18 - Modifying a Theme 964Lesson 19 - Modifying a Background 969Lesson 20 - Animating Slide Objects 975Lesson 21 - Creating Multimedia Presentations 982Lesson 22 - Working with Tables 990Lesson 23 - Working with Charts 996End-of-Chapter Activities 1002Index 1005The following Bonus Chapters can be accessed from the Companion Web site www pearsonhighered com/learningseriesThe Bonus Chapters are also provided on the CD-ROM that accompanies the Teacher's Wraparound Edition Word Chapter 4 Printing Documents and Using the InternetLesson 27 - Creating FormsLesson 28 - Protecting DocumentsLesson 29 - Inspecting and Checking DocumentsLesson 30 - Marking a Document As Final and Using Digital SignaturesLesson 31 - Using CommentsLesson 32 - Managing Source Information and Generating Tables of ContentsLesson 33 - Formatting Web Pages with WordLesson 34 - Using the World Wide WebLesson 35 - Sharing Documents and Communicating with WordEnd-of-Chapter ActivitiesExcel Chapter 5 Advanced Formatting and Workbook FeaturesLesson 39 - Working with File FormatsLesson 40 - Working with Graphics and Saving a Worksheet As a Web PageLesson 41 - Working with Web DataLesson 42 - Linking and Embedding DataLesson 43 - Working with WorkbooksLesson 44 - Working with Comments and Modifying Page SetupLesson 45 - Using Copy and Paste SpecialLesson 46 - Moving and Linking Data Between WorkbooksLesson 47 - Working with 3-D FormulasLesson 48 - Working with Data Validation and MacrosEnd-of-Chapter ActivitiesPowerPoint Chapter 4 Finalizing a PresentationLesson 24 - Working with MastersLesson 25 - Working with Themes and TemplatesLesson 26 - Working with Links, Action Buttons, and External ContentLesson 27 - Organizing and Rehearsing a Slide ShowLesson 28 - Setting Up and Running a Slide ShowLesson 29 - Reviewing a PresentationLesson 30 - Inspecting and Protecting a PresentationLesson 31 - Sharing a PresentationEnd-of-Chapter Activities