Having given a set of data which include different data types, If I ask you to find the total count of numbers in it. How will you do that? For sure I will pick COUNT function…!!! Let us see how to use it in detail… 1. What is COUNT Function? 2. What is the Syntax? … Continue reading How To Use Excel COUNT Function – A Quick Guide
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
There might be situations where you need to keep a note of the number of pages. Inserting page numbers in worksheets can help you with that. Let’s see, how to do that quickly… Various possible operations are 1. Insert page numbers on a single worksheet 2. Insert page numbers in multiple worksheets 3. How to … Continue reading How To Insert Page Number In Excel – A Quick Guide
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
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
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?