What Is Excel SUMIFS Function – A Quick Guide

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

How To Use Excel SMALL Function – Explained

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

How To Use Excel LARGE 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

How To Use Excel ROUND Function – Quick Guide

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