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
Puneet
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…If you work in MS Word… …there is
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
How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]
This blog post covers the topic for inserting a timestamp in a cell in Excel using different ways, written by Puneet.A few years back when I was working for a