Klientu atbalsts: 27018494

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

E-grāmata: Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

3.50/5 (4 ratings by Goodreads)

Curtis Frye, Joan Lambert

Formāts: 480 pages
Sērija : Step by Step
Izdošanas datums: 07-Dec-2021
Izdevniecība: Addison Wesley
Valoda: eng
ISBN-13: 9780137564354

Citas grāmatas par šo tēmu:

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: 07-Dec-2021
Izdevniecība: Addison Wesley
Valoda: eng
ISBN-13: 9780137564354

Citas grāmatas par šo tēmu:

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.

With Microsoft Excel 365 Step by Step students will master the skills they need:

Quickly set up workbooks, enter data, and format it for easier viewing
Perform calculations and find and correct errors
Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines
Visualize data with 3D maps, funnel charts, and other powerful tools
Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query
Build powerful data models and use them in business intelligence
Look up just the tasks and lessons needed

The quick way to learn Microsoft Excel!

This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers—brisk lessons and detailed screenshots show you exactly what to do, step by step.

Quickly set up workbooks, enter data, and format it for effective visual impact
Perform calculations and find and correct errors
Manage, filter, summarize, validate, reorder, and combine data
Identify trends, illustrate processes and relationships, and dynamically analyze data
Build sophisticated forecasts, key performance indicators (KPIs), and timelines
Visualize data with customized charts, 3D maps, and other powerful tools
Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query
Use powerful Excel Data Models for advanced business intelligence

Acknowledgments

xii

About the author

xii

Introduction

xiii

Who this book is for

xiii

The Step by Step approach

xiii

Features and conventions

xiv

Download the practice files

Sidebar: Adapt exercise steps

E-book edition

xxii

Get support and give feedback

xxii

Errata and support

xxii

Stay in touch

xxii

Part 1 Create and format workbooks

1 Set up a workbook

(38)

Create workbooks

(6)

Modify workbooks

(5)

Modify worksheets

(5)

Merge and unmerge cells

(2)

Customize the Excel app window

(16)

Manage the ribbon

(5)

Manage the Quick Access Toolbar

(5)

Customize the status bar

(2)

Change the magnification level of a worksheet

(1)

Arrange multiple workbook windows

(2)

Skills review

(1)

Practice tasks

(2)

2 Work with data and Excel tables

(30)

Enter and revise data

(4)

Manage data by using Flash Fill

(2)

Move data within a workbook

(5)

Sidebar: Quickly access data-formatting commands

(1)

Find and replace data

(4)

Correct and fine-tune data

(5)

Define Excel tables

(5)

Skills review

(1)

Practice tasks

(3)

3 Perform calculations on data

(32)

Name data ranges

(4)

Sidebar: Operators and precedence

(1)

Create formulas to calculate values

(7)

Summarize data that meets specific conditions

(4)

Copy and move formulas

(3)

Create array formulas

(2)

Find and correct errors in calculations

(4)

Configure automatic and iterative calculation options

(3)

Skills review

(1)

Practice tasks

100

(3)

4 Change workbook appearance

103

(34)

Format cells

104

(6)

Define and manage cell styles

110

(3)

Apply and modify workbook themes

113

(2)

Apply and modify table styles

115

(4)

Make numbers easier to read

119

(3)

Change the appearance of data based on its value

122

(7)

Add images to worksheets

129

(3)

Skills review

132

(1)

Practice tasks

133

(4)

Part 2 Analyze and present data

5 Manage worksheet data

137

(22)

Filter data ranges and tables

138

(5)

Summarize filtered data

143

(7)

Sidebar: Randomly select list rows

149

(1)

Enforce data entry criteria

150

(6)

Skills review

156

(1)

Practice tasks

157

(2)

6 Reorder and summarize data

159

(16)

Sort worksheet data

160

(6)

Sort data by using custom lists

166

(2)

Outline and subtotal data

168

(4)

Skills review

172

(1)

Practice tasks

173

(2)

7 Combine data from multiple sources

175

(18)

Look up data from other locations

176

(9)

Locate information in the same row (VLOOKUP)

177

(2)

Locate information in the same column (HLOOKUP)

179

(3)

Locate information anywhere (XLOOKUP)

182

(3)

Link to data in other locations

185

(3)

Consolidate multiple sets of data

188

(2)

Skills review

190

(1)

Practice tasks

191

(2)

8 Analyze alternative data sets

193

(14)

Define and display alternative data sets

194

(5)

Forecast data by using data tables

199

(3)

Identify the input necessary to achieve a specific result

202

(2)

Skills review

204

(1)

Practice tasks

205

(2)

9 Create charts and graphics

207

(46)

Create standard charts

208

(7)

Create combo charts

215

(1)

Create specialized charts

216

(10)

Hierarchy charts

217

(1)

Statistic charts

218

(2)

Scatter charts

220

(1)

Stock charts

221

(1)

Map charts

222

(4)

Customize chart appearance

226

(7)

Identify data trends

233

(2)

Summarize data by using sparklines

235

(3)

Illustrate processes and relationships

238

(6)

Insert and manage shapes

244

(5)

Sidebar: Insert mathematical equations

248

(1)

Skills review

249

(1)

Practice tasks

250

(3)

10 Create PivotTables and PivotCharts

253

(32)

Analyze data dynamically in PivotTables

254

(8)

Filter, show, and hide PivotTable data

262

(8)

Edit PivotTables

270

(3)

Format PivotTables

273

(4)

Create dynamic PivotCharts

277

(3)

Skills review

280

(1)

Practice tasks

281

(4)

Part 3 Collaborate and share in Excel

11 Print worksheets and charts

285

(22)

Add headers and footers to printed pages

286

(5)

Prepare worksheets for printing

291

(6)

Fit your worksheet contents to the printed page

292

(3)

Change page breaks in a worksheet

295

(2)

Change the page printing order for worksheets

297

(1)

Print worksheets

297

(3)

Print parts of worksheets

300

(2)

Print charts

302

(2)

Skills review

304

(1)

Practice tasks

305

(2)

12 Automate tasks and input

307

(28)

Enable and examine macros

308

(7)

Set macro security levels in Excel

309

(3)

Examine macros

312

(3)

Create and modify macros

315

(2)

Run macros

317

(5)

Assign a macro to a Quick Access Toolbar button

318

(2)

Assign a macro to a shape

320

(1)

Run a macro when a workbook opens

321

(1)

Present information and options as form controls

322

(10)

Skills review

332

(1)

Practice tasks

333

(2)

13 Work with other Microsoft 365 apps

335

(16)

Combine Excel, Word, and PowerPoint content

336

(4)

Link from Excel to a document or presentation

336

(2)

Embed file content

338

(2)

Create hyperlinks from worksheets

340

(6)

Copy or link to charts

346

(2)

Skills review

348

(1)

Practice tasks

349

(2)

14 Collaborate with colleagues

351

(22)

Manage comments

352

(4)

Protect workbooks and worksheets

356

(6)

Finalize workbooks

362

(2)

Save workbook content as a PDF file

364

(1)

Create and distribute workbook templates

365

(3)

Skills review

368

(5)

Part 4 Perform advanced analysis

15 Perform business intelligence analysis

373

(30)

Manage the Excel Data Model

374

(6)

Sidebar: Power View data visualizations

375

(5)

Define relationships between data sources

380

(4)

Manage data by using Power Pivot

384

(7)

Display data on timelines

391

(4)

Import data by using Power Query

395

(5)

Skills review

400

(1)

Practice tasks

401

(2)

16 Create forecasts and visualizations

403

(38)

Create forecast worksheets

404

(6)

Linear forecasting

404

(1)

Exponential smoothing forecasting

404

(6)

Define and manage measures

410

(2)

Define and display key performance indicators

412

(4)

Create 3D data maps

416

(5)

Skills review

421

(1)

Practice tasks

422

(3)

Appendix Keyboard Shortcuts

425

(1)

Excel for Microsoft 365 Keyboard shortcuts

425

(7)

Excel function key commands

432

(2)

Microsoft 365 app keyboard shortcuts

434

(7)

Glossary

441

(6)

Index

447

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series.

A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the world. She currently resides with her familyone daughter, two dogs, two cats, and seven chickensin the Beehive State, where she enjoys the majestic mountain views every dayfrom her office chair.

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