Learning Microsoft Office 2013
Level 2 -- CTE/School
Published on 18. October 2013
Book
Spiral bound
928 pages
978-0-13-340781-5 (ISBN)
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. This book is 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 in their home life and career.
More details
Other editions
Previous edition
.. .. Emergent Learning | Suzanne Weixel | Faithe Wempen
Learning Microsoft Office 2010, Advanced Student Edition -- CTE/School
Book
02/2011
Pearson
€103.53
Article exhausted; check for reprint
Content
Microsoft Word 2013
Chapter 5 Using Advanced Formatting, Lists, and Charts 2
Lesson 36 - Inserting Text Files and Blank Pages 4
Lesson 37 - Creating and Editing Styles 10
Lesson 38 - Managing Style Formatting 18
Lesson 39 - Working with Multilevel Lists 29
Lesson 40 - Inserting Charts 35
Chapter 6 Using Reusable Content and Markup Tools 46
Lesson 41 - Customizing Language and Word Options 48
Lesson 42 - Using Advanced Find and Replace 58
Lesson 43 - Using Building Blocks 67
Lesson 44 - Inserting Fields from Quick Parts 73
Lesson 45 - Creating Custom Templates, Themes, and Style Sets 79
Lesson 46 - Tracking Changes 91
Lesson 47 - Comparing Documents 98
Lesson 48 - Restricting Access to Documents 107
End-of-Chapter Activities 112
Chapter 7 Using Advanced Tables and Graphics 116
Lesson 49 - Customizing Table Styles 118
Lesson 50 - Using Advanced Table Features 126
Lesson 51 - Using Advanced Graphics 137
Lesson 52 - Linking Text Boxes 146
Lesson 53 - Creating WordArt and Watermarks 155
End-of-Chapter Activities 161
Chapter 8 Working with Long Documents 166
Lesson 54 - Working with Outlines 168
Lesson 55 - Advanced Layout Options 176
Lesson 56 - Working with Master Documents 184
Lesson 57 - Creating Custom Headers and Footers, Bookmarks, and Cross-References 191
Lesson 58 - Creating an Index 200
Lesson 59 - Managing Source Information and Generating Special Tables 208
End-of-Chapter Activities 200
Chapter 9 Embedding and Linking Objects, Using Mail Merge, and Creating Macros 226
Lesson 60 - Copying, Moving, and Embedding Data and Objects 228
Lesson 61 - Linking Files and Objects 237
Lesson 62 - Integrating Word and PowerPoint 243
Lesson 63 - Creating a Directory with Mail Merge 248
Lesson 64 - Using Merge to Create E-mail 257
Lesson 65 - Working with Macros 263
End-of-Chapter Activities 275
Microsoft Excel 2013
Chapter 6 Managing Large Workbooks 280
Lesson 49 - Customizing the Excel Interface and Converting Text 282
Lesson 50 - Formatting Cells 290
Lesson 51 - Hiding and Formatting Workbook Elements 298
Lesson 52 - Customizing Styles and Themes 306
Lesson 53 - Customizing Data Entry 316
Lesson 54 - Formatting and Replacing Data Using Functions 323
Lesson 55 - Working with Subtotals 331
End-of-Chapter Activities 341
Chapter 7 Creating Charts, Shapes, and Templates 346
Lesson 56 - Formatting Chart Elements 348
Lesson 57 - Formatting the Value Axis 355
Lesson 58 - Creating Stacked Area Charts 364
Lesson 59 - Working with Sparklines and Trendlines 372
Lesson 60 - Drawing and Positioning Shapes 379
Lesson 61 - Formatting Shapes 385
Lesson 62 - Enhancing Shapes with Text and Effects 390
Lesson 63 - Working with Templates 397
End-of-Chapter Activities 407
Chapter 8 Creating Macros and Using Data Analysis Tools 412
Lesson 64 - Recording a Macro 414
Lesson 65 - Using Functions 424
Lesson 66 - Working with Absolute References and Using Financial Functions 433
Lesson 67 - Creating and Interpreting Financial Statements 440
Lesson 68 - Creating Scenarios and Naming Ranges 447
Lesson 69 - Finding and Fixing Errors in Formulas 454
End-of-Chapter Activities 462
Chapter 9 Importing and Analyzing Database Data 466
Lesson 70 - Importing Data into Excel 468
Lesson 71 - Working with Excel Tables
Lesson 72 - Using Advanced Filters, Slicers, and Database Functions 482
Lesson 73 - Using Flash Fill and Data Consolidation 493
Lesson 74 - Linking Workbooks 501
Lesson 75 - Using PivotTables 508
Lesson 76 - Using PivotCharts 516
Lesson 77 - Using PowerPivot and Power View 524
End-of-Chapter Activities 533
Chapter 10 Collaborating with Others and Preparing a Final Workbook for Distribution 536
Lesson 78 - Tracking Changes 538
Lesson 79 - Ensuring Data Integrity 548
Lesson 80 - Protecting Data 557
Lesson 81 - Securing a Workbook 564
Lesson 82 - Finalizing a Workbook 569
Lesson 83 - Sharing a Workbook 575
End-of-Chapter Activities 581
Microsoft Access 2013
Chapter 4 Customizing Tables and Databases 584
Lesson 26 - Normalizing and Analyzing Tables 586
Lesson 27 - Using Advanced Field and Table Properties 596
Lesson 28 - Formatting and Correcting Tables 604
Lesson 29 - Creating Macros 608
End-of-Chapter Activities 615
Chapter 5 Developing Advanced Queries 618
Lesson 31 - Creating Crosstab Queries 620
Lesson 32 - Creating Queries That Find Unmatched or Duplicate Records 627
Lesson 33 - Creating Queries That Prompt for Input 631
Lesson 34 - Creating Action Queries 637
Lesson 35 - Working with Advanced Query Options 641
End-of-Chapter Activities 647
Chapter 6 Customizing Forms and Reports 650
Lesson 36 - Working with Report Layouts 652
Lesson 37 - Working with Controls 660
Lesson 38 - Formatting Controls 671
Lesson 39 - Creating Special Forms 678
Lesson 40 - Working with Subforms and Subreports 683
Lesson 41 - Working with Charts 691
Lesson 42 - Creating Switchboards 699
Lesson 43 - Creating Navigation Forms 706
End-of-Chapter Activities 711
Chapter 7 Securing, Integrating, and Maintaining Data 714
Lesson 44 - Converting and Securing Data 716
Lesson 45 - Sharing Data with Word and Other Text Applications 721
Lesson 46 - Sharing Data with Excel and Access 727
Lesson 47 - Linking to Data Sources 734
Lesson 48 - Customizing Access 738
End-of-Chapter Activities 744
Microsoft PowerPoint 2013
Chapter 5 Working with Masters, Handouts, and Text 746
Lesson 32 - Working with Advanced Slide Master Features 748
Lesson 33 - Customizing Themes and Effects 755
Lesson 34 - Working with Notes and Handouts 760
Lesson 35 - Integrating PowerPoint with Word 769
Lesson 36 - Fine-Tuning Text Formats 776
Lesson 37 - Using Research Tools 784
End-of-Chapter Activities 790
Chapter 6 Working with Graphic Objects and Media 794
Lesson 38 - Applying Advanced Picture Formatting 796
Lesson 39 - Working with Advanced Multimedia Features 804
Lesson 40 - Applying Advanced Animations 810
Lesson 41 - Drawing and Adjusting Tables 818
Lesson 42 - Formatting Tables 828
Lesson 43 - Formatting Charts 835
End-of-Chapter Activities 844
Chapter 7 Finalizing and Sharing a Presentation 848
Lesson 44 - Making a Presentation Accessible to Everyone 850
Lesson 45 - Saving a Presentation in Other Formats 855
Lesson 46 - Working with Links and Actions 862
Lesson 47 - with Online Presentations 869
End-of-Chapter Activities 880
Index 885
Chapter 5 Using Advanced Formatting, Lists, and Charts 2
Lesson 36 - Inserting Text Files and Blank Pages 4
Lesson 37 - Creating and Editing Styles 10
Lesson 38 - Managing Style Formatting 18
Lesson 39 - Working with Multilevel Lists 29
Lesson 40 - Inserting Charts 35
Chapter 6 Using Reusable Content and Markup Tools 46
Lesson 41 - Customizing Language and Word Options 48
Lesson 42 - Using Advanced Find and Replace 58
Lesson 43 - Using Building Blocks 67
Lesson 44 - Inserting Fields from Quick Parts 73
Lesson 45 - Creating Custom Templates, Themes, and Style Sets 79
Lesson 46 - Tracking Changes 91
Lesson 47 - Comparing Documents 98
Lesson 48 - Restricting Access to Documents 107
End-of-Chapter Activities 112
Chapter 7 Using Advanced Tables and Graphics 116
Lesson 49 - Customizing Table Styles 118
Lesson 50 - Using Advanced Table Features 126
Lesson 51 - Using Advanced Graphics 137
Lesson 52 - Linking Text Boxes 146
Lesson 53 - Creating WordArt and Watermarks 155
End-of-Chapter Activities 161
Chapter 8 Working with Long Documents 166
Lesson 54 - Working with Outlines 168
Lesson 55 - Advanced Layout Options 176
Lesson 56 - Working with Master Documents 184
Lesson 57 - Creating Custom Headers and Footers, Bookmarks, and Cross-References 191
Lesson 58 - Creating an Index 200
Lesson 59 - Managing Source Information and Generating Special Tables 208
End-of-Chapter Activities 200
Chapter 9 Embedding and Linking Objects, Using Mail Merge, and Creating Macros 226
Lesson 60 - Copying, Moving, and Embedding Data and Objects 228
Lesson 61 - Linking Files and Objects 237
Lesson 62 - Integrating Word and PowerPoint 243
Lesson 63 - Creating a Directory with Mail Merge 248
Lesson 64 - Using Merge to Create E-mail 257
Lesson 65 - Working with Macros 263
End-of-Chapter Activities 275
Microsoft Excel 2013
Chapter 6 Managing Large Workbooks 280
Lesson 49 - Customizing the Excel Interface and Converting Text 282
Lesson 50 - Formatting Cells 290
Lesson 51 - Hiding and Formatting Workbook Elements 298
Lesson 52 - Customizing Styles and Themes 306
Lesson 53 - Customizing Data Entry 316
Lesson 54 - Formatting and Replacing Data Using Functions 323
Lesson 55 - Working with Subtotals 331
End-of-Chapter Activities 341
Chapter 7 Creating Charts, Shapes, and Templates 346
Lesson 56 - Formatting Chart Elements 348
Lesson 57 - Formatting the Value Axis 355
Lesson 58 - Creating Stacked Area Charts 364
Lesson 59 - Working with Sparklines and Trendlines 372
Lesson 60 - Drawing and Positioning Shapes 379
Lesson 61 - Formatting Shapes 385
Lesson 62 - Enhancing Shapes with Text and Effects 390
Lesson 63 - Working with Templates 397
End-of-Chapter Activities 407
Chapter 8 Creating Macros and Using Data Analysis Tools 412
Lesson 64 - Recording a Macro 414
Lesson 65 - Using Functions 424
Lesson 66 - Working with Absolute References and Using Financial Functions 433
Lesson 67 - Creating and Interpreting Financial Statements 440
Lesson 68 - Creating Scenarios and Naming Ranges 447
Lesson 69 - Finding and Fixing Errors in Formulas 454
End-of-Chapter Activities 462
Chapter 9 Importing and Analyzing Database Data 466
Lesson 70 - Importing Data into Excel 468
Lesson 71 - Working with Excel Tables
Lesson 72 - Using Advanced Filters, Slicers, and Database Functions 482
Lesson 73 - Using Flash Fill and Data Consolidation 493
Lesson 74 - Linking Workbooks 501
Lesson 75 - Using PivotTables 508
Lesson 76 - Using PivotCharts 516
Lesson 77 - Using PowerPivot and Power View 524
End-of-Chapter Activities 533
Chapter 10 Collaborating with Others and Preparing a Final Workbook for Distribution 536
Lesson 78 - Tracking Changes 538
Lesson 79 - Ensuring Data Integrity 548
Lesson 80 - Protecting Data 557
Lesson 81 - Securing a Workbook 564
Lesson 82 - Finalizing a Workbook 569
Lesson 83 - Sharing a Workbook 575
End-of-Chapter Activities 581
Microsoft Access 2013
Chapter 4 Customizing Tables and Databases 584
Lesson 26 - Normalizing and Analyzing Tables 586
Lesson 27 - Using Advanced Field and Table Properties 596
Lesson 28 - Formatting and Correcting Tables 604
Lesson 29 - Creating Macros 608
End-of-Chapter Activities 615
Chapter 5 Developing Advanced Queries 618
Lesson 31 - Creating Crosstab Queries 620
Lesson 32 - Creating Queries That Find Unmatched or Duplicate Records 627
Lesson 33 - Creating Queries That Prompt for Input 631
Lesson 34 - Creating Action Queries 637
Lesson 35 - Working with Advanced Query Options 641
End-of-Chapter Activities 647
Chapter 6 Customizing Forms and Reports 650
Lesson 36 - Working with Report Layouts 652
Lesson 37 - Working with Controls 660
Lesson 38 - Formatting Controls 671
Lesson 39 - Creating Special Forms 678
Lesson 40 - Working with Subforms and Subreports 683
Lesson 41 - Working with Charts 691
Lesson 42 - Creating Switchboards 699
Lesson 43 - Creating Navigation Forms 706
End-of-Chapter Activities 711
Chapter 7 Securing, Integrating, and Maintaining Data 714
Lesson 44 - Converting and Securing Data 716
Lesson 45 - Sharing Data with Word and Other Text Applications 721
Lesson 46 - Sharing Data with Excel and Access 727
Lesson 47 - Linking to Data Sources 734
Lesson 48 - Customizing Access 738
End-of-Chapter Activities 744
Microsoft PowerPoint 2013
Chapter 5 Working with Masters, Handouts, and Text 746
Lesson 32 - Working with Advanced Slide Master Features 748
Lesson 33 - Customizing Themes and Effects 755
Lesson 34 - Working with Notes and Handouts 760
Lesson 35 - Integrating PowerPoint with Word 769
Lesson 36 - Fine-Tuning Text Formats 776
Lesson 37 - Using Research Tools 784
End-of-Chapter Activities 790
Chapter 6 Working with Graphic Objects and Media 794
Lesson 38 - Applying Advanced Picture Formatting 796
Lesson 39 - Working with Advanced Multimedia Features 804
Lesson 40 - Applying Advanced Animations 810
Lesson 41 - Drawing and Adjusting Tables 818
Lesson 42 - Formatting Tables 828
Lesson 43 - Formatting Charts 835
End-of-Chapter Activities 844
Chapter 7 Finalizing and Sharing a Presentation 848
Lesson 44 - Making a Presentation Accessible to Everyone 850
Lesson 45 - Saving a Presentation in Other Formats 855
Lesson 46 - Working with Links and Actions 862
Lesson 47 - with Online Presentations 869
End-of-Chapter Activities 880
Index 885