Expert@Excel : Pivot Tables and VBA Programming: Bundle: 2 Books in 1: A Step-By-Step Guide To Learn And Master Pivot Tables and VBA Programming To Get Ahead @ Work, Business And Personal Finances

Description

Have you ever wanted to learn how to manipulate large amounts of data on Excel but have been intimidated by how technical it all seems? Have you always thought that you are not getting the most out Excel at work, in business or in your personal use? If yes then just keep reading......... Excel is essentially one of the most powerful software tools for collecting and analysing data when used to its full potential. But all too often this may is not the case. It is estimated that on average people only use 20% of functions available on excel. Also that people are either unaware or intimidated by the other functions available on excel. Whether you want to enhance your productivity at work, in business or use it as a tool to help you organise your personal finances Expert @ Excel: Pivot tables and VBA Programming is for you Topics Covered In This Book Include: Book 1) Pivot TablesThe history of the Pivot table and the mechanics of how it works.A step by step guide on when is best to use Pivot Tables and navigate you through an exampleThe first steps of feeding data into the pivot table and techniques on advanced visualisation.Book 2) VBA ProgrammingWhat you can use Visual Basic Application and will go into detail how VBA can help automate documents such as word processing.How to navigate your way around an IDE (Integrated Development Environment) and what each window represents.Clear steps on how to write a program and the 5 important questions you must think about before you start to write.And much more! Chapter One: Overview of PivotTables Introduction The History of Pivot Tables Mechanics of Pivot Tables Implementation of Pivot Tables The Pivot Table Layout Design Report filter Column labels Row labels Summation values Four Main Areas of a Pivot Table Values area Row area Column area Filter area Chapter Exercise Chapter Two: When to Use Pivot Tables Chapter Exercise Chapter Three: Working With Excel Pivot Tables Fields and Areas of Pivot Table Layou t . Discovering Data with the Pivot Table Summary of Value Keeping the Pivot Table Updated Reports Generated by Pivot Table s . How to Use the Pivot Table Function Chapter Exercise Chapter Four: Building Excel PivotTables The First Step towards Creating a Pivot Table Feeding Data into the Pivot Table Techniques for Advanced Visualization Settings for the Value Field Chapter Exercise Important Points to Note about Pivot Tables Chapter Five: The Various Function You Can Undertake Using The Pivot Tables Use the Pivot Table to Create a Dynamic Range of Data Counting Items Using the Pivot Table How to Show Totals Regarding the Percentage You can Use the Pivot Table to Create a List of Unique Values Self-Contained Pivot Table Grouping the Pivot Table Manually Cloning the Pivot Tables just in Case you Need Another View How do you Unclone a Pivot Table to Refresh Independently? How to Do Away with the Unwanted Headings Pivot Tables Allow you to Turn Off Auto Fit when Necessary Chapter Exercise Chapter Six: Benefits of Using Pivot Tables Pivot Tables are Incredibly Fast You Don’t Require Formulas in Pivot Tables Elimination of Mistakes Pivot Tables Make You Look Like an Expert Pivot Tables are Perfect Prototyping Tools Pivot Tables can Examine Any Type of Data Finally, You can Quickly Update Pivot Tables Chapter Exercise Chapter Seven: Types of PivotTables Time Tracking Pivot Table User Activity in a Web Portal Pivot Table Class List Pivot Table Instrument Measurement Pivot Table Email Sign Ups Pivot Tables Monthly Reports Chapter Exercise Chapter Eight: Advantages of Working with Pivot Tables Chapter Exercise Chapter Nine: Application Support of Pivot Table Database Support for Pivot Tables Conclusion