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 Formulas

How To Combine IF and OR Functions in Excel

    how to combine if and or functions featured image

    IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power. Combining IF and OR functions is one the most useful formula combination in excel. In this post, I’ll show you why we need to combine IF and OR functions. And, […]

    Check it out now

    How To Remove First Character From a Cell Using Quick Methods

      how to remove first character in excel cell using quick methods featured image

      Yesterday, one of my colleagues, who is really passionate to learn Excel these days asked me “do you know how to remove first character from a cell? I told him a small formula (which was easy) for that, but he was not satisfied & want another method. And after that, I told him about five […]

      Check it out now

      How To Use VLOOKUP Approximate Match Technique To Create Magic

        VLOOKUP-Approximate-Match-Technique-To-Create-Magic

        In this post, you will learn to create a VLOOKUP Approximate Match to get values from a range. The Idea is very simple to lookup for a value & get values which are approximately matched with lookup value. In this post, I will show how to perform this VLOOKUP Approximate Match so you will able to […]

        Check it out now

        How To Use Vlookup and Match as a Combination

          Using VLOOKUP With MATCH Will Make You A Dynamic Data Pro

          In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.

          Check it out now

          How To Create An In-Cell Gantt Chart With REPT Function

            In Cell CHart With REPT Functions In Cell Gantt Chart

            Creating In-Cell Charts with REPT Function is a smart move. You can use these charts in your dashboards to give a quick view to your user. I have used this text repeating formula to create an In-Cell Column Chart & a Star Rating Template. But, here I have created an In-Cell Gantt Chart for the sake of my laziness. Let me […]

            Check it out now

            How To Create A In Cell Column Chart With REPT Function

              In Cell Charting With REPT Function To Create a Column Chart

              Creating an In Cell Column Chart by using the REPT Function is the second part of our in cell charting Series. Yesterday, I had used this text repetition formula to create a star rating template in excel. Basic Idea of creating a column chart with REPT Function is as simple as we create a normal column chart in excel. I have used a percentage data set to create […]

              Check it out now

              Star Rating Template In Excel Using REPT Function [Quick Tip]

                Excel Star Rating Template In Excel Using REPT Function

                Here is a quick tip for you to create a star rating template in excel. To create this star rating template all you need, REPT Function. REPT Function is useful when you want to repeat a given text for a number of times. And, today we will use this formula to create this Star Rating […]

                Check it out now

                How To Calculate Age From Date of Birth In Excel

                  How To Calculate Age From Date Of Birth In Excel

                  In this post, you will learn about how to calculate age from date of birth in excel using a simple formula. We will use that formula to calculate age by using the date of birth. And, we will get the result in years, months and days. But before telling you how to calculate age from […]

                  Check it out now

                  How use DATEDIF Function in Excel

                    DatedIF function is the best tool to calculate your age from date of birth. Ahead In this post, I will show you how to use the DatedIF function in excel, why it is a useful & worth to learn. Use of DatedIF DATEDIF Function In Excel will be your buddy if you want to calculate the […]

                    Check it out now

                    How To Convert Incorrect Date Formats Into Correct Dates

                      We have already learned in Basic Date Functions that dates are the base of all the data & trend analysis. But, sometimes it is very nasty when we got some dates in a non-standard format. In these conditions, we have to correct date format by using some formulas and functions. Using formulas doesn’t mean that […]

                      Check it out now