"The comprehensive tutorial resource"--Cover

PART I: Getting started with Excel. Introducing Excel ; Entering and editing worksheet data ; Performing basic worksheet operations ; Working with Excel ranges and tables ; Formatting worksheets ; Understanding Excel files and templates ; Printing your work ; Customizing the Excel user interface -- PART II: Working with formulas and functions. Introducing formulas and functions ; Understanding and using array formulas ; Using formulas for math and dates ; Using formulas to manipulate text ; Using formulas for conditional analysis ; Using formulas for matching and lookups ; Using formulas with conditional formatting ; Making your formulas error-free -- PART III: Creating charts and other visualizations. Getting started with Excel charts ; Using advanced charting techniques ; Creating Sparkline graphics ; Visualizing with custom number formats and shapes -- PART IV: Managing and analyzing data. Importing and cleaning data ; Using data validation ; Creating and using worksheet outlines ; Linking and consolidating worksheets ; Introducing Pivot Tables ; Analyzing data with Pivot Tables ; Performing spreadsheet what-if analysis ; Analyzing data using goal seeking and solver ; Analyzing data with the Analysis ToolPak ; Protecting your work -- PART V: Understanding Power Pivot and Power Query. Introducing Power Pivot ; Working directly with the internal data model ; Adding formulas to Power Pivot ; Introducing Power Query ; Transforming data with Power Query ; Making queries work together ; Enhancing Power Query productivity -- PART VI: Automating Excel. Introducing Visual Basic for Applications ; Creating custom worksheet functions ; Creating UserForms ; Using UserForm controls in a worksheet ; Working with Excel events ; Creating custom Excel add-ins ; Office scripts for Excel

"Neatly organized and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel -- from the basics, such as navigating the user interface, to more advanced topics, such as creating visualizations and crafting custom functions."--

Includes index

This book covers features released as of the November 2024 update of Microsoft 365. Note: this book is not applicable to Microsoft Excel for Mac. -- page xlii