Excel Interview Question - Cognizant

-
In this video tutorial, I have shared one of my friend's recent Interview experience with one of the Top MNC (Cognizant - Gurgaon). He was asked some of the tricky questions and he got stuck with few of them. I decided to make a series of some Hot Interview Questions and this is the first video in this series. In this tutorial, I have used VLOOKUP with MATCH and INDEX with MATCH functions to build a customize formula to "Perform Two 2 Way Lookup". The video teaches Beginning to Advanced Level of knowledge of both formulas.

Watch Here!

Comments

Post a Comment

Popular posts from this blog

Data Analytics Vs Data Science

-
With data becoming the New Money, mastering the trade of Data Science or Data Analytics has become of prime importance. Though Data science may be the tree, understanding & mastering Data analytics is a feat in its own genre. With “the coolest job of the century” title, becoming a Data Analyst helps you to open multitudes of prospects which helps you in shaping your future in Data analytics. Read More...
Read more

Loan Amortization Schedule Template in Microsoft Excel

-
An  Loan Amortization Schedule  which is also known as mortgage or loan schedule, is a list of payments that shows each loan repayment and a breakdown of the principle amount and the interest. It shows the breakdown so that you can see how much is going toward the principle and interest each month.  Apart from this, the schedule also shows the remaining balance after each payment has been made. In other words, it calculates your monthly loan repayment and lets you know how much of your monthly installment will go towards the principle and how much will be paid for interest. Read More....
Read more