Use of SUMIF function in Excel-
SUMIF helps to sum up values only once it matches certain criteria. It can be used to add numbers based on criteria’s like Text, Number and Dates, also can use with logical operators (=,<>,>,<
603 total views, no views today
Hi,
As an Excel user, sometimes we store or transfer an Excel file, which contains some confidential data. It becomes a basic need to protect it either in a way that the user either can only see the data (read-only)
267 total views, no views today
Hi,
Flash fill option has been introduced into the Ms-office 2013 version and would be available after 2013 version. It is very powerful and useful option developed by Microsoft community.
What flash fill can do?
Flash fill will extract the
303 total views, no views today
Hi,
In February, Microsoft office has introduced Office 365. In this version, Microsoft introduced Six new functions which are more useful in the calculation and can save your time.
In this article, you’ll learn how to use Excel’s new function
309 total views, no views today
Hi All,
Dashboard- Dashboard is one platform that helps management in tracking Performance, evaluation and help them to take a decision based on it. A dashboard is often called a report, however, not all reports are in the dashboard.
Now that
1,305 total views, no views today
Hi,
Conditional formatting is the best way to visualize data in a colourway. With conditional formatting, we can do things like highlights data into colours, apply bars, Icons, Flags and formulas.
As an Excel user, we usually highlight data into
300 total views, no views today
Hi All,
Hope you all are doing great!
As an Excel user, we maintain data in different files with different formats and at the end, we want to consolidate these files into excel.
First, we need to understand the problem
573 total views, no views today
Hi,
As an excel user, when we are maintaining data on different tables or on different sheets however we want to pull the information on a single sheet from the tables. If we do type manually or copy and paste
387 total views, no views today
As an excel user, you may have come across a problem where you have a big data in excel, in which few rows are hidden or the data is filtered and you wish to copy the visible or filtered data
390 total views, no views today
Sometimes the data is spread over multiple worksheets and the requirement is to consolidate them in to a single worksheet, usually either we copy and paste data individually for each sheet or consolidate option of Ms-Excel can be used but
405 total views, no views today