How To Add Leading Zero In Excel

Most frustrating thing in excel is saving Account numbers, Phone numbers and ZIP codes, we end up losing the leading zeroes. Today Let us see how to avoid it What is leading zero? Where excel leading zeroes are used? How to use it with an example What is leading zero? A leading zero is any … Continue reading How To Add Leading Zero In Excel

How To Use Excel FRACTION

Let’s talk about “Fraction” in Excel What is a fraction? Where excel fraction is used? How to use it with an example Where excel fraction is used? It is a part of the whole number and is├é┬árepresented as numerator and denominator i.e.a/b Where excel fraction is used? In everyday life, it can be used in … Continue reading How To Use Excel FRACTION

How To Use AUTOCORRECT In Excel

How awesome will it be, if you get someone who understands you best? Excel has a command called “AutoCorrect” It can be your best partner, you just type two words and it will just display your choice. Helpful in both shorthand data entry and misspelled words… Excel has a few in-built terms which are wrongly … Continue reading How To Use AUTOCORRECT In Excel

How To Use UNDO And REDO In Excel

Have you ever encountered a situation where you have drafted everything and lately realized that the earlier version was far more better than the current one or you have mistakenly filled few cells with incorrect information. Don’t you worry as Excel has got you two helpful controls “Undo and Redo” Anytime you go wrong or … Continue reading How To Use UNDO And REDO In Excel

Bored of entering repeated data into Excel-Use Fill Handle( Auto Fill Option)

Few days back, a colleague of mine have been asked to document a template to keep a record of all the monthly activities Something similar to this I remembered myself , when I have watched him doing a similar mundane work that I did a few years back Its like entering each date and corresponding … Continue reading Bored of entering repeated data into Excel-Use Fill Handle( Auto Fill Option)