Tag: DATA VALIDATION

Lesson#106: How to lookup picture in excel

Okay friends here I will show you an interesting tricks about Excel. That is how to lookup picture in excel. We have  learned looking up values from a table but looking up picture from table is little different. Here in

Tagged with: , , ,

Short Tips#0042: Avoid data input error by Data Validation

Tagged with:

Lesson#96: How to HLOOKUP chart from a drop down menu in Excel

So here is another important lesson for you. How to HLOOKUP chart from a drop down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how to

Tagged with: ,

Lesson#95: How to VLOOKUP chart from a drop down menu in Excel

So that’s an important lesson for you my dear. How to VLOOKUP chart from a drop down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how

Tagged with: ,

Short Tips#0007: Make drop down list in Excel sheet

Tagged with:

Lesson#88: How to make a Payslip format from Employee database

So my friend, I will here discuss an important lesson which are really required for office people. That is how to make a salary slip from an employee database. This is not about salary slip only, we can make many

Tagged with: ,

Lesson#83: How to add drop down in excel sheet

I always hear a common question from beginner Excel users that “How to make a drop down menu in Excel?”. I would like to ask them have you used the feature Data Validation? Select all the cells on which you

Tagged with:

Lesson#52: Let’s check your lifeline with Excel

Just a different exercise of excel. I have downloaded a list country wise average life expectancy by WHO. Lets check where are we in our lifeline by this sheet. Lets take an input of date of birth from user. I

Tagged with: , , , , , , , , , ,

Lesson#48: Graphical 20X20 multiplication table

In this post I will make a graphical 20X20 multiplication table and showing the process of making.   Merged and centered these cells for showing data bar like I have shown in the picture below. Selected two random numbers between

Tagged with: , ,

Lesson#43: Make a ON/OFF switch for Conditional Formatting in your excel sheet

Showing a random example worksheet where I have used conditional formatting and color formatting. Now I will make a switch which will trigger the Conditional Formatting ON or OFF. Beside the table I have made a drop down list of 

Tagged with: ,
Top