Pivot tables are one of Excel’s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Creating Pivot Table in Advance Excel

1. Select any cell in the source data table.

2. On the Ribbon, click the Insert tab.

3.In the Tables group, click Recommended PivotTables.

4. In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. Click on a layout, to see a larger view.

5. Click on the layout that you want to use, then click OK.

#advanceexceltutorial #pivottableinexcel #pivottableoption

BPA Educators has been established with a vision to aid students and professionals in achieving their goals. We at BPA Educators understand the aspirations of young students and professionals. Our sole aim is to reduce the hassle that one can encounter while choosing the right career option. We have striven hard for the past 10 years and trained over 1000+ students till date. Our team of counselors is qualified and experienced, consisting of CA’s, CMA’s, CS, LLB, and MBA’s who have exposure to practical training with hands-on experience in the industry, having experience of 10 to 15 years and growing strong with a commitment to transform the career of students with better opportunities amongst various age groups. Linked videos: Cost Center in Tally | Use of Cost Center in Tally- BPA Educators – https://www.youtube.com/watch?v=cFUbqlM0aEo Popular videos: How to use pivot table in excel – https://www.youtube.com/watch?v=zuPy6… Data validation in excel – https://www.youtube.com/watch?v=xDVHt… KEY FEATURES Live projects A Certificate of Professional Training after the completion of course. OJT Certificate. OJT(On the Job Training). Expert advice Call: +91-8512851249 Address: C-8/13, Sector-7, Rohini, Delhi-110085 Email: info@bpaeducators.com Website: www.bpaeducators.com Instagram: https://instagram.com/bpaeducator?igshid=b1rskij5lfc8 Facebook: https://www.facebook.com/bpaeducator Twitter: https://twitter.com/bpa_educators LinkedIn: https://www.linkedin.com/in/bpa-educators-627052190/