I've been using Excel for years, but I've always been frustrated by the more advanced stuff in Excel. Things like pivot tables and pivot charts, or the super-powerful but mega-confusing VLOOKUP function. Sometimes I'd get lucky and figure out how to get one of these things to work, but most times I'd have to ask a co-worker to figure it out for me.Now, I'm starting to be the guy that folks are coming to for help with advanced Excel stuff. This book is fantastic, and for the first time I'm starting to really use Excel for something more advanced than the Sum button!
Here's the table of contents from my copy of the book. Some of the chapters might sound intimidating, but believe me, this book is fun and easy to read:
Part I: Where's the Beef?
Chapter 1: Introducing Excel Lists.
Chapter 2: Grabbing Data from External Sources.
Chapter 3: Scrub-a-Dub-Dub: Cleaning Data.
Part II: PivotTables and PivotCharts.
Chapter 4: Working with PivotTables.
Chapter 5: Building PivotTable Formulas.
Chapter 6: Working with PivotCharts.
Chapter 7: Customizing PivotCharts.
Part III: Advanced Tools.
Chapter 8: Using the Database Functions.
Chapter 9: Using the Statistics Functions.
Chapter 10: Descriptive Statistics.
Chapter 11: Inferential Statistics.
Chapter 12: Optimization Modeling with Solver.
Part IV: The Part of Tens.
Chapter 13: Almost Ten Things You Ought to Know about Statistics.
Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.
Part V: Appendix.
Appendix: Glossary of Data Analysis and Excel Terms.
