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

Abi | Registreeri | Logi sisse

E-raamat: Office 2019 For Dummies

4.00/5 (2 hinnangut Goodreads-ist)

Wallace Wang

Formaat: PDF+DRM
Ilmumisaeg: 26-Sep-2018
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781119514008

Teised raamatud teemal:

Microsoft Office

Formaat - PDF+DRM
Hind: 21,44 €*
* 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: 26-Sep-2018
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781119514008

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.

Now updated and revised to cover the latest features of Microsoft Office 2019

The world’s leading suite of business productivity software, Microsoft Office helps users complete common business tasks, including word processing, email, presentations, data management and analysis, and much more. Whether you need accessible instruction on Word, Excel, PowerPoint, Outlook, or Access—or all of the above—this handy reference makes it easier.

In Office X For Dummies, you’ll get help with typing and formatting text in Word, creating and navigating an Excel spreadsheet, creating a powerful PowerPoint presentation, adding color, pictures, and sound to a presentation, configuring email with Outlook, designing an Access database, and more. Information is presented in the straightforward but fun language that has defined the Dummies series for more than twenty years.

Get insight into common tasks and advanced tools
Find full coverage of each application in the suite
Benefit from updated information based on the newest software release
Make your work life easier and more efficiently

If you need to make sense of Office X and don’t have time to waste, this is the trusted reference you’ll want to keep close at hand!

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 2019

(66)

Chapter 1 Introducing Microsoft Office 2019

(24)

Starting an Office 2019 Program

(1)

Introducing the Microsoft Office Ribbon

(2)

Using the File Tab

(6)

Creating a file

(1)

Opening an existing file

(1)

Saving a file

(3)

Using the Ribbon

(7)

Deciphering Ribbon icons

(2)

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

(1)

Removing icons

(1)

Moving the Quick Access toolbar

(1)

Customizing the Ribbon for Touch

(1)

Customizing an Office 2019 Program

(2)

Changing the file format and default location

(1)

Customizing the Ribbon icons

(1)

Exiting Office 2019

(1)

Chapter 2 Selecting and Editing Data

(14)

Adding Data by Pointing

(2)

Selecting Data

(3)

Selecting data with the mouse

(1)

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 2019 Programs

(4)

Using the Office Clipboard

(1)

Viewing and pasting items from the Office Clipboard

(1)

Deleting items from the Office Clipboard

(2)

Chapter 3 Modifying Pictures and Drawing on Documents

(18)

Adding and Deleting Pictures

(3)

Getting pictures from the Internet

(2)

Capturing screenshots

(1)

Manipulating Pictures

(2)

Moving a picture

(1)

Resizing a picture

(1)

Rotating a picture

(1)

Enhancing Pictures

(6)

Choosing visual effects

(3)

Choosing a picture style

(1)

Adding a border around a picture

(2)

Drawing with the Draw Tab

(2)

Drawing lines

(1)

Moving lines

(1)

Erasing lines

(1)

Drawing Shapes

(1)

Creating Math Equations

(3)

Chapter 4 Getting Help from Office 2019

(8)

Searching in the Help Window

(2)

Making the Help Window Easier to Read

(2)

Moving the Help window

(1)

Resizing the Help window

(1)

Displaying Help text in a browser window

(1)

Closing the Help window

(1)

Finding the Right Commands to Use

(3)

Part 2: Working With Word

(70)

Chapter 5 Typing Text in Word

(22)

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

(7)

Using the Find command

(2)

Customizing text searching

(2)

Searching by headings

(1)

Browsing through pages

(1)

Using the Find and Replace command

(1)

Checking Your Spelling

(2)

Checking Your Grammar

(1)

Viewing a Document

(8)

Switching between views

(1)

Using Read Mode view

(1)

Using Outline view

(6)

Chapter 6 Formatting Text

(20)

Finding Formatting Tools on the Home Tab

(1)

Changing the Font

(1)

Changing the Font Size

(1)

Changing the Text Style

(1)

Changing Colors

(3)

Changing the color of text

(1)

Highlighting text with color

100

(1)

Using Text Effects

101

(1)

Justifying Text Alignment

102

(1)

Adjusting Line Spacing

103

(1)

Making Lists

104

(3)

Indenting list items

105

(1)

Converting list items back to text

105

(1)

Customizing a list

105

(1)

Renumbering numbered lists

106

(1)

Using the Ruler

107

(3)

Adjusting left and right paragraph margins

108

(1)

Defining indentation with the Ruler

109

(1)

Using Format Painter

110

(1)

Using Styles

111

(1)

Using Templates

112

(1)

Removing Formatting from Text

113

(2)

Chapter 7 Designing Your Pages

115

(26)

Inserting New Pages

116

(1)

Adding (and Deleting) a Cover Page

116

(1)

Inserting Page Breaks

117

(1)

Inserting Headers and Footers

118

(3)

Creating a header or footer

118

(1)

Defining which pages display a header or footer

119

(2)

Deleting a header or footer

121

(1)

Organizing Text in Tables

121

(5)

Creating a table by highlighting rows and columns

121

(1)

Creating a table with the Insert Table dialog box

122

(1)

Creating a table with the mouse

123

(1)

Creating a table from existing text

124

(2)

Formatting and Coloring a Table

126

(4)

Selecting all or part of a table

126

(1)

Aligning text in a table cell

127

(1)

Choosing a table style

128

(1)

Resizing columns and rows

128

(2)

Sorting a Table

130

(1)

Deleting Tables

131

(2)

Deleting an entire table

131

(1)

Deleting rows and columns

132

(1)

Deleting cells

132

(1)

Deleting cell borders

133

(1)

Making Text Look Artistic

133

(2)

Creating drop caps

134

(1)

Creating WordArt

134

(1)

Dividing Text into Columns

135

(3)

Editing columns

136

(1)

Removing columns

137

(1)

Previewing a Document before Printing

138

(5)

Defining page size and orientation

138

(1)

Using Print Preview

139

(2)

Part 3: Playing The Numbers With Excel

141

(86)

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

143

(32)

Understanding Spreadsheets

144

(1)

Storing Stuff in a Spreadsheet

145

(2)

Typing data into a single cell

145

(1)

Typing data in multiple cells

145

(1)

Typing in sequences with AutoFill

146

(1)

Formatting Numbers and Labels

147

(7)

Formatting numbers

147

(3)

Formatting cells

150

(4)

Navigating a Spreadsheet

154

(4)

Using the mouse to move around in a spreadsheet

154

(1)

Using the keyboard to move around a spreadsheet

155

(1)

Naming cells

156

(2)

Searching a Spreadsheet

158

(3)

Searching for text

158

(2)

Searching for formulas

160

(1)

Editing a Spreadsheet

161

(4)

Editing data in a cell

161

(1)

Changing the size of rows and columns with the mouse

161

(1)

Typing the size of rows and columns

162

(1)

Adding and deleting rows and columns

162

(1)

Adding sheets

163

(1)

Renaming sheets

164

(1)

Rearranging sheets

164

(1)

Deleting a sheet

164

(1)

Clearing Data

165

(1)

Printing Workbooks

166

(9)

Using Page Layout view

166

(1)

Adding a header or footer

167

(1)

Printing gridlines

168

(1)

Defining a print area

169

(1)

Inserting and removing page breaks

170

(1)

Printing row and column headings

171

(1)

Defining printing margins

172

(1)

Defining paper orientation and size

173

(1)

Printing in Excel

174

(1)

Chapter 9 Playing with Formulas

175

(26)

Creating a Formula

175

(5)

Organizing formulas with parentheses

178

(1)

Copying formulas

179

(1)

Using Functions

180

(4)

Using the AutoSum command

182

(1)

Using recently used functions

183

(1)

Editing a Formula

184

(1)

Conditional Formatting

185

(2)

Comparing data values

185

(1)

Creating conditional formatting rules

186

(1)

Data Validation

187

(3)

Goal Seeking

190

(2)

Creating Multiple Scenarios

192

(5)

Creating a scenario

192

(2)

Viewing a scenario

194

(1)

Editing a scenario

195

(1)

Viewing a scenario summary

195

(2)

Auditing Your Formulas

197

(2)

Finding where a formula gets its data

197

(1)

Finding which formula(s) a cell can change

198

(1)

Checking for Errors

199

(2)

Chapter 10 Charting and Analyzing Data

201

(26)

Understanding the Parts of a Chart

201

(2)

Creating a Chart

203

(2)

Editing a Chart

205

(2)

Moving a chart on a worksheet

205

(1)

Moving a chart to a new sheet

206

(1)

Resizing a chart

207

(1)

Using the Chart Tools

207

(5)

Changing the chart type

207

(1)

Changing the data source

208

(1)

Switching rows and columns

209

(1)

Changing the parts of a chart

210

(1)

Designing the layout of a chart

211

(1)

Deleting a chart

212

(1)

Using Sparklines

212

(3)

Creating a Sparkline

213

(1)

Customizing a Sparkline

213

(1)

Deleting a Sparkline

214

(1)

Organizing Lists in Pivot Tables

215

(14)

Creating a pivot table

215

(2)

Rearranging labels in a pivot table

217

(2)

Modifying a pivot table

219

(1)

Filtering a pivot table

220

(1)

Summing a pivot table

221

(1)

Slicing up a pivot table

222

(2)

Creating a pivot chart

224

(3)

Part 4: Making Presentations With Powerpoint

227

(60)

Chapter 11 Creating a PowerPoint Presentation

229

(16)

Defining the Purpose of Your Presentation

229

(1)

Creating a PowerPoint Presentation

230

(7)

Designing a presentation in Normal view

231

(3)

Designing a presentation with Outline view

234

(3)

Working with Text

237

(8)

Creating a text box

238

(1)

Formatting text

239

(1)

Aligning text

239

(1)

Adjusting line spacing

240

(1)

Making numbered and bulleted lists

241

(1)

Making columns

242

(1)

Moving and resizing a text box

243

(1)

Rotating a text box

244

(1)

Chapter 12 Adding Color and Pictures to a Presentation

245

(22)

Applying a Theme

246

(1)

Changing the Background

247

(5)

Choosing a solid color background

248

(1)

Choosing a gradient background

249

(2)

Choosing a picture background

251

(1)

Choosing a pattern background

252

(1)

Adding Graphics to a Slide

252

(6)

Placing picture files on a slide

253

(1)

Placing clip art on a slide

253

(1)

Creating WordArt

254

(1)

Capturing screenshots

255

(1)

Resizing, moving, and deleting graphic images

256

(1)

Rotating graphics

257

(1)

Layering objects

257

(1)

Adding Movies to a Slide

258

(6)

Searching for a video on the Internet

258

(1)

Searching for video on your computer

259

(1)

Trimming a video

260

(1)

Coloring a video

261

(1)

Formatting the shape of a video

262

(2)

Adding Sound to a Slide

264

(3)

Adding audio from a file

264

(1)

Recording audio

265

(2)

Chapter 13 Showing Off a Presentation

267

(20)

Spell-Checking Your Presentation

267

(2)

Organizing Slides in Sections

269

(3)

Adding a section

269

(1)

Expanding and collapsing a section

270

(1)

Deleting a section

271

(1)

Adding Visual Transitions

272

(4)

Adding slide transitions

273

(2)

Text and graphic transitions

275

(1)

Using Animation Painter

276

(1)

Adding Hyperlinks

276

(4)

Creating web page hyperlinks

277

(1)

Creating hyperlinks to external files

278

(1)

Running a program through a hyperlink

279

(1)

Removing a hyperlink or action

279

(1)

Viewing a Presentation

280

(4)

Creating a custom slide show

281

(2)

Hiding a slide

283

(1)

Organizing with Slide Sorter view

283

(1)

Creating Handouts

284

(3)

Part 5: Getting Organized With Outlook

287

(32)

Chapter 14 Managing Email with Outlook

289

(16)

Configuring Email Settings

289

(2)

Adding an email account

290

(1)

Creating Email

291

(4)

Creating an email message

291

(1)

Replying to an email message

292

(1)

Using a stored email address to create a new email message

293

(2)

Attaching Files to Messages

295

(2)

Reading and Organizing Email

297

(4)

Grouping messages into categories

298

(1)

Changing the appearance of the Reading Pane

298

(1)

Retrieving a file attachment from a message

299

(2)

Deleting Email Messages

301

(1)

Creating Quick Steps

301

(4)

Chapter 15 Calendars, Contacts, and Tasks

305

(14)

Setting Appointments

305

(5)

Making an appointment

305

(3)

Viewing appointments

308

(1)

Deleting an appointment

309

(1)

Storing Names and Addresses

310

(3)

Adding a name

310

(1)

Viewing names

311

(1)

Searching names

312

(1)

Managing Tasks

313

(8)

Storing a task

315

(1)

Searching tasks

316

(1)

Viewing tasks

317

(2)

Part 6: Storing Stuff In Access

319

(52)

Chapter 16 Using a Database

321

(16)

Understanding the Basics of a Database

322

(1)

Designing a Database

323

(3)

Editing and Modifying a Database

326

(3)

Naming a field

326

(1)

Adding and deleting a field

327

(1)

Defining the type and size of a field

328

(1)

Typing Data into a Database

329

(6)

Using Datasheet view

330

(1)

Using Form view

330

(1)

Creating a form

331

(1)

Viewing and editing data in a form

332

(1)

Editing a form

332

(3)

Closing and Saving a Database

335

(2)

Closing a database

335

(1)

Exiting Access

336

(1)

Chapter 17 Searching, Sorting, and Querying a Database

337

(20)

Searching a Database

338

(8)

Searching for a specific record

338

(1)

Filtering a database

339

(7)

Sorting a Database

346

(1)

Querying a Database

347

(10)

Creating a simple query

347

(2)

Creating a crosstab query

349

(3)

Creating a query that finds duplicate field data

352

(2)

Creating an unmatched query

354

(1)

Viewing, renaming, closing, and deleting queries

355

(2)

Chapter 18 Creating a Database Report

357

(14)

Using the Report Wizard

357

(4)

Manipulating the Data in a Report

361

(3)

Switching a report to Layout view

361

(1)

Counting records or values

361

(2)

Sorting a field

363

(1)

Filtering a field

363

(1)

Editing a Report

364

(2)

Resizing fields

365

(1)

Deleting fields

366

(1)

Making Reports Look Pretty

366

(3)

Applying themes

367

(1)

Creating conditional formatting

367

(2)

Deleting a Report

369

(2)

Part 7: The Part Of Tens

371

(24)

Chapter 19 Ten Tips for Using Office 2019

373

(14)

Saving Office 2019 Files

373

(2)

Password-Protecting Your Files

375

(2)

Guarding Against Macro Viruses

377

(1)

Customizing the Ribbon

378

(2)

Changing the Size of the Office Window

380

(1)

Right-Clicking the Mouse

381

(1)

Freezing Row and Column Headings in Excel

381

(1)

Displaying Slides Out of Order in PowerPoint

382

(1)

Reducing Spam in Outlook

382

(3)

Setting up Outlook's junk email filter

382

(2)

Creating a Safe Senders list

384

(1)

Creating a Blocked Senders list

385

(1)

Using Office 365 and Office on Android and iOS

385

(2)

Chapter 20 Ten Ways to Make Office 2019 Easier to Use

387

Build (and Use) Your Own Office Add-Ins

387

(1)

Collaborating with the Review Tab

388

(1)

Using Word's References Tab

389

(1)

Using Excel's Data Tab

389

(1)

Saving and Sending Files

390

(1)

Encrypting a File

390

(1)

Saving to the Cloud

391

(1)

Ignoring the Silly Office Ribbon

392

(1)

Find More Office Templates

392

(1)

Use Microsoft Office Everywhere

393

(2)

Index

395

9781681061825

Preface

xii

Acknowledgments

xiv

Food and Drink

1 Eat Breakfast on a Train at Frank's Diner

(1)

2 Sip with a View at Arbor Crest

(1)

3 Splurge on Sunday Brunch at the Davenport

(2)

4 Get a Great Cuppa Joe at an Indie Coffeehouse

(2)

5 Slurp an Old-Fashioned Shake at the Milk Bottle

(1)

6 Quaff Craft Beer and Eat Great Guacamole at Steel Barrel

(1)

7 Graze the Farmers Market

(1)

8 Take a Nostalgic Burger Tour

(1)

9 Watch the Planes over Breakfast at Felts Field

(1)

10 Dine by the Falls at Clinkerdagger

(1)

11 Get a Scoop at the Scoop

(1)

12 Paddle to No-Li Brewhouse

(1)

13 Pick Your Own at Green Bluff

(1)

14 Throw Back a Shot at Dry Fly

(1)

15 Go Gourmet with Great Chefs

(2)

16 Dine under the Stacks at the Steam Plant

(1)

17 Raise a Toast Downtown to Washington Grapes

(1)

18 Savor Spokandy

(2)

19 Follow in the Footsteps of Jimmie Durkin

(1)

20 Enjoy Upscale Food at a Gas Station

(1)

21 Feast at Kendall Yards

(1)

22 Follow the Ale Trail

(1)

23 Order a Steak to Remember at Wolf Lodge Inn

(2)

24 Take in the Tiny Tiki Bar

(1)

25 Stroll the Perry District

(3)

Music and Entertainment

26 Luxuriate in Art Deco Splendor at the Fox

(1)

27 Pig Out in the Park

(1)

28 Imbibe an Adult Beverage at Baby Bar

(1)

29 Catch a Classic at the Garland

(1)

30 Paint the Town at Summer Art Festivals

(1)

31 See Big-Name Talent at the Bing

(1)

32 Experience a Collision of Art and Music at Terrain

(1)

33 Sing and Dance on the Bar at O'Doherty's

(1)

34 Go to a Glorious Concert at the Cathedral

(2)

35 Take in a Small Club with Big Ideas at The Bartlett

(1)

36 Rock Out at the Knit

(1)

37 Get Down with Bach and Beethoven

(1)

38 Soak Up Summertime in Sandpoint

(1)

39 Ring in the New Year for the Symphony

(1)

40 Party for a Cause at Gleason Fest

(3)

Sports and Recreation

41 Thrill to a Fantastic SkyRide

(1)

42 Photograph a Moose in City Limits

(1)

43 Tube the Spokane River

(1)

44 Snag the Hottest Ticket in Town at Gonzaga

(1)

45 Take a Spin on the Looff Carrousel

(1)

46 Slide Down the Big Red Wagon

(1)

47 Skate the Ice Ribbon

(1)

48 Hit the Streets for Hoopfest

(1)

49 Run Bloomsday

(1)

50 Pitch in at a River Clean-Up

(1)

51 Play Catch on the Field at an Indians Game

(1)

52 Zip Across Mica Peak

(1)

53 Join the Dawn Patrol at Mount Spokane

(2)

54 Paddle the Little Spokane River

(1)

55 Hook Up with a Trout

(1)

56 Walk the Centennial Trail

(1)

57 Play the Canyon

(1)

58 Brave the Timber Terror at Silverwood

(1)

59 Find a Swimming Hole

(1)

60 Take a Bald Eagle Tour at Lake Coeur d'Alene

(1)

61 Cross a Suspension Bridge at the Bowl and Pitcher

(1)

62 Walk Duncan Gardens at Manito Park

(2)

63 Take a Hike and Get a Gooey at Tubbs Hill

(1)

64 Hit the Trail Below High Drive

(1)

65 Raft Devil's Toenail

(1)

66 Snap a Selfie with a Trumpeter Swan at Turnbull National Wildlife Refuge

(1)

67 Bike with the Human-Powered Mass

(1)

68 Stand on Mount Spokane's Summit

(1)

69 Hike to a Hidden Waterfall at Indian Canyon Park

(1)

70 Shoot Clays at the Spokane Gun Club

(1)

71 Mountain Bike at Beacon Hill

(2)

72 Fly Down the Rock Water Slides near Priest Lake

(1)

73 See Snowy Owls in the Wild

(1)

74 Pick Huckleberries in Mount Spokane State Park

(4)

Culture and History

75 Visit the Library with a View

(1)

76 Feed the Garbage Goat

(1)

77 Drink in Words, Wine, and Live Music at Northwest Passages

(2)

78 Get Smart at Get Lit!

(1)

79 Eat an Elephant Ear at the Fair

(1)

80 Spend an Afternoon at the MAC

(1)

81 Honor an American Hero on a Sculpture Walking Tour

(1)

82 Gawk at Fine Old Buildings at the Heart of the City

100

(2)

83 Visit the Bing Crosby House Museum

102

(1)

84 Revel in Lilac City

103

(1)

85 Go to a Powwow

104

(1)

86 Catch a Romantic Scene atop Cliff Drive

105

(1)

87 Take a Mansion Walking Tour of Browne's Addition

106

(2)

88 Soak up Palisades Park

108

(1)

89 Drive to the Top of Steptoe Butte

109

(1)

90 Take a Portrait at Finch Arboretum

110

(1)

91 See Where They Made the Movie

111

(1)

92 Check out a Chihuly at the Jundt Art Museum

112

(4)

Shopping and Fashion

93 Get Lost at Auntie's

116

(1)

94 Get Your Mockingbird Fix at Atticus and Boo Radley's

117

(1)

95 Find Hidden Gems and Antiques

118

(2)

96 Hunt for Treasures at Farm Chicks

120

(1)

97 Hang Out at Merlyn's Comic Book Shop

121

(1)

98 Indulge in a Spa Day

122

(2)

99 Shop Local Artisans

124

(2)

100 Shop on a Budget

126

(3)

Suggested Itineraries

129

(3)

Activities by Season

132

(3)

Index

135

Wallace Wang is the bestselling author of more than 50 computer books, with over three million of his For Dummies books in print. They include numerous versions of Office For Dummies as well as Beginning Programming For Dummies. When not playing with computers, Wallace splits his time between teaching, writing, game designing, screenwriting, and stand-up comedy.

Lisainfo e-raamatute kohta