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

All posts by Puneet

How to Get Day Name from a Date in Excel

Let’s say you have a date from that date you want to get the day name i.e. Sat, Sunday. This can be done with a formula, in fact, there is more than one formula can be used.Get Day Name With TEXT FunctionYou can use TEXT function for extracting day name from a date. Let’s say you […]

➲ Continue Reading

How to Average TOP 5 Values in Excel

Let say you have a line-up of 20 products in your company.Now you have data for monthly sales of all the 20 products and from that data, you want to calculate the average of top 5 products.In short, you want to get the average of top 5 values from that data.Formula: Average TOP 5 ValuesTo […]

➲ Continue Reading

How to Get Total Days in Month in Excel

Sometimes you need to calculate the total number of days in a month to use in the further calculation.It happens specifically when you work on templates and dashboards. So today, let me show a simple formula which can do this for you.To calculate the number of days in a given month from a date, we […]

➲ Continue Reading

6 Methods to Convert a Formula to Value in Excel

From the starting days of my job, I have learned one thing hard way that before sending a report to someone we must convert a formula to value.It simply means to replace a formula with its result.Just think this way, when you send a report to someone, they are not concerned with formulas but result.Why […]

➲ Continue Reading

How to Hide Formula in Excel

It happens sometimes you send Excel files to others and they made some changes into formulasOr, sometimes you simply don’t want to show a formula to others.Hiding a formula is a simple way to do this so that others can’t able to see which formula you have used and how they get calculated.Now the question […]

➲ Continue Reading