How to Convert a Formula to Value in Excel
From the starting days of my job, I have learned one thing hard way: Before sending a report (In Excel) to someone… …we must convert a formula to value.It simply means to
Puneet
How to Hide Formula in Excel
It happens sometimes you send Excel files to others… …and they made some changes into formulas. Or, sometimes you simply don’t want to show a formula to others.Hiding a formula is a
How to Insert/Type DEGREE Symbol in Excel
You need to learn how to insert and use a degree symbol in a cell.That’s right.Let me tell you why I’m saying this.Yesterday I was working on some temperature data.For
How to Search on Google using a VBA Code
There are a lot of important things which we all do other than using Excel. Am I right? One of those things is using Google to search for something.In my list of
How to COUNT Words in Excel
There is one option which I always wish Excel should have.?And that’s count number of words from a cell.If you work in MS Word… …there is an inbuilt option on the
How to Group Dates in a Pivot Table
By grouping dates in a pivot table you can create instant reports. ?Here’s the point:Let’s say……you want to group all the dates as months……instead of adding a different column in