Office 2016 Simplified

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.

Autorentext
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.

Zusammenfassung
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.

Inhalt
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 OnScreen 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...