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 How To

Excel’s AUTO FORMAT Option

    how to use excel auto format option for quick formatting

    Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

    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 Calculate Weighted Average With Sumproduct

        how to calculate weighted average with sumproduct

        The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

        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 Sales Chart Template In Excel

            how create a sales funnel template in excel

            In this real world, everything has a process. From Marketing to Production, Sales To Purchase everything has a stage. To make the process successful we need to track each and every stage. And, to track a sales process, sales funnel chart is one the best tool you can use. Just think this way. You are a […]

            Check it out now

            How To Use Condition in SUMPRODUCT

              how to use conditional sumproduct in excel

              SUMPRODUCT is one of the powerful excel functions. And, today, I will show you one of its amazing powers. You will learn how can you write a conditional sumproduct function. Well, as you know you can use sumproduct to multiply and sum specified ranges or arrays. But, while using a conditional sumproduct you can you can […]

              Check it out now

              How To Create Barcode Generator Template In Excel

                how to create a barcode template in excel featured image

                Do you want to create a barcode in excel? So today, just for you, I will reveal the method to create barcode generator template in excel. In this post, I will show you how to generate code 39 barcodes. Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan […]

                Check it out now

                Add a Horizontal Line in a Chart

                  featured image to add horizontal line in excel chart

                  You can add a horizontal line in an Excel chart to use as a target line. All you need, 30 seconds to add a horizontal line to an excel chart. And, without much efforts. You know what, my company’s CEO told me these things a year back. It is better to have a comparison to […]

                  Check it out now

                  Automatically Add Serial Numbers In Excel

                    how to automatically add serial numbers in excel featured image

                    Serial numbers are an important part of data. Even every small data table in excel should have serial numbers. But, adding them manually is a pain. So, today I’ll show you 6 quick methods to automatically add serial numbers in excel. You can use any of these methods which you think is perfect for you. Table […]

                    Check it out now

                    How To Multiply In Excel Using Paste Special

                      how to multiply using paste special in excel featured image

                      Sometimes, you have to perform some quick calculations in excel. And, you can use paste special for these quick calculations instead of formulas. In this post, you will learn a quick tip for these calculations. I will show you how can you use paste special to quickly multiply in excel. Not only multiple but subtract, divided, and […]

                      Check it out now
                      1 2 3 5