Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

Category Archives for Pivot Tables

How To Group Dates in a Pivot Table in Excel

    group dates with in pivot table in excel

    When it comes to summarizing data, pivot table is everyone’s first choice. It doesn’t matter how big your data is, it has no problem to handle it. You can instantly create insightful and ready to present reports with a pivot table. And the best is, it is dynamic, flexible and powerful. Grouping dates is one […]

    Check it out now

    How To Add Ranks in a Pivot Table in Excel

      how to add ranks in a pivot table in excel featured image

      By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc. One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each […]

      Check it out now

      How To Automatically Update a Pivot Table Range

        how to update pivot table range automatically

        If you use pivot tables in your work frequently, I am sure you face the problem to update it’s source data range manually. Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh your pivot table. Now, just imagine if you add […]

        Check it out now

        How to Create a Pivot Table from Multiple Worksheets

          create pivot from multiple worksheets featured image

          This post is brought to you by Chandeep from Goodly. He is a consultant and trainer. He helps people on Business Intelligence Dashboards, Business Plans, Financial Models and PowerPoint Presentations. Make sure to download his special resources from here. And, today he is going to solve a save a problem for you. I am sure you all have faced […]

          Check it out now

          How To Create An Excel Pivot Chart In Excel

            excel pivot chart for dynamic chart for date analysis

            Do you remember when last time you used an Excel Pivot Chart? And, do you know pivot chart is a easiest way to create dynamic charts in excel? The bad news is, most of the Excel users avoid using pivot chart in their work. But the good news is, creating a pivot chart is simple, just like a creating a […]

            Check it out now

            How To Add a Running Total in a Pivot Table

              In this tutorial, I will show you how to add a running total in a pivot table. You will also learn about different situations in which you can use it.

              Check it out now

              How To Use Conditional Formatting In Pivot Table [Examples]

                Apply Conditional Formatting in Pivot Table By Using Slicer

                You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. Ahead of this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table.

                Check it out now

                How To Use Pivot Table Timeline To Filter Dates [Quick Tip]

                  Learn About Pivot Table Timeline

                  Using Pivot Table Timeline is not only save your ton of hard work but it will also a good habit of using it in our dashboards. Please follow me & learn how this Pivot Table Timeline will change your life. So here is the complete detail about Pivot Table Timeline.

                  Check it out now

                  How To Refresh All Pivot Tables At Once Using Different Methods

                    Refresh All Pivot Tables At Once

                    I hope you are doing well with your Pivot Tables. In this tutorial, I’ll show you some quick methods to refresh all pivot table at once in your worksheet.

                    Check it out now

                    A Single Slicer To Filter Multiple Pivot Tables

                      how to connect slingle slicer with multiple pivot tables in excel

                      Sometimes using more than one pivot table is a mess. But, it’s not a mess if you connect all the pivot tables with a single slicer. So, do you know how to link a slicer with multiple pivot tables? If you don’t know then follow this post. And, you will learn a superb trick to […]

                      Check it out now