Excel Productivity Guide

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

All posts by Puneet

Excel 3D Reference – A Thing You Should Consider

    how to use 3D range in excel

    Using 3D Reference can save your a lot of time and help you to avoid writing lengthy formulas. It’s is like three-dimensional chart or image which has more than one phase. A normal range is all about a group of cells from a single worksheet. For Example, in =SUM(Sheet1!A1:A10), “A1:A10” is a group of cells which is referred from Sheet1. But, a 3D reference […]

    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 a Milestone Chart in Excel

            how to create a milestone chart in excel

            Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy. And, a milestone chart is a perfect way to track a project in a simple way. The basic idea in milestone chart is to track each step of your project on a […]

            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

              How To Highlight Duplicate Values Using VBA

                highlight duplicate values using vba

                While working with huge data, Duplicate Values are always a concern. And, I am sure most of the time you remove them with remove duplicate option. But, removing duplicate values or just counting duplicate values never sort out the problem. The important thing is to review all the duplicate values before deletion. So, today I will […]

                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

                  How To Add Leading Zeros In Excel

                    how to add leading zeros in excel featured image

                    You can’t add a zero before a number in excel. Whenever you try to add a leading zero, it disappears. Not matter what, how many zeros you trying to add, it will disappear. Let me tell you what’s the reason for this. In below example, I am trying to start a number with 0 but I […]

                    Check it out now

                    8 Examples for Using Formulas in Conditional Formatting

                      how to use formulas in conditional formatting featured image

                      The best part of conditional formatting is you can use formulas in it. It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE. If that formula returns TRUE, conditional formatting will apply. And, if it returns FALSE, conditional formatting will not […]

                      Check it out now