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

45 Quick Time Saving Excel Keyboard Shortcuts You Must Know

-
There are hundred of Excel keyboard shortcuts which are important and can save lots of time however, few of them are very important. Also, knowing all the shortcuts are never easy but few important ones can easily be memorized. Whether it is jumping from one cell to another, expending selections, accessing ribbon commands or printing spreadsheet, almost everything in Excel can be controlled with the keyboards. In this article, I am going to talk about some  45   Quick Time Saving Excel Keyboard Shortcuts  that can increase your productivity by 30% to 40%. Read more.....
Read more