Tag Archives for " Basic Excel Tips for Beginners "

How to Convert a Formula to Value in Excel

How to Convert a Formula to Value in ExcelFrom 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 replace a formula with its result value.Just think this way, when you send a report to […]

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]

How to Insert a Timestamp in Excel [Formula + VBA + Shortcut]By Puneet Gogia 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 […]

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

1 2 3 4