Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Category Archives for Formulas

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