Klientu atbalsts: 27018494

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

E-grāmata: Microsoft Excel 2019 Step by Step

3.82/5 (18 ratings by Goodreads)

Curtis Frye

Formāts: 480 pages
Sērija : Step by Step
Izdošanas datums: 19-Nov-2018
Izdevniecība: Microsoft Press
Valoda: eng
ISBN-13: 9781509306169

Citas grāmatas par šo tēmu:

Excel

Formāts - EPUB+DRM
Cena: 29,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: 480 pages
Sērija : Step by Step
Izdošanas datums: 19-Nov-2018
Izdevniecība: Microsoft Press
Valoda: eng
ISBN-13: 9781509306169

Citas grāmatas par šo tēmu:

Excel

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.

The quick way to learn Microsoft Excel 2019!

This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots show you exactly what to do, step by step.

Quickly set up workbooks, enter data, and format it for easier viewing
Perform calculations and find and correct errors
Filter, sort, summarize, and combine data
Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
Build data models and use them in business intelligence analyses
Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
Look up just the tasks and lessons you need

Acknowledgments

xiii

About the Author

Introduction

xvii

Who this book is for

xvii

The Step by Step approach

xvii

Download the practice files

xviii

Ebook edition

xxi

Sidebar: Adapt exercise steps

xxii

Get support and give feedback

xxiv

Errata and support

xxiv

Stay in touch

xxiv

Part 1: Create and format workbooks

1 Set up a workbook

(36)

Explore the editions of Excel 2019

(1)

Excel 2019

(1)

Excel Online

(1)

Excel Mobile Apps

(1)

Become familiar with new features in Excel 2019

(1)

Create workbooks

(6)

Modify workbooks

(4)

Modify worksheets

(6)

Merge and unmerge cells

(2)

Customize the Excel 2019 app window

(12)

Zoom in on a worksheet

(2)

Arrange multiple workbook windows

(2)

Add buttons to the Quick Access Toolbar

(2)

Customize the ribbon

(6)

Skills review

(1)

Practice tasks

(2)

Create workbooks

(1)

Modify workbooks

(1)

Modify worksheets

(1)

Merge and unmerge cells

(1)

Customize the Excel 2019 app window

(1)

2 Work with data and Excel tables

(30)

Enter and revise data

(4)

Manage data by using Flash Fill

(3)

Move data within a workbook

(6)

Find and replace data

(4)

Correct and expand upon data

(4)

Define Excel tables

(4)

Skills review

(1)

Practice tasks

(3)

Enter and revise data

(1)

Manage data by using Flash Fill

(1)

Move data within a workbook

(1)

Find and replace data

(1)

Correct and expand upon data

(1)

Define Excel tables

(1)

3 Perform calculations on data

(34)

Name groups of data

(3)

Create formulas to calculate values

(11)

Sidebar: Operators and precedence

(2)

Summarize data that meets specific conditions

(5)

Set iterative calculation options and enable or disable automatic calculation

(3)

Use array formulas

(2)

Find and correct errors in calculations

(5)

Skills review

(1)

Practice tasks

100

(3)

Name groups of data

100

(1)

Create formulas to calculate values

100

(1)

Summarize data that meets specific conditions

100

(1)

Set iterative calculation options and enable or disable automatic calculation

101

(1)

Use array formulas

101

(1)

Find and correct errors in calculations

102

(1)

4 Change workbook appearance

103

(34)

Format cells

104

(5)

Define styles

109

(4)

Apply workbook themes and Excel table styles

113

(4)

Make numbers easier to read

117

(4)

Change the appearance of data based on its value

121

(7)

Add images to worksheets

128

(4)

Skills review

132

(1)

Practice tasks

133

(4)

Format cells

133

(1)

Define styles

133

(1)

Apply workbook themes and Excel table styles

133

(1)

Make numbers easier to read

134

(1)

Change the appearance of data based on its value

134

(1)

Add images to worksheets

134

(3)

Part 2: Analyze and present data

5 Manage worksheet data

137

(18)

Limit data that appears on your screen

138

(4)

Manipulate worksheet data

142

(8)

Select list rows at random

142

(1)

Summarize data in worksheets that have hidden and filtered rows

143

(6)

Find unique values within a data set

149

(1)

Define valid sets of values for ranges of cells

150

(2)

Skills review

152

(1)

Practice tasks

153

(2)

Limit data that appears on your screen

153

(1)

Manipulate worksheet data

153

(1)

Define valid sets of values for ranges of cells

154

(1)

6 Reorder and summarize data

155

(18)

Sort worksheet data

156

(5)

Sort data by using custom lists

161

(2)

Organize data into levels

163

(4)

Look up information in a worksheet

167

(3)

Skills review

170

(1)

Practice tasks

171

(2)

Sort worksheet data

171

(1)

Sort data by using custom lists

171

(1)

Organize data into levels

171

(1)

Look up information in a worksheet

172

(1)

7 Combine data from multiple sources

173

(16)

Use workbooks as templates for other workbooks

174

(4)

Link to data in other workbooks and worksheets

178

(5)

Consolidate multiple sets of data into a single workbook

183

(3)

Skills review

186

(1)

Practice tasks

187

(2)

Use workbooks as templates for other workbooks

187

(1)

Link to data in other workbooks and worksheets

187

(1)

Consolidate multiple sets of data into a single workbook

187

(2)

8 Analyze alternative data sets

189

(26)

Examine data by using the Quick Analysis Lens

190

(1)

Define an alternative data set

191

(4)

Define multiple alternative data sets

195

(1)

Analyze data by using data tables

196

(4)

Vary your data to get a specific result by using Goal Seek

200

(2)

Find optimal solutions by using Solver

202

(6)

Analyze data by using descriptive statistics

208

(2)

Skills review

210

(1)

Practice tasks

211

(4)

Examine data by using the Quick Analysis Lens

211

(1)

Define an alternative data set

211

(1)

Define multiple alternative data sets

211

(1)

Analyze data by using data tables

212

(1)

Vary your data to get a specific result by using Goal Seek

212

(1)

Find optimal solutions by using Solver

213

(1)

Analyze data by using descriptive statistics

214

(1)

9 Create charts and graphics

215

(40)

Create charts

216

(7)

Perform business intelligence analysis using charts

223

(6)

Customize chart appearance

229

(6)

Find trends in your data

235

(3)

Create combo charts

238

(1)

Summarize your data by using sparklines

239

(2)

Create diagrams by using SmartArt

241

(4)

Create and manage shapes

245

(2)

Create and manage mathematical equations

247

(4)

Skills review

251

(1)

Practice tasks

252

(3)

Create charts

252

(1)

Perform business intelligence analysis using charts

252

(1)

Customize chart appearance

253

(1)

Find trends in your data

253

(1)

Create combo charts

253

(1)

Summarize your data by using sparklines

253

(1)

Create diagrams by using SmartArt

254

(1)

Create and manage shapes and mathematical equations

254

(1)

Create and manage mathematical equations

254

(1)

10 Use PivotTables and PivotCharts

255

(38)

Analyze data dynamically by using PivotTables

256

(8)

Filter, show, and hide PivotTable data

264

(9)

Edit PivotTables

273

(4)

Format PivotTables

277

(3)

Create PivotTables from external data

280

(4)

Create dynamic charts by using PivotCharts

284

(3)

Skills review

287

(1)

Practice tasks

288

(5)

Analyze data dynamically by using PivotTables

288

(1)

Filter, show, and hide PivotTable data

288

(1)

Edit PivotTables

289

(1)

Format PivotTables

289

(1)

Create PivotTables from external data

289

(1)

Create dynamic charts by using PivotCharts

290

(3)

Part 3: Collaborate and share in Excel

11 Print worksheets and charts

293

(22)

Add headers and footers to printed pages

294

(5)

Prepare worksheets for printing

299

(6)

Fit your worksheet contents to the printed page

300

(3)

Change page breaks in a worksheet

303

(1)

Change the page printing order for worksheets

304

(1)

Print worksheets

305

(3)

Print parts of worksheets

308

(3)

Print charts

311

(1)

Skills review

312

(1)

Practice tasks

313

(2)

Add headers and footers to printed pages

313

(1)

Prepare worksheets for printing

313

(1)

Print worksheets

314

(1)

Print parts of worksheets

314

(1)

Print charts

314

(1)

12 Automate repetitive tasks by using macros

315

(24)

Enable and examine macros

316

(6)

Set macro security levels in Excel 2019

316

(3)

Examine macros

319

(3)

Create and modify macros

322

(1)

Click a button to run a macro

323

(4)

Run a macro when you open a workbook

327

(1)

Insert form controls into a worksheet

328

(8)

Skills review

336

(1)

Practice tasks

337

(2)

Enable and examine macros

337

(1)

Create and modify macros

337

(1)

Run macros when you click a button

337

(1)

Run a macro when you open a workbook

338

(1)

Insert form controls into a worksheet

338

(1)

13 Work with other Microsoft Office apps

339

(14)

Include Office documents in workbooks and other files

340

(4)

Link Office documents to Excel workbooks

341

(1)

Embed files in Excel and other Office apps

342

(2)

Create hyperlinks

344

(5)

Paste charts into documents

349

(1)

Skills review

350

(1)

Practice tasks

351

(2)

Include Office documents in workbooks and other files

351

(1)

Create hyperlinks

351

(1)

Paste charts into documents

352

(1)

14 Collaborate with colleagues

353

(32)

Save workbooks for electronic distribution

354

(1)

Manage comments

355

(3)

Protect workbooks and worksheets

358

(6)

Finalize workbooks

364

(2)

Authenticate workbooks

366

(3)

Save workbooks for the web

369

(2)

Import and export XML data

371

(3)

Work with OneDrive and Excel Online

374

(5)

Skills review

379

(1)

Practice tasks

380

(5)

Save workbooks for electronic distribution

380

(1)

Manage comments

380

(1)

Add protection to workbooks and worksheets

380

(1)

Finalize workbooks

381

(1)

Authenticate workbooks

381

(1)

Save workbooks for the web

381

(1)

Import and export XML data

382

(1)

Work with OneDrive and Excel Online

382

(3)

Part 4: Perform advanced analysis

15 Perform business intelligence analysis

385

(24)

Define a Data Model

386

(2)

Define relationships between tables

388

(4)

Analyze data by using Power Pivot

392

(5)

View data by using timelines

397

(4)

Bring in external data by using Power Query

401

(5)

Skills review

406

(1)

Practice tasks

407

(2)

Define a Data Model

407

(1)

Define relationships between tables

407

(1)

Analyze data by using Power Pivot

407

(1)

View data by using timelines

408

(1)

Bring in external data by using Power Query

408

(1)

16 Create forecasts and visualizations

409

(22)

Create forecast worksheets

410

(6)

Define and manage measures

416

(2)

Define and display key performance indicators

418

(4)

Create 3D maps

422

(6)

Skills review

428

(1)

Practice tasks

429

(2)

Create forecast worksheets

429

(1)

Define and manage measures

429

(1)

Define and display KPIs

430

(1)

Create 3D maps

430

(1)

Keyboard Shortcuts

431

(8)

Glossary

439

(6)

Index

445

Curt Frye is the author of more than 30 books, including Microsoft Excel 2016 Step by Step and Microsoft OneNote Step by Step for Microsoft Press. He has also created and recorded more than 60 online training courses for lynda.com and LinkedIn Learning, including Office 365 for Mac: Excel Essential Training, Excel: Scenario Planning and Analysis, Excel: Statistical Process Control, and Microsoft Excel: Using Solver for Decision Analysis.

Curt is a popular conference speaker, offering his Improspectives® program on applying the techniques of improvisational theater to business and life as well as Which Game Are You Playing?, which applies lessons from the strategies and tactics of popular games to business. He earned his undergraduate degree in political science from Syracuse University in 1990 and will receive his MBA from the University of Illinois in December 2018.

Curt lives in Portland, Oregon with his wife Virginia

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