Feed on
Posts
Comments

Category Archive for 'Random Tutorials'

How to create Drop Down Box in MS Excel Cells using Data Validation

Posted in Random Tutorials on May 27th, 2009

The idea behind this tutorial is to learn how to use the Data Validation function of Microsoft Excel to insert a Drop Down Combo Box with Options to select from so that users have the option only to select out of those pre-defined options while filling inputs to an excel cell.
I have taken some screenshots [...]

Read Full Post »

Tutorial: How to use Excel vlookup with Examples and Samples

Posted in Random Tutorials on Apr 12th, 2009

I have been working on excel for the last 6 month for my official data analysis and I have come across many new things which make things much simpler. Of course, these things are not new to many people but for newbies like me, it’s exciting to find many such useful functions integrated in the [...]

Read Full Post »