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.

Worth $20, Absolutely Free

Category Archives for Formulas

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 […]

➲ Continue Reading

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 […]

➲ Continue Reading

How to Create a Star Rating Template in Excel

Here is a quick tip for you to create a star rating template in Excel.To create this star rating template all you need is REPT function. REPT Function is useful when you want to repeat a given text for a number of times.Steps to Create a Star Rating TemplateInsert two different types of stars (☆★) […]

➲ Continue Reading

DATEDIF Function

Try to type “DATEDIF” in a cell in your worksheet, you won’t find anything listed with this name.Even if you check help system, there is nothing listed with this name.But, if you step back to the help system of the Excel 2000, you will find DATEDIF Function documented there.Well, it’s a mystery that why Microsoft […]

➲ Continue Reading

Convert Text To Date

Dates play an important role when we need to analyze trends. And, this is one of the most important things which we need to capture in a right way.In Excel, the right format to insert a date is mm/dd/yyyy. That’s the basic date format which is used by Excel to store dates. Apart for this, […]

➲ Continue Reading