- Introduction
- Part I: Understanding Formula Basics
- Part II: Leveraging Excel Functions
- Part III: Financial Formulas
- Part IV: Array Formulas
- Part V: Miscellaneous Formula Techniques
- Chapter 16: Importing and Cleaning Data
- Chapter 17: Charting Techniques
- Chapter 18: Pivot Tables
- About Pivot Tables
- A Pivot Table Example
- Data Appropriate for a Pivot Table
- Creating a Pivot Table Automatically
- Creating a Pivot Table Manually
- More Pivot Table Examples
- Grouping Pivot Table Items
- Creating a Frequency Distribution
- Creating a Calculated Field or Calculated Item
- Filtering Pivot Tables with Slicers
- Filtering Pivot Tables with a Timeline
- Referencing Cells Within a Pivot Table
- Another Pivot Table Example
- Using the Data Model
- Creating Pivot Charts
- Chapter 19: Conditional Formatting
- Chapter 20: Using Data Validation
- Chapter 21: Creating Megaformulas
- Chapter 22: Tools and Methods for Debugging Formulas
- Part VI: Developing Custom Worksheet Functions
- Part VII: Appendixes
- Advert
- EULA
About the Technical Editor
Niek Otten lives in the Netherlands. He started in data processing in 1967 in an insurance company. He ran into Visicalc in 1980 and has been addicted to spreadsheets ever since. His first encounter with Excel (version 1!) was in 1985 on a Macintosh. Since 2005, Niek has been self-employed—reviewing books, writing articles, and developing Excel-related software, such as a high-performance actuarial add-in.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.