Most often you might have come across documents which contain watermarks similar to Draft, Sample, Confidential and few brand logos etc. They are the ways to let people know the document status and few times just to put up your brand all over. Let’s look at how to do it for our documents too. You … Continue reading How To Insert A Watermark In Excel – A Complete Guide
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
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)
Have you ever been too lazy to work on something and though of a genie , a magic that can help you work. May be in real life we might not find one, but excel has got you a feature called â€œQuick access toolbar Great isn’t!!! Lets explore it >> Right Click the Quick access … Continue reading Time saving friend Excel Quick Access Toolbar
Though we have been using excel for quite a long time, we still might not be aware of a few basic elements that we ignore or just don’t explore. Let’s dig deeper into the details: ***Explained***Â Title Bar: Displays the current workbook name along with few controls to modify the window. Menu Bar: It contains … Continue reading Excel main window dissected
It’s been almost a decade since I’m using this tool which is inevitable in many of our lives, people call it “Excel” and if used to its full potential, it can really save a lot of time and make us much more productive. A wide range of activities from simple tasks like handling cash flow, … Continue reading What’s the need for excel?