Table of Contents – BPB Online
Skip to content
- Chapter 1 What’s New in Excel 2016 (and 2013)
- Chapter 2 Using the Excel Interface
- Chapter 3 Customizing Excel
- Chapter 4 Keyboard Shortcuts
- Chapter 5 Understanding Formulas
- Chapter 6 Controlling Formulas
- Chapter 7 Understanding Functions
- Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions
- Chapter 9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions
- Chapter 10 Other Functions
- Chapter 11 Connecting Worksheets and Workbooks
- Chapter 12 Array Formulas and Names in Excel
- Chapter 13 Transforming Data
- Chapter 14 Summarizing Data Using Subtotals or Filter
- Chapter 15 Using Pivot Tables to Analyze Data
- Chapter 16 Using Slicers and Filtering a Pivot Table
- Chapter 17 Mashing Up Data with Power Pivot
- Chapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver
- Chapter 19 Automating Repetitive Functions Using VBA Macros
- Chapter 20 More Tips and Tricks for Excel 2016
- Chapter 21 Formatting Worksheets
- Chapter 22 Using Data Visualizations and Conditional Formatting
- Chapter 23 Graphing Data Using Excel Charts
- Chapter 24 Using 3D Maps
- Chapter 25 Using Spark lines
- Chapter 26 Decorating Spreadsheets
- Chapter 27 Printing
- Chapter 28 Excel Online