### Excel Productivity Guide

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

## How To Combine IF and OR Functions in Excel

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

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

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

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

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

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]

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

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