Tag Archives for " Basic Excel Tips for Beginners "

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

Best 8 Tips to Filter Data in Excel

Using a filter in Excel is not a #rocketscience. Everyone knows that they can do a lot of things with filter option.But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it.And, the good news is you can be one of […]

How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]

A few years back when I was working for a tech company I was one of those people who were Excel help point for all.And, that’s the real reason I’m fascinated to learn more.One day the lady who was working as a reception coordinator came to me and asked:Puneet, I’m managing a list of tasks […]

Excel’s AUTO FORMAT Option

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone.But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

Excel Fill Justify to Merge Text from Multiple Cells to One Cell

Fill justify is a life saver option.The single core motive to use fill justify in excel is to merge the data from multiple cells into a single cell.And, if you  have any other idea to merge text into one cell, leave it. Fill justify is a better option.So today, in this post, you will learn […]