Microsoft-Excel

How to use VLookup Match function in Excel

VLookup Match one of the most powerful and important function in Excel. Sometime we need to use VLookup and Match function together to lookup specific value. If you need better control over during lookup and match the value then you must have to know how to use VLookup Match function in Excel. This dynamic function allows you to reduce the chances of error and improve the capability of VLookup function. Read More

How to use Double VLookup in Excel

If you have data in two different table or worksheet then you need to apply double VLookup in Excel. At this situation most the Excel user face lot of issue how to get the exact result which match the condition. This article helps you to know how to use Excel Double VLookup function in active worksheet. Read More

Excel VLookup Find First, 2nd Or Nth Match Value in Excel?

If you have more than one columns and want to use Excel VLookup to find first, 2nd or Nth match value in Excel. Normally it’s not easy to do this job but after reading this article you can easily find out first, 2nd or Nth match value in Excel sheet. All we know VLookup is a powerful lookup function which is located in lookup and reference category. Read More

How to use Excel SUMSQ Function to get Sum of the Squares

Excel SUMSQ function is another important function which is used to returns the sum of the squares of the given arguments. The Excel SUMSQ function is built-in very popular function. This function is also used as a worksheet function in active Excel sheet. In this article we have to explain how to effectively use SUMSQ function in Excel. Read More

How to use Excel Subtotal Function

Excel Subtotal function allows you to returns a subtotal in the list or database. Subtotal function in Excel return the Sum, Average, Count, Max, Min and many more. Excel Subtotal function is located in Math and Trig category. You can also use this function as a worksheet function in Excel. Read More

How to Show Percentage of Parent Total in an Excel PivotTable

Excel allows you to quickly show the percentage using parent total in an Excel PivotTable. Once you create the Excel PivotTable, you can easily discover which type of report management you need. PivotTable gives the ability to easily manipulate the well organised information. The Value Filed Settings allows you to quickly perform different kind of summarizations as per your need. Calculated Fields. Calculated fields allows you to build the formulas which is based on the PivotTable value. You can easily convert your data and show values in-terms of percentage of parent total in an Excel PivotTable. Read More

Excel FactDouble Function – Return Double Factorial of Number

Excel FactDouble function is used to returns the double factorial of given positive number. The FactDouble function in Excel is located in the Math & Trig category. The double factorial of any positive number is equal to 6*4*2…. number, while for any negative number is equal to 5*3*1.. If you need to quickly calculate double factorial of any large even or odd number then you can use Excel FactDouble function in active worksheet. In this article we have to describe the formula and how to use Excel FactDouble function. Read More

Excel Fact Function – Return Factorial of Number

Excel Fact function is used to returns the factorial of given positive number. The Fact function in Excel is located in the Math & Trig category. The factorial of a positive number is equal to 1*2*3*…. number. If you need to quickly calculate factorial of any large number then you can use Excel Fact function in active worksheet. In this article we have to describe the formula and how to use Excel Fact function. Read More

How to use Excel INT Function to Remove Decimal Places

Excel INT function which is used to rounds a number down to the nearest integer. The Excel INT function is located in the Math & Trig category in Excel. If you have a large list of numbers in which you have lot of decimal places then you have easily remove then with the help of INF function in Excel. Read More