How To Use Excel ROUND Function – Quick Guide

Given a set of data which includes the cricket team scores, you might want to find the highest among them. Let us see how to use it in detail.. 1. What is MAX Function? 2. What is the Syntax? 3. How to use it with an example? 1. What is MAX Function? The MAX function … Continue reading How To Use Excel ROUND Function – Quick Guide

How To Use Excel COUNTIF Function – Quick Guide

Just in case if we want to find the count of specific items COUNTIF function of excel can come in handy. Let us see how to use it in detail… 1. What is COUNTIF Function? 2. What is the Syntax? 3. How to use it with an example? 1. What is COUNTIF Function? The COUNTIF function can … Continue reading How To Use Excel COUNTIF Function – Quick Guide

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)

Time saving friend Excel Quick Access Toolbar

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

Excel main window dissected

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

What’s the need for excel?

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?