Advanced Pivot Table Techniques (to achieve more in Excel)

18,60,446 views 8 Apr 2021 Excel Pivot Tables
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... In this video you'll learn the Top 10 Advanced Pivot Table Tips, Tricks & techniques for Microsoft Excel. PivotTables are one of Excel's most important tools. They help you to automatically summarize and aggregate data. This way you don't have to write a single formula. The Pivot table does the aggregations for you. ⬇️ Grab your Pivot table sample file here: https://pages.xelplus.com/pivot-table... What You'll Learn: ▪️ Field List Customization: Learn how to adjust field list settings for better organization and efficiency. ▪️ One-Click Multiple Reports: Generate multiple pivot reports for different data categories with just a single click. ▪️ Drill-Down Feature: Uncover the hidden details behind any number in your pivot table with a simple double-click. ▪️ Data Bars Integration: Enhance your pivot tables visually by adding dynamic data bars. ▪️ Calculated Fields: Create and manipulate custom fields in your pivot tables to analyze data more effectively. ▪️ Column Differences Calculation: Easily calculate and compare differences between columns in your pivot tables. ▪️ Smart Custom Number Formatting: Apply custom formatting to display data more intuitively. ▪️ Custom Groupings Creation: Organize your data into meaningful groups based on your criteria. ▪️ Date Grouping Customization: Tailor how your dates are grouped in pivot tables to match your analysis needs. ▪️ Timeline Addition: Add interactive timelines to your pivot tables for easier date filtering. I'll show you some Excel tricks that you can use in Pivot tables, such as using conditional formatting in a pivot table. How to drill-down and view details of a value; How to generate multiple pivot table reports with one click; how to use custom number formatting to get emojis and icons in your pivot table and how to add a timeline to your report. Aside from using pivot tables to analyze your data, you can use pivot tables to create interactive dashboards. 00:00 Advanced Pivot Table Tips And Tricks You Need To Know 00:30 Create a Pivot table 00:54 Adjust Pivot table Field List Settings 01:25 Create Multiple Pivot Reports With 1 Click 02:37 Drill Down in Pivot tables For Details 03:06 Add Data Bars to Pivot Tables 04:29 Create Calculated Fields 05:36 Calculate the Difference Between Columns 07:00 Smart Custom Number Formatting 08:15 Create Your Own Custom Groupings 09:23 How to Group Date Fields 10:17 Add A Timeline to Your Pivot Table 11:12 Wrap Up Learn how to format your source data and create your first Pivot Table in this video: ► Pivot Tables for Beginners:    • Excel Pivot Table EXPLAINED in 10 Min...   ________________ ➡️ Join this channel to get access to perks:    / @leilagharani   🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Comments

Post a Comment

Popular posts from this blog

*Who is Modi?* commented by *New York Times Editor-in-Chief Joseph Hope

Image
Prime Minister of India Narendra Modi " The rise of this man is a threat to the world, as he has not only made enemies of each other's interests in India but also used them.  It only shows the desire to make India a great country.  His sole aim is to make India supreme.  If this person is not blocked, then one day in future India will become a powerful nation around the world and it will surprise the United States. He goes through a specific strategy and no one knows what he wants to do.  A dangerous patriot is hidden behind his smiling face.  He uses all the countries of the world for the benefit of India.    By destroying the US relationship with Pakistan and Afghanistan, and forming alliances with enemies like Vietnam, Modi will see the use of the three countries against China.    Vietnam began producing oil in China's southern seaboard, where it supplies all its oil to India, and the Indian company forced Reliance to wor...
Read more

Central Government Schemes

Image
Central Government Schemes PM-KISAN Scheme (Pradhan Mantri Kisan Samman Nidhi)   Main purpose: This scheme promises to pay all poor farmers (small and marginal farmers having lands up to 2 hectares) Rs. 6,000 each year in 3 installments through Direct Bank Transfer. It would reportedly benefit around 14.5 crore farmers in India. Pradhan Mantri Kisan Pension Yojana: Main purpose: To address the problems of farm sector distress, the Modi 2.0 Cabinet has approved a proposal to provide small and marginal farmers with a minimum Rs 3,000 per month fixed pension, costing Rs 10,774.5 crore per annum to the exchequer. The eligible farmers around the 18-40 years age bracket can participate during this voluntary and contributory pension scheme. Once the beneficiary of the pension dies, the spouse will be entitled to receive 50% of the original beneficiary's pension amount. Mega Pension Scheme:  Main purpose: A Mega Pension Scheme has been approved for the traders, sho...
Read more