The requirement of counting is almost always present in our day to day job and Excel made it really easy for us by giving a number of counting functions like Count, CountA, CountBlank, CountIf and CountIfs. Let’s understand them in detail one by one: 1. COUNT FUNCTION- COUNT function count only …
Power Query is an amazing tool to import data from almost any popular or semi-popular data source in Excel. One can import any database, which can be in any format like .txt, CSV, JSON, Access etc. or from any database form like Azure, SQL, ODBC, DBMS, Oracle, IBM etc. One can also import any website’s …
Pareto charts are extremely useful for analyzing what problem needs attention first, the taller bars on the chart, which represent frequency and the line shows the cumulative frequency percentage. The Pareto principle (also known as the 80/20 rule), states that, for many events, roughly 80% of the effects come from 20% of the causes. Let’s …
How to use Sparkline in Excel? Charts are the Graphical visualization in excel which help us to understand the weekly, monthly performance and consolidated report of entire data, However if we have a data in to tabular form and we need to visualize our data next to each row and if we apply charts it …
Hi All, Do you know apart from only copy and pasting the whole content with formatting in Excel, we can paste a certain attribute such as Value only, Column Width, Formula only, formatting or comment in Excel. Paste specials give you an opportunity to choose what we want to paste in cells. When standard copy/paste …
Custom Number Formatting- Sometimes when you download or import any data into Excel, its formatting looks weird. Dates get converted to numbers or Numbers are showing in scientific characters (2.34568E+12), Decimal points, Currency symbols, convert number into percentage, friction, Text format etc. For these unexpected formats we have a listed options available in under “Number …
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 (=,<>,>,< ) and wildcards (*asterisk, ? Question mark). As you noticed in the screenshot above, …
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) or can modify it also. Microsoft Excel gives us few protection features, which are strong …
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 information from any congested data in a simple way.in the further example, you will see …
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 to create more efficient expressions. Six new formulas are listed below- 1- TextJoin 2- IFS 3- MaxIFs 4- MinIfs …
Microsoft Updates six new Excel functions in Office 365 Read More »