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 Visualization

-
Data visualization tools have made the interpretation and study of large amounts of datasets extremely convenient and it has ended the worries of being able to manipulate and handle data. Earlier methods of analyzing data without the means of data and tools proved to be a very laborious and a mind-boggling job. Since the dawn of tools that were capable of handling data and showcase them using via visualizations, it has become a lot easier and convenient to handle data and gain insights through visually enticing graphics which help in decision making. Data visualization is an age-old human requirement of gaining insights into the hidden truth. The best example of this is when Galileo had access to a telescope, he looked at the sun for 40 days and every day he would draw a picture of what he saw on the surface of the sun. the post-analysis of these 40 pictures made clear a phenomenon called “the sunspots” which to date baffles many astronomers. Read more 
Read more