How to count number of cells with nonzero values in Excel?
For counting total number of cells with nonzero values in Excel, here we will show you two methods. Please browse for more details. Count number of cells with nonzero values…
Excel
Using VLOOKUP in an Excel Formula
Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer? Excel can do these…
Excel 2013: How to Create a PivotTable from Multiple Sheets
Once you become a PivotTable fan, you will start to see lots of uses for this powerful analysis tool. But what can you do when the data you want to…
Combining Multiple Worksheets in Any Version of Excel
xfgiro/istock From time to time you may have a need to stack data from two or more worksheets into a single list. Most users would copy and paste the data…
How to calculate average (mean) in Excel
The tutorial shows how to calculate mean in Excel for different data types by using AVERAGE or AVERAGEA formulas. You will also learn how to use the AVERAGEIF and AVERAGEIFS…
The Complete Guide to Power Query
What is power query? Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape…
Add a query to an Excel worksheet (Power Query)
Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016. Note: For…
Dynamic Excel Filter Search Box – Extract Data as you Type
There is a dual functionality to this – you can select a country’s name from the drop-down list, or you can manually enter the data in the search box, and…
XLOOKUP function
SyntaxThe XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the…
IF function – nested formulas and avoiding pitfalls
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and…