Excel Pivot Tables: A Comprehensive Intermediate Guide To Learn Excel Pivot Tables For Data Analysis and Modeling

by M.g. Martin

If you have read the first book of the series, you will have a clear idea of what a pivot table is. The book also shed some light on the different ways in which you can use a pivot table for data analysis. You would have learned how to create pivot tables, and the various functions you can perform on the pivot table. This book will shed some light on the different ways one can use Excel for data analysis.

You will gather information on VBA, Visual Basic for Applications, and also learn more about how you can VBA to work on pivots. You will also learn more about how you can use VBA for Data analysis. Before we jump into how you can use VBA to work with pivot tables, we will learn more about what VBA is and how you can use it to make it easier to perform tasks in Excel.

Inside this book you will learn:

- The Function Library
- Formula Editing
- Different Formulas for Data Analysis
- Data Validation in Excel
- Introduction to VBA
- Automating Processes using VBA

And many more…

Grab your copy today so you can finally polish your skills in Excel Pivot Tables.

Kindle Edition

Published July 27, 2019

About the author

m.g. martin grew up on the big island of hawai'i. He attended San Francisco State University where he was the recipient of the San Francisco Browning Society Dramatic Monologue Award & the Academy of American Poets Award. He is the producer & host of the San Francisco chapter of Literary Death Match. One For None (Ink Press) is his first collection of poems. m.g. eats spam too often & blogs at mgmartin.tumblr.com"