John Walkenbach
Excel 2013 Bible (eBook, PDF)
Schade – dieser Artikel ist leider ausverkauft. Sobald wir wissen, ob und wann der Artikel wieder verfügbar ist, informieren wir Sie an dieser Stelle.
John Walkenbach
Excel 2013 Bible (eBook, PDF)
- Format: PDF
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei
bücher.de, um das eBook-Abo tolino select nutzen zu können.
Hier können Sie sich einloggen
Hier können Sie sich einloggen
Sie sind bereits eingeloggt. Klicken Sie auf 2. tolino select Abo, um fortzufahren.
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei bücher.de, um das eBook-Abo tolino select nutzen zu können.
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner…mehr
- Geräte: PC
- eBook Hilfe
Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else. * Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 * Provides essential coverage of all the newest features of Excel 2013 * Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience * Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
Produktdetails
- Produktdetails
- Verlag: John Wiley & Sons
- Seitenzahl: 1056
- Erscheinungstermin: 31. Januar 2013
- Englisch
- ISBN-13: 9781118491720
- Artikelnr.: 38249627
- Verlag: John Wiley & Sons
- Seitenzahl: 1056
- Erscheinungstermin: 31. Januar 2013
- Englisch
- ISBN-13: 9781118491720
- Artikelnr.: 38249627
John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.
Acknowledgments ix Introduction xxxvii Is This Book for You? xxxvii Software Versions xxxvii Conventions Used in This Book xxxviii Excel commands xxxviii Filenames, named ranges, and your input xxxviii Key names xxxviii Functions xxxviii Mouse conventions xxxix How This Book Is Organized xl How to Use This Book xl What's on the Website xli Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data 29 Chapter 3: Essential Worksheet Operations 49 Chapter 4: Working with Cells and Ranges 69 Chapter 5: Introducing Tables 101 Chapter 6: Worksheet Formatting 119 Chapter 7: Understanding Excel Files 145 Chapter 8: Using and Creating Templates 161 Chapter 9: Printing Your Work 171 Part II: Working with Formulas and Functions 193 Chapter 10: Introducing Formulas and Functions 195 Chapter 11: Creating Formulas That Manipulate Text 231 Chapter 12: Working with Dates and Times 251 Chapter 13: Creating Formulas That Count and Sum 285 Chapter 14: Creating Formulas That Look Up Values 313 Chapter 15: Creating Formulas for Financial Applications 333 Chapter 16: Miscellaneous Calculations 359 Chapter 17: Introducing Array Formulas 373 Chapter 18: Performing Magic with Array Formulas 397 Part III: Creating Charts and Graphics 419 Chapter 19: Getting Started Making Charts 421 Chapter 20: Learning Advanced Charting 457 Chapter 21: Visualizing Data Using Conditional Formatting 503 Chapter 22: Creating Sparkline Graphics 525 Chapter 23: Enhancing Your Work with Pictures and Drawings 539 Part IV: Using Advanced Excel Features 561 Chapter 24: Customizing the Excel User Interface 563 Chapter 25: Using Custom Number Formats 573 Chapter 26: Using Data Validation 591 Chapter 27: Creating and Using Worksheet Outlines 603 Chapter 28: Linking and Consolidating Worksheets 613 Chapter 29: Excel and the Internet 631 Chapter 30: Protecting Your Work 643 Chapter 31: Making Your Worksheets Error Free 655 Part V: Analyzing Data with Excel 683 Chapter 32: Importing and Cleaning Data 685 Chapter 33: Introducing Pivot Tables 715 Chapter 34: Analyzing Data with Pivot Tables 739 Chapter 35: Performing Spreadsheet What-If Analysis 777 Chapter 36: Analyzing Data Using Goal Seeking and Solver 793 Chapter 37: Analyzing Data with the Analysis ToolPak 813 Part VI: Programming Excel with VBA 825 Chapter 38: Introducing Visual Basic for Applications 827 Chapter 39: Creating Custom Worksheet Functions 855 Chapter 40: Creating UserForms 869 Chapter 41: Using UserForm Controls in a Worksheet 889 Chapter 42: Working with Excel Events 903 Chapter 44: Creating Custom Excel Add-Ins 931 Part VII: Appendixes 941 Appendix A: Worksheet Function Reference 943 Appendix B: Excel Shortcut Keys 961 Index 967
Acknowledgments ix
Introduction xxxvii
Is This Book for You? xxxvii
Software Versions xxxvii
Conventions Used in This Book xxxviii
Excel commands xxxviii
Filenames, named ranges, and your input xxxviii
Key names xxxviii
Functions xxxviii
Mouse conventions xxxix
How This Book Is Organized xl
How to Use This Book xl
What's on the Website xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values 313
Chapter 15: Creating Formulas for Financial Applications 333
Chapter 16: Miscellaneous Calculations 359
Chapter 17: Introducing Array Formulas 373
Chapter 18: Performing Magic with Array Formulas 397
Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts 421
Chapter 20: Learning Advanced Charting 457
Chapter 21: Visualizing Data Using Conditional Formatting503
Chapter 22: Creating Sparkline Graphics 525
Chapter 23: Enhancing Your Work with Pictures and Drawings539
Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface 563
Chapter 25: Using Custom Number Formats 573
Chapter 26: Using Data Validation 591
Chapter 27: Creating and Using Worksheet Outlines 603
Chapter 28: Linking and Consolidating Worksheets 613
Chapter 29: Excel and the Internet 631
Chapter 30: Protecting Your Work 643
Chapter 31: Making Your Worksheets Error Free 655
Part V: Analyzing Data with Excel 683
Chapter 32: Importing and Cleaning Data 685
Chapter 33: Introducing Pivot Tables 715
Chapter 34: Analyzing Data with Pivot Tables 739
Chapter 35: Performing Spreadsheet What-If Analysis 777
Chapter 36: Analyzing Data Using Goal Seeking and Solver 793
Chapter 37: Analyzing Data with the AnalysisToolPak 813
Part VI: Programming Excel with VBA 825
Chapter 38: Introducing Visual Basic forApplications 827
Chapter 39: Creating Custom Worksheet Functions 855
Chapter 40: Creating UserForms 869
Chapter 41: Using UserForm Controls in a Worksheet 889
Chapter 42: Working with Excel Events 903
Chapter 44: Creating Custom Excel Add-Ins 931
Part VII: Appendixes 941
Appendix A: Worksheet Function Reference 943
Appendix B: Excel Shortcut Keys 961
Index 967
Introduction xxxvii
Is This Book for You? xxxvii
Software Versions xxxvii
Conventions Used in This Book xxxviii
Excel commands xxxviii
Filenames, named ranges, and your input xxxviii
Key names xxxviii
Functions xxxviii
Mouse conventions xxxix
How This Book Is Organized xl
How to Use This Book xl
What's on the Website xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values 313
Chapter 15: Creating Formulas for Financial Applications 333
Chapter 16: Miscellaneous Calculations 359
Chapter 17: Introducing Array Formulas 373
Chapter 18: Performing Magic with Array Formulas 397
Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts 421
Chapter 20: Learning Advanced Charting 457
Chapter 21: Visualizing Data Using Conditional Formatting503
Chapter 22: Creating Sparkline Graphics 525
Chapter 23: Enhancing Your Work with Pictures and Drawings539
Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface 563
Chapter 25: Using Custom Number Formats 573
Chapter 26: Using Data Validation 591
Chapter 27: Creating and Using Worksheet Outlines 603
Chapter 28: Linking and Consolidating Worksheets 613
Chapter 29: Excel and the Internet 631
Chapter 30: Protecting Your Work 643
Chapter 31: Making Your Worksheets Error Free 655
Part V: Analyzing Data with Excel 683
Chapter 32: Importing and Cleaning Data 685
Chapter 33: Introducing Pivot Tables 715
Chapter 34: Analyzing Data with Pivot Tables 739
Chapter 35: Performing Spreadsheet What-If Analysis 777
Chapter 36: Analyzing Data Using Goal Seeking and Solver 793
Chapter 37: Analyzing Data with the AnalysisToolPak 813
Part VI: Programming Excel with VBA 825
Chapter 38: Introducing Visual Basic forApplications 827
Chapter 39: Creating Custom Worksheet Functions 855
Chapter 40: Creating UserForms 869
Chapter 41: Using UserForm Controls in a Worksheet 889
Chapter 42: Working with Excel Events 903
Chapter 44: Creating Custom Excel Add-Ins 931
Part VII: Appendixes 941
Appendix A: Worksheet Function Reference 943
Appendix B: Excel Shortcut Keys 961
Index 967
Acknowledgments ix Introduction xxxvii Is This Book for You? xxxvii Software Versions xxxvii Conventions Used in This Book xxxviii Excel commands xxxviii Filenames, named ranges, and your input xxxviii Key names xxxviii Functions xxxviii Mouse conventions xxxix How This Book Is Organized xl How to Use This Book xl What's on the Website xli Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data 29 Chapter 3: Essential Worksheet Operations 49 Chapter 4: Working with Cells and Ranges 69 Chapter 5: Introducing Tables 101 Chapter 6: Worksheet Formatting 119 Chapter 7: Understanding Excel Files 145 Chapter 8: Using and Creating Templates 161 Chapter 9: Printing Your Work 171 Part II: Working with Formulas and Functions 193 Chapter 10: Introducing Formulas and Functions 195 Chapter 11: Creating Formulas That Manipulate Text 231 Chapter 12: Working with Dates and Times 251 Chapter 13: Creating Formulas That Count and Sum 285 Chapter 14: Creating Formulas That Look Up Values 313 Chapter 15: Creating Formulas for Financial Applications 333 Chapter 16: Miscellaneous Calculations 359 Chapter 17: Introducing Array Formulas 373 Chapter 18: Performing Magic with Array Formulas 397 Part III: Creating Charts and Graphics 419 Chapter 19: Getting Started Making Charts 421 Chapter 20: Learning Advanced Charting 457 Chapter 21: Visualizing Data Using Conditional Formatting 503 Chapter 22: Creating Sparkline Graphics 525 Chapter 23: Enhancing Your Work with Pictures and Drawings 539 Part IV: Using Advanced Excel Features 561 Chapter 24: Customizing the Excel User Interface 563 Chapter 25: Using Custom Number Formats 573 Chapter 26: Using Data Validation 591 Chapter 27: Creating and Using Worksheet Outlines 603 Chapter 28: Linking and Consolidating Worksheets 613 Chapter 29: Excel and the Internet 631 Chapter 30: Protecting Your Work 643 Chapter 31: Making Your Worksheets Error Free 655 Part V: Analyzing Data with Excel 683 Chapter 32: Importing and Cleaning Data 685 Chapter 33: Introducing Pivot Tables 715 Chapter 34: Analyzing Data with Pivot Tables 739 Chapter 35: Performing Spreadsheet What-If Analysis 777 Chapter 36: Analyzing Data Using Goal Seeking and Solver 793 Chapter 37: Analyzing Data with the Analysis ToolPak 813 Part VI: Programming Excel with VBA 825 Chapter 38: Introducing Visual Basic for Applications 827 Chapter 39: Creating Custom Worksheet Functions 855 Chapter 40: Creating UserForms 869 Chapter 41: Using UserForm Controls in a Worksheet 889 Chapter 42: Working with Excel Events 903 Chapter 44: Creating Custom Excel Add-Ins 931 Part VII: Appendixes 941 Appendix A: Worksheet Function Reference 943 Appendix B: Excel Shortcut Keys 961 Index 967
Acknowledgments ix
Introduction xxxvii
Is This Book for You? xxxvii
Software Versions xxxvii
Conventions Used in This Book xxxviii
Excel commands xxxviii
Filenames, named ranges, and your input xxxviii
Key names xxxviii
Functions xxxviii
Mouse conventions xxxix
How This Book Is Organized xl
How to Use This Book xl
What's on the Website xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values 313
Chapter 15: Creating Formulas for Financial Applications 333
Chapter 16: Miscellaneous Calculations 359
Chapter 17: Introducing Array Formulas 373
Chapter 18: Performing Magic with Array Formulas 397
Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts 421
Chapter 20: Learning Advanced Charting 457
Chapter 21: Visualizing Data Using Conditional Formatting503
Chapter 22: Creating Sparkline Graphics 525
Chapter 23: Enhancing Your Work with Pictures and Drawings539
Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface 563
Chapter 25: Using Custom Number Formats 573
Chapter 26: Using Data Validation 591
Chapter 27: Creating and Using Worksheet Outlines 603
Chapter 28: Linking and Consolidating Worksheets 613
Chapter 29: Excel and the Internet 631
Chapter 30: Protecting Your Work 643
Chapter 31: Making Your Worksheets Error Free 655
Part V: Analyzing Data with Excel 683
Chapter 32: Importing and Cleaning Data 685
Chapter 33: Introducing Pivot Tables 715
Chapter 34: Analyzing Data with Pivot Tables 739
Chapter 35: Performing Spreadsheet What-If Analysis 777
Chapter 36: Analyzing Data Using Goal Seeking and Solver 793
Chapter 37: Analyzing Data with the AnalysisToolPak 813
Part VI: Programming Excel with VBA 825
Chapter 38: Introducing Visual Basic forApplications 827
Chapter 39: Creating Custom Worksheet Functions 855
Chapter 40: Creating UserForms 869
Chapter 41: Using UserForm Controls in a Worksheet 889
Chapter 42: Working with Excel Events 903
Chapter 44: Creating Custom Excel Add-Ins 931
Part VII: Appendixes 941
Appendix A: Worksheet Function Reference 943
Appendix B: Excel Shortcut Keys 961
Index 967
Introduction xxxvii
Is This Book for You? xxxvii
Software Versions xxxvii
Conventions Used in This Book xxxviii
Excel commands xxxviii
Filenames, named ranges, and your input xxxviii
Key names xxxviii
Functions xxxviii
Mouse conventions xxxix
How This Book Is Organized xl
How to Use This Book xl
What's on the Website xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 101
Chapter 6: Worksheet Formatting 119
Chapter 7: Understanding Excel Files 145
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 231
Chapter 12: Working with Dates and Times 251
Chapter 13: Creating Formulas That Count and Sum 285
Chapter 14: Creating Formulas That Look Up Values 313
Chapter 15: Creating Formulas for Financial Applications 333
Chapter 16: Miscellaneous Calculations 359
Chapter 17: Introducing Array Formulas 373
Chapter 18: Performing Magic with Array Formulas 397
Part III: Creating Charts and Graphics 419
Chapter 19: Getting Started Making Charts 421
Chapter 20: Learning Advanced Charting 457
Chapter 21: Visualizing Data Using Conditional Formatting503
Chapter 22: Creating Sparkline Graphics 525
Chapter 23: Enhancing Your Work with Pictures and Drawings539
Part IV: Using Advanced Excel Features 561
Chapter 24: Customizing the Excel User Interface 563
Chapter 25: Using Custom Number Formats 573
Chapter 26: Using Data Validation 591
Chapter 27: Creating and Using Worksheet Outlines 603
Chapter 28: Linking and Consolidating Worksheets 613
Chapter 29: Excel and the Internet 631
Chapter 30: Protecting Your Work 643
Chapter 31: Making Your Worksheets Error Free 655
Part V: Analyzing Data with Excel 683
Chapter 32: Importing and Cleaning Data 685
Chapter 33: Introducing Pivot Tables 715
Chapter 34: Analyzing Data with Pivot Tables 739
Chapter 35: Performing Spreadsheet What-If Analysis 777
Chapter 36: Analyzing Data Using Goal Seeking and Solver 793
Chapter 37: Analyzing Data with the AnalysisToolPak 813
Part VI: Programming Excel with VBA 825
Chapter 38: Introducing Visual Basic forApplications 827
Chapter 39: Creating Custom Worksheet Functions 855
Chapter 40: Creating UserForms 869
Chapter 41: Using UserForm Controls in a Worksheet 889
Chapter 42: Working with Excel Events 903
Chapter 44: Creating Custom Excel Add-Ins 931
Part VII: Appendixes 941
Appendix A: Worksheet Function Reference 943
Appendix B: Excel Shortcut Keys 961
Index 967