Includes index

"Almost every job and profession requires digging into an Excel spreadsheet from time to time. You can spend hours of trial and error figuring out how to make Excel work for you, or jump right to the answers you need with the help of this book. This collection of Excel insight walks you through the basics of spreadsheet creation and dives into creating next-level formulas, data visualizations, and analysis. It's the roadmap to unleashing the Excel guru inside of you!"-- Page [4] of cover

Introduction --

Getting started with Excel.

Getting started with spreadsheets ; Carrying out basic calculations ; Formatting cells and worksheets ; Organizing data and creating tables ; Navigating worksheets and workbooks --

Working with formulas and functions.

Tapping into formula and function fundamentals ; Saving time with function tools ; Building array formulas and functions ; Fixing errors in formulas --

Goring farther with functions.

Calculating loans, interest, and depreciation ; Performing functional math ; Working with date and time functions ; Manipulating text with functions --

Analyzing data.

Using basic data analysis techniques ; Working with data analysis tools ; Analyzing table data with functions --

Summarizing, visualizing, and illustrating data.

Creating charts ; Creating and using PivotTables ; Performing PivotTable calculations ; Building PivotCharts --

Reporting and querying data.

Introducing Power Pivot ; Advanced moves with PivotTables ; Working directly with internal data model ; Adding formulas to Power Pivot ; Meeting Power Query and its connection types --

Creating dashboards and reports.

Getting in the dashboard state of mind ; Building a super model ; Dressing up your data tables ; Formatting your way to visualizations ; Displaying performance against a target --

Automating Excel with macros and VBA.

Macro fundamentals ; Getting cozy with Visual Basic Editor ; The anatomy of macros ; Working with workbooks --

Index