Tips-Trick

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

Avoid Common mistakes on WhatsApp

WhatsApp is too much popular free to use application which is used to send instant messages on smartphones. But most of the person have to avoid given common mistakes on WhatsApp. WhatsApp is an important part of our life. Lot of person share his important and personal things with his friends, family members and others on WhatsApp. This is not correct thing you must have to take few precautions during working on WhatsApp. 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 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