Tasuta saatmine! | Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Office 2016 For Dummies

3.40/5 (12 hinnangut Goodreads-ist)

Wallace Wang

Formaat: PDF+DRM
Ilmumisaeg: 02-Jun-2016
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781119297291

Teised raamatud teemal:

Microsoft Office

Formaat - PDF+DRM
Hind: 20,47 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: PDF+DRM
Ilmumisaeg: 02-Jun-2016
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781119297291

Teised raamatud teemal:

Microsoft Office

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

Office 2016 For Dummies (9781119293477) was previously published as Office 2016 For Dummies (9781119077374). While this version features a new Dummies cover and design, the content is the same as the prior release and should not be considered a new or updated product.

The bestselling Microsoft Office book of all time

Packed with straightforward, friendly instruction, this updated edition of the bestselling Microsoft Office book gets you thoroughly up to speed on the latest version of the industry standard for office productivity suites. In no time, Office 2016 For Dummies will help you become a whiz at Word, take your Excel skills to new heights, add pizzazz to your PowerPoint presentations, and make every part of your work day more organized and productive.

Following alongside approachable, plain-English explanations, you'll quickly discover how to type, format text, and design documents in Word; navigate and edit spreadsheets, create formulas, and analyze data in Excel; configure email, store contacts, organize tasks, and schedule your time with Outlook; create and edit well-designed and crowd-pleasing PowerPoint presentations; and design, edit, and modify an Access database. Even if the mere thought of working with Microsoft Office makes you nervous, this fun and friendly guide makes it easy.

Helps you make sense of word processing, email, presentations, data management and analysis, and much more
Covers the five main Office applications: Word, Excel, PowerPoint, Outlook, and Access
Walks you through the new features of Microsoft Office 2016
Written by a veteran author who has written more than 20 For Dummies books, which account for more than three million books in print

If you're an uninitiated user looking to make the most of this powerful suite of applications, this hands-on, friendly guide is the key to your brand new Office!

Introduction

(4)

Who Should Buy This Book

(2)

Icons Used in This Book

(1)

Beyond the Book

(1)

Getting Started

(1)

Part 1 Getting Started With Office 2016

(68)

Chapter 1 Introducing Microsoft Office 2016

(28)

Starting an Office 2016 Program

(1)

Windows 10

(1)

Windows 8

(1)

Windows 7

(1)

Introducing the Microsoft Office Ribbon

(9)

The File tab

(6)

Using the Ribbon

(9)

Deciphering Ribbon icons

(4)

Identifying Ribbon icons

(1)

Displaying dialog boxes

(1)

Minimizing the Ribbon

(2)

Using the Quick Access Toolbar

(4)

Using the Quick Access icons

(1)

Adding icons

(2)

Removing icons

(1)

Moving the Quick Access toolbar

(1)

Customizing an Office 2016 Program

(2)

Changing the file format and default location

(1)

Customizing the Ribbon icons

(1)

Exiting Office 2016

(2)

Chapter 2 Selecting and Editing Data

(16)

Adding Data by Pointing

(2)

Selecting Data

(3)

Selecting data with the mouse

(2)

Selecting data with the keyboard

(1)

Selecting multiple chunks of data with the mouse and keyboard

(1)

Editing Text with the Pop-up Toolbar

(1)

Deleting Data

(1)

Cutting and Pasting (Moving) Data

(1)

Copying and Pasting Data

(1)

Using Paste Options

(2)

Dragging with the Mouse to Cut, Copy, and Paste

(1)

Undo and Redo

(1)

Sharing Data with Other Office 2016 Programs

(5)

Using the Office Clipboard

(1)

Viewing and pasting items from the Office Clipboard

(1)

Deleting items from the Office Clipboard

(3)

Chapter 3 Modifying Pictures

(14)

Adding (and Deleting) Pictures

(3)

Getting pictures from the Internet

(1)

Capturing screenshots

(2)

Manipulating Pictures

(2)

Moving a picture

(1)

Resizing a picture

(1)

Rotating a picture

(1)

Enhancing Pictures

(8)

Choosing visual effects

(3)

Choosing a picture style

(2)

Adding a border around a picture

(3)

Chapter 4 Getting Help from Office 2016

(8)

Searching in the Help Window

(3)

Making the Help Window Easier to Read

(2)

Resizing and pinning the Help window

(1)

Enlarging the text in the Help window

(2)

Printing the text in the Help window

(1)

Finding the Right Commands to Use

(3)

Part 2 Working With Word

(80)

Chapter 5 Typing Text in Word

(24)

Moving the Cursor with the Mouse

(2)

Moving the Cursor with the Keyboard

(1)

Navigating through a Document

(2)

Navigating with the mouse

(1)

Using the Go To command

(1)

Finding and Replacing Text

(8)

Using the Find command

(2)

Customizing text searching

(2)

Searching by headings

(1)

Browsing through pages

(1)

Using the Find and Replace command

(2)

Checking Your Spelling

(2)

Checking Your Grammar

(1)

Viewing a Document

(8)

Switching between views

(1)

Using Read Mode view

(1)

Using Outline view

(7)

Chapter 6 Formatting Text

(22)

Changing the Font

100

(1)

Changing the Font Size

101

(1)

Changing the Text Style

102

(1)

Changing Colors

103

(3)

Changing the color of text

103

(1)

Highlighting text with color

104

(1)

Using Text Effects

105

(1)

Justifying Text Alignment

106

(1)

Adjusting Line Spacing

107

(1)

Making Lists

108

(4)

Indenting list items

109

(1)

Converting list items back into text

109

(1)

Customizing a list

110

(1)

Renumbering numbered lists

111

(1)

Using the Ruler

112

(3)

Adjusting left and right paragraph margins

113

(1)

Defining indentation with the Ruler

114

(1)

Using Format Painter

115

(2)

Using Styles

117

(1)

Using Templates

118

(1)

Removing Formatting from Text

119

(2)

Chapter 7 Designing Your Pages

121

(32)

Inserting New Pages

121

(1)

Adding (and Deleting) a Cover Page

122

(1)

Inserting Page Breaks

123

(1)

Inserting Headers and Footers

124

(3)

Creating a header (or footer)

125

(1)

Defining which pages display a header (or footer)

125

(2)

Deleting a header (or footer)

127

(1)

Organizing Text in Tables

127

(6)

Creating a table by highlighting rows and columns

128

(1)

Creating a table with the Insert Table dialog box

129

(1)

Creating a table with the mouse

130

(1)

Creating a table from existing text

131

(2)

Formatting and Coloring a Table

133

(5)

Selecting all or part of a table

134

(1)

Aligning text in a table cell

135

(1)

Picking a table style

136

(1)

Resizing columns and rows

137

(1)

Sorting a Table

138

(2)

Deleting Tables

140

(4)

Deleting an entire table

140

(1)

Deleting rows and columns

140

(1)

Deleting cells

141

(1)

Deleting cell borders

142

(2)

Making Text Look Artistic

144

(3)

Creating drop caps

144

(1)

Creating WordArt

145

(2)

Dividing Text into Columns

147

(2)

Editing columns

148

(1)

Removing columns

149

(1)

Previewing a Document before Printing

149

(6)

Defining page size and orientation

150

(1)

Using Print Preview

151

(2)

Part 3 Playing The Numbers With Excel

153

(102)

Chapter 8 The Basics of Spreadsheets: Numbers, Labels, and Formulas

155

(38)

Understanding Spreadsheets

156

(1)

Storing Stuff in a Spreadsheet

157

(3)

Typing data into a single cell

157

(1)

Typing data in multiple cells

157

(1)

Typing in sequences with AutoFill

158

(2)

Formatting Numbers and Labels

160

(8)

Formatting numbers

160

(3)

Formatting cells

163

(5)

Navigating a Spreadsheet

168

(5)

Using the mouse to move around in a spreadsheet

168

(1)

Using the keyboard to move around a spreadsheet

169

(2)

Naming cells

171

(2)

Searching a Spreadsheet

173

(3)

Searching for text

173

(1)

Searching for formulas

174

(2)

Editing a Spreadsheet

176

(5)

Editing data in a cell

176

(1)

Changing the size of rows and columns with the mouse

176

(1)

Typing the size of rows and columns

177

(1)

Adding and deleting rows and columns

178

(1)

Adding sheets

179

(1)

Renaming sheets

179

(1)

Rearranging sheets

180

(1)

Deleting a sheet

180

(1)

Clearing Data

181

(1)

Printing Workbooks

182

(11)

Using Page Layout view

182

(1)

Adding a header (or footer)

183

(2)

Printing gridlines

185

(1)

Defining a print area

185

(2)

Inserting (and removing) page breaks

187

(1)

Printing row and column headings

188

(2)

Defining printing margins

190

(1)

Defining paper orientation and size

190

(2)

Printing in Excel

192

(1)

Chapter 9 Playing with Formulas

193

(32)

Creating a Formula

194

(5)

Organizing formulas with parentheses

196

(1)

Copying formulas

197

(2)

Using Functions

199

(4)

Using the AutoSum command

201

(1)

Using recently used functions

202

(1)

Editing a Formula

203

(1)

Conditional Formatting

204

(4)

Comparing data values

204

(1)

Creating conditional formatting rules

205

(3)

Data Validation

208

(3)

Goal Seeking

211

(3)

Creating Multiple Scenarios

214

(6)

Creating a scenario

214

(3)

Viewing a scenario

217

(1)

Editing a scenario

217

(1)

Viewing a scenario summary

218

(2)

Auditing Your Formulas

220

(2)

Finding where a formula gets its data

220

(1)

Finding which formula(s) a cell can change

221

(1)

Checking for Errors

222

(3)

Chapter 10 Charting and Analyzing Data

225

(30)

Understanding the Parts of a Chart

225

(3)

Creating a Chart

228

(2)

Editing a Chart

230

(2)

Moving a chart on a worksheet

230

(1)

Moving a chart to a new sheet

231

(1)

Resizing a chart

232

(1)

Using the Chart Tools

232

(6)

Changing the chart type

233

(1)

Changing the data source

234

(1)

Switching rows and columns

235

(1)

Changing the parts of a chart

235

(1)

Designing the layout of a chart

236

(1)

Deleting a chart

237

(1)

Using Sparklines

238

(3)

Creating a Sparkline

239

(1)

Customizing a Sparkline

240

(1)

Deleting a Sparkline

241

(1)

Organizing Lists in Pivot Tables

241

(16)

Creating a pivot table

242

(3)

Rearranging labels in a pivot table

245

(1)

Modifying a pivot table

245

(3)

Filtering a pivot table

248

(1)

Summing a pivot table

249

(1)

Slicing up a pivot table

250

(1)

Creating PivotCharts

251

(4)

Part 4 Making Presentations With Powerpoint

255

(66)

Chapter 11 Creating a PowerPoint Presentation

257

(18)

Defining the Purpose of Your Presentation

258

(1)

Creating a PowerPoint Presentation

258

(7)

Designing a presentation with the Normal view

260

(2)

Designing a presentation with Outline view

262

(3)

Working with Text

265

(10)

Typing text in a text box

266

(1)

Formatting text

267

(1)

Aligning text

268

(1)

Adjusting line spacing

269

(1)

Making numbered and bulleted lists

270

(1)

Making columns

271

(1)

Moving and resizing a text box

272

(1)

Rotating a text box

273

(2)

Chapter 12 Adding Color and Pictures to a Presentation

275

(22)

Applying a Theme

275

(2)

Changing the Background

277

(5)

Choosing a solid color background

277

(2)

Choosing a gradient background

279

(2)

Choosing a picture background

281

(1)

Choosing a pattern background

281

(1)

Adding Graphics to a Slide

282

(6)

Placing picture files on a slide

283

(1)

Placing clip art on a slide

283

(1)

Creating WordArt

284

(1)

Capturing screenshots

285

(1)

Resizing, moving, and deleting graphic images

286

(1)

Rotating graphics

287

(1)

Layering objects

287

(1)

Adding Movies to a Slide

288

(6)

Searching for a video on the Internet

288

(2)

Searching for video on your computer

290

(1)

Trimming a video

290

(2)

Coloring a video

292

(1)

Formatting the shape of a video

292

(2)

Adding Sound to a Slide

294

(3)

Adding audio from a file

295

(1)

Recording audio

295

(2)

Chapter 13 Showing Off a Presentation

297

(24)

Spell-Checking Your Presentation

297

(2)

Organizing Slides in Sections

299

(4)

Adding a section

299

(1)

Expanding and collapsing a section

300

(1)

Deleting a section

301

(2)

Adding Visual Transitions

303

(5)

Adding slide transitions

304

(2)

Text and graphic transitions

306

(2)

Using the Animation Painter

308

(1)

Adding Hyperlinks

308

(4)

Creating web page hyperlinks

308

(2)

Creating hyperlinks to external files

310

(1)

Running a program through a hyperlink

310

(2)

Removing a hyperlink or action

312

(1)

Viewing a Presentation

312

(6)

Creating a custom slide show

313

(3)

Hiding a slide

316

(1)

Organizing with Slide Sorter view

317

(1)

Creating Handouts

318

(3)

Part 5 Getting Organized With Outlook

321

(36)

Chapter 14 Managing Email with Outlook

323

(18)

Configuring Email Settings

323

(2)

Adding an email account

324

(1)

Creating Email

325

(4)

Creating a new email message

325

(1)

Replying to an email message

326

(1)

Using a stored email address to create a new email message

327

(2)

Attaching Files to Messages

329

(3)

Reading and Organizing Email

332

(4)

Grouping messages into categories

332

(1)

Changing the appearance of the Reading Pane

333

(1)

Retrieving a file attachment from a message

333

(3)

Deleting Email Messages

336

(1)

Creating Quick Steps

337

(4)

Chapter 15 Calendars, Contacts, and Tasks

341

(16)

Setting Appointments

341

(5)

Making an appointment

341

(3)

Viewing appointments

344

(1)

Deleting an appointment

345

(1)

Storing Names and Addresses

346

(4)

Adding a name

347

(1)

Viewing names

348

(1)

Searching names

349

(1)

Managing Tasks

350

(9)

Storing a task

350

(3)

Searching tasks

353

(1)

Viewing tasks

354

(3)

Part 6 Storing Stuff In Access

357

(58)

Chapter 16 Using a Database

359

(18)

Understanding the Basics of a Database

360

(1)

Designing a Database

361

(4)

Editing and Modifying a Database

365

(3)

Naming a field

365

(1)

Adding and deleting a field

365

(2)

Defining the type and size of a field

367

(1)

Typing Data into a Database

368

(6)

Using Datasheet view

369

(1)

Using Form view

369

(1)

Creating a form

370

(1)

Viewing and editing data in a form

371

(1)

Editing a form

371

(3)

Closing and Saving a Database

374

(3)

Closing a database

375

(1)

Exiting Access

375

(2)

Chapter 17 Searching, Sorting, and Querying a Database

377

(22)

Searching a Database

378

(9)

Searching for a specific record

378

(2)

Filtering a database

380

(7)

Sorting a Database

387

(1)

Querying a Database

388

(11)

Creating a simple query

389

(2)

Creating a crosstab query

391

(4)

Creating a query that finds duplicate field data

395

(1)

Creating an unmatched query

396

(2)

Viewing, renaming, closing, and deleting queries

398

(1)

Chapter 18 Creating a Database Report

399

(16)

Using the Report Wizard

399

(4)

Manipulating the Data in a Report

403

(4)

Switching a report to Layout view

404

(1)

Counting records or values

405

(1)

Sorting a field

406

(1)

Filtering a field

406

(1)

Editing a Report

407

(3)

Resizing fields

409

(1)

Deleting fields

409

(1)

Making Reports Look Pretty

410

(3)

Applying themes

410

(1)

Creating conditional formatting

411

(2)

Deleting a Report

413

(2)

Part 7 The Part Of Tens

415

(22)

Chapter 19 Ten Tips for Using Office 2016

417

(1599)

Saving Office 2016 Files

417

(2)

Password-Protecting Your Files

419

(1)

Guarding Against Macro Viruses

420

(2)

Customize the Ribbon

422

(1)

Send Feedback to Microsoft

423

(2)

When in Doubt, Right-Click the Mouse

425

(1)

Freezing Row and Column Headings in Excel

425

(1)

Displaying Slides Out of Order in PowerPoint

426

(1)

Reduce Spam in Outlook

426

(4)

Setting up Outlook's junk email filter

427

(1)

Creating a Safe Senders list

428

(1)

Creating a Blocked Senders list

429

(1)

Using Office 365 and Office on Android and iOS

430

(1586)

Chapter 20 Almost Ten Ways to Make Office

2016

Easier to Use

431

(1)

Build (and Use) Your Own Office Add-Ins

431

(1)

Collaborating with the Review Tab

432

(1)

Using Word's References Tab

433

(1)

Using Excel's Data Tab

433

(1)

Saving and Sending Files

434

(1)

Encrypting a File

434

(1)

Saving to the Cloud

435

(1)

Ignoring the Silly Office Ribbon

436

(1)

Index

437

Wallace Wang has written more than 50 computer books and has more than three million copies of his previous For Dummies books in print, including Office 2013 For Dummies and Beginning Programming All-in-One For Dummies. A veteran teacher, writer, and game designer, he's also done stand-up comedy.

Lisainfo e-raamatute kohta