Teach Yourself VISUALLY Office 2016 1st edition by Elaine Marmel – Ebook PDF Instant Download/Delivery: 1119074762 , 978-1119074762
Full download Teach Yourself VISUALLY Office 2016 1st edition after payment
Product details:
ISBN 10: 1119074762
ISBN 13: 978-1119074762
Author: Elaine Marmel
Quickly and efficiently learn the latest version of Office
Are you a visual learner who wants to spend more time working in Microsoft Office than trying to figure out how the programs actually work? Teach Yourself Visually Office offers you a straightforward, visual approach to making your work life more efficient and productive using the latest version of the Microsoft Office suite. Featuring visually rich tutorials and step-by-step instructions that will help you make the most of this power-packed suite of office productivity tools, it covers everything you need to compute, document, graph, chart, present, and organize your way to success in the workplace—from the most basic to the most advanced.
The Microsoft Office suite can be intimidating to the uninitiated, but it doesn’t have to be. Through a series of easy-to-follow, full-color two-page tutorials, you’ll quickly get up and running on working in Word, excelling at Excel, powering through PowerPoint, keeping in touch on Outlook, managing data in Access, and propelling your way through Publisher like a pro!
- Highly visual tutorials and step-by-step screenshots make lessons easy to follow and understand
- Helps you grasp the basic functions of Microsoft Office—and beyond
- Walks you through Microsoft Office’s new features
- Demonstrates how to use the Microsoft Office suite to make your work life more streamlined and effective
Whether you’re looking to discover what’s new in the latest release of Microsoft Office or don’t know Access from Word, this visual guide makes learning easy!
Teach Yourself VISUALLY Office 2016 1st Table of contents:
Part I 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
Check Your File for Hidden or Personal Data 26
Email a File 28
Select Data 30
Cut, Copy, and Paste Data 32
Arrange Windows 34
Chapter 3 Office Graphics Tools
Insert a Picture 36
Insert an Online Picture 38
Resize and Move Objects 40
Understanding Graphics Modification Techniques 42
Chapter 4 Working with Office Files Online
Office and the Cloud 44
Sign In to Office 365 46
Share a Document from Office 48
Download Apps from the Office Store 50
Sign In to OneDrive 52
Using an Online App in OneDrive 54
Using an Office Program from OneDrive 56
Upload a Document to OneDrive 58
Share a Document Using OneDrive 60
Part II Word
Chapter 5 Adding Text
Change Word’s Views 64
Type and Edit Text 66
Insert Quick Parts 68
Insert Symbols 70
Create a Blog Post 72
Chapter 6 Formatting Text
Change the Font, Size, and Color 74
Align Text 78
Set Line Spacing 79
Indent Text 80
Set Tabs 82
Set Margins 84
Create Lists 86
Copy Formatting 88
Clear Formatting 89
Format with Styles 90
Using a Template 92
Chapter 7 Adding Extra Touches
Insert an Online Video 94
Assign a Theme 96
Add Borders 98
Create Columns 100
Insert a Table 102
Apply Table Styles 104
Insert Table Rows or Columns 105
Add Headers and Footers 106
Insert Footnotes and Endnotes 108
Insert Page Numbers and Page Breaks 110
Mark Index Entries 112
Generate an Index 114
Generate a Table of Contents 116
Create a Bibliography 118
Chapter 8 Reviewing Documents
Work in Read Mode View 120
Find and Replace Text 124
Scan Document Content 126
Check Spelling and Grammar 128
Work with AutoCorrect 130
Using Word’s Thesaurus and Dictionary 132
Translate Text 134
Track and Review Document Changes 136
Lock and Unlock Tracking 138
Combine Reviewers’ Comments 140
Work with Comments 142
Part III Excel
Chapter 9 Building Spreadsheets
Enter Cell Data 146
Select Cells 148
Faster Data Entry with AutoFill 150
Turn On Text Wrapping 152
Center Data Across Columns 153
Adjust Cell Alignment 154
Change the Font and Size 156
Change Number Formats 158
Increase or Decrease Decimals 159
Add Cell Borders and Shading 160
Format Data with Styles 162
Apply Conditional Formatting 164
Add Columns and Rows 166
Resize Columns and Rows 168
Freeze Column and Row Titles On‐Screen 169
Name a Range 170
Clear or Delete Cells 172
Split and Format a Column of Data 174
Chapter 10 Worksheet Basics
Add a Worksheet 176
Name a Worksheet 177
Change Page Setup Options 178
Move and Copy Worksheets 180
Delete a Worksheet 181
Find and Replace Data 182
Create a Table 184
Filter or Sort Table Information 186
Analyze Data Quickly 188
Understanding Data Analysis Choices 189
Track and Review Worksheet Changes 190
Insert a Comment 192
Chapter 11 Working with Formulas and Functions
Understanding Formulas 194
Create a Formula 196
Apply Absolute and Relative Cell References 198
Understanding Functions 200
Apply a Function 202
Total Cells with AutoSum 204
Audit a Worksheet for Errors 206
Chapter 12 Working with Charts
Create a Chart 208
Move and Resize Charts 210
Change the Chart Type 212
Change the Chart Style 213
Change the Chart Layout 214
Add Chart Elements 215
Format Chart Objects 216
Change the Chart Data 217
Using Sparklines to View Data Trends 218
Understanding PivotTables 220
Create a PivotTable 222
Create a PivotChart 224
Insert a PivotTable Slicer 226
Part IV PowerPoint
Chapter 13 Creating a Presentation
Create a New Presentation 230
Create a Photo Album Presentation 232
Change PowerPoint Views 234
Insert Slides 236
Change the Slide Layout 238
Change the Slide Size 240
Chapter 14 Populating Presentation Slides
Add and Edit Slide Text 242
Change the Font, Size, and Color 244
Apply a Theme 248
Set Line Spacing 249
Align Text 250
Add a Text Box to a Slide 251
Add a Table to a Slide 252
Add a Chart to a Slide 254
Add a Video Clip to a Slide 256
Move a Slide Object 258
Resize a Slide Object 259 Chapter 15 Assembling and Presenting a Slide Show
Reorganize Slides 260
Reuse a Slide 262
Organize Slides into Sections 264
Define Slide Transitions 266
Add Animation Effects 268
Create a Custom Animation 270
Record Narration 272
Insert a Background Song 273
Create Speaker Notes 274
Rehearse a Slide Show 276
Run a Slide Show 278
Review a Presentation 282
Package Your Presentation on a CD 284
Present Online 286
Part V Access
Chapter 16 Database Basics
Understanding Database Basics 290
Create a Database Based on a Template 292
Create a Blank Database 294
Create a New Table 296
Change Table Views 298
Add a Field to a Table 300
Delete a Field from a Table 301
Hide a Field in a Table 302
Move a Field in a Table 303
Create a Form 304
Change Form Views 306
Move a Field in a Form 307
Delete a Field in a Form 308
Apply a Database Theme 309
Format Form Fields 310
Add a Background Image 311
Chapter 17 Adding, Finding, and Querying Data
Add a Record to a Table 312
Add a Record to a Form 314
Navigate Records in a Form 316
Search for a Record Using a Form 317
Delete a Record from a Table 318
Delete a Record Using a Form 319
Sort Records 320
Filter Records 322
Apply Conditional Formatting 324
Perform a Simple Query 326
Create a Report 330
Part VI Outlook
Chapter 18 Organizing with Outlook
Navigate in Outlook 336
Schedule an Appointment 338
Create a New Contact 340
Create a New Task 342
Add a Note 344
Customize the Navigation Bar 346
Peek at Appointments and Tasks 348
Search for Outlook Items 350
Work with the To‐Do Bar 352
Link Contacts 353
Chapter 19 Emailing with Outlook
Compose and Send a Message 354
Send a File Attachment 356
Read an Incoming Message 357
Reply To or Forward a Message 358
Add a Sender to Your Outlook Contacts 360
Delete a Message 361
Work with Conversations 362
Screen Junk Email 364
Create a Message Rule 366
Part VII Publisher
Chapter 20 Publisher Basics
Create a Publication 370
Zoom In and Out 372
Add Text 374
Add a New Text Box 375
Swap Pictures 376
Save a Publication for Photo Center Printing 378
Chapter 21 Fine‐Tuning a Publication
Change the Font, Size, and Color 380
Apply a Text Effect 384
Change Text Alignment 385
Add a Border 386
Control Text Wrap 387
Link Text Boxes 388
Edit the Background 390
Add a Building Block Object 392
Create a Building Block Object 394
Part VIII OneNote
Chapter 22 Taking Notes with OneNote
Navigate OneNote 398
Type and Draw Notes 400
Insert and Format a Table 402
Attach Files to Notes 404
Create a Quick Note 405
Insert a Screen Clipping 406
Record an Audio Note 408
Chapter 23 Organizing and Sharing Notes
Create a New Notebook 410
Create a New Section 411
Create a New Page 412
Rename a Section or Page 413
Group Sections 414
Search Notes 416
Search for Recent Edits 418
Set Synchronization Options 419
Share Notes with People Who Do Not Have OneNote 420
Index 422
People also search for Teach Yourself VISUALLY Office 2016 1st :
teach yourself visually excel 2016
teach yourself visually word 2019
teach yourself visually excel 2019
teach yourself visually
teach yourself visually microsoft 365
Tags: Elaine Marmel, Teach Yourself, VISUALLY Office