Create pivot table in excel (in a jiffy) | Pivot table excel [2020]. This tool will help in summarizing & presenting data according to the specific requirement. Pivot table seems like a complicated tool but once understood it is very easy to use and very useful in analyzing complex data sets. In this video, 3 examples are considered for creating Pivot tables for Data Range & Data Table. This lecture will be beneficial for both beginners and professionals who use Excel. It is part of the excel course having series of lectures on various concepts of Excel. This tool is available in all the versions of Excel.
In this video, following items are covered:
Creating Pivot tables for a Data Range
Creating Pivot tables for a Data Table
Difference between the two methods and which one is better
Visit & Subscribe channel: / @techreflections
In coming videos, advanced features of Pivot Tables will be explored.
Welcome to Tech Reflections (#techreflections) & I am Vikram. You can checkout more videos on this channel by clicking on below Playlists:
Checkout Other Playlists on this channel:
Excel formula and functions:
• Excel - Formulae & Functions
Conditional Formatting:
• Excel - Conditional Formatting
Pivot Tables:
• Pivot Tables & its features
#techreflections #pivottables #howtocreatepivottable