How-to-guide

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 On-Screen Keyboard in Windows Operating System

Windows Operating systems allows you to use On-Screen Keyboard on your system. On-Screen Keyboard is an application which provides a visual keyboard at your display screen. You can use On-Screen Keyboard in place of a physical keyboard. Windows allows you to manipulated the On-Screen Keyboard with the mouse or any other pointing device as per your need. Read More

Top 5 Secret WhatsApp tricks you should know

WhatsApp is the most popular instant messaging platform at this time. There are lot of secret WhatsApp tricks which are useful for us. Most of the WhatsApp users don’t know about this given secret WhatsApp tricks. WhatsApp is an important part of our life and it take place of old messaging apps. Recently WhatsApp add few latest features for his users. So, in this article we have to discuss about top 5 secret WhatsApp tricks you should know. 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