Office 2013 Digital Classroom

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