9781118568477

This complete training package makes learning the new Office 2013 even easier! Featuring both a video training DVD and a full-color book, this training package is like having your own personal instructor guiding you through each lesson of learning Office 2013, all while you work at your own pace. The self-paced lessons allow you to discover the new features and capabilities of the new Office suite. Each lesson includes step-by-step instructions and lesson files, and provides valuable video tutorials that complement what you're learning and clearly demonstrate how to do tasks. This essential training package takes you well beyond the basics in a series of short, easy-to-absorb lessons. Takes you from the basics through intermediate level topics and helps you find the information you need in a clear, approachable manner Walks you through numerous lessons, each consisting of easy-to-follow, step-by-step instructions in full color that make each task less intimidating Covers exciting new features of Office 2013 applications: Word, Excel, PowerPoint, Outlook, and Publisher Features a companion DVD that includes lesson files and video tutorials for a complete training experience Shares additional resources available on companion website: www.digitalclassroombooks.com This all-in-one, value-packed combo teaches you all you need to know to get confidently up and running with the new Office 2013 suite!

Starting up

About Microsoft Office 2013 Digital Classroom 1

Prerequisites 1

System requirements 2

Fonts used in this book 2

Access lesson files and videos any time 2

Checking for updated lesson files 2

Loading lesson files 3

Working with the video tutorials 3

Setting up for viewing the video tutorials 4

Viewing the video tutorials with the Adobe Flash Player 4

Additional resources 5

Word Lesson 1: Microsoft Word 2013 Jumpstart Starting up 7

The project 8

Interface conventions 9

Working with words 10

Text and fields 10

Applying styles to text 12

Your document’s look and feel 13

Working with themes, style sets, and color schemes 13

Working with images and video 16

Styling an image 16

Working with online images and videos 17

Different views of your document 18

Collapsing document sections 18

Working with Word’s windows 19

Collaboration and tracking changes 20

Communicating with colleagues in comments 20

Save always 21

Self study 22

Review 22

Word Lesson 2: Getting Started with Word 2013

Starting up 23

The Word 2013 interface 24

The Start screen and template gallery 24

Opening a document 25

The Ribbon 26

Customizing the Ribbon 27

The Quick Access toolbar 29

The Status bar 30

The Navigation pane 30

Different viewing modes 31

Laying out the page 33

Page size, margins, and marginalia 33

Headers and footers 34

Windows and panes: splitting your document view 35

Self study 37

Review 37

Word Lesson 3: Beginning Text and Layout Operations

Starting up 39

Working with text in Word 40

Paragraph and character formatting 40

Spacing 41

Styles, themes, and live preview 42

Cut, copy, and paste 45

Paste options 45

Copying a look: Format Painter 46

A paste to fit every taste 46

Working with columns 47

Text boxes and images 49

Placing text boxes and images 49

Inserting an object directly into a paragraph 52

Self study 53

Review 53

Word Lesson 4: Structuring Complex Documents

Starting up 55

Documents are data 56

Headings: logical document divisions 56

Text folding 56

Sorting sections alphabetically 58

Building an outline with headings 59

Working in outline view 59

Captions 60

Tagging images with captions 61

Working with fields 62

Viewing field codes 62

Setting and accessing document properties 63

Adding a cover page 64

Page and section breaks 65

Seeing breaks and other hidden characters 65

Section breaks 66

Cross-references 66

Footnotes and endnotes 68

Adding and deleting ntoes 68

Endnotes, briefly 69

Adding a table of contents 69

From headings to table of contents 69

Building a custom table of contents 71

Using table fields in your TOC 72

Adding a table of figures 73

Self study 74

Review 74

Word Lesson 5: Working with Tables

Starting up 75

The uses of tables 76

Table basics 77

Inserting and navigating tables 77

Split cells and table styles 78

Working with text in and around tables 79

Text alignment and merged cells 80

Merging cells with the Eraser tool 82

Presenting and sorting tabular data 83

Adding, deleting, and moving columns and rows 83

Sorting data in a table 84

Designing tables 85

Table style options 85

Applying a table style 87

Setting cell and table borders 88

Using the Border Painter tool 88

Editing cell contents 89

Cell text and manual cell sizing 89

Using AutoFit and Fit Text 91

Images in tables 92

Self study 93

Review 93

Word Lesson 6: Beyond Word: Linking and Collaborating

Starting up 95

Group work and Groupware 96

Tracking your edits 96

How Word displays edits 97

Tracking new changes 99

Controlling the markup that you see 100

The Reviewing pane 100

Editing and collaborating 101

Accepting and rejecting changes 101

Comments and conversations 102

Taking a comment thread to e-mail or instant messenger 103

Access control 103

Blocking certain edits 103

Restricting editing 104

Comparing and combining documents 105

Comparing documents 105

Combining documents 106

Embedding and linking objects 107

Linking to an Excel spreadsheet 107

Unlinking a linked object 108

Self study 108

Review 108

Word Lesson 7: Creating Mail Merges

Starting up 109

Mail merges 110

Linking to a data source 110

Data sources for mail merges 112

Inserting merge fields into a document 112

Inserting simple merge fields 113

Using if-then conditional fields 115

Previewing a merge 117

Conditionally inserting an image 117

Finalizing the merge 118

Self study 120

Review 120

Word Lesson 8: Blogging in Word

Starting up 121

How blogs work 122

Setting up a blog account 122

Creating a blog post 124

Setting your blog post’s categories 125

Uploading posts and drafts 126

Editing posts stored on the server 126

Self study 126

Review 126

Excel Lesson 1: Getting Started with Excel 2013

Starting up 127

Getting to know the workspace 128

Getting to know the cell pointer 130

Using the Ribbon 131

Exploring the Status bar 134

Using the Quick Access toolbar 136

Using the Formula bar 137

Moving around the worksheet 138

Exploring what’s new in Excel 2013 142

Self study 146

Review 146

Excel Lesson 2: Creating a Worksheet in Excel 2013

Starting up 147

Creating a worksheet 148

Entering data in a cell 148

Working with cell ranges 152

Saving workbooks 155

Opening workbooks 157

Editing data 159

Using Undo and Redo 162

Working with rows and columns 162

Creating additional worksheets 167

Printing worksheets and workbooks 170

Self study 176

Review 176

Excel Lesson 3: Formatting a Worksheet

Starting up 177

Understanding cell formats 178

Changing number formats 179

Changing the font and font size 184

Modifying row heights and column widths 189

Cell alignment 191

Borders and shading 193

Copying cell formats 196

Working with cell styles 196

Using conditional formatting 201

Using page themes 204

Self study 208

Review 208

Excel Lesson 4: Using Formulas in Excel 2013

Starting up 209

Formulas 210

Entering simple formulas 211

Referencing cells from other worksheets or workbooks 213

Using functions 214

Using the Function Library 215

Using the AutoSum tool 217

Using common functions 218

Working with ranges 223

Copying formulas 227

Formula auditing 231

Self study 235

Review 235

Excel Lesson 5: Working with Charts

Starting up 237

Understanding chart types 238

Creating a chart 239

Understanding chart elements 240

Using chart recommendations 241

Moving and resizing charts 242

Enhancing a chart 245

Formatting a chart 250

Editing a chart 253

Customizing the chart 259

Printing a chart 262

Using Sparklines 262

Self study 266

Review 266

Excel Lesson 6: Working with Data

Starting up 267

Working with lists 268

Creating a list 268

Sorting records 270

Filtering records 274

Searching records 276

Deleting records 277

Removing duplicates 278

Extracting records 279

Subtotaling data 280

Grouping records 282

Using data validation 283

Converting text to columns 286

Using Flash Fill 288

Self study 290

Review 290

Excel Lesson 7: Working with Excel 2013 Templates

Starting up 291

Excel templates 292

Working with templates 294

Saving a workbook as a template 295

Opening a custom template 296

Protecting workbooks 297

Protecting worksheets 301

Unlocking cells in a protected worksheet 302

Hide and protect formulas 305

Searching for templates 306

Self study 307

Review 307

Excel Lesson 8: Advanced Data Analysis

Starting up 309

Introduction to PivotTables 310

Creating a PivotTable 310

Rearranging a PivotTable 313

Removing fields from a PivotTable 315

Formatting a PivotTable 316

Editing and updating a PivotTable 321

Changing the calculation 323

Hiding and showing data in a PivotTable 326

Adding subtotals to a PivotTable 329

Using recommended PivotTables 332

Working with PivotCharts 334

Working with tables 338

What-If analysis 343

Self study 349

Review 349

PowerPoint Lesson 1: Microsoft PowerPoint 2013 Jumpstart

Starting up 351

Choosing a template 353

Editing the title slide 354

Adding slides 354

Adding text to your presentation 354

Adding visuals to a slide 356

From slides to presentation 358

Including speaker notes 358

Practicing the slide show 359

Animating your presentation 361

Making the most of animations 362

Linking slides with transitions 363

Grouping and ordering slides in Slide Sorter 364

Setting your overall look with document themes 365

Self study 367

Review 367

PowerPoint Lesson 2: Getting Started with PowerPoint 2013

Starting up 369

Your workspace and your toolbox 370

PowerPoint and the Office 2013 user interface 370

The Ribbon and Backstage view 371

Choosing a look with the Design tab 372

Moving from content to performace 372

Building your presentation content 373

Building an outline 373

Editing slide content 374

Formatting inserted images 375

Creating notes pages 377

Reading view 378

Working with text, images and visual effects 378

Simplified text handling 378

Inserting images 379

Adding and editing animations 379

Transitions and slide sorter 381

Design tools 382

What’s in a template? 382

Applying themes to a slide show 384

Customizing a theme in the Slide Master view 384

Self study 385

Review 385

PowerPoint Lesson 3: Designing a Presentation

Starting up 387

Building better slides 388

Working with text 388

Filling in an existing text area 388

Adding and styling text boxes 390

The Format pane 392

Autofit and text boxes 393

Styling text with WordArt 394

Formatting the whole presentation 395

The Slide Master view 395

Editing the Slide Master 395

Creating custom slide layouts 397

Adding a custom slide layout 398

Completing the custom layout 399

Applying the custom layout 399

Customizing a presentation theme 400

Changing a theme’s visual scheme 401

Self study 402

Review 402

PowerPoint Lesson 4: Using Tables, Charts, and SmartArt

Starting Up 403

Giving structure to your content 404

Transforming text into SmartArt 404

Formatting bulleted lists as SmartArt 404

Visually editing a flowchart 405

Styling a piece of SmartArt 407

Piecing together SmartArt 409

Linking and embedding external data 411

Embedding an Excel worksheet as an object 411

Editing embedded objects 413

Creating a linked object 415

Creating a chart from tabular data 415

Generating charts in PowerPoint 415

Editing individual chart elements 416

Linking a chart to external Excel data 417

Styling charts and graphs 418

Self study 420

Review 420

PowerPoint Lesson 5: Adding Graphics and Multimedia to Your Presentation

Starting up 421

Beyond bulleted lists and bar graphs 422

Recoloring and adjusting images 422

Cropping an image 424

Reordering images in the object “Stack” 425

Heightening visual impact with animations 426

Creating a crossfade effect with

stacked slide elements 426

Creating complex scenes by clustering animations 426

Enriching slides with sound effects 428

Adding background sounds to a presentation 429

Trimming and triggering sound effects 430

Adding custom actions to slide objects 432

Integrating video into a presentation 433

Embedding and formatting video 433

Considerations for embedding local video 434

Media compression and compatibility 435

Laying out slide elements 436

Taking advantage of the grid 436

Working with alignment guides 438

Self study 439

Review 439

PowerPoint Lesson 6: Delivering Your Presentation

Starting Up 441

Presentations are performances 442

Preparing for your presentation 442

Setting up the slide show 443

Controlling your presentation from the keyboard 444

Creating custom slide shows 445

Presenting in slide show preview 446

Mission control: PowerPoint’s presenter view 446

Using speaker notes 448

How detailed should speaker notes be? 449

Formatting and printing notes pages 449

Designing a printed handout 451

Navigating with the slide sorter 451

Going to a black or white screen 452

Focusing audience attention with Pen tools 452

Using the laser pointer and highlighter 452

Keeping ink annotations 453

Rehearsing your presentation 454

Recording slide and presentation timings 454

Recording narration and pointer movements 455

Tweaking and removing timings, narration, and laser pointer movements 456

Presenting online 456

Delivering a presentation using

Office Presentation service 457

Presenting in Lync 459

Embedding your slide show in a webpage 459

Giving excellent presentations 460

Self study 462

Review 462

Access Lesson 1: Microsoft Access 2013 Jumpstart

Starting up 463

What is Access? 464

Ways to use Access 464

Database basics 464

Basic database terminology 465

Database design tips 465

Quick tour of Access 2013 466

Opening an Access 2013 file 466

Access 2013 components 467

Exploring a database 470

Working with records 475

Searching for a record 475

Sorting records 476

Adding and deleting records 477

Customizing the Quick Access toolbar 479

Getting help 480

Ending an Access session 480

Self study 481

Review 481

Access Lesson 2: Getting Started with Microsoft Access 2013

Starting up 483

Access 2013 database types 484

Creating a simple database 484

Creating a database using a template 484

Saving a new table 487

Tables, views, and data types 487

Creating a table in Datasheet view 488

Adding fields to an Access table 489

Creating a table in Design view 491

Adding fields to a table 492

Importing data from a Microsoft Excel spreadsheet 494

To rename the new table Sheet1 495

Self study 496

Review 496

OneNote Lesson 1: Microsoft OneNote 2013 Jumpstart

Starting up 497

Discovering OneNote 498

Exploring the OneNote environment 498

Opening OneNote 498

About the Send to OneNote command 499

Opening a new blank Notebook 500

Normal (Notebook) view 501

Working in Backstage view 503

Searching OneNote 504

Creating a new Notebook section 505

Customizing OneNote 507

Getting help 509

Ending a OneNote session 509

Self study 510

Review 510

OneNote Lesson 2: Getting Started with OneNote 2013

Starting up 511

Managing Notebooks 512

Creating a new Notebook 512

Managing Sections 513

Creating new Sections 514

Renaming a Section in OneNote 514

Grouping Sections 515

Creating Section groups in a OneNote project 515

Saving a Notebook 517

Saving a copy of a Notebook 517

Managing Pages 518

Adding and renaming Pages 518

Inserting content into Notebook Pages 519

Direct text entry (typing) 519

Copying and pasting 520

Creating a drawing using a mouse, touchpad, or electronic pen 520

Inserting audio and video notes 522

Inserting web content 523

Self study 527

Review 527

Publisher Lesson 1: Introduction to Microsoft Publisher 2013

Starting up 529

What is Publisher? 530

Ways to use Publisher 530

Publisher basics 530

Quick tour of Publisher 2013 531

Opening a publication 536

Changing your view 537

Saving a publication 538

Customizing the Quick Access toolbar 539

Getting help 540

Closing a Publisher session 540

Self study 541

Review 541

Publisher Lesson 2: Microsoft Publisher 2013 Jumpstart

Starting up 543

Creating a blank publication 544

Working with pages 545

Setting page margins 547

Changing page orientation 548

Changing page sizes 548

Inserting a text box 550

Formatting text 551

Flowing text 552

Inserting and modifying images 553

Printing your publication 555

Using Pack and Go 556

Sending a publication using e-mail 557

E-mail preview 559

Self study 560

Review 560

Outlook Lesson 1: Introduction to Microsoft Outlook 2013

Starting up 561

What is Microsoft Outlook? 562

Setting up Outlook 562

Using more than one e-mail account 563

Outlook 2013 interface 563

The Ribbon tabs 563

Minimizing Outlook Ribbons 564

The Quick Access toolbar 564

Composing e-mail, inserting attachments, adding recipients, and sending messages 566

Adding attachments to e-mail messages 567

Adding signatures 568

Receiving e-mail 569

Organizing e-mail 569

Using folders 569

Archiving old messages 571

Contacts and the Address Book 572

Adding contacts 573

Finding contacts 573

Creating groups 574

Calendar 575

Appointments and meetings 575

Creating appointments and setting-up reminders 575

Setting-up meetings and inviting attendees 577

Using tasks 578

Self study 579

Review 579

Outlook Lesson 2: Getting Started with Microsoft Outlook 2013

Starting up 581

Outlook views 582

Printing in Outlook views 582

Printing in the Mail view 582

Printing in the Calendar view 583

Adjusting views in Calendar 584

Printing in other views 585

Customizing the Mail view 585

About the Folder pane 585

Customizing the Folder pane for the Mail view 585

Folder pane navigation options 587

Customizing the Reading pane 588

Customizing the To-Do bar 591

Customizing the People pane 593

Customizing the Ribbons 594

Forwarding and replying to e-mail 596

Replying to an e-mail message 596

Forwarding an e-mail message 598

Using Rules to manage incoming items 599

Creating a Rule to manage e-mail 599

Managing a Rule 600

Recurring appointments and meetings 601

Creating a recurring appointment 601

Create a recurring meeting 602

Junk e-mail options 603

Managing Junk e-mail 603

Self study 604

Review 604

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Microsoft Office 2013 Digital Classroom

Microsoft Office 2013 Digital Classroom

1118568478

Summary

Table of Contents

Supplemental Materials

Write a Review