Start learning the latest in Office Office Simplified is the quick, easy, full-color guide to the new features and tools of the latest version of Office. With a clear, highly visual, introductory style of instruction, this book gives you step-by-step directions alongside illustrative screen shots to help you learn Microsoft's bestselling productivity software. You'll take a tour through all Office applications, and learn how the new tools can make your workday easier. The simplified approach eliminates unnecessary information, focusing instead on the essentials you need to know to get things done. Organized for easy navigation, this helpful guide is designed to be used both as a start-to-finish tutorial and as a handy desk reference when you run into unfamiliar territory. Whether you're upgrading from a previous version or using the Office suite of applications for the first time, this book has you covered every step of the way. You'll find the answers you need, new tools you can use, and the step-by-step guidance that helps you get it right on the first try.
Get acquainted with the Office workflow Walk through Word, Excel, PowerPoint, Outlook, and Publisher Follow along with practical examples to tackle dozens of tasks Compose documents, create spreadsheets, organize your email, and more This book provides the ideal rundown of Microsoft Office's full feature set and capabilities. Even experienced users may learn something they never realized they were missing. If you need to get things done with minimal interruption to your workflow, Office Simplified will get you up to speed quickly and easily.
John Wiley & Sons Inc
Country of Publication:
23 October 2015
OFFICE FEATURES Chapter 1 Office Basics Start and Exit Office Applications 4 Navigate the Program Windows 6 Work with Backstage View 7 Change the Color Scheme 8 Find a Ribbon Command 10 Work with the Ribbon 12 Customize the Quick Access Toolbar 14 Using an Office Program on a Tablet PC 16 Chapter 2 Working with Files Create a New File 18 Save a File 20 Open a File 22 Print a File 24 Email a File 26 Select Data 28 Cut, Copy, and Paste Data 30 Arrange Windows 32 Chapter 3 Office Graphics Tools Insert a Picture 34 Insert an Online Picture 36 Resize and Move Objects 38 Understanding Graphics Modification Techniques 40 Chapter 4 Working with Office Files Online Office and the Cloud 42 Sign In to Office 365 44 Share a Document from Office 46 Download Apps from the Office Store 48 Sign In to OneDrive 50 Using an Online App in OneDrive 52 Using an Office Program from OneDrive 54 Upload a Document to OneDrive 56 Share a Document Using OneDrive 58 WORD Chapter 5 Adding Text Change Word's Views 62 Type and Edit Text 64 Insert Quick Parts 66 Insert Symbols 68 Create a Blog Post 70 Chapter 6 Formatting Text Change the Font, Size, and Color 72 Align Text 76 Set Line Spacing 77 Indent Text 78 Set Tabs 80 Set Margins 82 Create Lists 84 Copy Formatting 86 Clear Formatting 87 Format with Styles 88 Using a Template 90 EXCEL Chapter 7 Adding Extra Touches Insert an Online Video 92 Assign a Theme 94 Add Borders 96 Create Columns 98 Insert a Table 100 Apply Table Styles 102 Insert Table Rows or Columns 103 Add Headers and Footers 104 Insert Footnotes and Endnotes 106 Insert Page Numbers and Page Breaks 108 Generate a Table of Contents 110 Create a Bibliography 112 Chapter 8 Reviewing Documents Work in Read Mode View 114 Find and Replace Text 116 Scan Document Content 118 Check Spelling and Grammar 120 Work with AutoCorrect 122 Using Word's Thesaurus and Dictionary 124 Translate Text 126 Track and Review Document Changes 128 Lock and Unlock Tracking 130 Work with Comments 132 EXCEL Chapter 9 Building Spreadsheets Enter Cell Data 136 Select Cells 137 Faster Data Entry with AutoFill 138 Turn On Text Wrapping 140 Center Data Across Columns 141 Adjust Cell Alignment 142 Change the Font and Size 144 Change Number Formats 146 Increase or Decrease Decimals 147 Add Cell Borders and Shading 148 Format Data with Styles 150 Apply Conditional Formatting 152 Add Columns and Rows 154 Resize Columns and Rows 156 Freeze Column and Row Titles On?Screen 157 Name a Range 158 Clear or Delete Cells 160 Split and Format a Column of Data 162 Chapter 10 Worksheet Basics Add a Worksheet 164 Name a Worksheet 165 Change Page Setup Options 166 Move and Copy Worksheets 168 Delete a Worksheet 169 Find and Replace Data 170 Create a Table 172 Filter or Sort Table Information 174 Analyze Data Quickly 176 Understanding Data Analysis Choices 177 Track and Review Worksheet Changes 178 Insert a Comment 180 Chapter 11 Working with Formulas and Functions Understanding Formulas 182 Create a Formula 184 Apply Absolute and Relative Cell References 186 Understanding Functions 188 Apply a Function 190 Total Cells with AutoSum 192 Audit a Worksheet for Errors 194 Chapter 12 Working with Charts Create a Chart 196 Move and Resize Charts 198 Change the Chart Type 200 Change the Chart Style 201 Change the Chart Layout 202 Add Chart Elements 203 Format Chart Objects 204 Change the Chart Data 205 Using Sparklines to View Data Trends . . . . . . . . . . . . . .206 POWERPOINT Chapter 13 Creating a Presentation Create a New Presentation 210 Create a Photo Album Presentation 212 Change PowerPoint Views 214 Insert Slides 216 Change the Slide Layout 217 Change the Slide Size 218 Chapter 14 Populating Presentation Slides Add and Edit Slide Text 220 Change the Font, Size, and Color 222 Apply a Theme 226 Set Line Spacing 227 Align Text 228 Add a Text Box to a Slide 229 Add a Table to a Slide 230 Add a Chart to a Slide 232 Add a Video Clip to a Slide 234 Move a Slide Object 236 Resize a Slide Object 237 Chapter 15 Assembling and Presenting a Slide Show Reorganize Slides 238 Reuse a Slide 240 Define Slide Transitions 242 Add Animation Effects 244 Record Narration 246 Insert a Background Song 247 Create Speaker Notes 248 Rehearse a Slide Show 250 Run a Slide Show 252 Review a Presentation 256 Package Your Presentation on a CD 258 Present Online 260 ACCESS Chapter 16 Database Basics Understanding Database Basics 264 Create a Database Based on a Template 266 Create a Blank Database 268 Create a New Table 270 Change Table Views 272 Add a Field to a Table 274 Delete a Field from a Table 275 Hide a Field in a Table 276 Move a Field in a Table 277 Create a Form 278 Change Form Views 280 Move a Field in a Form 281 Delete a Field in a Form 282 Apply a Database Theme 283 Chapter 17 Adding, Finding, and Querying Data Add a Record to a Table 284 Add a Record to a Form 286 Navigate Records in a Form 288 Search for a Record Using a Form 289 Delete a Record from a Table 290 Delete a Record Using a Form 291 Sort Records 292 Filter Records 294 Apply Conditional Formatting 296 Perform a Simple Query 298 Create a Report 302 OUTLOOK Chapter 18 Organizing with Outlook Navigate in Outlook 306 Schedule an Appointment 308 Create a New Contact 310 Create a New Task . . . . . . . . . . . . . . . . . . . . .312 Add a Note 314 Customize the Navigation Bar 316 Peek at Appointments and Tasks 318 Search for Outlook Items 320 Work with the To?Do Bar 322 Link Contacts 323 Chapter 19 Emailing with Outlook Compose and Send a Message 324 Send a File Attachment 326 Read an Incoming Message 327 Reply To or Forward a Message 328 Add a Sender to Your Outlook Contacts 330 Delete a Message 331 Work with Conversations 332 Screen Junk Email 334 PUBLISHER Chapter 20 Publisher Basics Create a Publication 338 Zoom In and Out 340 Add Text 342 Add a New Text Box 343 Swap Pictures 344 Save a Publication for Photo Center Printing 346 Chapter 21 Fine?Tuning a Publication Change the Font, Size, and Color 348 Apply a Text Effect 352 Change Text Alignment 353 Add a Border 354 Control Text Wrap 355 Link Text Boxes 356 Edit the Background 358 Taking Notes with OneNote Navigate OneNote 362 Type and Draw Notes 364 Insert and Format a Table 366 Attach Files to Notes 368 Create a Quick Note 369 Insert a Screen Clipping 370 Record an Audio Note 372 ONENOTE Chapter 22 Organizing and Sharing Notes Create a New Notebook 374 Create a New Section 375 Create a New Page 376 Rename a Section or Page 377 Group Sections 378 Search Notes 380 Search for Recent Edits 382 Set Synchronization Options 383 Share Notes with People Who Do Not Have OneNote 384
Elaine Marmel (Phoenix, AZ) is President of Marmel Enterprises, LLC, an organization that specializes in technical writing and software training. Elaine has an MBA from Cornell University and worked on projects to build financial management systems for New York City and Washington, D.C. and trained more than 600 employees to use these systems. This prior experience provided the foundation for Marmel Enterprises, LLC to help small businesses manage the project of implementing a computerized accounting system. Elaine spends most of her time writing; she has authored and co-authored over seventy books. She left her native Chicago for the warmer climes of Arizona (by way of Cincinnati, OH; Jerusalem, Israel; Ithaca, NY; Washington, D.C. and Tampa, FL) where she basks in the sun with her PC, her cross stitch projects, and her dog Jack.