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!
Author(s): Daniel Reed
Series: 2 Books in 1
Year: 2018
Language: English
Pages: 142
Tags: Excel Pivot Tables and VBA Programming
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
