With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office 2013 skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Office 2013 continues to engage students in applying skills to real-world situations, making concepts relevant. A new Troubleshoot case problem enhances critical thinking, and a new tutorial on Managing Your Files helps students navigate Windows 8. As always, New Perspectives improves learning outcomes and transference of skills by helping students understand why what they're learning is important.

upload/misc_2025_10/IXKXcI5mZnjhFnLAUPaa/E-Books/computer/office/9781285167640_new_perspectives_on_microsoft_office_2013_first_course_6249.pdf

nexusstc/New Perspectives on Microsoft Office 2013, Second Course/70e06fe48c730b62528b591229e62319.pdf

lgli/New Perspectives on Microsoft Office 2013, Second Course, 1st Edition.pdf

lgrsnf/New Perspectives on Microsoft Office 2013, Second Course, 1st Edition.pdf

zlib/Computers/Applications & Software/Ann Shaffer, Patrick Carey, Roy Ageloff, S. Scott Zimmerman, Beverly B. Zimmerman/New Perspectives on Microsoft Office 2013, Second Course_2345377.pdf

New perspectives on Microsoft Office 2013 : first course

Shaffer, Ann, Carey, Patrick, Ageloff, Roy, Zimmerman, S. Scott, Zimmerman, Beverly B.

Shaffer, Ann, Carey, Patrick, Parsons, June Jamrich, Oja, Dan, Finnegan, Kathy T.

Ann Shaffer, Patrick Carey, June Jamrich Parsons, Dan Oja, Kathy T. Finnegan

CENGAGE Learning Custom Publishing

Cengage Learning Australia

Course Technology Ptr

New perspectives series, Australia, 2013

United States, United States of America

Australia, 2014

0

lg1176904

producers:
Adobe PDF Library 9.9

{"edition":"1","isbns":["1285167759","9781285167756"],"last_page":933,"publisher":"Cengage Learning"}

ISBN-13:,9781285167756,ISBN-10:,1285167759
ISBN-13: 9781285167756,ISBN-10: 1285167759
Cover 1
IFC 2
Half Title 3
Title Page 5
Statement 6
ISBN 9781285167756 8
Preface 9
The New Perspectives Approach 10
Our Complete System of Instruction 11
Brief Contents 12
Table of Contents 13
Word Tutorials 21
Tutorial 5: Working with Templates, Themes, and Styles: Creating a Summary Report 21
Objectives 21
Case: Department of Cultural Affairs 21
Starting Data Files 21
Session 5.1 Visual Overview: Custom Themes and Style Sets 22
Creating a New Document from a Template 24
Using Go To 27
Using the Thesaurus to Find Synonyms 29
Customizing the Document Theme 31
Selecting a Style Set 35
Customizing Styles 38
Session 5.1 Quick Check 43
Session 5.2: Visual Overview: Creating a New Style 44
Creating a New Style 46
Displaying Information About Styles and Formatting 50
Generating a Table of Contents 56
Updating a Table of Contents 60
Saving a Document as a Template 61
Opening a New Document Based on Your Template 66
Creating a New Quick Part 67
Session 5.2 Quick Check 71
Review Assignments 72
Case Problems 73
Tutorial 6: Using Mail Merge: Creating a Form Letter, Mailing Labels, and a Telephone Directory 79
Objectives 79
Case: Candlestick Artisan Bakery 79
Starting Data Files 79
Session 6.1 Visual Overview: Mail Merge 80
Inserting a Date Field 82
Performing a Mail Merge 83
Starting the Mail Merge and Selecting a Main Document 84
Creating a Data Source 85
Inserting Merge Fields 93
Previewing the Merged Document 97
Merging the Main Document and the Data Source 99
Session 6.1 Quick Check 101
Session 6.2 Visual Overview: Editing a Data Source 102
Reopening a Main Document 104
Editing a Data Source 105
Sorting Records 108
Filtering Records 110
Creating Mailing Labels 112
Creating a Telephone Directory 117
Converting Text to a Table 120
Session 6.2 Quick Check 124
Review Assignments 125
Case Problems 126
Tutorial 7: Collaborating with Others and Integrating Data: Preparing an Information Sheet and a Webpage 133
Objectives 133
Case: Rain Gardens for Carrel Springs 133
Starting Data Files 133
Session 7.1 Visual Overview: Tracking Changes 134
Editing a Document with Tracked Changes 136
Adjusting Track Changes Options 140
Comparing and Combining Documents 142
Accepting and Rejecting Changes 146
Embedding and Linking Objects from Other Programs 150
Session 7.1 Quick Check 157
Session 7.2 Visual Overview: Linking an Excel Chart Object 158
Linking an Excel Chart Object 160
Using Hyperlinks in Word 168
Saving a Word Document as a Webpage 173
Formatting a Webpage 176
Editing Hyperlinks 181
Viewing the Webpage in a Browser 183
Creating and Publishing a Blog Post 185
Session 7.2 Quick Check 187
Review Assignments 188
Case Problems 190
ProSkills Exercise: Teamwork 195
Excel Tutorials 197
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts: Tracking Cash Receipts 197
Objectives 197
Case: Laurie’s Coffeehouse 197
Starting Data Files 197
Session 5.1 Visual Overview: Elements of an Excel Table 198
Planning a Structured Range of Data 200
Freezing Rows and Columns 202
Creating an Excel Table 204
Maintaining Data in an Excel Table 207
Sorting Data 211
Session 5.1 Quick Check 215
Session 5.2 Visual Overview: Filtering Table Data 216
Filtering Data 218
Using the Total Row to Calculate Summary Statistics 227
Splitting the Worksheet Window into Panes 230
Inserting Subtotals 232
Session 5.2 Quick Check 237
Session 5.3 Visual Overview: PivotTable and PivotChart 238
Analyzing Data with PivotTables 240
Creating a PivotTable 240
Filtering a PivotTable 248
Refreshing a PivotTable 252
Creating a Recommended PivotTable 254
Creating a PivotChart 256
Session 5.3 Quick Check 258
Review Assignments 259
Case Problems 260
Tutorial 6: Managing Multiple Worksheets and Workbooks: Summarizing Recycling Data 267
Objectives 267
Case: Better World Recycling 267
Starting Data Files 267
Session 6.1 Visual Overview: Worksheet Groups and 3-D References 268
Grouping Worksheets 270
Working with Multiple Worksheets 276
Printing a Worksheet Group 287
Session 6.1 Quick Check 289
Session 6.2 Visual Overview: Links and External References 290
Linking Workbooks 292
Updating Linked Workbooks 301
Session 6.2 Quick Check 307
Session 6.3 Visual Overview: Templates and Hyperlinks 308
Creating a Hyperlink 310
Using Templates 312
Session 6.3 Quick Check 322
Review Assignments 323
Case Problems 324
Tutorial 7: Developing an Excel Application: Creating a Receipt 329
Objectives 329
Case: Youth Soccer League 329
Starting Data Files 329
Session 7.1 Visual Overview: Excel Application and Defined Names 330
Planning an Excel Application 332
Naming Cells and Ranges 334
Using Defined Names in Formulas 340
Session 7.1 Quick Check 347
Session 7.2 Visual Overview: Data Validation and Protection 348
Validating Data Entry 350
Protecting a Worksheet and a Workbook 360
Inserting Comments 365
Session 7.2 Quick Check 367
Session 7.3 Visual Overview: Working with Macros 368
Automating Tasks with Macros 370
Protecting Against Macro Viruses 371
Recording a Macro 373
Running a Macro 377
Creating the TransferData Macro 379
Working with the Visual Basic Editor 381
Creating Macro Buttons 384
Saving a Workbook with Macros 390
Opening a Workbook with Macros 391
Removing a Tab from the Ribbon 392
Session 7.3 Quick Check 392
Review Assignments 393
Case Problems 395
Tutorial 8: Working with Advanced Functions: Calculating Employee Compensation and Benefits 403
Objectives 403
Case: Educational Video Games 403
Starting Data Files 403
Session 8.1 Visual Overview: Logical Functions 404
Working with Logical Functions 406
Using Structured References to Create Formulas in Excel Tables 417
Session 8.1 Quick Check 421
Session 8.2 Visual Overview: Nested IFs and Lookup Tables 422
Creating Nested IFs 424
Using LOOKUP Functions 429
Using the IFERROR Function 440
Session 8.2 Quick Check 443
Session 8.3 Visual Overview: Conditional Formatting and Functions 444
Applying Conditional Formatting 446
Using Functions to Summarize Data Conditionally 451
Session 8.3 Quick Check 459
Review Assignments 460
Case Problems 461
ProSkills Exercise: Problem Solving 466
Appendix A: Working with Text Functions and Creating Custom Formats: Cleaning Data in a Spreadsheet 469
Objectives 469
Case: Sharp Blades Hockey Club 469
Starting Data Files 469
Opening and Saving Workbooks Created in Earlier Versions of Excel 470
Using Text Functions 471
Creating Custom Formats 482
Using the Compatibility Checker 485
Review Assignments 487
Case Problems 487
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions: Filtering and Summarizing Database Information 489
Objectives 489
Case: E-Quip Tools 489
Starting Data Files 489
Using Advanced Filters 490
Using Database Functions to Summarize Data 497
Summarizing Data Using the COUNTIFS, SUMIFS, and AVERAGEIFS Functions 501
Review Assignments 507
Case Problems 507
Access Tutorials 509
Tutorial 5: Creating Advanced Queries and Enhancing Table Design: Making the Clinic Database Easier to Use 509
Objectives 509
Case: Chatham Community Health Services 509
Starting Data Files 509
Session 5.1 Visual Overview: Calculated Field 510
Reviewing the Clinic Database 512
Using a Pattern Match in a Query 513
Using a List-of-Values Match in a Query 516
Using the Not Logical Operator in a Query 517
Assigning a Conditional Value to a Calculated Field 521
Creating a Parameter Query 525
Session 5.1 Quick Check 529
Session 5.2 Visual Overview: Advanced Query Wizards 530
Creating a Crosstab Query 532
Creating a Find Duplicates Query 538
Creating a Find Unmatched Query 540
Creating a Top Values Query 543
Session 5.2 Quick Check 545
Session 5.3 Visual Overview: Lookup Fields and Input Masks 546
Creating a Lookup Field 548
Using the Input Mask Wizard 552
Identifying Object Dependencies 558
Defining Data Validation Rules 559
Working with Long Text Fields 563
Designating a Trusted Folder 566
Session 5.3 Quick Check 569
Review Assignments 570
Case Problems 571
Tutorial 6: Using Form Tools and Creating Custom Forms: Creating Forms for Chatham Community Health Services 577
Objectives 577
Case: Chatham Community Health Services 577
Starting Data Files 577
Session 6.1 Visual Overview: Anchoring Controls 578
Designing Forms 580
Printing Database Relationships and Using the Documenter 583
Creating Forms Using Form Tools 587
Session 6.1 Quick Check 597
Session 6.2 Visual Overview: Form in Design View 598
Planning and Designing a Custom Form 600
Creating a Custom Form in Design View 600
Selecting, Moving, and Aligning Controls 605
Resizing and Deleting Controls 609
Adding a Combo Box to a Form 612
Using Form Headers and Form Footers 618
Adding a Title to a Form 619
Session 6.2 Quick Check 621
Session 6.3 Visual Overview: Custom Form in Form View 622
Adding a Combo Box to Find Records 624
Displaying a Subform’s Calculated Controls in the Main Form 632
Changing the Tab Order in a Form 640
Improving a Form’s Appearance 643
Session 6.3 Quick Check 648
Review Assignments 649
Case Problems 651
Tutorial 7: Creating Custom Reports: Creating Custom Reports for Chatham Community Health Services 657
Objectives 657
Case: Chatham Community Health Services 657
Starting Data Files 657
Session 7.1 Visual Overview: Report Sections 658
Customizing Existing Reports 660
Session 7.1 Quick Check 675
Session 7.2 Visual Overview: Report Design view and Print Preview 676
Designing a Custom Report 678
Creating a Query for a Custom Report 679
Creating a Custom Report 681
Working with Controls in Design View 688
Hiding Duplicate Values in a Report 694
Session 7.2 Quick Check 695
Session 7.3 Visual Overview: Custom report in Design view 696
Adding the Date to a Report 698
Adding a Title to a Report 704
Creating Mailing Labels 706
Session 7.3 Quick Check 710
Review Assignments 711
Case Problems 712
Tutorial 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Clinic Database 719
Objectives 719
Case: Chatham Community Health Services 719
Starting Data Files 719
Session 8.1 Visual Overview: Exporting data to XML and HTML 720
Exporting an Access Query to an HTML Document 722
Importing a CSV File as an Access Table 725
Importing a table from an Access Database 730
Using XML 732
Session 8.1 Quick Check 741
Session 8.2 Visual Overview: Tabbed Control with a Chart 742
Creating a Tabbed Form Using a Tab Control 744
Integrating Access with Other Programs 748
Embedding a Chart in a Form 750
Using Templates and Application Parts 756
Exporting a Report to a PDF File 761
Linking Data from an Excel Worksheet 762
Session 8.2 Quick Check 765
Review Assignments 766
Case Problems 767
ProSkills Exercise: Decision Making 771
Appendix A: Relational Databases and Database Design 773
Objectives 773
Tables 774
Keys 775
Relationships 777
Entity-Relationship Diagrams 781
Integrity Constraints 783
Dependencies and Determinants 784
Anomalies 786
Normalization 787
Natural, Artificial, and Surrogate Keys 793
Microsoft Access Naming Conventions 797
Review Assignments 800
PowerPoint Tutorials 805
Tutorial 3: Applying Advanced Formatting to Objects: Formatting Objects in a Presentation for a Seminar Management Company 805
Objectives 805
Case: Spring Lake Seminar Management, Inc. 805
Starting Data Files 805
Session 3.1 Visual Overview: Creating a Chart on a Slide 806
Creating SmartArt Diagrams 808
Adding Audio to Slides 813
Adding a Chart to a Slide 815
Inserting and Formatting Text Boxes 821
Applying WordArt Styles to Text 824
Session 3.1 Quick Check 827
Session 3.2 Visual Overview: Formatting Shapes and Pictures 828
Editing Photos 830
Removing the Background from Photos 832
Applying Artistic Effects to Photos 834
Creating a Custom Shape 836
Applying Advanced Formatting to Shapes 841
Making Presentations Accessible 845
Session 3.2 Quick Check 849
Review Assignments 850
Case Problems 852
Tutorial 4: Advanced Animations and Distributing Presentations: Creating an Advanced Presentation for a Wireless Control Systems Company 857
Objectives 857
Case: Duplantis Control Systems 857
Starting Data Files 857
Session 4.1 Visual Overview: Understanding Advanced Animations 858
Adding More Than One Animation to an Object 860
Using the Animation Pane 864
Setting Animation Triggers 866
Changing the Slide Background 868
Creating and Editing Hyperlinks 872
Customizing Theme Colors 879
Session 4.1 Quick Check 883
Session 4.2 Visual Overview: Automatic Slide Timings 884
Creating a Self-Running Presentation 886
Setting Options for Overriding the Automatic Timings 893
Applying Kiosk Browsing 893
Using the Document Inspector 895
Packaging a Presentation for CD 897
Saving the Presentation in an Earlier Version of PowerPoint 898
Session 4.2 Quick Check 900
Review Assignments 901
Case Problems 902
ProSkills Exercise: Teamwork 907
Glossary/Index 909
Task Reference 925
IBC 933

2014-06-07