pivot table excel

Hello friends, today we are going to learn how to use pivot table excel. Here I am providing you some basic step for beginners who don't know how to use a pivot table so, let's go friends to learn ......
PIVOT TABLE IS AN VERY IMPORTANT TOOL WHICH IS BUILT AND PROVIDING BY MY EXCEL.

pivot table
pivot table excel
pivot table excel



First of all, I make this table as an example for the Pivot table


  • I HAVE TO MAKE THE TABLE OF THE COMPANY PRODUCTS SALE  IN THE YEAR 2018 AND 2019 BY COMPANY WORKERS... RAM, SHYAM ETC.


pivot table excel
pivot table excel


pivot table excel
pivot table excel



pivot table excel
pivot table excel



pivot table excel
pivot table excel


pivot table excel
pivot table excel



BASIC STEPS... OF PIVOT TABLE



  • NOW GO TO INSERT TAB 
  • GO TO TABLES GROUPS
  • THERE YOU FIND PIVOT TABLE
  • CLICK DOWN ARROW 
  • CLICK PIVOT TABLE 
  •  THEN A DIALOG BOX WILL APPEAR ON THE SCREEN
  • THERE YOU THE RANGE OPTION 
  • SELECT THE RANGE OF YOUR TABLE WHICH YOU WANT TO CONVERT INTO PIVOT TABLE
  • NOW, SEE BELOW THE DIALOG BOX YOU SEE TWO OPTIONS = EXISTING SHEET AND NEW SHEET OPTION.
  • IT TOTALLY DEPEND UPON YOU WHICH OPTION YOU WANT TO SELECT 
  • I THIS WAY I TO HAVE GO WITH NEW SHEET OPTION 
  • THEN CLICK ON IT AND YOU SEE THE FUNCTION MODULE OF PIVOT TABLE



HOW TO WORK IN PIVOT TABLE AND USE THE PIVOT TABLE TO SHOW INFORMATION ABOUT THE COMPANY SALE DEPARTMENT.


pivot table excel
pivot table excel


  • IF YOU WANT TO KNOW THE TOTAL SALE OF EACH DEPARTMENT THEN SELECT THE BOX OF THE LEFT SIDE = DEPARTMENT, SALE 2018, SALE 2019.


pivot table excel
pivot table excel


  • IF YOU WANT  TO KNOW HOW MUCH WORKER WORKS IN EACH DEPARTMENT BY NAME OR NO. THEN SELECT THE BOX= DEPARTMENT, NAME OF PERSON.


pivot table excel
pivot table excel


  • IF YOU WANT TO KNOW HOW MUCH SALE DONE BY IN the YEAR 2018 THEN YOU CAN CLICK = DEPARTMENT, NAME OF PERSON, SALE 2018.


pivot table excel
pivot table excel


  • IF YOU WANT TO KNOW THE SALE OF the YEAR 2019  THEN SELECT THE BOX = SALE 2019 TOO.


pivot table excel
pivot table excel



THESE ARE BASIC STEPS BY APPLY AND PRACTICE THESE STEPS YOU CAN EASILY LEARN AND MANAGE BIG COMPANY DATE IN HUGE AMOUNT WITH SUCCESSIVE MANNER.


  IF YOU FACE ANY TYPE OF PROBLEM THEN YOU CAN COMMENT BELOW I WILL DEFINITELY FIX IT...





 PLEASE FRIENDS DON'T BE CHEAP TO SHARE THIS TYPE OF INFORMATION WITHIN YOUR FRIENDS... TO USE PIVOT TABLE EXCEL


Popular posts from this blog

[2024]BESt LATEST COLOR PREDICTION GAME FORMULA TRICK

Image
hello readers, in this post we will know how to make money online through latest color prediction game formula trick, we provide all the color prediction combinations of red, violet and green color trend, this color prediction game formula is very well applicable to all color prediction GAMES website or application platform you just have to logically and statistically choose the color according to  our table color graph. what is color prediction game? color prediction game is a color betting game which you can earn real money, there are three different colors RED, GREEN and VIOLET, RED color consist of even numbers (0,2,4,6 & 8) GREEN are odd numbers of 1,3,5,7& 9. Note: numbers 0 & 5 is considered as VIOLET. There are 480 periods to bet, 24/7, each period gives you 2minutes and half to bet any color or number, and the results will display in full 3 minutes. Experts are predicting 4 times every day, but their prediction is not 100% correct. To win through the latest color
Read more

The most expensive Android phone, what makes Google's Pixel 3XL special

Image
The most expensive Android phone, what makes Google's Pixel 3XL special Specifications - 6.3-inch QHAD Plus display, Corning Gorilla Glass 5 Protection, Android 9.0, Snapdragon 845 processor, 4GB RAM, 64 or 128 GB storage, 12.2 MP dual pixel rear camera and 8-8 megapixel selfie camera, 3430mAh battery The phone does not become fast due to excessive GB, the picture quality is not the best after being megapixel and the battery does not run much if it is more mAh ... These are some simple wicks which are lost in the specifications of the specs And people started to evaluate the numbers according to the count of these numbers instead of the Experience. We used to understand this difference while using Pixel 3XL continuously. There are many USP pixels, its camera, its speed, battery management, software power The most expensive Android phone, what makes Google's Pixel 3XL special (Camera) The camera of this phone makes you amazed, whether it is in the day or in a le
Read more

which protocol replaced tkip for wpa2?

Image
Wireless communication has become an integral part of our daily lives. From smartphones to laptops, our devices are constantly connected to Wi-Fi networks.which protocol replaced tkip for wpa2? To safeguard the confidentiality and integrity of data transmitted over these networks, robust security protocols are essential. In the realm of Wi-Fi security, CCMP (Counter Mode with Cipher Block Chaining Message Authentication Code Protocol) has emerged as a formidable successor to TKIP (Temporal Key Integrity Protocol) in the WPA2 standard. In this article, we'll explore the significance of CCMP and its role in fortifying Wi-Fi security. Which protocol replaced TKIP for WPA2 quizlet? The Importance of Wi-Fi Security Wi-Fi networks are vulnerable to a variety of threats, including eavesdropping, data tampering, and unauthorized access. Protecting sensitive information, such as personal data, financial transactions, and confidential business communications, is imperative. WPA2 was designed
Read more