Produktbild: Excel 2016 Bible

Excel 2016 Bible Bible

Aus der Reihe Bible

51,99 €

inkl. gesetzl. MwSt., Versandkostenfrei


Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

13.11.2015

Verlag

John Wiley & Sons Inc

Seitenzahl

1152

Maße (L/B/H)

23,9/19,5/5,8 cm

Gewicht

1942 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-06751-1

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

13.11.2015

Verlag

John Wiley & Sons Inc

Seitenzahl

1152

Maße (L/B/H)

23,9/19,5/5,8 cm

Gewicht

1942 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-119-06751-1

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: gpsr@libri.de

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 2016 Bible
  • Acknowledgments ix

    Introduction xli

    Part I: Getting Started with Excel 1

    Chapter 1: Introducing Excel 3

    Chapter 2: Entering and Editing Worksheet Data 9

    Chapter 3: Essential Worksheet Operations 51

    Chapter 4: Working with Cells and Ranges 73

    Chapter 5: Introducing Tables 109

    Chapter 6: Worksheet Formatting 129

    Chapter 7: Understanding Excel Files 157

    Chapter 8: Using and Creating Templates 171

    Chapter 9: Printing Your Work 181

    Part II: Working with Formulas and Functions 205

    Chapter 10: Introducing Formulas and Functions 207

    Chapter 11: Creating Formulas That Manipulate Text 243

    Chapter 12: Working with Dates and Times 263

    Chapter 13: Creating Formulas That Count and Sum 297

    Chapter 14: Creating Formulas That Look Up Values 327

    Chapter 15: Creating Formulas for Financial Applications 349

    Chapter 16: Miscellaneous Calculations 381

    Chapter 17: Introducing Array Formulas 395

    Chapter 18: Performing Magic with Array Formulas 421

    Part III: Creating Charts and Graphics 445

    Chapter 19: Getting Started Making Charts 447

    Chapter 20: Learning Advanced Charting 491

    Chapter 21: Visualizing Data Using Conditional Formatting 539

    Chapter 22: Creating Sparkline Graphics 563

    Chapter 23: Enhancing Your Work with Pictures and Drawings 579

    Part IV: Using Advanced Excel Features 601

    Chapter 24: Customizing the Excel User Interface 603

    Chapter 25: Using Custom Number Formats 613

    Chapter 26: Using Data Validation 633

    Chapter 27: Creating and Using Worksheet Outlines 647

    Chapter 28: Linking and Consolidating Worksheets 657

    Chapter 29: Excel and the Internet 677

    Chapter 30: Protecting Your Work 689

    Chapter 31: Making Your Worksheets Error Free 701

    Part V: Analyzing Data with Excel 731

    Chapter 32: Importing and Cleaning Data 733

    Chapter 33: Introducing Pivot Tables 763

    Chapter 34: Analyzing Data with Pivot Tables 785

    Chapter 35: Performing Spreadsheet What-If Analysis 823

    Chapter 36: Analyzing Data Using Goal Seeking and Solver 841

    Chapter 37: Analyzing Data with the Analysis ToolPak 863

    Chapter 38: Working with Get & Transform 877

    Part VI: Programming Excel with VBA 907

    Chapter 39: Introducing Visual Basic for Applications 909

    Chapter 40: Creating Custom Worksheet Functions 939

    Chapter 41: Creating UserForms 955

    Chapter 42: Using UserForm Controls in a Worksheet 977

    Chapter 43: Working with Excel Events 993

    Chapter 44: VBA Examples 1005

    Chapter 45: Creating Custom Excel Add-Ins 1021

    Part VII: Appendixes 1031

    Appendix A: Worksheet Function Reference 1033

    Appendix B: Excel Shortcut Keys 1053

    Index 1061