Klientu atbalsts: 27018494

Grāmatu iegāde | Jauns profils | Ienākt

E-grāmata: Office 2016 All-in-One For Dummies

3.88/5 (138 ratings by Goodreads)

Peter Weverka (San Francisco, California)

Formāts: PDF+DRM
Izdošanas datums: 12-Oct-2015
Izdevniecība: For Dummies
Valoda: eng
ISBN-13: 9781119083214

Citas grāmatas par šo tēmu:

Microsoft Office

Formāts - PDF+DRM
Cena: 23,48 €*
* ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
Ielikt grozā
Pievienot vēlmju sarakstam
Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.

Formāts: PDF+DRM
Izdošanas datums: 12-Oct-2015
Izdevniecība: For Dummies
Valoda: eng
ISBN-13: 9781119083214

Citas grāmatas par šo tēmu:

Microsoft Office

DRM restrictions

Kopēšana (kopēt/ievietot):

nav atļauts
Drukāšana:

nav atļauts
Lietošana:

Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

Nepieciešamā programmatūra
Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Each book covers all the necessary information a beginner needs to know about a particular topic, providing an index for easy reference and using the series' signature set of symbols to clue the reader in to key topics, categorized under such titles as Tip, Remember, Warning!, Technical Stuff and True Story. Original.

The fast and easy way to get things done with Office

Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word—and every application in between—this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more—and make your work and home life easier, more productive, and more streamlined.

Microsoft Office is the leading productivity tool in the world. From word processing to business communication to data crunching, it requires a lot of knowledge to operate it—let alone master it. Luckily,Office 2016 All-in-One For Dummies is here to deliver the breadth of information you need to complete basic tasks and drill down into Office's advanced features.

Create customized documents and add graphic elements, proofing, and citations in Word
Build a worksheet, create formulas, and perform basic data analysis in Excel
Create a notebook and organize your thoughts in Notes
Manage messages, tasks, contacts, and calendars in Outlook

Clocking in at over 800 pages, Office 2016 All-in-One For Dummies will be the singular Microsoft Office resource you'll turn to again and again.

Introduction

(4)

About This Book

(1)

Foolish Assumptions

(1)

Icons Used in This Book

(1)

Beyond the Book

(1)

Where to Go from Here

(1)

Book I: Common Office Tasks

(46)

Chapter 1 Office Nuts and Bolts

(18)

A Survey of Office Applications

(2)

All about Office 365

(1)

Finding Your Way Around the Office Interface

(6)

The File tab and Backstage

(2)

The Quick Access toolbar

(1)

The Ribbon and its tabs

(1)

Context-sensitive tabs

(1)

The anatomy of a tab

(1)

Mini-toolbars and shortcut menus

(1)

Office 2016 for keyboard lovers

(1)

Saving Your Files

(3)

Saving a file

(1)

Saving a file for the first time

(1)

Saving AutoRecovery information

(1)

Navigating the Save As and Open Windows

(1)

Opening and Closing Files

(1)

Opening a file

(1)

Closing a file

(1)

Reading and Recording File Properties

(1)

Locking a File with a Password

(3)

Password-protecting a file

(1)

Removing a password from a file

(1)

Chapter 2 Wrestling with the Text

(18)

Manipulating the Text

(3)

Selecting text

(2)

Moving and copying text

(1)

Taking advantage of the Clipboard task pane

(1)

Deleting text

(1)

Changing the Look of Text

(7)

Choosing fonts for text

(1)

Changing the font size of text

(2)

Applying font styles to text

(1)

Applying text effects to text

(2)

Underlining text

(1)

Changing the color of text

(1)

Quick Ways to Handle Case, or Capitalization

(1)

Entering Symbols and Foreign Characters

(2)

Creating Hyperlinks

(5)

Linking a hyperlink to a web page

(2)

Creating a hyperlink to another place in your file

(1)

Creating an email hyperlink

(1)

Repairing and removing hyperlinks

(2)

Chapter 3 Speed Techniques Worth Knowing About

(8)

Undoing and Repeating Commands

(2)

Undoing a mistake

(1)

Repeating an action — and quicker this time

(1)

Zooming In, Zooming Out

(1)

Viewing a File Through More Than One Window

(1)

Correcting Typos on the Fly

(1)

Entering Text Quickly with the AutoCorrect Command

(3)

Book II: Word 2016

(162)

Chapter 1 Speed Techniques for Using Word

(18)

Introducing the Word Screen

(2)

Creating a New Document

(2)

Getting a Better Look at Your Documents

(4)

Viewing documents in different ways

(3)

Splitting the screen

(1)

Selecting Text in Speedy Ways

(2)

Moving Around Quickly in Documents

(3)

Keys for getting around quickly

(1)

Navigating from page to page or heading to heading

(2)

Going there fast with the Go To command

(1)

Bookmarks for hopping around

(1)

Inserting a Whole File into a Document

(1)

Entering Information Quickly in a Computerized Form

(4)

Creating a computerized form

(2)

Entering data in the form

(1)

Chapter 2 Laying Out Text and Pages

(24)

Paragraphs and Formatting

(1)

Inserting a Section Break for Formatting Purposes

(2)

Breaking a Line

(1)

Starting a New Page

(1)

Setting Up and Changing the Margins

(2)

Indenting Paragraphs and First Lines

(2)

Clicking an Indent button (for left-indents)

(1)

"Eye-balling it" with the ruler

(2)

Indenting in the Paragraph dialog box

(1)

Numbering the Pages

(3)

Numbering with page numbers only

(1)

Including a page number in a header or footer

(1)

Changing page number formats

(1)

Putting Headers and Footers on Pages

(4)

Creating, editing, and removing headers and footers

(2)

Fine-tuning a header or footer

(1)

Adjusting the Space between Lines

(1)

Adjusting the Space Between Paragraphs

(1)

Creating Numbered and Bulleted Lists

(3)

Simple numbered and bulleted lists

(1)

Constructing lists of your own

(1)

Managing a multilevel list

(1)

Working with Tabs

(1)

Hyphenating Text

(3)

Automatically and manually hyphenating a document

(1)

Unhyphenating and other hyphenation tasks

(1)

Chapter 3 Word Styles

(16)

All About Styles

(2)

Styles and templates

(1)

Types of styles

(1)

Applying Styles to Text and Paragraphs

(4)

Applying a style

(1)

Experimenting with style sets

(1)

Choosing which style names appear on the Style menus

(2)

Creating a New Style

101

(2)

Creating a style from a paragraph

101

(1)

Creating a style from the ground up

102

(1)

Modifying a Style

103

(2)

Creating and Managing Templates

105

(6)

Creating a new template

105

(4)

Opening a template so that you can modify it

109

(1)

Modifying, deleting, and renaming styles in templates

110

(1)

Chapter 4 Constructing the Perfect Table

111

(22)

Talking Table Jargon

111

(1)

Creating a Table

112

(2)

Entering the Text and Numbers

114

(1)

Selecting Different Parts of a Table

115

(1)

Laying Out Your Table

116

(4)

Changing the size of a table, columns, and rows

116

(1)

Adjusting column and row size

116

(1)

Inserting columns and rows

117

(1)

Deleting columns and rows

118

(1)

Moving columns and rows

119

(1)

Aligning Text in Columns and Rows

120

(1)

Merging and Splitting Cells

121

(1)

Repeating Header Rows on Subsequent Pages

122

(1)

Formatting Your Table

123

(4)

Designing a table with a table style

123

(1)

Calling attention to different rows and columns

124

(1)

Decorating your table with borders and colors

124

(3)

Using Math Formulas in Tables

127

(1)

Neat Table Tricks

128

(5)

Changing the direction of header row text

128

(1)

Wrapping text around a table

129

(1)

Using a picture as the table background

130

(1)

Drawing diagonal lines on tables

131

(1)

Drawing on a table

132

(1)

Chapter 5 Taking Advantage of the Proofing Tools

133

(20)

Correcting Your Spelling Errors

133

(4)

Correcting misspellings one at a time

134

(1)

Running a spell-check

135

(1)

Preventing text from being spell checked

136

(1)

Checking for Grammatical Errors in Word

137

(1)

Getting a Word Definition

138

(1)

Finding and Replacing Text

138

(8)

The basics: Finding stray words and phrases

138

(1)

Narrowing your search

139

(6)

Conducting a find-and-replace operation

145

(1)

Researching a Topic Inside Word

146

(2)

Finding the Right Word with the Thesaurus

148

(1)

Proofing Text Written in a Foreign Language

149

(2)

Telling Office which languages you will use

150

(1)

Marking text as foreign language text

150

(1)

Translating Foreign Language Text

151

(2)

Chapter 6 Desktop Publishing with Word

153

(18)

Experimenting with Themes

153

(2)

Sprucing Up Your Pages

155

(2)

Decorating a page with a border

155

(1)

Putting a background color on pages

156

(1)

Getting Word's help with cover letters

157

(1)

Making Use of Charts, Diagrams, Shapes, and Photos

157

(1)

Working with the Drawing Canvas

158

(1)

Positioning and Wrapping Objects Relative to the Page and Text

159

(4)

Wrapping text around an object

159

(2)

Positioning an object on a page

161

(2)

Working with Text Boxes

163

(1)

Inserting a text box

163

(1)

Making text flow from text box to text box

164

(1)

Dropping In a Drop Cap

164

(1)

Watermarking for the Elegant Effect

165

(1)

Putting Newspaper-Style Columns in a Document

166

(2)

Doing the preliminary work

167

(1)

Running text into columns

167

(1)

Landscape Documents

168

(1)

Printing on Different Size Paper

169

(1)

Showing Online Video in a Document

169

(2)

Chapter 7 Getting Word's Help with Office Chores

171

(20)

Highlighting Parts of a Document

171

(1)

Commenting on a Document

172

(3)

Entering a comment

172

(2)

Viewing and displaying comments

174

(1)

Caring for and feeding comments

174

(1)

Tracking Changes to Documents

175

(5)

Telling Word to start marking changes

176

(1)

Reading and reviewing a document with change marks

176

(2)

Marking changes when you forgot to turn on change marks

178

(1)

Accepting and rejecting changes to a document

179

(1)

Printing an Address on an Envelope

180

(2)

Printing a Single Address Label (Or a Page of the Same Label)

182

(1)

Churning Out Letters, Envelopes, and Labels for Mass Mailings

183

(8)

Preparing the source file

184

(1)

Merging the document with the source file

185

(4)

Printing form letters, envelopes, and labels

189

(2)

Chapter 8 Tools for Reports and Scholarly Papers

191

(22)

Alphabetizing a List

191

(1)

Outlines for Organizing Your Work

192

(2)

Viewing the outline in different ways

193

(1)

Rearranging document sections in Outline view

193

(1)

Collapsing and Expanding Parts of a Document

194

(1)

Generating a Table of Contents

195

(4)

Creating a TOC

195

(1)

Updating and removing a TOC

196

(1)

Customizing a TOC

196

(1)

Changing the structure of a TOC

197

(2)

Indexing a Document

199

(4)

Marking index items in the document

199

(2)

Generating the index

201

(2)

Editing an index

203

(1)

Putting Cross-References in a Document

203

(2)

Putting Footnotes and Endnotes in Documents

205

(3)

Entering a footnote or endnote

206

(1)

Choosing the numbering scheme and position of notes

207

(1)

Deleting, moving, and editing notes

208

(1)

Compiling a Bibliography

208

(7)

Inserting a citation for your bibliography

208

(2)

Editing a citation

210

(1)

Changing how citations appear in text

210

(1)

Generating the bibliography

211

(2)

Book III: Excel 2016

213

(100)

Chapter 1 Up and Running with Excel

215

(18)

Creating a New Excel Workbook

215

(2)

Getting Acquainted with Excel

217

(2)

Rows, columns, and cell addresses

219

(1)

Workbooks and worksheets

219

(1)

Entering Data in a Worksheet

219

(6)

The basics of entering data

219

(2)

Entering text labels

221

(1)

Entering numeric values

221

(1)

Entering date and time values

222

(3)

Quickly Entering Lists and Serial Data with the AutoFill Command

225

(2)

Formatting Numbers, Dates, and Time Values

227

(1)

Establishing Data-Validation Rules

228

(5)

Chapter 2 Refining Your Worksheet

233

(14)

Editing Worksheet Data

233

(1)

Moving Around in a Worksheet

234

(1)

Getting a Better Look at the Worksheet

235

(3)

Freezing and splitting columns and rows

235

(2)

Hiding columns and rows

237

(1)

Comments for Documenting Your Worksheet

238

(2)

Selecting Cells in a Worksheet

240

(1)

Deleting, Copying, and Moving Data

240

(1)

Handling the Worksheets in a Workbook

241

(2)

Keeping Others from Tampering with Worksheets

243

(4)

Hiding a worksheet

244

(1)

Protecting a worksheet

244

(3)

Chapter 3 Formulas and Functions for Crunching Numbers

247

(32)

How Formulas Work

247

(6)

Referring to cells in formulas

248

(2)

Referring to formula results in formulas

250

(1)

Operators in formulas

250

(3)

The Basics of Entering a Formula

253

(1)

Speed Techniques for Entering Formulas

254

(5)

Clicking cells to enter cell references

254

(1)

Entering a cell range

254

(2)

Naming cell ranges so that you can use them in formulas

256

(2)

Referring to cells in different worksheets

258

(1)

Copying Formulas from Cell to Cell

259

(2)

Detecting and Correcting Errors in Formulas

261

(3)

Correcting errors one at a time

261

(1)

Running the error checker

261

(2)

Tracing cell references

263

(1)

Working with Functions

264

(5)

Using arguments in functions

265

(1)

Entering a function in a formula

265

(4)

A Look at Some Very Useful Functions

269

(10)

AVERAGE for Averaging Data

269

(1)

COUNT and COUNTIF for Tabulating Data Items

270

(1)

CONCATENATE for Combining Values

270

(2)

PMT for Calculating How Much You Can Borrow

272

(2)

IF for Identifying Data

274

(1)

LEFT, MID, and RIGHT for Cleaning Up Data

275

(1)

PROPER for Capitalizing Words

275

(1)

LARGE and SMALL for Comparing Values

275

(2)

NETWORKDAY and TODAY for Measuring Time in Days

277

(1)

LEN for Counting Characters in Cells

278

(1)

Chapter 4 Making a Worksheet Easier to Read and Understand

279

(18)

Laying Out a Worksheet

279

(5)

Aligning numbers and text in columns and rows

279

(3)

Inserting and deleting rows and columns

282

(1)

Changing the size of columns and rows

282

(2)

Decorating a Worksheet with Borders and Colors

284

(5)

Cell styles for quickly formatting a worksheet

284

(2)

Formatting cells with table styles

286

(1)

Slapping borders on worksheet cells

287

(1)

Decorating worksheets with colors

288

(1)

Getting Ready to Print a Worksheet

289

(8)

Making a worksheet fit on a page

289

(4)

Making a worksheet more presentable

293

(1)

Repeating row and column headings on each page

294

(3)

Chapter 5 Advanced Techniques for Analyzing Data

297

(16)

Seeing What the Sparklines Say

297

(1)

Conditional Formats for Calling Attention to Data

298

(2)

Managing Information in Lists

300

(3)

Sorting a list

300

(1)

Filtering a list

301

(2)

Forecasting with the Goal Seek Command

303

(2)

Performing What-If Analyses with Data Tables

305

(3)

Using a one-input table for analysis

305

(2)

Using a two-input table for analysis

307

(1)

Analyzing Data with PivotTables

308

(7)

Getting a PivotTable recommendation from Excel

310

(1)

Creating a PivotTable from scratch

310

(2)

Putting the finishing touches on a PivotTable

312

(1)

Book IV: PowerPoint 2016

313

(92)

Chapter 1 Getting Started in PowerPoint

315

(22)

Getting Acquainted with PowerPoint

316

(1)

A Brief Geography Lesson

317

(1)

A Whirlwind Tour of PowerPoint

318

(1)

Creating a New Presentation

319

(3)

Advice for Building Persuasive Presentations

322

(2)

Creating New Slides for Your Presentation

324

(4)

Inserting a new slide

324

(2)

Speed techniques for inserting slides

326

(1)

Conjuring slides from Word document headings

326

(2)

Selecting a different layout for a slide

328

(1)

Getting a Better View of Your Work

328

(2)

Changing views

328

(1)

Looking at the different views

328

(2)

Hiding and Displaying the Slides Pane and Notes Pane

330

(1)

Selecting, Moving, and Deleting Slides

330

(2)

Selecting slides

331

(1)

Moving slides

331

(1)

Deleting slides

331

(1)

Putting Together a Photo Album

332

(3)

Creating your photo album

332

(2)

Putting on the final touches

334

(1)

Editing a photo album

335

(1)

Hidden Slides for All Contingencies

335

(2)

Hiding a slide

335

(1)

Showing a hidden slide during a presentation

336

(1)

Chapter 2 Fashioning a Look for Your Presentation

337

(14)

Looking at Themes and Slide Backgrounds

337

(2)

Choosing a Theme for Your Presentation

339

(1)

Creating Slide Backgrounds on Your Own

340

(6)

Using a solid (or transparent) color for the slide background

340

(1)

Creating a gradient color blend for slide backgrounds

341

(2)

Placing a picture in the slide background

343

(1)

Using a photo of your own for a slide background

344

(1)

Using a texture for a slide background

345

(1)

Changing the Background of a Single or Handful of Slides

346

(1)

Choosing the Slide Size

347

(1)

Using Master Slides and Master Styles for a Consistent Design

347

(4)

Switching to Slide Master view

348

(1)

Understanding master slides and master styles

348

(2)

Editing a master slide

350

(1)

Changing a master slide layout

350

(1)

Chapter 3 Entering the Text

351

(16)

Entering Text

351

(4)

Choosing fonts for text

352

(1)

Changing the font size of text

352

(1)

Changing the look of text

353

(2)

Fun with Text Boxes and Text Box Shapes

355

(1)

Controlling How Text Fits in Text Frames and Text Boxes

356

(3)

Choosing how AutoFit works in text frames

357

(2)

Choosing how AutoFits works in text boxes

359

(1)

Positioning Text in Frames and Text Boxes

359

(1)

Handling Bulleted and Numbered Lists

360

(3)

Creating a standard bulleted or numbered list

360

(1)

Choosing a different bullet character, size, and color

361

(1)

Choosing a different list-numbering style, size, and color

362

(1)

Putting Footers (and Headers) on Slides

363

(4)

Some background on footers and headers

363

(1)

Putting a standard footer on all your slides

364

(1)

Creating a nonstandard footer

365

(1)

Removing a footer from a single slide

366

(1)

Chapter 4 Making Your Presentations Livelier

367

(16)

Suggestions for Enlivening Your Presentation

367

(1)

Presenting Information in a Table

368

(2)

Exploring Transitions and Animations

370

(4)

Showing transitions between slides

370

(2)

Animating parts of a slide

372

(2)

Making Audio Part of Your Presentation

374

(3)

Inserting an audio file on a slide

375

(1)

Telling PowerPoint when and how to play an audio file

375

(1)

Playing audio during a presentation

376

(1)

Playing Video on Slides

377

(3)

Inserting a video on a slide

377

(1)

Fine-tuning a video presentation

378

(1)

Experimenting with the look of the video

379

(1)

Recording a Voice Narration for Slides

380

(3)

Chapter 5 Delivering a Presentation

383

(22)

All about Notes

383

(1)

Rehearsing and Timing Your Presentation

384

(1)

Showing Your Presentation

385

(4)

Starting and ending a presentation

386

(1)

Going from slide to slide

387

(2)

Tricks for Making Presentations a Little Livelier

389

(2)

Wielding a pen or highlighter in a presentation

389

(2)

Blanking the screen

391

(1)

Zooming In

391

(1)

Delivering a Presentation When You Can't Be There in Person

391

(16)

Providing handouts for your audience

392

(1)

Creating a self-running, kiosk-style presentation

393

(1)

Creating a user-run presentation

394

(3)

Presenting a Presentation Online

397

(1)

Packaging your presentation on a CD

398

(3)

Creating a presentation video

401

(4)

Book V: OneNote 2016

405

(38)

Chapter 1 Up and Running with OneNote

407

(12)

Introducing OneNote

407

(1)

Finding Your Way Around the OneNote Screen

408

(1)

Notebook pane

408

(1)

Section (and section group) tabs

408

(1)

Page window

408

(1)

Page pane

409

(1)

Units for Organizing Notes

409

(1)

Creating a Notebook

410

(2)

Creating Sections and Section Groups

412

(2)

Creating a new section

412

(1)

Creating a section group

413

(1)

Creating Pages and Subpages

414

(1)

Creating a new page

414

(1)

Creating a new subpage

415

(1)

Renaming and Deleting Groups and Pages

415

(1)

Getting from Place to Place in OneNote

415

(1)

Changing Your View of OneNote

416

(3)

Chapter 2 Taking Notes

419

(16)

Entering a Typewritten Note

419

(1)

Notes: The Basics

420

(3)

Moving and resizing note containers

420

(1)

Formatting the Text in Notes

420

(2)

Selecting notes

422

(1)

Deleting notes

422

(1)

Getting more space for notes on a page

422

(1)

Drawing on the Page

423

(3)

Drawing with a pen or highlighter

423

(1)

Drawing a shape

424

(1)

Changing the size and appearance of drawings and shapes

425

(1)

Converting a Handwritten Note to Text

426

(1)

Writing a Math Expression in a Note

427

(1)

Taking a Screen-Clipping Note

428

(1)

Recording and Playing Audio Notes

429

(2)

Recording an audio note

429

(2)

Playing an audio note

431

(1)

Attaching, Copying, and Linking Files to Notes

431

(4)

Attaching an Office file to a note

431

(1)

Copying an Office file into OneNote

432

(1)

Linking a Word or PowerPoint file to OneNote

432

(2)

Copying a note into another Office program

434

(1)

Chapter 3 Finding and Organizing Your Notes

435

(8)

Finding a Stray Note

435

(2)

Searching by word or phrase

435

(1)

Searching by author

436

(1)

Tagging Notes for Follow Up

437

(3)

Tagging a note

438

(1)

Arranging tagged notes in the task pane

439

(1)

Creating and modifying tags

439

(1)

Color-Coding Notebooks, Sections, and Pages

440

(1)

Merging and Moving Sections, Pages, and Notes

441

(2)

Book IV: Outlook 2016

443

(64)

Chapter 1 Outlook Basics

445

(14)

What Is Outlook, Anyway?

445

(1)

Navigating the Outlook Folders

446

(2)

Categorizing Items

448

(1)

Creating a category

448

(1)

Assigning items to categories

449

(1)

Arranging items by category in folders

449

(1)

Searching for Stray Folder Items

449

(3)

Conducting an instant search

450

(1)

Refining a search

451

(1)

Conducting an advanced search

452

(1)

Deleting Email Messages, Contacts, Tasks, and Other Items

452

(1)

Finding and Backing Up Your Outlook File

453

(1)

Cleaning Out Your Folders

454

(5)

Archiving the old stuff

454

(3)

Running the Mailbox Cleanup command

457

(2)

Chapter 2 Maintaining the Contacts Folder

459

(10)

Maintaining a Happy and Healthy Contacts Folder

459

(4)

Entering a new contact in the Contacts folder

460

(2)

Changing a contact's information

462

(1)

Contact Groups for Sending Messages to Groups

463

(3)

Creating a contact group

463

(2)

Addressing email to a contact group

465

(1)

Editing a contact group

466

(1)

Finding a Contact in the Contacts Folder

466

(1)

Printing the Contacts Folder

466

(3)

Different ways to print contact information

466

(1)

Changing the look of printed pages

467

(2)

Chapter 3 Handling Your Email

469

(22)

Setting Up an Email Account

469

(1)

Addressing and Sending Email Messages

470

(6)

The basics: Sending an email message

470

(2)

Addressing an email message

472

(2)

Sending copies and blind copies of messages

474

(1)

Replying to and forwarding email messages

475

(1)

Sending Files and Photos

476

(2)

Sending a file along with a message

476

(1)

Including a photo in an email message

477

(1)

Receiving Email Messages

478

(1)

Getting your email

478

(1)

Being notified that email has arrived

479

(1)

Reading Your Email in the Inbox Window

479

(2)

Handling Files That Were Sent to You

481

(1)

Opening a file you received

482

(1)

Saving a file you received

482

(1)

Techniques for Organizing Email Messages

482

(5)

Flagging email messages

484

(1)

Being reminded to take care of email messages

485

(1)

Rules for earmarking messages as they arrive

486

(1)

All about Email Folders

487

(2)

Moving email messages to different folders

487

(1)

Creating a new folder for storing email

488

(1)

Yes, You Can Prevent Junk Mail (Sort of)

489

(2)

Defining what constitutes junk email

489

(1)

Preventative medicine for junk email

490

(1)

Chapter 4 Managing Your Time and Schedule

491

(8)

Introducing the Calendar

491

(1)

The Different Kinds of Activities

492

(1)

Seeing Your Schedule

493

(1)

Going to a different day, week, or month

493

(1)

Rearranging the Calendar window

494

(1)

Scheduling Appointments and Events

494

(3)

Scheduling an activity: The basics

494

(2)

Scheduling a recurring appointment or event

496

(1)

Scheduling an event

497

(1)

Canceling, Rescheduling, and Altering Activities

497

(2)

Chapter 5 Tasks, Reminders, and Notes

499

(8)

Tasks: Seeing What Needs to Get Done

499

(3)

Entering a task in the Tasks window

499

(2)

Examining tasks in the Tasks window

501

(1)

Handling and managing tasks

502

(1)

Reminders for Being Alerted to Activities and Tasks

502

(2)

Handling reminder messages

503

(1)

Scheduling a reminder message

503

(1)

Making reminders work your way

504

(1)

Making Notes to Yourself

504

(3)

Book VII: Access 2016

507

(80)

Chapter 1 Introducing Access

509

(14)

What Is a Database, Anyway?

509

(1)

Tables, Queries, Forms, and Other Objects

510

(5)

Database tables for storing information

510

(2)

Forms for entering data

512

(1)

Queries for getting the data out

512

(2)

Reports for presenting and examining data

514

(1)

Macros and modules

514

(1)

Creating a Database File

515

(2)

Creating a blank database file

516

(1)

Getting the help of a template

516

(1)

Finding Your Way Around the Navigation Pane

517

(1)

Designing a Database

518

(5)

Deciding what information you need

518

(1)

Separating information into different database tables

519

(2)

Choosing fields for database tables

521

(1)

Deciding on a primary key field for each database table

521

(1)

Mapping the relationships between tables

522

(1)

Chapter 2 Building Your Database Tables

523

(28)

Creating a Database Table

523

(4)

Creating a database table from scratch

524

(1)

Creating a database table from a template

524

(1)

Importing a table from another database

525

(2)

Opening and Viewing Tables

527

(1)

Entering and Altering Table Fields

528

(5)

Creating a field

528

(2)

All about data types

530

(2)

Designating the primary key field

532

(1)

Moving, renaming, and deleting fields

533

(1)

Field Properties for Making Sure That Data Entries Are Accurate

533

(8)

A look at the Field Properties settings

534

(5)

Creating a lookup data-entry list

539

(2)

Indexing for Faster Sorts, Searches, and Queries

541

(3)

Indexing a field

542

(1)

Indexing based on more than one field

542

(2)

Establishing Relationships Between Database Tables

544

(7)

Types of relationships

545

(1)

Handling tables in the Relationships window

546

(1)

Forging relationships between tables

547

(2)

Editing table relationships

549

(2)

Chapter 3 Entering the Data

551

(10)

The Two Ways to Enter Data

551

(1)

Entering the Data in Datasheet View

552

(4)

Entering data

553

(1)

Two tricks for entering data quicker

554

(1)

Changing the appearance of the datasheet

555

(1)

Entering the Data in a Form

556

(1)

Creating a form

556

(1)

Entering the data

557

(1)

Finding a Missing Record

557

(2)

Finding and Replacing Data

559

(2)

Chapter 4 Sorting, Querying, and Filtering for Data

561

(20)

Sorting Records in a Database Table

561

(1)

Ascending vs. descending sorts

561

(1)

Sorting records

562

(1)

Filtering to Find Information

562

(6)

Different ways to filter a database table

564

(1)

"Unfiltering" a database table

564

(1)

Filtering by selection

565

(1)

Filtering for input

565

(1)

Filtering by form

566

(2)

Querying: The Basics

568

(8)

Creating a new query

568

(1)

Viewing queries in Datasheet and Design view

569

(1)

Finding your way around the Query Design window

570

(1)

Choosing which database tables to query

570

(1)

Choosing which fields to query

571

(1)

Sorting the query results

572

(1)

Choosing which fields appear in query results

572

(1)

Entering criteria for a query

573

(3)

At last — saving and running a query

576

(1)

Six Kinds of Queries

576

(5)

Select query

576

(1)

Top-value query

576

(1)

Summary query

577

(1)

Calculation query

578

(1)

Delete query

579

(1)

Update query

580

(1)

Chapter 5 Presenting Data in a Report

581

(6)

Creating a Report

581

(2)

Opening and Viewing Reports

583

(1)

Tweaking a Report

583

(4)

Book VIII: Working with Charts and Graphics

587

(82)

Chapter 1 Creating a Chart

589

(18)

The Basics: Creating a Chart

589

(2)

Choosing the Right Chart

591

(2)

Providing the Raw Data for Your Chart

593

(2)

Positioning Your Chart in a Workbook, Page, or Slide

595

(1)

Changing a Chart's Appearance

595

(6)

Changing the chart type

596

(1)

Changing the size and shape of a chart

597

(1)

Choosing a new look for your chart

597

(1)

Changing the layout of a chart

598

(1)

Handling the gridlines

599

(1)

Changing a chart element's color, font, or other particular

600

(1)

Saving a Chart as a Template So That You Can Use It Again

601

(1)

Saving a chart as a template

601

(1)

Creating a chart from a template

602

(1)

Chart Tricks for the Daring and Heroic

602

(4)

Decorating a chart with a picture

602

(1)

Annotating a chart

603

(1)

Displaying the raw data alongside the chart

604

(1)

Placing a trendline on a chart

605

(1)

Troubleshooting a Chart

606

(1)

Chapter 2 Making a SmartArt Diagram

607

(18)

The Basics: Creating SmartArt Diagrams

607

(2)

Choosing a diagram

607

(2)

Making the diagram your own

609

(1)

Creating the Initial Diagram

609

(2)

Creating a diagram

610

(1)

Swapping one diagram for another

611

(1)

Changing the Size and Position of a Diagram

611

(1)

Laying Out the Diagram Shapes

612

(5)

Selecting a diagram shape

612

(1)

Removing a shape from a diagram

612

(1)

Moving diagram shapes to different positions

612

(1)

Adding shapes to diagrams apart from hierarchy diagrams

613

(1)

Adding shapes to hierarchy diagrams

614

(1)

Adding shapes to Organization charts

615

(2)

Promoting and demoting shapes in hierarchy diagrams

617

(1)

Handling the Text on Diagram Shapes

617

(2)

Entering text on a diagram shape

617

(1)

Entering bulleted lists on diagram shapes

618

(1)

Changing a Diagram's Direction

619

(1)

Choosing a Look for Your Diagram

620

(1)

Changing the Appearance of Diagram Shapes

621

(3)

Changing the size of a diagram shape

621

(1)

Exchanging one shape for another

622

(1)

Changing a shape's color, fill, or outline

622

(1)

Changing fonts and font sizes on shapes

623

(1)

Creating a Diagram from Scratch

624

(1)

Chapter 3 Handling Graphics and Photos

625

(16)

All about Picture File Formats

625

(4)

Bitmap and vector graphics

625

(2)

Resolution

627

(1)

Compression

627

(1)

Color depth

628

(1)

Choosing Me formats for graphics

628

(1)

Inserting a Picture in an Office File

629

(3)

Inserting a picture of your own

629

(1)

Obtaining a picture online

630

(2)

Touching Up a Picture

632

(7)

Softening and sharpening pictures

632

(1)

Correcting a picture's brightness and contrast

633

(1)

Recoloring a picture

633

(1)

Choosing an artistic effect

634

(1)

Selecting a picture style

635

(1)

Cropping off part of a picture

636

(1)

Removing the background

637

(2)

Compressing Pictures to Save Disk Space

639

(2)

Chapter 4 Drawing and Manipulating Lines, Shapes, and Other Objects

641

(28)

The Basics: Drawing Lines, Arrows, and Shapes

642

(1)

Handling Lines, Arrows, and Connectors

643

(5)

Changing the length and position of a line or arrow

643

(1)

Changing the appearance of a line, arrow, or connector

644

(1)

Attaching and handling arrowheads on lines and connectors

645

(1)

Connecting shapes by using connectors

646

(2)

Handling Rectangles, Ovals, Stars, and Other Shapes

648

(3)

Drawing a shape

648

(2)

Changing a shape's symmetry

650

(1)

Using a shape as a text box

650

(1)

WordArt for Embellishing Letters and Words

651

(1)

Creating WordArt

652

(1)

Editing WordArt

652

(1)

Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects

652

(4)

Selecting objects so that you can manipulate them

654

(1)

Hiding and displaying the rulers and grid

655

(1)

Changing an Object's Size and Shape

656

(1)

Changing an Object's Color, Outline Color, and Transparency

657

(4)

Filling an object with color, a picture, or a texture

657

(3)

Making a color transparent

660

(1)

Putting the outline around an object

660

(1)

Moving and Positioning Objects

661

(10)

Tricks for aligning and distributing objects

662

(2)

When objects overlap: Choosing which appears above the other

664

(2)

Rotating and flipping objects

666

(1)

Grouping objects to make working with them easier

667

(2)

Book IX: Office 2016 — One Step Beyond

669

(42)

Chapter 1 Customizing an Office Program

671

(14)

Customizing the Ribbon

671

(5)

Displaying and selecting tab, group, and command names

673

(1)

Moving tabs and groups on the Ribbon

673

(1)

Adding, removing, and renaming tabs, groups, and commands

674

(1)

Creating new tabs and groups

675

(1)

Resetting your Ribbon customizations

676

(1)

Customizing the Quick Access Toolbar

676

(3)

Adding buttons to the Quick Access toolbar

677

(1)

Changing the order of buttons on the Quick Access toolbar

678

(1)

Removing buttons from the Quick Access toolbar

678

(1)

Placing the Quick Access toolbar above or below the Ribbon

679

(1)

Customizing the Status Bar

679

(1)

Changing the Screen Background and Office Theme

680

(1)

Customizing Keyboard Shortcuts in Word

681

(4)

Chapter 2 Ways of Distributing Your Work

685

(10)

Printing — the Old Standby

685

(1)

Distributing a File in PDF Format

686

(1)

About PDF files

687

(1)

Saving an Office file as a PDF

687

(1)

Sending Your File in an Email Message

687

(1)

Saving an Office File as a Web Page

688

(3)

Choosing how to save the component parts

689

(1)

Turning a file into a web page

690

(1)

Opening a web page in your browser

691

(1)

Blogging from inside Word

691

(4)

Describing a blog account to Word

691

(1)

Posting an entry to your blog

692

(1)

Taking advantage of the Blog Post tab

693

(2)

Chapter 3 Working with Publisher

695

(16)

"A Print Shop in a Can"

695

(1)

Introducing Frames

696

(1)

Creating a Publication

697

(1)

Redesigning a Publication

697

(2)

Choosing a different template

698

(1)

Choosing a color scheme

699

(1)

Setting up your pages

699

(1)

Getting a Better View of Your Work

699

(2)

Zooming in and out

699

(1)

Viewing single pages and two-page spreads

700

(1)

Going from page to page

700

(1)

Entering Text on the Pages

701

(1)

Making Text Fit in Text Frames

702

(2)

Fitting overflow text in a single frame

703

(1)

Making text flow from frame to frame

703

(1)

Making Text Wrap around a Frame or Graphic

704

(1)

Replacing the Placeholder Pictures

705

(1)

Inserting, Removing, and Moving Pages

706

(1)

Master Pages for Handling Page Backgrounds

707

(2)

Switching to Master Page view

707

(1)

Changing the look of a master page

708

(1)

Applying (or unapplying) a master page to publication pages

708

(1)

Running the Design Checker

709

(1)

Commercially Printing a Publication

710

(1)

Book X: File Sharing and Collaborating

711

(20)

Chapter 1 Up and Running on OneDrive

713

(10)

Signing In to OneDrive

713

(2)

Exploring the OneDrive Window

715

(1)

Managing Your OneDrive Folders

715

(4)

Creating a folder

715

(1)

Viewing and locating folders in the OneDrive window

716

(1)

Going from folder to folder in OneDrive

716

(2)

Deleting, moving, and renaming folders

718

(1)

Uploading Files to a Folder on OneDrive

719

(1)

Saving a File from Office 2016 to OneDrive

720

(2)

Opening a File from OneDrive

722

(1)

Starting in an Office 2016 application

722

(1)

Starting in OneDrive

722

(1)

Downloading Files from OneDrive to Your Computer

722

(1)

Chapter 2 File Sharing and Collaborating

723

(8)

Sharing Files: The Big Picture

723

(1)

Sharing Your Files and Folders with Others

724

(4)

Inviting people by email

724

(1)

Generating a link to shared files

725

(2)

Generating HTML code

727

(1)

Seeing Files and Folders Others Shared with You

728

(1)

Investigating and Changing How Files and Folders Are Shared

729

(2)

Index

731

Peter Weverka is a veteran For Dummies author. In addition to previous books on Microsoft Office, Peter has written guides to Windows, the Internet, and Quicken.

Biežāk uzdotie jautājumi par e-grāmatām