Learn || Apply || Share
Just adding a few numbers without any condition applied is a very rare scenario. Most of the time, we may face situations where we are required to filter the data out first and then sum them up…!!! Let us see how to use it in detail… 1. What is the SUMIFS Function? 2. What is … Continue reading What Is Excel SUMIFS Function – A Quick Guide
Suppose you want to add a few numbers based on certain criteria. How will you approach it? I will surely rush back to SUMIF function… 🙂 Let us see how to use it in detail… 1. What is the SUMIF Function? 2. What is the Syntax? 3. How to use it with an example? 1. … Continue reading What Is Excel SUMIF Function – A Complete Guide
It can be during complex financial calculations or simple daily math, we can’t escape the addition of numbers. SUM function of excel can help us with that!!! Let us see how to use it in detail… 1. What is the SUM Function? 2. What is the Syntax? 3. How to use it with an example? … Continue reading What Is Excel SUM Function – How To Use It?
One fine day, you have decided to invest in stocks and you want to try your hands in it. As it is the first time, you might just want to pick a few low-cost stocks and to start investing somehow!!! Let us see how Excel’s SMALL function can help you with that… 1. What is … Continue reading How To Use Excel SMALL Function – Explained
You might one day come across a situation where you might be required to find the 1st, 2nd and 3rd largest number from a given set of data. Wondering how to do it? No problem, we can use excel’s Large function!!! Let us see how to use it in detail… 1. What is a LARGE … Continue reading How To Use Excel LARGE Function – Explained
It can be during simple calculations or it can complex ones, you might want to round off a few numbers. Excel ROUND Function can help you with that. If it is that you only want to hide them from displaying, then be cautious of it…Go with formatting option instead of ROUND function. Let us see … Continue reading 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 the MAX Function? 2. What is the Syntax? 3. How to use it with an example? 1. What is the MAX Function? The … Continue reading How To Use Excel MAX Function – Quick Guide
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