Buchhandlung BOOKandPAPER.store

Suche

Excel 2019 Bible Kartoniert / Broschiert.

Excel 2019 Bible Kartoniert / Broschiert.

| Alexander, Michael; Kusleika, Richard

Taschenbuch
2018 Wiley & Sons; Wiley
Auflage: 1. Auflage
1120 Seiten; 55 mm x 190 mm
Sprache: English
ISBN: 978-1-119-51478-7

Rezension verfassen

€ 53,40

Introduction xli
 
Part I: Getting Started with Excel 1
 
Chapter 1: Introducing Excel 3
 
Chapter 2: Entering and Editing Worksheet Data 29
 
Chapter 3: Performing Basic Worksheet Operations 51
 
Chapter 4: Working with Excel Ranges and Tables 71
 
Chapter 5: Formatting Worksheets 117
 
Chapter 6: Understanding Excel Files and Templates 153
 
Chapter 7: Printing Your Work 173
 
Chapter 8: Customizing the Excel User Interface 195
 
Part II: Working with Formulas and Functions 205
 
Chapter 9: Introducing Formulas and Functions 207
 
Chapter 10: Using Formulas for Common Mathematical Operations 239
 
Chapter 11: Using Formulas to Manipulate Text 253
 
Chapter 12: Using Formulas with Dates and Times 269
 
Chapter 13: Using Formulas for Conditional Analysis 295
 
Chapter 14: Using Formulas for Matching and Lookups 315
 
Chapter 15: Using Formulas for Financial Analysis 333
 
Chapter 16: Using Formulas for Statistical Analysis 365
 
Chapter 17: Using Formulas with Tables and Conditional Formatting 385
 
Chapter 18: Understanding and Using Array Formulas 399
 
Chapter 19: Making Your Formulas Error-Free 423
 
Part III: Creating Charts and Other Visualizations 443
 
Chapter 20: Getting Started with Excel Charts 445
 
Chapter 21: Using Advanced Charting Techniques 489
 
Chapter 22: Creating Sparkline Graphics 523
 
Chapter 23: Visualizing with Custom Number Formats and Shapes 537
 
Chapter 24: Implementing Excel Dashboarding Best Practices 567
 
Part IV: Managing and Analyzing Data 577
 
Chapter 25: Importing and Cleaning Data 579
 
Chapter 26: Using Data Validation 613
 
Chapter 27: Creating and Using Worksheet Outlines 627
 
Chapter 28: Linking and Consolidating Worksheets 637
 
Chapter 29: Introducing PivotTables. 655
 
Chapter 30: Analyzing Data with PivotTables 679
 
Chapter 31: Performing Spreadsheet What-If Analysis 715
 
Chapter 32: Analyzing Data Using Goal Seeking and Solver r 733
 
Chapter 33: Analyzing Data with the Analysis ToolPak 755
 
Chapter 34: Protecting Your Work 769
 
Part V: Understanding Power Pivot and Power Query 781
 
Chapter 35: Introducing Power Pivot 783
 
Chapter 36: Working Directly with the Internal Data Model 807
 
Chapter 37: Adding Formulas to Power Pivot 817
 
Chapter 38: Introducing Power Query. y 835
 
Chapter 39: Transforming Data with Power Query. 859
 
Chapter 40: Making Queries Work Together r 887
 
Chapter 41: Enhancing Power Query Productivity 903
 
Part VI: Automating Excel 915
 
Chapter 42: Introducing Visual Basic for Applications 917
 
Chapter 43: Creating Custom Worksheet Functions 947
 
Chapter 44: Creating UserForms 961
 
Chapter 45: Using UserForm Controls in a Worksheet 983
 
Chapter 46: Working with Excel Events 997
 
Chapter 47: Seeing Some VBA Examples 1011
 
Chapter 48: Creating Custom Excel Add-Ins 1027
 
Index x 1037

Langtext
The complete guide to Excel 2019
 
Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
 
Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible.
* Create functional spreadsheets that work
* Master formulas, formatting, pivot tables, and more
* Get acquainted with Excel 2019's new features and tools
 
Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.

Michael Alexander is a Microsoft MVP and author of several books on advanced business analysis. He shares his wisdom from more than fifteen years consulting and developing reporting solutions for a variety of industries as the principle contributor at DataPigTechnologies.com, where he offers free video tutorials with the Microsoft Excel and Access communities. Dick Kusleika is a twelve-time Microsoft Excel MVP and principle contributor at the Daily Dose of Excel blog. John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books including all previous editions of the Excel Bible.