Hugendubel.info - Die B2B Online-Buchhandlung 

Merkliste
Die Merkliste ist leer.
Bitte warten - die Druckansicht der Seite wird vorbereitet.
Der Druckdialog öffnet sich, sobald die Seite vollständig geladen wurde.
Sollte die Druckvorschau unvollständig sein, bitte schliessen und "Erneut drucken" wählen.

Microsoft Excel 365 Bible

E-BookEPUB2 - DRM Adobe / EPUBE-Book
1072 Seiten
Englisch
John Wiley & Sonserschienen am14.02.20221. Auflage
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365

Excel 365 is Microsoft's latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it's an ideal solution for businesses and people looking to make sense of-and draw intelligence from-their data.

The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You'll learn to create spreadsheets and workbooks and navigate the user interface. If you're ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.

You'll also get:
Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365
Guidance on how to import, manage, and analyze large amounts of data
Advice on how to craft predictions and 'What-If Analyses' based on data you already have

Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world's most popular, easy-to-use spreadsheet software.



Michael Alexander is a senior consultant at Slalom Consulting with more than 15 year's 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.mehr
Verfügbare Formate
BuchKartoniert, Paperback
EUR57,50
E-BookPDF2 - DRM Adobe / Adobe Ebook ReaderE-Book
EUR36,99
E-BookEPUB2 - DRM Adobe / EPUBE-Book
EUR36,99

Produkt

KlappentextYour personal, hands-on guide to the latest and most useful features in Microsoft Excel 365

Excel 365 is Microsoft's latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it's an ideal solution for businesses and people looking to make sense of-and draw intelligence from-their data.

The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365. The authoring team with their decades of Excel and business intelligence experience and recognition from the Excel community as Excel MVPs delivers an accessible and authoritative roadmap to Excel 365. Interested in the basics? You'll learn to create spreadsheets and workbooks and navigate the user interface. If you're ready for more advanced topics you can skip right to the material on creating visualizations, crafting custom functions, and using Visual Basic for Applications to script automations.

You'll also get:
Over 900 pages of powerful tips, tricks, and strategies to unlock the full potential of Microsoft Excel 365
Guidance on how to import, manage, and analyze large amounts of data
Advice on how to craft predictions and 'What-If Analyses' based on data you already have

Perfect for anyone new to Excel, as well as experts and advanced users, the Excel 365 Bible is your comprehensive, go-to guide for everything you need to know about the world's most popular, easy-to-use spreadsheet software.



Michael Alexander is a senior consultant at Slalom Consulting with more than 15 year's 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.
Details
Weitere ISBN/GTIN9781119835233
ProduktartE-Book
EinbandartE-Book
FormatEPUB
Format Hinweis2 - DRM Adobe / EPUB
FormatFormat mit automatischem Seitenumbruch (reflowable)
Erscheinungsjahr2022
Erscheinungsdatum14.02.2022
Auflage1. Auflage
ReiheBible
Seiten1072 Seiten
SpracheEnglisch
Dateigrösse83002 Kbytes
Artikel-Nr.8922219
Rubriken
Genre9201

Inhalt/Kritik

Inhaltsverzeichnis
Introduction xxxix

Part I: Getting Started with Excel 1

Chapter 1: Introducing Excel 3

Chapter 2: Entering and Editing Worksheet Data 27

Chapter 3: Performing Basic Worksheet Operations 53

Chapter 4: Working with Excel Ranges and Tables 73

Chapter 5: Formatting Worksheets 121

Chapter 6: Understanding Excel Files and Templates 157

Chapter 7: Printing Your Work 177

Chapter 8: Customizing the Excel User Interface 199

Part II: Working with Formulas and Functions 209

Chapter 9: Introducing Formulas and Functions 211

Chapter 10: Understanding and Using Array Formulas 247

Chapter 11: Using Formulas for Common Mathematical Operations 271

Chapter 12: Using Formulas to Manipulate Text 285

Chapter 13: Using Formulas with Dates and Times 301

Chapter 14: Using Formulas for Conditional Analysis 329

Chapter 15: Using Formulas for Matching and Lookups 347

Chapter 16: Using Formulas with Tables and Conditional Formatting 365

Chapter 17: Making Your Formulas Error-Free 379

Part III: Creating Charts and Other Visualizations 399

Chapter 18: Getting Started with Excel Charts 401

Chapter 19: Using Advanced Charting Techniques 441

Chapter 20: Creating Sparkline Graphics 475

Chapter 21: Visualizing with Custom Number Formats and Shapes 489

Part IV: Managing and Analyzing Data 519

Chapter 22: Importing and Cleaning Data 521

Chapter 23: Using Data Validation 553

Chapter 24: Creating and Using Worksheet Outlines 567

Chapter 25: Linking and Consolidating Worksheets 577

Chapter 26: Introducing PivotTables 595

Chapter 27: Analyzing Data with PivotTables 617

Chapter 28: Performing Spreadsheet What-If Analysis 651

Chapter 29: Analyzing Data Using Goal Seeking and Solver 675

Chapter 30: Analyzing Data with the Analysis ToolPak 697

Chapter 31: Protecting Your Work 709

Part V: Understanding Power Pivot and Power Query 721

Chapter 32: Introducing Power Pivot 723

Chapter 33: Working Directly with the Internal Data Model 747

Chapter 34: Adding Formulas to Power Pivot 757

Chapter 35: Introducing Power Query 777

Chapter 36: Transforming Data with Power Query 805

Chapter 37: Making Queries Work Together 837

Chapter 38: Enhancing Power Query Productivity 855

Part VI: Automating Excel 867

Chapter 39: Introducing Visual Basic for Applications 869

Chapter 40: Creating Custom Worksheet Functions 899

Chapter 41: Creating UserForms 913

Chapter 42: Using UserForm Controls in a Worksheet 935

Chapter 43: Working with Excel Events 949

Chapter 44: Seeing Some VBA Examples 963

Chapter 45: Creating Custom Excel Add-Ins 979

Index 989mehr
Leseprobe

Introduction

Welcome to the world of Excel. Okay, that's a bit cheesy. But if you look around the business world, the financial world, the manufacturing world, and any other industry you can think of, you will see people using Excel. Excel is everywhere. It is by far the most popular program in the history of business applications. So, we truly are living in a world of Excel. This is probably why you've picked up this book. You need a way to accelerate your learning and get up to speed quickly.

Well, worry not, dear reader. Whether you're boning up on Excel for a new job (congratulations, by the way), for a school project, or just for home use, this book is perfect for you.

In this book, we've organized everything that one would need to know to get up and running quickly with Excel. And we've made certain that this book contains many useful examples and lots of tips and tricks that cover all the essential aspects of Excel-from the basics to more advanced topics.
Looking at What's New in Excel 365

Here's an overview of what's available to those with Microsoft 365 subscriptions as of the October 2021 update and those using the stand-alone (perpetual license) version of Office/Excel 2021.
Dynamic array inherent to Excel's calculation engine âDynamic array behavior is now fundamentally part of Excel's calculation engine. When any function uses an array that returns multiple values, the results will be output to a spill range. This even includes older functions that weren't designed to output arrays. With dynamic arrays, Excel moves into a new era where you no longer need to be a formula guru to leverage the power of arrays. The underlying changes to Excel's calculation engine make legacy array formulas obsolete.
New dynamic array functions âWith the introduction of dynamic arrays, Microsoft released several new functions that leverage dynamic arrays to improve the ability to carry out complex formula operations with ease. These new functions can remove duplicates, extract unique values, filter data, dynamically sort data, and perform sophisticated look-ups.
Formula variables âFormula variables enable you to create a container of sorts that holds the results of a function or calculation for use later in other calculations. Armed with the new LET function, you can simplify your formulas and potentially improve performance.
Power Query Custom Data Types âThe Custom Data feature of Power Query allows you to store multiple columns of data in one column as metadata. You can think of a Custom Data Type as a kind of container that allows you to store the data for many columns, then use that data elsewhere in your workbook.
Power Query import from PDF âPower Query now allows you to import and transform data directly from PDF files.
Power Query Data Profiler âPower Query's new data profiling capabilities allow you to know your data and identify potential issues before using it. You can leverage data profiling in Power Query to get a better understanding of your data and address problem areas before they become a problem later in your reporting processes.
Import custom 3D models âExcel now allows you to import your own custom 3D model graphics, including 3D Manufacturing, Filmbox, Binary GL Transmission, Polygon, and StereoLithography files.
Threaded comments âThreaded comments allow for discussions between contributors directly within a workbook. With the look and feel of comments on a blog or online forum, anyone with access to the workbook can enter their own comments or reply to yours. Traditional comments are now called notes.
Action Pen âWith the new Action Pen feature, you can handwrite directly in the cells and Excel will convert writing into data! Primarily designed for mobile devices, Action Pen makes it easy to edit your workbooks on the go.
Is This Book for You?

This book is designed to enhance the skillset of users at all levels (beginning, intermediate, and even advanced users).

Start at the beginning if you're new to Excel. Part I covers everything you'll need to get familiar with entering data, managing workbooks, formatting worksheets, and printing. You can then move on to Part II, where you'll discover the ins and outs of Excel formulas and functions.

If you're a seasoned analyst, hoping to enhance your data visualization and analytic toolset, check out Part III and Part IV. We've included many examples and tips for analyzing data and creating visually appealing Excel dashboards.

If you've been working with an earlier version of Excel, this book is for you too! Part V covers the Power Pivot and Power Query toolsets. In the past, these features were free Microsoft add-ins that were used peripherally. Now they've become an essential part of how Excel manages data and interacts with external data sources.

If you want to learn the basics of Visual Basic for Applications (VBA) programming, you'll find what you need in Part VI. This part offers a robust set of chapters that will get you started leveraging VBA to automate and enhance your Excel solutions.
Software Versions

This book covers features released as of the October 2021 update of Microsoft 365. The functionality explored here will be available to those on Microsoft 365 subscriptions and those using the stand-alone (perpetual license) version of Office/Excel 2021 for the desktop. Please note that this book is not applicable to Microsoft Excel for Mac.

Excel is available in several versions, including a web version and a version for tablets and phones. Though this book was written for the desktop version of Excel, much of the information here will also apply to the web and tablet versions.

Over the last few years, Microsoft has adopted an agile release cycle, releasing updates to Microsoft 365 practically on a monthly basis. This is great news for those who love seeing new features added to Excel. It's not so great if you're trying to document the features of these tools in a book.

Our assumption is that Microsoft will continue to add new bells and whistles to Excel at a rapid pace after publication of this book. Thus, you may encounter new functionality not covered in this book. That being said, Excel has a broad feature set, much of which is stable and here to stay. So, even though changes will be made to Excel, they won't be so drastic as to turn this book into a doorstop. The core functionality covered in these chapters will remain relevant-even if the mechanics change a bit.
Conventions Used in This Book

Take a minute to scan the following sections to learn some of the typographical and organizational conventions that this book uses.
Excel commands

Excel uses a context-sensitive Ribbon system. The words along the top (such as File, Home, Insert, Page Layout, and so on) are known as tabs. Click a tab, and the Ribbon displays the commands for the selected tab. Each command has a name, which is (usually) displayed next to or below the icon. The commands are arranged in groups, and the group name appears at the bottom of the Ribbon.

The convention we use is to indicate the tab name, followed by the group name, followed by the command name. So, the command used to toggle word wrap within a cell is indicated as follows:
Home ⪠Alignment ⪠Wrap Text

You'll learn more about the Ribbon user interface in Chapter 1, Introducing Excel.
Typographical conventions

Anything that you're supposed to type using the keyboard appears in a bold monospaced font. Lengthy input usually appears on a separate line. Here's an example:
="Part Name: " &VLOOKUP(PartNumber,PartList,2)
Names of the keys on your keyboard appear in normal type. When two keys should be pressed simultaneously, they're connected with a plus sign, like this: Press Ctrl+C to copy the selected cells.

The four arrow keys are collectively known as the navigation keys.

Excel's built-in worksheet functions appear in monospaced font in uppercase like this: Note the SUMPRODUCT function used in cell C20.
Mouse conventions

You'll come across some of the following mouse-related terms, which are all standard fare:
Mouse pointer âThis is the small graphic figure that moves onscreen when you move your mouse. The mouse pointer is usually an arrow, but it changes shape when you move to certain areas of the screen or when you're performing certain actions.
Point âMove the mouse so that the mouse pointer is on a specific item; for example, Point to the Paste button on the Home tab.
Click âPress the left mouse button once and release it immediately.
Right-click âPress the right mouse button once and release it immediately. The right mouse button is used in Excel to open shortcut menus that are appropriate for whatever is currently selected.
Double-click âPress the left mouse button twice in rapid succession.
Drag âPress the left mouse button and keep it pressed while you move the mouse. Dragging is often used...
mehr