Produktbild: Excel 2019 Bible

Excel 2019 Bible

Aus der Reihe Bible

Fr. 73.90

inkl. gesetzl. MwSt., Versandkostenfrei


Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

04.12.2018

Verlag

John Wiley & Sons

Seitenzahl

1120

Maße (L/B/H)

23.3/19/5 cm

Gewicht

1807 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-51478-7

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

04.12.2018

Verlag

John Wiley & Sons

Seitenzahl

1120

Maße (L/B/H)

23.3/19/5 cm

Gewicht

1807 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-51478-7

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: GPSR Kontakt

Noch keine Bewertungen vorhanden

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.

Kundinnen und Kunden meinen

Bewertungen (0)

Die Leseprobe wird geladen.
  • Produktbild: Excel 2019 Bible
  • 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