Excel Pivot Tables: A Comprehensive Intermediate Guide To Learn Excel Pivot Tables For Data Analysis and Modeling
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.
- The Function Library
- Formula Editing
- Different Formulas for Data Analysis
- Data Validation in Excel
- Introduction to VBA
- Automating Processes using VBA
Inside this book you will learn:
And many more...
Grab your copy today so you can finally polish your skills in Excel Pivot Tables.