Elaine Marmel
Office 2016 Simplified
Elaine Marmel
Office 2016 Simplified
- Broschiertes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
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…mehr
Andere Kunden interessierten sich auch für
- Peter WeverkaOffice 2016 All-In-One for Dummies30,99 €
- Elaine MarmelHow to Do Everything with Microsoft Office Project 200725,99 €
- Nancy ConnerOffice 2010: The Missing Manual34,99 €
- Peter WeverkaMicrosoft Office Home and Student Edition 2013 All-In-One for Dummies26,99 €
- Ann ShafferNew Perspectives on Microsoft Office 2003, First Course [With CDROM]135,99 €
- Chris GroverOffice 2007: The Missing Manual30,99 €
- David NuscherMicrosoft Office 2010 Workbook236,99 €
-
-
-
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.
Produktdetails
- Produktdetails
- Verlag: John Wiley & Sons / Wiley
- Seitenzahl: 416
- Erscheinungstermin: 2. November 2015
- Englisch
- Abmessung: 251mm x 201mm x 25mm
- Gewicht: 839g
- ISBN-13: 9781119074748
- ISBN-10: 1119074746
- Artikelnr.: 42559591
- Verlag: John Wiley & Sons / Wiley
- Seitenzahl: 416
- Erscheinungstermin: 2. November 2015
- Englisch
- Abmessung: 251mm x 201mm x 25mm
- Gewicht: 839g
- ISBN-13: 9781119074748
- ISBN-10: 1119074746
- Artikelnr.: 42559591
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.
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
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
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
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