Pivot Tables for everyone: Useful guide for creating Pivot Tables

Length: 99 pages
Edition: 1
Language: English
Publisher: ResearchFreelance
Publication Date: 2022-01-09
ISBN-10: B09Q2LHSBZ
Sales Rank: #0 (See Top 100 Books)

This work stems from the need to develop some Excel sheets to reach the required results.

For example, in the workplace it often happens to have data that without a precise sorting or a filter or processing based on a certain field may seem unusable.

Here are some features of the programs that process spreadsheets such as Excel from Office or Calc from OpenOffice or Calc from LibreOffice, as well as others, can be useful for achieving the result we want to obtain.

In this volume we will explain in a simple and effective way the usefulness of some important functions of the processing of spreadsheets and pivot tables that are essential for any work that focuses on data analysis.

Today it is no longer possible to ignore the use of Excel or other software for processing spreadsheets for both business and leisure purposes. In this work we will dedicate ourselves to the processing of quantitative data for work purposes, taking into consideration various examples that will explain how to solve the problems proposed through subsequent steps that will lead to the solution of the same.

Pivot Tables for everyone
Summary
Introduction
What are Pivot Tables
What Pivot Tables can be used for
Set the data for creating the Tables
Useful Excel functions for setting data
Filters and sorts
Examples of work problems solved with functions and tables
Example No. 1 TOTAL COST FOR TWO-MONTH OCCASIONAL EMPLOYEES
Example No. 2 HOURLY AND TOTAL COST FOR OCCASIONAL EMPLOYEES
Example N. 3 SUMMARY SALARY TABLES BY COMPANY FRAMEWORK
Example No. 4 SUMMARY TABLE OF EMPLOYEE ACCESSORY CHARGES
Example N. 5 SUMMARY TABLE OF AGENT SALES
Relationships, data model and Power Pivot
Relations and data model
Power Pivot
Conclusions