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 the above picture you can see that I am having a picture table between range…

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 HLOOKUP the chart from there. First you have to make a drop down menu from…

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 to VLOOKUP the chart from there. First you have to make a drop down menu…

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 similar type of formats using this method. I am having a employee database in excel…

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 want to create a drop down then go to DATA>Data Validation. Select the option List below…

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 have made different boxes for Year, Month and Day. From that it will make the…

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 0 to 20 and multiplied both of them.   Selected both input cells, right clicked…

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  ON/OFF with Data Validation. Now I selected the area and clicked on Conditional Formatting>New Rule>Use a…

Copyright 2017-2018@Excelabcd