- 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
Credits
Acquisitions Editor
Stephanie McComb
Project Editor
Kelly Talbot
Technical Editor
Niek Otten
Production Editor
Rebecca Anderson
Copy Editor
Karen Gill
Manager of Content Development and Assembly
Mary Beth Wakefield
Marketing Director
David Mayhew
Marketing Manager
Carrie Sherrill
Professional Technology & Strategy Director
Barry Pruett
Business Manager
Amy Knies
Executive Editor
Jody Lefevere
Project Coordinator, Cover
Patrick Redmond
Proofreader
Rebecca Rider
Indexer
Johnna VanHoose Dinse
Cover Designer
Wiley
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.