Microsoft Office 2013 simplified

A basic introduction to learn Office 2013 quickly, easily, and in full color Office 2013 has new features and tools to master, and whether you're upgrading from an earlier version or using the Office applications for the first time, you'll appreciate this simplified approach. Offering a clear, visual style of learning, this book provides you with concise, step-by-step instructions and full-color screen shots that walk you through the applications in the Microsoft Office 2013 suite: Word, Excel, PowerPoint, Outlook, and Publisher. Shows you how to tackle dozens of Office 2013 tasks Shares practical examples and beneficial advice to guide you through each application Focuses on visual learners, with step-by-step instructions illustrated with full-color screen shots throughout Office 2013 Simplified makes the new Office suite easy to understand, even if you are new to the software. Microsoft Office 2013 Simplified......Page 1 Dedication......Page 6 How to Use This Book......Page 7 Table of Contents......Page 8 Part I: Office Features......Page 16 Start and Exit Office Applications......Page 18 Navigate the Program Windows......Page 20 Work with Backstage View......Page 21 Work with the Ribbon......Page 22 Customize the Quick Access Toolbar......Page 24 Using an Office Program on a Tablet PC......Page 26 Create a New File......Page 28 Working with Files......Page 29 Save a File......Page 30 Open a File......Page 32 Print a File......Page 34 E-Mail a File......Page 36 Select Data......Page 38 Cut, Copy, and Paste Data......Page 40 Arrange Windows......Page 42 Insert a Picture......Page 44 Insert an Online Picture......Page 46 Resize and Move Graphic Objects......Page 48 Understanding Graphic Object Modification Techniques......Page 50 Office and the Cloud......Page 52 Sign In to Office Online......Page 54 Share a Document from Office......Page 56 Download Apps from the Office Store......Page 58 Download Apps from the Office Store (continued)......Page 60 Sign In to SkyDrive......Page 62 Using a Web App in SkyDrive......Page 64 Using an Office Program from SkyDrive......Page 66 Upload a Document to SkyDrive......Page 68 Share a Document Using SkyDrive......Page 70 Part II: Word......Page 72 Change Word’s Views......Page 74 Type and Edit Text......Page 76 Insert Quick Parts......Page 78 Insert Symbols......Page 80 Create a Blog Post......Page 82 Change the Font, Size, and Color......Page 84 Change the Font, Size, and Color (continued)......Page 86 Align Text......Page 88 Set Line Spacing......Page 89 Indent Text......Page 90 Set Tabs......Page 92 Set Margins......Page 94 Create Lists......Page 96 Copy Formatting......Page 98 Clear Formatting......Page 99 Format with Styles......Page 100 Apply a Template......Page 102 Insert an Online Video......Page 104 Assign a Theme......Page 106 Add Borders......Page 108 Create Columns......Page 110 Insert a Table......Page 112 Apply Table Styles......Page 114 Insert an Excel Spreadsheet......Page 115 Add Headers and Footers......Page 116 Insert Footnotes and Endnotes......Page 118 Insert Page Numbers and Page Breaks......Page 120 Generate a Table of Contents......Page 122 Create a Bibliography......Page 124 Work in Read Mode View......Page 126 Find and Replace Text......Page 128 Scan Document Content......Page 130 Check Spelling and Grammar......Page 132 Work with AutoCorrect......Page 134 Using Word’s Thesaurus and Dictionary......Page 136 Translate Text......Page 138 Track and Review Document Changes......Page 140 Lock and Unlock Tracking......Page 142 Work with Comments......Page 144 Part III: Excel......Page 146 Enter Cell Data......Page 148 Select Cells......Page 149 Faster Data Entry with AutoFill......Page 150 Building Spreadsheets......Page 151 Turn On Text Wrapping......Page 152 Center Data across Columns......Page 153 Adjust Cell Alignment......Page 154 Change the Font and Size......Page 156 Change Number Formats......Page 158 Increase or Decrease Decimals......Page 159 Add Cell Borders and Shading......Page 160 Format Data with Styles......Page 162 Apply Conditional Formatting......Page 164 Add Columns and Rows......Page 166 Resize Columns and Rows......Page 168 Freeze Column and Row Titles On-Screen......Page 169 Name a Range......Page 170 Clear or Delete Cells......Page 172 Split and Format a Column of Data......Page 174 Add a Worksheet......Page 176 Name a Worksheet......Page 177 Change Page Setup Options......Page 178 Worksheet Basics......Page 179 Move and Copy Worksheets......Page 180 Delete a Worksheet......Page 181 Find and Replace Data......Page 182 Create a Table......Page 184 Filter or Sort Table Information......Page 186 Analyze Data Quickly......Page 188 Understanding Data Analysis Choices......Page 189 Track and Review Worksheet Changes......Page 190 Track and Review Worksheet Changes (continued)......Page 192 Insert a Comment......Page 194 Understanding Formulas......Page 196 Create a Formula......Page 198 Apply Absolute and Relative Cell References......Page 200 Understanding Functions......Page 202 Apply a Function......Page 204 Total Cells with AutoSum......Page 206 Audit a Worksheet for Errors......Page 208 Create a Chart......Page 210 Move and Resize Charts......Page 212 Change the Chart Type......Page 214 Change the Chart Style......Page 215 Change the Chart Layout......Page 216 Add Chart Elements......Page 217 Format Chart Objects......Page 218 Change the Chart Data......Page 219 Using Sparklines to View Data Trends......Page 220 Part IV: PowerPoint......Page 222 Create a New Presentation......Page 224 Create a Photo Album Presentation......Page 226 Change PowerPoint Views......Page 228 Insert Slides......Page 230 Change the Slide Layout......Page 231 Change the Slide Size......Page 232 Add and Edit Slide Text......Page 234 Change the Font, Size, and Color......Page 236 Change the Font, Size, and Color (continued)......Page 238 Apply a Theme......Page 240 Set Line Spacing......Page 241 Align Text......Page 242 Add a Text Box to a Slide......Page 243 Add a Table to a Slide......Page 244 Add a Chart to a Slide......Page 246 Add a Video Clip to a Slide......Page 248 Move a Slide Object......Page 250 Resize a Slide Object......Page 251 Reorganize......Page 252 Reuse a Slide......Page 254 Define Slide Transitions......Page 256 Add Animation Effects......Page 258 Record Narration......Page 260 Insert a Background Song......Page 261 Create Speaker Notes......Page 262 Rehearse a Slide Show......Page 264 Run a Slide Show......Page 266 Run a Slide Show (continued)......Page 268 Review a Presentation......Page 270 Package Your Presentation on a CD......Page 272 Present Online......Page 274 Part V: Access......Page 276 Understanding Database Basics......Page 278 Create a Database Based on a Template......Page 280 Create a Blank Database......Page 282 Create a New Table......Page 284 Change Table Views......Page 286 Add a Field to a Table......Page 288 Delete a Field from a Table......Page 289 Hide a Field in a Table......Page 290 Move a Field in a Table......Page 291 Create a Form......Page 292 Change Form Views......Page 294 Move a Field in a Form......Page 295 Delete a Field in a Form......Page 296 Apply a Database Theme......Page 297 Add a Record......Page 298 Add a Record to a Form......Page 300 Navigate Records in a Form......Page 302 Search for a Record in a Form......Page 303 Delete a Record from a Table......Page 304 Delete a Record from a Form......Page 305 Sort Records......Page 306 Filter Records......Page 308 Apply Conditional Formatting......Page 310 Perform a Simple Query......Page 312 Perform a Simple Query (continued)......Page 314 Create a Report......Page 316 Part VI: Outlook......Page 318 Navigate in Outlook......Page 320 Schedule an Appointment......Page 322 Create a New Contact......Page 324 Create a New Task......Page 326 Add a Note......Page 328 Customize the Navigation Bar......Page 330 Peek at Appointments and Tasks......Page 332 Perform a Basic Search......Page 334 Link Contacts......Page 335 Compose and Send a Message......Page 336 Send a File Attachment......Page 338 Read an Incoming Message......Page 339 Reply To or Forward a Message......Page 340 Add a Sender to Your Outlook Contacts......Page 342 Delete a Message......Page 343 Work with Conversations......Page 344 Screen Junk E-Mail......Page 346 Part VII: Publisher......Page 348 Create a Publication......Page 350 Zoom In and Out......Page 352 Add Text......Page 354 Add a New Text Box......Page 355 Swap Pictures......Page 356 Save a Publication for Photo Center Printing......Page 358 Change the Font, Size, and Color......Page 360 Change the Font, Size, and Color (continued)......Page 362 Apply a Text Effect......Page 364 Change Text Alignment......Page 365 Add a Border......Page 366 Control Text Wrap......Page 367 Link Text Boxes......Page 368 Edit the Background......Page 370 Part VIII: OneNote......Page 372 Navigate OneNote......Page 374 Type and Draw Notes......Page 376 Insert and Format a Table......Page 378 Attach Files to Notes......Page 380 Send Information to OneNote......Page 381 Insert a Screen Clipping......Page 382 Create a Quick Note......Page 383 Record an Audio Note......Page 384 Create a New Notebook......Page 386 Create a New Section......Page 387 Create a New Page......Page 388 Rename a Section or Page......Page 389 Group Sections......Page 390 Search Notes......Page 392 Search for Recent Edits......Page 394 Set Synchronization Options......Page 395 Share Notes with People Who Do Not Have OneNote......Page 396 Index......Page 398 Office features. Office basics ; Working with files ; Office graphics tools ; Working with Office files online Word. Adding text ; Formatting text ; Adding extra touches ; Reviewing documents Excel. Building spreadsheets ; Worksheet basics ; Working with formulas and functions ; Working with charts PowerPoint. Creating a presentation ; Populating presentation slides ; Assembling and presenting a slide show Access. Database basics ; Adding, finding, and querying data Outlook. Organizing with Outlook ; E-mailing with Outlook Publisher. Publisher basics ; Fine-tuning a publication OneNote. Taking notes with OneNote ; Organizing and sharing notes. Teach Like a Champion 2.0 is a complete update to the international bestseller. This teaching guide is a must-have for new and experienced teachers alike. Over 700,000 teachers around the world already know how the techniques in this book turn educators into classroom champions. With ideas for everything from classroom management to inspiring student engagement, you will be able to perfect your teaching practice right away.