Multilevel Drop Down Lists

1 Cascading drop downs are really useful when you have categories and sub-categories that you want to be able to specify within an Excel worksheet.  In the example shown in the video our first drop down allows us to specify a location – this could be an office location and the second drop down an employee.  If I select “London” in the first drop down I only want the London employees to appear in the second – I don’t want the...

EMPLOY AUTOFILL (OFFICE)

Click the Sales tab. In cell A1, type: Frog Sales Make this text Arial, 12 point, bold: In cell A3, type: January In cell B3, type: February In cell C3, type: March Highlight cells A3 through C3. Place the cursor on the Fill Handle. It should turn into a black cross: Drag the cursor to cell L3. Release the mouse button. The...

How To do Wudu

1.          First, make the Niyyah (intention) in your heart that this act of Wudu is for the purpose of preparing for Salah, and say: "Bismillah" (in the name of Allah). 2.          Wash both hands up to the wrists (starting with the right hand) three times, making sure that water has reached between the fingers. While...

General Shortcuts for any program

* Windows key + E = Explorer* Windows key + Break = System properties* Windows key + F = Search* Windows key + D = Hide/Display all windows* Windows key + R = Run command pop-ups* ALT + Tab = Switch between windows* ALT, Space, X = Maximize window* CTRL + Shift + Esc = Task Manager* CTRL + C = Copy* CTRL + X = Cut* CTRL + V = Paste* CTRL...

Energy consumption calculator

Now-a-days the amount of energy consumed and the cost per unit are becoming more than expected. In order to avoid use of more energy a efficient calculator was designed. Using this you can calculate the total power consumed and also your monthly bill.. Although it states the average assumption for all states more or less your bill bill be around the value it calculated. ...

BREAD UPMA

Bread Upma recipe Recipe Cuisine: Indian  |  Recipe Category:BreakfastPrep Time: 5 mins    |  Cook time: 15 mins    |  Serves: 2 Ingredients Bread slice 4  Onion 1  Tomato 1  Green Chilli 2  Sambar powder 3/4 tsp  Turmeric powder 1/8 tsp  Ginger garlic paste (optional) 1/2 tsp  Salt 3/4...

ALOO BHINDI FRY

Aloo Bhindi fry recipe Prep Time: 10 mins    |  Cook time: 10 mins    |  Serves: 3 Ingredients Potatoes1 Ladies finger20 Onion1 Red chilli powder3/4 tsp Amchoor powder1/4 tsp Jeera1 tsp Oil2 tblsp SaltAs needed Coriander leaves2 tblsp Method Clean and chop ladies finger into bite size pieces. In a microwavable bowl, add the ladies finger and toss it with 2 tsp of...