Klientu atbalsts: 27018494

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

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

4.11/5 (27 ratings by Goodreads)

Peter Weverka

Formāts: PDF+DRM
Izdošanas datums: 10-Oct-2018
Izdevniecība: For Dummies
Valoda: eng
ISBN-13: 9781119513315

Citas grāmatas par šo tēmu:

Microsoft Office

Formāts - PDF+DRM
Cena: 26,29 €*
* š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: 10-Oct-2018
Izdevniecība: For Dummies
Valoda: eng
ISBN-13: 9781119513315

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.

One practical book that's ten books in one: Learn everything you need to know about Microsoft Office with one comprehensive guide on your bookshelf

To know your way around all the applications within Microsoft Office would require you to be part mathematician, part storyteller, and part graphic designer--with some scheduling wizard and database architect sprinkled in. If these talents don't come naturally to you in equal measure, don't panic--Office 2019 All-in-One For Dummies can help.

This hefty but easily accessible tome opens with Book 1, an overview of the Office suite of applications and tips for handling text and becoming more efficient. From there, you'll find a book on each of the suite's major applications:

Word: Learn the basics of word processing with Word, plus lay out text and pages; use Word's styles and proofing tools; construct tables, reports, and scholarly papers; and become familiar with manipulating documents. Excel: In addition to refining your worksheets so they're easier to understand, you can also master formulas, functions, and data analysis. PowerPoint: Find out how to make your presentations come alive with text, graphics, backgrounds, audio, and video. This book also contains a chapter with guidance and tips for delivering presentations--in person or virtually. Outlook: From helping you to manage your contacts, inbox, calendar, and tasks, Outlook can organize your days and keep you working productively. Access: Not everyone needs to build and maintain databases, but if that's part of your job, this book has all the hands-on information you need to get going: Build a database table, enter data, sort and query data, and filter data into report format. Publisher: The Publisher book is a quick-and-dirty introduction into desktop publishing, helping you to design a publication using built-in color schemes, templates, fonts, and finishing touches like borders and backgrounds.

The last three books cover material that applies to all the applications. Book 8 shows you how to create charts, handle graphics and photos, and draw lines and shapes. Book 9 provides a quick primer on customizing the Ribbon, the Quick Access toolbar, and the Status bar, and guidance on distributing your work (via printing, emailing, converting to PDF, and more). Finally, Book 10 wraps up with how to use OneDrive, especially for file sharing and online collaboration.

If you need to make sense of Office and don't have time to waste, Office 2019 All-in-One For Dummies is the reference you'll want to keep close by!

Introduction

(4)

What Makes This Book Different

(1)

Foolish Assumptions

(1)

Conventions Used in This Book

(1)

Icons Used in This Book

(1)

Beyond the Book

(1)

Book 1: Common Office Tasks

(50)

Chapter 1 Office Nuts and Bolts

(20)

A Survey of Office Applications

(2)

All about Office 365

(2)

Finding Your Way Around the Office Interface

(7)

The File tab and Backstage

(1)

The Quick Access toolbar

(1)

The Ribbon and its tabs

(2)

Context-sensitive tabs

(1)

The anatomy of a tab

(2)

Mini-toolbars and shortcut menus

(1)

Office 2019 for keyboard lovers

(2)

Saving Your Files

(1)

Saving a file

(1)

Saving a file for the first time

(1)

Saving AutoRecovery information

(1)

Navigating the Save As and Open Windows

(2)

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

(1)

Password-protecting a file

(1)

Removing a password from a file

(1)

Trusting (or not Trusting) Microsoft with Your "Content"

(3)

Chapter 2 Wrestling with the Text

(20)

Manipulating the Text

(3)

Selecting text

(1)

Moving and copying text

(1)

Taking advantage of the Clipboard task pane

(1)

Deleting text

(1)

Speaking, not Typing, the Words

(2)

Changing the Look of Text

(7)

Choosing fonts for text

(2)

Changing the font size of text

(2)

Applying font styles to text

(1)

Applying text effects to text

(1)

Underlining text

(1)

Changing the color of text

(1)

Quick Ways to Handle Case, or Capitalization

(2)

Entering Symbols and Foreign Characters

(1)

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

(1)

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 2: Word 2019

(178)

Chapter 1 Speed Techniques for Using Word

(20)

Introducing the Word Screen

(2)

Creating a New Document

(2)

Getting a Better Look at Your Documents

(5)

Viewing documents in different ways

(2)

Splitting the screen

(2)

Selecting Text in Speedy Ways

(1)

Moving Around Quickly in Documents

(4)

Keys for getting around quickly

(1)

Navigating from page to page or heading to heading

(1)

Going there fast with the Go To command

(1)

Bookmarks for hopping around

(1)

Inserting a Whole File into a Document

(1)

Getting Word to Read It

(1)

Entering Information Quickly in a Computerized Form

(5)

Creating a computerized form

(2)

Entering data in the form

(2)

Chapter 2 Laying Out Text and Pages

(28)

Paragraphs and Formatting

(1)

Inserting a Section Break for Formatting Purposes

(3)

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)

"Eyeballing" 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

(1)

Fine-tuning a header or footer

(1)

Adjusting the Space Between Lines

(2)

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

(2)

Hyphenating Text

101

(4)

Automatically and manually hyphenating a document

102

(1)

Unhyphenating and other hyphenation tasks

102

(3)

Chapter 3 Word Styles

105

(18)

All About Styles

105

(2)

Styles and templates

106

(1)

Types of styles

106

(1)

Applying Styles to Text and Paragraphs

107

(5)

Applying a style

107

(2)

Experimenting with style sets

109

(1)

Choosing which style names appear on the Style menus

109

(3)

Creating a New Style

112

(2)

Creating a style from a paragraph

112

(1)

Creating a style from the ground up

113

(1)

Modifying a Style

114

(2)

Creating and Managing Templates

116

(7)

Creating a new template

116

(4)

Opening a template so that you can modify it

120

(1)

Modifying, deleting, and renaming styles in templates

121

(2)

Chapter 4 Constructing the Perfect Table

123

(24)

Talking Table Jargon

124

(1)

Creating a Table

124

(3)

Entering the Text and Numbers

127

(1)

Selecting Different Parts of a Table

128

(1)

Laying Out Your Table

128

(5)

Changing the size of a table, columns, and rows

128

(1)

Adjusting column and row size

129

(1)

Inserting columns and rows

130

(1)

Deleting columns and rows

131

(2)

Moving columns and rows

133

(1)

Aligning Text in Columns and Rows

133

(1)

Merging and Splitting Cells

134

(1)

Repeating Header Rows on Subsequent Pages

135

(2)

Formatting Your Table

137

(3)

Designing a table with a table style

137

(1)

Calling attention to different rows and columns

138

(1)

Decorating your table with borders and colors

139

(1)

Using Math Formulas in Tables

140

(1)

Neat Table Tricks

141

(6)

Changing the direction of header row text

141

(1)

Wrapping text around a table

142

(1)

Using a picture as the table background

143

(2)

Drawing diagonal lines on tables

145

(1)

Drawing on a table

145

(2)

Chapter 5 Taking Advantage of the Proofing Tools

147

(20)

Correcting Your Spelling Errors

148

(3)

Correcting misspellings one at a time

148

(1)

Running a spell check

149

(2)

Preventing text from being spell checked

151

(1)

Correcting Grammatical Errors

151

(2)

Finding and Replacing Text

153

(8)

The basics: Finding stray words and phrases

153

(1)

Narrowing your search

154

(5)

Conducting a find-and-replace operation

159

(2)

Finding the Right Word with the Thesaurus

161

(1)

Proofing Text Written in a Foreign Language

162

(2)

Telling Office which languages you will use

163

(1)

Marking text as foreign language text

163

(1)

Translating Foreign Language Text

164

(3)

Chapter 6 Desktop Publishing with Word

167

(20)

Experimenting with Themes

167

(1)

Sprucing Up Your Pages

168

(3)

Decorating a page with a border

169

(1)

Putting a background color on pages

170

(1)

Getting Word's help with cover letters

170

(1)

Making Use of Charts, Diagrams, Shapes, and Photos

171

(1)

Working with the Drawing Canvas

172

(1)

Positioning and Wrapping Objects Relative to the Page and Text

173

(4)

Wrapping text around an object

174

(1)

Positioning an object on a page

175

(2)

Working with Text Boxes

177

(2)

Inserting a text box

178

(1)

Making text flow from text box to text box

178

(1)

Dropping In a Drop Cap

179

(1)

Watermarking for the Elegant Effect

180

(1)

Putting Newspaper-Style Columns in a Document

181

(2)

Doing the preliminary work

181

(1)

Running text into columns

182

(1)

Landscape Documents

183

(1)

Printing on Different Size Paper

184

(1)

Showing Online Video in a Document

184

(3)

Chapter 7 Getting Word's Help with Office Chores

187

(22)

Highlighting Parts of a Document

187

(1)

Commenting on a Document

188

(4)

Entering comments

188

(2)

Viewing and displaying comments

190

(1)

Caring for and feeding comments

190

(2)

Tracking Changes to Documents

192

(5)

Telling Word to start marking changes

193

(1)

Reading and reviewing a document with change marks

193

(1)

Marking changes when you forgot to turn on change marks

194

(2)

Accepting and rejecting changes to a document

196

(1)

Printing an Address on an Envelope

197

(2)

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

199

(1)

Churning Out Letters, Envelopes, and Labels for Mass Mailings

200

(9)

Preparing the source file

201

(1)

Merging the document with the source file

202

(4)

Printing form letters, envelopes, and labels

206

(3)

Chapter 8 Tools for Reports and Scholarly Papers

209

(24)

Alphabetizing a List

209

(1)

Outlines for Organizing Your Work

210

(2)

Viewing the outline in different ways

210

(2)

Rearranging document sections in Outline view

212

(1)

Collapsing and Expanding Parts of a Document

212

(1)

Generating a Table of Contents

213

(5)

Creating a TOC

214

(1)

Updating and removing a TOC

214

(1)

Customizing a TOC

214

(2)

Changing the structure of a TOC

216

(2)

Indexing a Document

218

(4)

Marking index items in the document

218

(2)

Generating the index

220

(2)

Editing an index

222

(1)

Putting Cross-References in a Document

222

(3)

Putting Footnotes and Endnotes in Documents

225

(2)

Entering a footnote or endnote

225

(1)

Choosing the numbering scheme and position of notes

226

(1)

Deleting, moving, and editing notes

227

(1)

Compiling a Bibliography

227

(8)

Inserting a citation for your bibliography

228

(2)

Editing a citation

230

(1)

Changing how' citations appear in text

230

(1)

Generating the bibliography

230

(3)

Book 3: Excel 2019

233

(102)

Chapter 1 Up and Running with Excel

235

(18)

Creating a New Excel Workbook

235

(2)

Getting Acquainted with Excel

237

(2)

Rows, columns, and cell addresses

239

(1)

Workbooks and worksheets

239

(1)

Entering Data in a Worksheet

239

(6)

The basics of entering data

239

(2)

Entering text labels

241

(1)

Entering numeric values

241

(1)

Entering date and time values

242

(3)

Quickly Entering Lists and Serial Data with the AutoFill Command

245

(3)

Formatting Numbers, Dates, and Time Values

248

(1)

Establishing Data-Validation Rules

249

(4)

Chapter 2 Refining Your Worksheet

253

(14)

Editing Worksheet Data

253

(1)

Moving Around in a Worksheet

254

(1)

Getting a Better Look at the Worksheet

255

(3)

Freezing and splitting columns and rows

255

(2)

Hiding columns and rows

257

(1)

Comments for Documenting Your Worksheet

258

(2)

Selecting Cells in a Worksheet

260

(1)

Deleting, Copying, and Moving Data

261

(1)

Handling the Worksheets in a Workbook

261

(3)

Keeping Others from Tampering with Worksheets

264

(3)

Hiding a worksheet

264

(1)

Protecting a worksheet

264

(3)

Chapter 3 Formulas and Functions for Crunching Numbers

267

(32)

How Formulas Work

267

(6)

Referring to cells in formulas

268

(2)

Referring to formula results in formulas

270

(1)

Operators in formulas

271

(2)

The Basics of Entering a Formula

273

(1)

Speed Techniques for Entering Formulas

273

(6)

Clicking cells to enter cell references

273

(1)

Entering a cell range

274

(1)

Naming cell ranges so that you can use them in formulas

275

(3)

Referring to cells in different worksheets

278

(1)

Copying Formulas from Cell to Cell

279

(2)

Detecting and Correcting Errors in Formulas

281

(3)

Correcting errors one at a time

281

(1)

Running the error checker

282

(1)

Tracing cell references

283

(1)

Working with Functions

284

(5)

Using arguments in functions

285

(1)

Entering a function in a formula

285

(4)

A Look at Some Very Useful Functions

289

(10)

AVERAGE for averaging data

289

(1)

COUNT and COUNTIF for tabulating data items

290

(1)

CONCATENATE for combining values

291

(1)

PMT for calculating how much you can borrow

292

(2)

IF for identifying data

294

(1)

LEFT, MID, and RIGHT for cleaning up data

295

(1)

PROPER for capitalizing words

296

(1)

LARGE and SMALL for comparing values

296

(1)

NETVVORKDAY and TODAY for measuring time in days

297

(1)

LEN for Counting Characters in Cells

298

(1)

Chapter 4 Making a Worksheet Easier to Read and Understand

299

(18)

Laying Out a Worksheet

299

(6)

Aligning numbers and text in columns and rows

300

(2)

Inserting and deleting rows and columns

302

(1)

Changing the size of columns and rows

303

(2)

Decorating a Worksheet with Borders and Colors

305

(5)

Cell styles for quickly formatting a worksheet

305

(2)

Formatting cells with table styles

307

(1)

Slapping borders on worksheet cells

308

(2)

Decorating worksheets with colors

310

(1)

Getting Ready to Print a Worksheet

310

(7)

Making a worksheet fit on a page

310

(4)

Making a worksheet more presentable

314

(1)

Repeating row and column headings on each page

315

(2)

Chapter 5 Advanced Techniques for Analyzing Data

317

(18)

Seeing What the Sparklines Say

317

(2)

Conditional Formats for Calling Attention to Data

319

(1)

Managing Information in Lists

320

(3)

Sorting a list

320

(1)

Filtering a list

321

(2)

Forecasting with the Goal Seek Command

323

(2)

Performing What-If Analyses with Data Tables

325

(4)

Using a one-input table for analysis

325

(2)

Using a two-input table for analysis

327

(2)

Analyzing Data with PivotTables

329

(8)

Getting a PivotTable recommendation from Excel

330

(1)

Creating a PivotTable from scratch

331

(2)

Putting the finishing touches on a PivotTable

333

(2)

Book 4: Powerpoint 2019

335

(90)

Chapter 1 Getting Started in PowerPoint

337

(22)

Getting Acquainted with PowerPoint

338

(1)

A Brief Geography Lesson

339

(1)

A Whirlwind Tour of PowerPoint

340

(1)

Creating a New Presentation

341

(3)

Advice for Building Persuasive Presentations

344

(2)

Creating New Slides for Your Presentation

346

(4)

Inserting a new slide

347

(1)

Speed techniques for inserting slides

348

(1)

Conjuring slides from Word document headings

348

(2)

Selecting a different layout for a slide

350

(1)

Getting a Better View of Your Work

350

(2)

Changing views

350

(1)

Looking at the different views

350

(2)

Hiding and Displaying the Slides Pane and Notes Pane

352

(1)

Selecting, Moving, and Deleting Slides

352

(2)

Selecting slides

353

(1)

Moving slides

353

(1)

Deleting slides

353

(1)

Putting Together a Photo Album

354

(3)

Creating your photo album

354

(2)

Putting on the final touches

356

(1)

Editing a photo album

357

(1)

Hidden Slides for All Contingencies

357

(2)

Hiding a slide

357

(1)

Showing a hidden slide during a presentation

358

(1)

Chapter 2 Fashioning a Look for Your Presentation

359

(14)

Looking at Themes and Slide Backgrounds

360

(1)

Choosing a Theme for Your Presentation

361

(1)

Creating Slide Backgrounds on Your Own

362

(6)

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

362

(1)

Creating a gradient color blend for slide backgrounds

363

(2)

Placing a picture in the slide background

365

(1)

Using a photo of your own for a slide background

366

(1)

Using a texture for a slide background

367

(1)

Changing the Background of a Single or Handful of Slides

368

(1)

Choosing the Slide Size

369

(1)

Using Master Slides and Master Styles for a Consistent Design

370

(3)

Switching to Slide Master view

370

(1)

Understanding master slides and master styles

370

(2)

Editing a master slide

372

(1)

Changing a master slide layout

372

(1)

Chapter 3 Entering the Text

373

(16)

Entering Text

373

(4)

Choosing fonts for text

374

(1)

Changing the font size of text

375

(1)

Changing the look of text

375

(2)

Fun with Text Boxes and Text Box Shapes

377

(2)

Controlling How Text Fits in Text Frames and Text Boxes

379

(3)

Choosing how AutoFit works in text frames

379

(2)

Choosing how AutoFits works in text boxes

381

(1)

Positioning Text in Frames and Text Boxes

382

(1)

Handling Bulleted and Numbered Lists

382

(3)

Creating a standard bulleted or numbered list

383

(1)

Choosing a different bullet character, size, and color

383

(2)

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

385

(1)

Putting Footers (and Headers) on Slides

385

(4)

Some background on footers and headers

386

(1)

Putting a standard footer on all your slides

386

(1)

Creating a nonstandard footer

387

(1)

Removing a footer from a single slide

388

(1)

Chapter 4 Making Your Presentations Livelier

389

(16)

Suggestions for Enlivening Your Presentation

389

(1)

Presenting Information in a Table

390

(3)

Exploring Transitions and Animations

393

(3)

Showing transitions between slides

393

(1)

Animating parts of a slide

394

(2)

Making Audio Part of Your Presentation

396

(3)

Inserting an audio file on a slide

397

(1)

Telling PowerPoint when and how to play an audio file

398

(1)

Playing audio during a presentation

399

(1)

Playing Video on Slides

399

(4)

Inserting a video on a slide

400

(1)

Fine-tuning a video presentation

400

(2)

Experimenting with the look of the video

402

(1)

Recording a Voice Narration for Slides

403

(2)

Chapter 5 Delivering a Presentation

405

(20)

All about Notes

405

(1)

Rehearsing and Timing Your Presentation

406

(2)

Showing Your Presentation

408

(3)

Starting and ending a presentation

408

(1)

Going from slide to slide

408

(3)

Tricks for Making Presentations a Little Livelier

411

(3)

Wielding a pen or highlighter in a presentation

412

(2)

Blanking the screen

414

(1)

Zooming In

414

(1)

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

414

(13)

Providing handouts for your audience

415

(1)

Creating a self-running, kiosk-style presentation

416

(2)

Creating a user-run presentation

418

(2)

Presenting a Presentation Online

420

(2)

Packaging your presentation on a CD or DVD

422

(1)

Creating a presentation video

423

(2)

Book 5: Outlook 2019

425

(64)

Chapter 1 Outlook Basics

427

(14)

What Is Outlook, Anyway?

427

(2)

Navigating the Outlook Folders

429

(1)

Categorizing Items

430

(2)

Creating a category

430

(1)

Assigning items to categories

431

(1)

Arranging items by category in folders

432

(1)

Searching for Stray Folder Items

432

(3)

Conducting an instant search

433

(1)

Refining a search

433

(1)

Conducting an advanced search

434

(1)

Deleting Email Messages, Contacts, Tasks, and Other Items

435

(1)

Cleaning Out Your Folders

436

(5)

Archiving the old stuff

436

(2)

Running the Mailbox Cleanup command

438

(3)

Chapter 2 Maintaining the Contacts Folder

441

(10)

Maintaining a Happy and Healthy Contacts Folder

442

(3)

Entering a new contact in the Contacts folder

442

(2)

Changing a contact's information

444

(1)

Contact Groups for Sending Messages to Groups

445

(2)

Creating a contact group

445

(2)

Addressing email to a contact group

447

(1)

Editing a contact group

447

(1)

Finding a Contact in the Contacts Folder

447

(1)

Printing the Contacts Folder

448

(3)

Different ways to print contact information

448

(1)

Changing the look of printed pages

449

(2)

Chapter 3 Handling Your Email

451

(22)

Setting Up an Email Account

451

(1)

Addressing and Sending Email Messages

452

(6)

The basics: Sending an email message

453

(1)

Addressing an email message

454

(2)

Sending copies and blind copies of messages

456

(1)

Replying to and forwarding email messages

456

(2)

Sending Files and Photos

458

(2)

Sending a file along with a message

458

(1)

Including a photo in an email message

459

(1)

Receiving Email Messages

460

(1)

Getting your email

460

(1)

Being notified that email has arrived

461

(1)

Reading Your Email in the Inbox Window

461

(2)

Handling Files That Were Sent to You

463

(1)

Opening a file you received

464

(1)

Saving a file you received

464

(1)

Techniques for Organizing Email Messages

464

(4)

Flagging email messages

466

(1)

Rules for earmarking messages as they arrive

466

(2)

All about Email Folders

468

(2)

Moving email messages to different folders

468

(1)

Creating a new folder for storing email

469

(1)

Yes, You Can Prevent Junk Mail (Sort of)

470

(3)

Defining what constitutes junk email

470

(1)

Preventative medicine for junk email

471

(2)

Chapter 4 Managing Your Time and Schedule

473

(8)

Introducing the Calendar

473

(1)

The Different Kinds of Activities

474

(1)

Seeing Your Schedule

475

(2)

Going to a different day, week, or month

476

(1)

Rearranging the Calendar window

476

(1)

Scheduling Appointments and Events

477

(3)

Scheduling an activity: The basics

477

(1)

Scheduling a recurring appointment or event

478

(1)

Scheduling an event

479

(1)

Canceling, Rescheduling, and Altering Activities

480

(1)

Chapter 5 Tasks, Reminders, and Notes

481

(8)

Tasks: Seeing What Needs to Get Done

481

(3)

Entering a task in the Tasks window

482

(2)

Examining tasks in the Tasks window

484

(1)

Handling and managing tasks

484

(1)

Reminders for Being Alerted to Activities and Tasks

484

(3)

Handling reminder messages

485

(1)

Scheduling a reminder message

486

(1)

Making reminders work your way

486

(1)

Making Notes to Yourself

487

(2)

Book 6: Access 2019

489

(84)

Chapter 1 Introducing Access

491

(16)

What Is a Database, Anyway?

492

(1)

Tables, Queries, Forms, and Other Objects

492

(5)

Database tables for storing information

492

(2)

Forms for entering data

494

(1)

Queries for getting the data out

495

(1)

Reports for presenting and examining data

496

(1)

Macros and modules

497

(1)

Creating a Database File

497

(2)

Creating a blank database file

498

(1)

Getting the help of a template

498

(1)

Finding Your Way Around the Navigation Pane

499

(2)

Designing a Database

501

(6)

Deciding what information you need

501

(1)

Separating information into different database tables

502

(1)

Choosing fields for database tables

503

(1)

Deciding on a primary key field for each database table

504

(1)

Mapping the relationships between tables

505

(2)

Chapter 2 Building Your Database Tables

507

(28)

Creating a Database Table

507

(4)

Creating a database table from scratch

508

(1)

Creating a database table from a template

509

(1)

Importing a table from another database

510

(1)

Opening and Viewing Tables

511

(1)

Entering and Altering Table Fields

512

(6)

Creating a field

512

(2)

All about data types

514

(1)

Designating the primary key field

515

(2)

Moving, renaming, and deleting fields

517

(1)

Field Properties for Making Sure That Data Entries Are Accurate

518

(8)

A look at the Field Properties settings

518

(6)

Creating a lookup data-entry list

524

(2)

Indexing for Faster Sorts, Searches, and Queries

526

(2)

Indexing a field

527

(1)

Indexing based on more than one field

527

(1)

Establishing Relationships Among Database Tables

528

(7)

Types of relationships

530

(1)

Handling tables in the Relationships window

530

(2)

Forging relationships between tables

532

(2)

Editing table relationships

534

(1)

Chapter 3 Entering the Data

535

(10)

The Two Ways to Enter Data

535

(1)

Entering the Data in Datasheet View

536

(4)

Entering data

537

(1)

Two tricks for entering data quicker

538

(1)

Changing the appearance of the datasheet

539

(1)

Entering the Data in a Form

540

(2)

Creating a form

540

(1)

Entering the data

541

(1)

Finding a Missing Record

542

(1)

Finding and Replacing Data

543

(2)

Chapter 4 Sorting, Querying, and Filtering for Data

545

(22)

Sorting Records in a Database Table

545

(1)

Ascending vs. descending sorts

546

(1)

Sorting records

546

(1)

Filtering to Find Information

546

(6)

Different ways to filter a database table

548

(1)

"Unfiltering" a database table

548

(1)

Filtering by selection

549

(1)

Filtering for input

549

(1)

Filtering by form

550

(2)

Querying: The Basics

552

(8)

Creating a new query

553

(1)

Viewing queries in Datasheet and Design views

554

(1)

Finding your way around the Query Design window

554

(1)

Choosing which database tables to query

554

(1)

Choosing which fields to query

555

(1)

Sorting the query results

556

(1)

Choosing which fields appear in query results

556

(2)

Entering criteria for a query

558

(2)

At last - saving and running a query

560

(1)

Six Kinds of Queries

560

(7)

Select query

561

(1)

Top-value query

561

(1)

Summary query

561

(1)

Calculation query

562

(2)

Delete query

564

(1)

Update query

564

(3)

Chapter 5 Presenting Data in a Report

567

(6)

Creating a Report

567

(2)

Opening and Viewing Reports

569

(1)

Tweaking a Report

569

(4)

Book 7: Publisher 2019

573

(38)

Chapter 1 Introducing Publisher

575

(12)

"A Print Shop in a Can"

575

(1)

Introducing Frames

576

(1)

Creating a Publication

577

(1)

Redesigning a Publication

578

(2)

Choosing a different template

578

(1)

Choosing a color scheme

578

(1)

Choosing a font scheme

578

(1)

Setting up your pages

579

(1)

Getting a Better View of Your Work

580

(2)

Zooming in and out

580

(1)

Viewing single pages and two-page spreads

581

(1)

Going from page to page

581

(1)

Understanding and Using the Layout Guides

582

(5)

Making use of layout guides

582

(3)

Snapping objects to ruler and grid lines

585

(2)

Chapter 2 Refining a Publication

587

(12)

Entering Text on the Pages

587

(1)

Making Text Fit in Text Frames

588

(4)

Fitting overflow text in a single frame

589

(1)

Making text flow from frame to frame

590

(1)

Filling out a text frame

591

(1)

Formatting Text

592

(1)

Making Text Wrap around a Frame or Graphic

592

(1)

Replacing the Placeholder Pictures

593

(1)

Inserting Frames on the Pages

594

(2)

Inserting a new frame

594

(1)

Changing the size and position of frames

595

(1)

Making Frames Overlap

596

(1)

Inserting, Removing, and Moving Pages

596

(3)

Chapter 3 Putting on the Finishing Touches

599

(12)

Decorating the Text

600

(2)

Drawing a horizontal rule on a frame

600

(1)

Dropping in a drop cap

601

(1)

Techniques for Decorating Pages

602

(4)

Plugging in a page part

602

(2)

Experimenting with borders and accents

604

(1)

Taking advantage of attention getters

604

(1)

Backgrounds for pages

605

(1)

Master Pages for Handling Page Backgrounds

606

(2)

Switching to Master Page view

606

(1)

Changing the look of a master page

607

(1)

Applying (or unapplying) a master page to publication pages

607

(1)

Running the Design Checker

608

(1)

Commercially Printing a Publication

609

(2)

Book 8: Working With Charts And Graphics

611

(94)

Chapter 1 Creating a Chart

613

(20)

The Basics: Creating a Chart

613

(2)

Choosing the Right Chart

615

(2)

Providing the Raw Data for Your Chart

617

(2)

Positioning Your Chart in a Workbook, Page, or Slide

619

(1)

Changing a Chart's Appearance

620

(6)

Changing the chart type

620

(1)

Changing the size and shape of a chart

621

(1)

Choosing a new look for your chart

622

(1)

Changing the layout of a chart

622

(2)

Handling the gridlines

624

(1)

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

624

(2)

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

626

(1)

Saving a chart as a template

626

(1)

Creating a chart from a template

626

(1)

Chart Tricks for the Daring and Heroic

627

(3)

Decorating a chart with a picture

627

(1)

Annotating a chart

628

(1)

Displaying the raw data alongside the chart

629

(1)

Placing a trendline on a chart

629

(1)

Troubleshooting a Chart

630

(3)

Chapter 2 Making a SmartArt Diagram

633

(20)

The Basics: Creating SmartArt Diagrams

633

(3)

Choosing a diagram

634

(1)

Making the diagram your own

635

(1)

Creating the Initial Diagram

636

(2)

Creating a diagram

636

(1)

Swapping one diagram for another

637

(1)

Changing the Size and Position of a Diagram

638

(1)

Laying Out the Diagram Shapes

638

(6)

Selecting a diagram shape

638

(1)

Removing a shape from a diagram

639

(1)

Moving diagram shapes to different positions

639

(1)

Adding shapes to diagrams apart from hierarchy diagrams

639

(1)

Adding shapes to hierarchy diagrams

640

(2)

Adding shapes to Organization charts

642

(2)

Promoting and demoting shapes in hierarchy diagrams

644

(1)

Handling the Text on Diagram Shapes

644

(3)

Entering text on a diagram shape

645

(1)

Entering bulleted lists on diagram shapes

645

(2)

Changing a Diagram's Direction

647

(1)

Choosing a Look for Your Diagram

647

(1)

Changing the Appearance of Diagram Shapes

648

(3)

Changing the size of a diagram shape

649

(1)

Exchanging one shape for another

649

(1)

Changing a shape's color, fill, or outline

650

(1)

Changing fonts and font sizes on shapes

650

(1)

Creating a Diagram from Scratch

651

(2)

Chapter 3 Handling Graphics and Photos

653

(18)

All about Picture File Formats

653

(4)

Bitmap and vector graphics

654

(1)

Resolution

655

(1)

Compression

656

(1)

Color depth

656

(1)

Choosing file formats for graphics

657

(1)

Inserting a Picture in an Office File

657

(3)

Inserting a picture of your own

657

(1)

Obtaining a picture online

658

(2)

Touching Up a Picture

660

(8)

Softening and sharpening pictures

661

(1)

Correcting a picture's brightness and contrast

662

(1)

Recoloring a picture

662

(1)

Choosing an artistic effect

663

(2)

Selecting a picture style

665

(1)

Cropping off part of a picture

665

(2)

Removing the background

667

(1)

Compressing Pictures to Save Disk Space

668

(3)

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

671

(34)

The Basics: Making Lines, Arrows, and Shapes

672

(2)

Handling Lines, Arrows, and Connectors

674

(4)

Changing the length and position of a line or arrow

674

(1)

Changing the appearance of a line, arrow, or connector

674

(1)

Attaching and handling arrowheads on lines and connectors

675

(1)

Connecting shapes by using connectors

676

(2)

Handling Rectangles, Ovals, Stars, and Other Shapes

678

(4)

Drawing a shape

679

(1)

Changing a shape's symmetry

680

(1)

Using a shape as a text box

681

(1)

Drawing by Freehand

682

(3)

Freehand drawing with a pen or highlighter

682

(1)

Changing the look of freehand drawings

683

(1)

Drawing a math expression

684

(1)

Decorating Your Work with Icons

685

(1)

Inserting a 3-D Model

686

(1)

WordArt for Embellishing Letters and Words

686

(2)

Creating WordArt

687

(1)

Editing WordArt

687

(1)

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

688

(3)

Selecting objects so that you can manipulate them

689

(1)

Hiding and displaying the rulers and grid

690

(1)

Changing an Object's Size and Shape

691

(1)

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

692

(5)

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

693

(2)

Making a color transparent

695

(1)

Putting the outline around an object

696

(1)

Moving and Positioning Objects

697

(10)

Tricks for aligning and distributing objects

697

(3)

When objects overlap: Choosing which appears above the other

700

(2)

Rotating and flipping objects

702

(1)

Grouping objects to make working with them easier

703

(2)

Book 9: Office 2019: One Step Beyond

705

(24)

Chapter 1 Customizing an Office Program

707

(14)

Customizing the Ribbon

707

(6)

Displaying and selecting tab, group, and command names

709

(1)

Moving tabs and groups on the Ribbon

710

(1)

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

710

(2)

Creating new tabs and groups

712

(1)

Resetting your Ribbon customizations

712

(1)

Customizing the Quick Access Toolbar

713

(3)

Adding buttons to the Quick Access toolbar

714

(1)

Changing the order of buttons on the Quick Access toolbar

715

(1)

Removing buttons from the Quick Access toolbar

716

(1)

Placing the Quick Access toolbar above or below the Ribbon

716

(1)

Customizing the Status Bar

716

(1)

Changing the Screen Background and Office Theme

717

(1)

Customizing Keyboard Shortcuts in Word

718

(3)

Chapter 2 Ways of Distributing Your Work

721

(8)

Printing - the Old Standby

721

(2)

Distributing a File in PDF Format

723

(2)

About PDF files

724

(1)

Saving an Office file as a PDF

724

(1)

Sending Your File in an Email Message

725

(1)

Saving an Office File as a Web Page

726

(5)

Turning a file into a web page

726

(1)

Opening a web page in your browser

727

(2)

Book 10: File Sharing And Collaborating

729

(22)

Chapter 1 Up and Running on OneDrive

731

(12)

Signing In to OneDrive

731

(2)

Exploring the OneDrive Window

733

(1)

Managing Your OneDrive Folders

733

(5)

Creating a folder

734

(1)

Viewing and locating folders in the OneDrive window

734

(2)

Selecting folders and files

736

(1)

Going from folder to folder in OneDrive

736

(1)

Deleting, moving, and renaming folders

736

(2)

Uploading Files to a Folder on OneDrive

738

(1)

Saving a File from Office 2019 to OneDrive

739

(1)

Opening a File from OneDrive

740

(1)

Starting in an Office 2019 application

740

(1)

Starting in OneDrive

741

(1)

Downloading Files from OneDrive to Your Computer

741

(2)

Chapter 2 File Sharing and Collaborating

743

(8)

Sharing Files: The Big Picture

743

(2)

Sharing Your Files and Folders with Others

745

(3)

Inviting people by email

745

(1)

Generating a link to shared files

746

(1)

Generating HTML code

747

(1)

Seeing Files and Folders Others Shared with You

748

(1)

Investigating and Managing How Files and Folders Are Shared

749

(2)

Index

751

Peter Weverka is a veteran tech writer and long-time For Dummies author. Among his credits are Office 2016 All-in-One For Dummies and Windows 10 For Seniors For Dummies, both top sellers in their respective categories.

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