Microsoft Excel 365 bible

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 common mathematical operations ; Using formulas to manipulate text ; Using formulas with dates and times ; Using formulas for conditional analysis ; Using formulas for matching and lookups ; Using formulas with tables and 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 PivotTables ; Analyzing data with PivotTables ; 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 ; Seeing some VBA examples ; Creating custom Excel add-ins.