51,90 €*
Versandkostenfrei per Post / DHL
Lieferzeit 1-2 Wochen
Your up-to-date guide to Excel 365
Microsoft Excel 365 is the dominant spreadsheet tool for people and businesses around the world. And now, with the second edition of Microsoft® Excel® 365 Bible, you can find all the easy-to-follow info you need in one convenient book. You'll learn to make and navigate spreadsheets, write formulas, use custom functions, visualize your data, and create reports. It's perfect for beginners and power-users.
- Get started with Excel 365 and see what's new in the latest version
- Format your worksheets for readability and a professional appearance
- Learn how to create worksheets and workbooks, import data, and more
- Create your own formulas and functions to help crunch your numbers
- Learn Power Pivot and Power Query
- Use charts and graphs to visualize your data
- Become a data analysis wiz, with What-If analyses, Solver, and other essential tools
- Automate your work and incorporate AI using Microsoft Copilot
- Use Office Scripts in Excel to automate Excel online
Your up-to-date guide to Excel 365
Microsoft Excel 365 is the dominant spreadsheet tool for people and businesses around the world. And now, with the second edition of Microsoft® Excel® 365 Bible, you can find all the easy-to-follow info you need in one convenient book. You'll learn to make and navigate spreadsheets, write formulas, use custom functions, visualize your data, and create reports. It's perfect for beginners and power-users.
- Get started with Excel 365 and see what's new in the latest version
- Format your worksheets for readability and a professional appearance
- Learn how to create worksheets and workbooks, import data, and more
- Create your own formulas and functions to help crunch your numbers
- Learn Power Pivot and Power Query
- Use charts and graphs to visualize your data
- Become a data analysis wiz, with What-If analyses, Solver, and other essential tools
- Automate your work and incorporate AI using Microsoft Copilot
- Use Office Scripts in Excel to automate Excel online
Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.
Dick Kusleika has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.
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 55
Chapter 4: Working with Excel Ranges and Tables 75
Chapter 5: Formatting Worksheets 125
Chapter 6: Understanding Excel Files and Templates 161
Chapter 7: Printing Your Work 181
Chapter 8: Customizing the Excel User Interface 203
Part II: Working with Formulas and Functions 213
Chapter 9: Introducing Formulas and Functions 215
Chapter 10: Understanding and Using Array Formulas 251
Chapter 11: Using Common Formulas for Math and Dates 273
Chapter 12: Using Formulas to Manipulate Text 311
Chapter 13: Using Formulas for Conditional Analysis 331
Chapter 14: Using Formulas for Matching and Lookups 347
Chapter 15: Using Formulas with Conditional Formatting 365
Chapter 16: Making Your Formulas Error-Free 379
Part III: Creating Charts and Other Visualizations 399
Chapter 17: Getting Started with Excel Charts 401
Chapter 18: Using Advanced Charting Techniques 439
Chapter 19: Creating Sparkline Graphics 473
Chapter 20: Visualizing with Custom Number Formats and Shapes 487
Part IV: Managing and Analyzing Data 519
Chapter 21: Importing and Cleaning Data 521
Chapter 22: Using Data Validation 553
Chapter 23: Creating and Using Worksheet Outlines 567
Chapter 24: Linking and Consolidating Worksheets 577
Chapter 25: Introducing Pivot Tables 597
Chapter 26: Analyzing Data with Pivot Tables 619
Chapter 27: Performing Spreadsheet What-If Analysis 653
Chapter 28: Analyzing Data Using Goal Seeking and Solver 675
Chapter 29: Analyzing Data with the Analysis ToolPak 695
Chapter 30: Protecting Your Work 707
Part V: Understanding Power Pivot and Power Query 721
Chapter 31: Introducing Power Pivot 723
Chapter 32: Working Directly with the Internal Data Model 747
Chapter 33: Adding Formulas to Power Pivot 757
Chapter 34: Introducing Power Query 787
Chapter 35: Transforming Data with Power Query 813
Chapter 36: Making Queries Work Together 845
Chapter 37: Enhancing Power Query Productivity 861
Part VI: Automating Excel 873
Chapter 38: Introducing Visual Basic for Applications 875
Chapter 39: Creating Custom Worksheet Functions 903
Chapter 40: Creating UserForms 917
Chapter 41: Using UserForm Controls in a Worksheet 939
Chapter 42: Working with Excel Events 953
Chapter 43: Creating Custom Excel Add-Ins 967
Chapter 44: Office Scripts for Excel 977
Index 1009
| Erscheinungsjahr: | 2025 |
|---|---|
| Fachbereich: | Anwendungs-Software |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | Einband - flex.(Paperback) |
| ISBN-13: | 9781394298242 |
| ISBN-10: | 1394298242 |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: |
Alexander, Michael
Kusleika, Dick |
| Auflage: | 2nd edition |
| Hersteller: | Wiley |
| Verantwortliche Person für die EU: | Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de |
| Maße: | 234 x 185 x 58 mm |
| Von/Mit: | Michael Alexander (u. a.) |
| Erscheinungsdatum: | 08.04.2025 |
| Gewicht: | 1,474 kg |
Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.
Dick Kusleika has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.
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 55
Chapter 4: Working with Excel Ranges and Tables 75
Chapter 5: Formatting Worksheets 125
Chapter 6: Understanding Excel Files and Templates 161
Chapter 7: Printing Your Work 181
Chapter 8: Customizing the Excel User Interface 203
Part II: Working with Formulas and Functions 213
Chapter 9: Introducing Formulas and Functions 215
Chapter 10: Understanding and Using Array Formulas 251
Chapter 11: Using Common Formulas for Math and Dates 273
Chapter 12: Using Formulas to Manipulate Text 311
Chapter 13: Using Formulas for Conditional Analysis 331
Chapter 14: Using Formulas for Matching and Lookups 347
Chapter 15: Using Formulas with Conditional Formatting 365
Chapter 16: Making Your Formulas Error-Free 379
Part III: Creating Charts and Other Visualizations 399
Chapter 17: Getting Started with Excel Charts 401
Chapter 18: Using Advanced Charting Techniques 439
Chapter 19: Creating Sparkline Graphics 473
Chapter 20: Visualizing with Custom Number Formats and Shapes 487
Part IV: Managing and Analyzing Data 519
Chapter 21: Importing and Cleaning Data 521
Chapter 22: Using Data Validation 553
Chapter 23: Creating and Using Worksheet Outlines 567
Chapter 24: Linking and Consolidating Worksheets 577
Chapter 25: Introducing Pivot Tables 597
Chapter 26: Analyzing Data with Pivot Tables 619
Chapter 27: Performing Spreadsheet What-If Analysis 653
Chapter 28: Analyzing Data Using Goal Seeking and Solver 675
Chapter 29: Analyzing Data with the Analysis ToolPak 695
Chapter 30: Protecting Your Work 707
Part V: Understanding Power Pivot and Power Query 721
Chapter 31: Introducing Power Pivot 723
Chapter 32: Working Directly with the Internal Data Model 747
Chapter 33: Adding Formulas to Power Pivot 757
Chapter 34: Introducing Power Query 787
Chapter 35: Transforming Data with Power Query 813
Chapter 36: Making Queries Work Together 845
Chapter 37: Enhancing Power Query Productivity 861
Part VI: Automating Excel 873
Chapter 38: Introducing Visual Basic for Applications 875
Chapter 39: Creating Custom Worksheet Functions 903
Chapter 40: Creating UserForms 917
Chapter 41: Using UserForm Controls in a Worksheet 939
Chapter 42: Working with Excel Events 953
Chapter 43: Creating Custom Excel Add-Ins 967
Chapter 44: Office Scripts for Excel 977
Index 1009
| Erscheinungsjahr: | 2025 |
|---|---|
| Fachbereich: | Anwendungs-Software |
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: | Einband - flex.(Paperback) |
| ISBN-13: | 9781394298242 |
| ISBN-10: | 1394298242 |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: |
Alexander, Michael
Kusleika, Dick |
| Auflage: | 2nd edition |
| Hersteller: | Wiley |
| Verantwortliche Person für die EU: | Libri GmbH, Europaallee 1, D-36244 Bad Hersfeld, gpsr@libri.de |
| Maße: | 234 x 185 x 58 mm |
| Von/Mit: | Michael Alexander (u. a.) |
| Erscheinungsdatum: | 08.04.2025 |
| Gewicht: | 1,474 kg |
Ähnliche Produkte
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Werktage
Lieferzeit 1-2 Werktage
Lieferzeit 1-2 Wochen
Lieferzeit 1-2 Wochen
Lieferzeit 2-4 Werktage
Lieferzeit 2-4 Werktage
Lieferzeit 1-2 Wochen