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

Martin, Mg

  • 出版商: Independently Published
  • 出版日期: 2019-07-29
  • 售價: $1,020
  • 貴賓價: 9.5$969
  • 語言: 英文
  • 頁數: 94
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1086265696
  • ISBN-13: 9781086265699
  • 相關分類: ExcelData Science
  • 無法訂購

商品描述

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.