Klientų aptarnavimas: +370 652 87781

Pagalba | Naujas vartotojas | Prisijungti

My Excel 2016 [Minkštas viršelis]

3.50/5 (4 ratings by Goodreads)

Tracy Syrstad

Formatas: Paperback / softback, 480 pages
Serija: My...
Išleidimo metai: 22-Oct-2015
Leidėjas: Que Corporation,U.S.
ISBN-10: 0789755424
ISBN-13: 9780789755421

Kitos knygos pagal šią temą:

Excel

Minkštas viršelis
Kaina: 30,46 €
Knygas pristatysime per 3-4 savaites.
Kiekis:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Įdėti į krepšelį
Pristatymas per 4-6 savaites
Įtraukti į pageidavimų sąrašą

Formatas: Paperback / softback, 480 pages
Serija: My...
Išleidimo metai: 22-Oct-2015
Leidėjas: Que Corporation,U.S.
ISBN-10: 0789755424
ISBN-13: 9780789755421

Kitos knygos pagal šią temą:

Excel

Pastovi nuoroda: https://www.kriso.lt/db/9780789755421.html

Book + Content Update Program

My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016.

Get productive fast with Excel 2016s updated interface Save time and make your data easier to work with Efficiently enter, insert, move, and manage data Use templates to reuse work and get a jumpstart on new projects Format worksheets and charts to make them clearer and more useful Use intuitive sparkline charts that fit in a single cell Build custom formulas using powerful built-in functions Sort, filter, and consolidate data and eliminate duplication Instantly group data and generate subtotals Quickly summarize huge data sets with PivotTables Find, fix, and avoid errors that break spreadsheets or cause inaccuracies Communicate more powerfully using visual tools such as SmartArt and WordArt Precisely control what you print and how it looks Securely share and distribute your workbooks Use Excel on the Web wherever you have Internet access

Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter.

In addition, this book is part of Ques exciting new Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.

How to access the web edition: Follow the instructions in the book to learn how to register your book to access the FREE Web Edition.

Introduction

(4)

What's in This Book

(1)

Guidance for Beginners

(3)

1 Understanding the Microsoft Excel Interface

(20)

Identifying Parts of the Excel Window

(2)

Using the Built-in Help

(2)

Perform a Search

(1)

Making Selections from the Ribbon

(1)

Customizing the Ribbon

(5)

Minimize the Ribbon Size

(1)

Add More Commands to the Ribbon

(3)

Customizing the QAT

(1)

Move the QAT to a New Location

(1)

Add More Commands to the QAT

(1)

Viewing Multiple Sheets at the Same Time

(3)

Arrange Multiple Sheets

(1)

Scroll Two Sheets Side by Side

(1)

Changing the Zoom on a Sheet

(1)

Use Excel's Zoom Controls

(1)

Moving Around on a Sheet

(1)

Keyboard Shortcuts for Quicker Navigation

(1)

Selecting a Range of Cells

(4)

Select a Range Using the Mouse

(4)

2 Working with Workbooks and Templates

(12)

Managing Workbooks

(5)

Create a New Workbook

(1)

Open an Existing Workbook

(1)

Use the Recent Workbooks List

(1)

Save a Workbook

(2)

Close a Workbook

(1)

Using Templates to Quickly Create New Workbooks

(7)

Use Microsoft's Online Templates

(1)

Save a Template

(1)

Open a Locally Saved Template to Enter Data

(1)

Edit the Design of a Locally Saved Template

(1)

Change Personal Templates Location

(2)

3 Working with Sheets

(8)

Adding and Deleting Sheets

(2)

Add a New Sheet

(1)

Delete a Sheet

(1)

Navigating and Selecting Sheets

(1)

Activate Another Sheet

(1)

Select Multiple Sheets

(1)

Moving or Copying Sheets

(3)

Move or Copy a Sheet in the Same Workbook

(1)

Move or Copy a Sheet Between Workbooks

(1)

Renaming a Sheet

(2)

Change a Sheet's Name

(2)

4 Getting Data onto a Sheet

(46)

Entering Different Types of Data into a Cell

(4)

Type Numbers or Text into a Cell

(1)

Enter Numbers as Text

(1)

Type Dates and Times into a Cell

(1)

Undo an Entry

(1)

Using Lists to Quickly Fill a Range

(5)

Extend a Series Containing Text

(1)

Extend a Numerical Series

(2)

Create Your Own List

(2)

Using Paste Special

(9)

Paste Values Only

(2)

Combine Multiple Paste Special Options

(3)

Multiply the Range by a Specific Value

(3)

Use Paste to Merge a Noncontiguous Selection

(1)

Using Text to Columns to Separate Data in a Single Column

(3)

Work with Delimited Text

(3)

Using Data Validation to Limit Data Entry in a Cell

(3)

Limit User Entry to a Selection from a List

(3)

Using Web Queries to Get Data onto a Sheet

(2)

Insert a Web Query

(2)

Editing Data

(1)

Modify Cell Data

(1)

Clearing the Contents of a Cell

(1)

Clear Only Data from a Cell

(1)

Clearing an Entire Sheet

(1)

Clear an Entire Sheet

(1)

Working with Tables

(4)

Define a Table

(2)

Add a Total Row to a Table

(1)

Change the Total Row Function

(1)

Expand a Table

(1)

Fixing Numbers Stored as Text

(4)

Use Convert to Number on Multiple Cells

(1)

Use Paste Special to Force a Number

(2)

Spell Checking a Sheet

(1)

Finding Data on a Sheet

(8)

Perform a Search

(2)

Perform a Wildcard Search

(1)

Replace Data on a Sheet

(4)

5 Selecting and Moving Data on a Sheet

(16)

Working with Rows and Columns

(10)

Select a Row or Column

(1)

Insert a New Row or Column

(2)

Delete a Row or Column

(1)

Move Rows or Columns by Dragging

(1)

Move Rows or Columns by Cutting

(2)

Copy Rows or Columns

(2)

Working with Cells

101

(6)

Select a Cell Using the Name Box

101

(1)

Select Noncontiguous Cells and Ranges

102

(1)

Insert Cells

103

(1)

Delete Cells

104

(1)

Move Cells

105

(2)

6 Formatting Sheets and Cells

107

(36)

Changing the Font Settings of a Cell

108

(7)

Select a New Font Typeface

109

(1)

Increase and Decrease the Font Size

110

(1)

Apply Bold, Italic, and Underline to Text

111

(1)

Apply Strikethrough, Superscript, and Subscript

111

(2)

Change the Font Color

113

(1)

Format a Character or Word in a Cell

114

(1)

Format Quickly with the Format Painter

114

(1)

Adjusting the Row Height

115

(4)

Modify the Row Height by Dragging

116

(1)

Modify the Row Height by Entering a Value

117

(1)

Use Font Size to Automatically Adjust the Row Height

118

(1)

Adjusting the Column Width

119

(2)

Modify the Column Width by Dragging

119

(1)

Modify the Column Width by Entering a Value

120

(1)

Aligning Text in a Cell

121

(1)

Change Text Alignment

121

(1)

Merging Two or More Cells

121

(3)

Merge and Center Data

122

(1)

Merge Across Columns

123

(1)

Unmerge Cells

123

(1)

Centering Text Across Multiple Cells

124

(1)

Center Text Without Merging

124

(1)

Wrapping Text in a Cell to the Next Line

125

(1)

Wrap Text in a Cell

125

(1)

Reflowing Text in a Paragraph

126

(1)

Fit Text to a Specific Range

126

(1)

Indenting Cell Contents

127

(1)

Indent Data

127

(1)

Applying Number Formats

128

(7)

Modify the Number Format

128

(1)

Change the Format of Negative Numbers

129

(1)

Apply a Currency Symbol

130

(1)

Format Dates and Times

131

(1)

Format as Percentage

132

(1)

Format as Text

133

(1)

Apply the Special Number Format

134

(1)

Adding a Border Around a Range

135

(3)

Format a Range with a Thick Outer Border and Thin Inner Lines

136

(1)

Add a Colored Border

137

(1)

Coloring the Inside of a Cell

138

(5)

Apply a Two-Color Gradient to a Cell

139

(4)

7 Advanced Formatting

143

(32)

Creating Custom Number Formats

143

(9)

The Four Sections of a Custom Number Format

144

(1)

Optional Versus Required Digits

145

(1)

Use the Thousands Separator, Color Codes, and Text

146

(2)

Line Up Decimals

148

(1)

Fill Leading and Trailing Spaces

149

(1)

Show More Than 24 Hours in a Time Format

150

(2)

Creating Hyperlinks

152

(2)

Create a Hyperlink to Another Sheet

152

(2)

Link to a Web Page

154

(1)

Dynamic Cell Formatting with Conditional Formatting

154

(12)

Use Icons to Mark Data

155

(2)

Highlight the Top 10

157

(2)

Highlight Duplicate or Unique Values

159

(2)

Create a Custom Rule

161

(2)

Clear Conditional Formatting

163

(1)

Edit Conditional Formatting

164

(2)

Using Cell Styles to Apply Cell Formatting

166

(3)

Apply a Style

166

(1)

Create a Custom Style

167

(2)

Using Themes to Ensure Uniformity in Design

169

(6)

Apply a New Theme

169

(1)

Create a New Theme

170

(3)

Share a Theme

173

(2)

8 Using Formulas

175

(34)

Entering a Formula into a Cell

175

(3)

Calculate a Formula

176

(1)

View All Formulas on a Sheet

177

(1)

Relative Versus Absolute Referencing

178

(2)

Lock the Row When Copying a Formula Down

179

(1)

Copying Formulas

180

(4)

Copy and Paste Formulas

180

(1)

Copy by Dragging the Fill Handle

181

(1)

Copy Rapidly Down a Column

182

(1)

Copy Between Workbooks Without Creating a Link

183

(1)

Converting Formulas to Values

184

(2)

Paste as Values

184

(1)

Select and Drag

185

(1)

Using Names to Simplify References

186

(3)

Create a Named Cell

186

(1)

Use a Name in a Formula

187

(2)

Inserting Formulas into Tables

189

(4)

Write a Formula in a Table

189

(2)

Write Table Formulas Outside the Table

191

(2)

Using Array Formulas

193

(2)

Enter an Array Formula

193

(1)

Delete a Multicell Array Formula

194

(1)

Working with Links

195

(3)

Control the Prompt

196

(1)

Refresh Data

196

(1)

Change the Source Workbook

197

(1)

Break the Link

198

(1)

Troubleshooting Formulas

198

(9)

Fix ###### in a Cell

199

(1)

Understand a Formula Error

199

(2)

Use Trace Precedents and Dependents

201

(2)

Track Formulas on Other Sheets with Watch Window

203

(1)

Use the Evaluate Formula Dialog Box

204

(2)

Evaluate with F9

206

(1)

Adjusting Calculation Settings

207

(2)

Set Calculations to Manual

207

(2)

9 Using Functions

209

(30)

Understanding Functions

209

(5)

Look Up Functions

210

(1)

Use the Function Arguments Dialog Box

211

(3)

Enter Functions Using Formula Tips

214

(1)

Using the AutoSum Button

214

(3)

Calculate a Single Range

215

(1)

Sum Rows and Columns at the Same Time

216

(1)

Quick Calculations

217

(2)

Calculate Results Quickly

217

(2)

Using Quick Analysis Functions

219

(1)

Using Lookup Functions

219

(6)

Use CHOOSE to Return the nth Value from a List

219

(2)

Use VLOOKUP to Return a Value from a Table

221

(2)

Use INDEX and MATCH to Return a Value from the Left

223

(2)

Using SUMIFS to Sum Based on Multiple Criteria

225

(3)

Sum a Column Based on Two Criteria

225

(3)

Using IF Statements

228

(1)

Compare Two Values

228

(1)

Hiding Errors with IFERROR

229

(2)

Hide a #DIV/0! Error

230

(1)

Understanding Dates and Times

231

(3)

Return a New Date X Workdays from Date

231

(2)

Calculate the Number of Days Between Dates

233

(1)

Using Goal Seek

234

(1)

Calculate the Best Payment

234

(1)

Using the Function Arguments Dialog Box to

Troubleshoot Formulas

235

(1)

Narrow Down a Formula Error

236

(3)

10 Sorting Data

239

(14)

Using the Sort Dialog Box

239

(5)

Sort by Values

240

(2)

Sort by Color or Icon

242

(2)

Doing Quick Sorts

244

(2)

Quick Sort a Single Column

244

(1)

Quick Sort Multiple Columns

245

(1)

Performing Custom Sorts

246

(3)

Perform a Random Sort

246

(1)

Sort with a Custom Sequence

247

(2)

Rearranging Columns

249

(2)

Sort Columns with the Sort Dialog Box

249

(2)

Fixing Sort Problems

251

(2)

11 Filtering and Consolidating Data

253

(26)

Using the Filter Tool

253

(5)

Apply a Filter

254

(2)

Clear a Filter

256

(1)

Reapply a Filter

257

(1)

Turn the Filter On for One Column

257

(1)

Filtering Grouped Dates

258

(2)

Turn On Grouped Dates

258

(1)

Filter by Date

259

(1)

Using Special Filters

260

(4)

Filter for Items that Include a Specific Term

260

(1)

Filter for Values Within a Range

261

(1)

Filter for the Top 25 Items

262

(1)

Filter Dates by Quarter

263

(1)

Filtering by Color or Icon

263

(1)

Filtering by Selection

264

(1)

Allowing Users to Filter a Protected Sheet

264

(2)

Filter a Protected Sheet

265

(1)

Using the Advanced Filter

266

(7)

Reorganize Columns

266

(2)

Create a List of Unique Items

268

(1)

Filter Records Using Criteria

269

(3)

Use Formulas as Criteria

272

(1)

Removing Duplicates

273

(1)

Delete Duplicate Rows

273

(1)

Consolidating Data

274

(5)

Merge Values from Two Datasets

274

(2)

Merge Data Based on Matching Labels

276

(3)

12 Distributing and Printing a Workbook

279

(42)

Using Cell Comments to Add Notes to Cells

280

(9)

Insert a New Cell Comment

280

(1)

Edit a Cell Comment

281

(1)

Format a Cell Comment

282

(2)

Insert an Image into a Cell Comment

284

(3)

Resize a Cell Comment

287

(1)

Show and Hide Cell Comments

287

(1)

Delete a Cell Comment

288

(1)

Allowing Multiple Users to Edit a Workbook at the Same Time

289

(2)

Share a Workbook

289

(2)

Hiding and Unhiding Sheets

291

(1)

Hide a Sheet

291

(1)

Unhide a Sheet

292

(1)

Using Freeze Panes

292

(3)

Lock the Top Row

293

(1)

Lock Multiple Rows and Columns

294

(1)

Configuring the Page Setup

295

(5)

Set Paper Size, Margins, and Orientation

295

(1)

Set the Print Area

296

(1)

Set Page Breaks

297

(2)

Scale the Data to Fit a Printed Page

299

(1)

Repeat Specific Rows on Each Printed Page

300

(1)

Creating a Custom Header or Footer

300

(4)

Add an Image to the Header or Footer

301

(2)

Add Page Numbering to the Header and Footer

303

(1)

Printing Sheets

304

(2)

Configure Print Options

304

(2)

Protecting a Workbook from Unwanted Changes

306

(2)

Set File-Level Protection

306

(1)

Set Workbook-Level Protection

307

(1)

Protecting the Data on a Sheet

308

(4)

Protect a Sheet

308

(1)

Unlock Cells

309

(1)

Allow Users to Edit Specific Ranges

310

(2)

Preventing Changes by Marking a File as Final

312

(1)

Mark a Workbook as Final

312

(1)

Sharing Files Between Excel Versions

313

(1)

Check Version Compatibility

313

(1)

Recovering Lost Changes

314

(2)

Configure Backups

314

(1)

Recover a Backup

315

(1)

Recover Unsaved Files

316

(1)

Sending an Excel File as an Attachment

316

(2)

Email a Workbook

317

(1)

Sharing a File Online

318

(3)

Save to OneDrive

318

(3)

13 Inserting Subtotals and Grouping Data

321

(20)

Using the SUBTOTAL Function

321

(2)

Calculate Visible Rows

322

(1)

Summarizing Data Using the Subtotal Tool

323

(4)

Apply a Subtotal

323

(2)

Expand and Collapse Subtotals

325

(1)

Remove Subtotals or Groups

325

(1)

Sort Subtotals

326

(1)

Copying the Subtotals to a New Location

327

(2)

Copy Subtotals

328

(1)

Applying Different Subtotal Function Types

329

(3)

Create Multiple Subtotal Results on Multiple Rows

329

(2)

Combine Multiple Subtotal Results to One Row

331

(1)

Adding Space Between Subtotaled Groups

332

(4)

Separate Subtotaled Groups for Print

333

(1)

Separate Subtotaled Groups for Distributed Files

334

(2)

Grouping and Outlining Rows and Columns

336

(5)

Apply Auto Outline

336

(1)

Group Data Manually

337

(4)

14 Creating Charts and Sparklines

341

(28)

Adding a Chart

341

(5)

Add a Chart with the Quick Analysis Tool

342

(1)

Preview All Charts

343

(1)

Switch Rows and Columns

344

(1)

Apply Chart Styles or Colors

345

(1)

Apply Chart Layouts

346

(1)

Resizing or Moving a Chart

346

(2)

Resize a Chart

346

(1)

Move to a New Location on the Same Sheet

347

(1)

Relocate to Another Sheet

347

(1)

Editing Chart Elements

348

(5)

Use the Format Task Pane

348

(1)

Edit the Chart or Axis Titles

349

(2)

Change the Display Units in an Axis

351

(1)

Customize a Series Color

352

(1)

Changing an Existing Chart's Type

353

(1)

Change the Chart Type

353

(1)

Creating a Chart with Multiple Chart Types

354

(2)

Insert a Multiple Type Chart

354

(2)

Add a Secondary Axis

356

(1)

Updating Chart Data

356

(2)

Change the Data Source

357

(1)

Adding Special Charts

358

(2)

Create a Stock Chart

358

(1)

Create a Bubble Chart

359

(1)

Pie Chart Issue: Small Slices

360

(3)

Rotate the Pie

360

(1)

Create a Bar of Pie Chart

361

(2)

Using a User-Created Template

363

(1)

Save a Chart Template

363

(1)

Use a Chart Template

364

(1)

Adding Sparklines to Data

364

(5)

Insert a Sparkline

365

(1)

Emphasize Points on a Sparkline

365

(1)

Space Markers by Date

366

(1)

Delete Sparklines

367

(2)

15 Summarizing Data with PivotTables

369

(26)

Creating a PivotTable

370

(7)

Use the Quick Analysis Tool

371

(1)

Create a PivotTable from Scratch

372

(3)

Change the Calculation Type of a Field Value

375

(1)

Format Values

376

(1)

Changing the PivotTable Layout

377

(1)

Choose a New Layout

378

(1)

PivotTable Sorting

378

(2)

Click and Drag

378

(1)

Use Quick Sort

379

(1)

Expanding and Collapsing Fields

380

(1)

Expand and Collapse a Field

380

(1)

Grouping Dates

381

(2)

Group by Week

381

(1)

Group by Month and Year

382

(1)

Filtering Data in a PivotTable

383

(1)

Filter for Listed Items

383

(1)

Clear a Filter

384

(1)

Creating a Calculated Field

384

(1)

Add a Calculated Field

384

(1)

Hiding Totals

385

(2)

Hide Totals

386

(1)

Hide Subtotals

386

(1)

Viewing the Records Used to Calculate a Value

387

(1)

Unlinking PivotTables

388

(1)

Unlink a PivotTable Report

388

(1)

Refreshing the PivotTable

389

(3)

Refresh on Open

390

(1)

Refresh After Adding New Data

390

(1)

Refresh After Editing the Data Source

391

(1)

Working with Slicers

392

(3)

Create a Slicer

392

(1)

Use a Slicer

393

(2)

16 Inserting SmartArt, WordArt, and Pictures

395

(16)

Working with SmartArt

395

(8)

Insert a SmartArt Graphic

396

(2)

Insert Images into SmartArt

398

(1)

Move and Resize SmartArt

399

(2)

Reorder Placeholders

401

(1)

Change the Layout

402

(1)

Change an Individual Shape

402

(1)

Working with WordArt

403

(1)

Insert WordArt

403

(1)

Inserting Pictures

404

(7)

Insert a Picture

404

(1)

Resize and Crop a Picture

405

(2)

Apply Corrections, Color, and Artistic Effects

407

(2)

Reduce a File's Size

409

(2)

17 Introducing the Excel Web App

411

(19)

Acquiring a Microsoft Account

411

(2)

Create an Account

412

(1)

Uploading a Workbook

413

(3)

Upload Through OneDrive

413

(1)

Save from Excel

414

(1)

Delete a File from OneDrive

415

(1)

Opening a Workbook Online or Locally

416

(2)

Open a Workbook

417

(1)

Download a Workbook

417

(1)

Creating a New Workbook Online

418

(2)

Create a Workbook

419

(1)

Rename the New Workbook

419

(1)

Sharing a Folder or Workbook

420

(5)

Create a View-Only Folder

420

(2)

Remove Sharing

422

(2)

Edit Simultaneously

424

(1)

Configuring Browser View Options

425

(3)

Create an Online Form

425

(3)

Designing a Survey Through the Web App

428

(2)

Create a Survey

428

(2)

Index

430

Tracy Syrstad is a Microsoft Excel developer and author of eight Excel books. She has been helping people with Microsoft Office issues since 1997 when she discovered free online forums where anyone could ask and answer questions. Tracy discovered she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on an acreage in eastern South Dakota with her husband, one dog, two cats, one horse (two soon), and a variety of wild foxes, squirrels, and rabbits.

My Excel 2016 [Minkštas viršelis]

Paskyra ir nustatymai

Paieška

Ieškoti duomenų bazėje

Patikslinti paiešką

Temos Temos anglų kalba

Pasirinkti pirkinių krepšelį