In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
In this video tutorial the instructor shows how to unzip files using the compressed folders. He starts by showing the examples of compressed folders and how to identify them by their unique zip icon. He shows how to right click on the folder and shows how to open the extract all wizard. There in the wizard he shows various options to set and finally unzips the folder. He shows the extracting process and also the final extracted files. This video tutorial shows how to extract folders form zipp...
Apply foundation in a shade close to your natural skin color or slightly darker. Make sure it is even and smooth. It is very important to remember when sculpting your face with makeup that highlight creates the illusion of an area coming out, while shadow causes it to recede. Both are necessary to create authentic looking wrinkles. Using a fine-tipped brush and dark brown cream makeup, carefully trace the natural lines on your face (around mouth, eyes and forehead) and neck. If you have no wr...
Is your waffle iron collecting dust? Plug it back in and use it like never before by whipping up a batch of brownies.
Looking for a hearty and healthy weekend breakfast idea? Look no further, we have a great egg recipe for you. This wonderful Indian recipe for masala egg paratha is perfect. Watch this how to video and learn how make this egg paratha for your breakfast.
Seasoned urad daal aka sukhi (dry) daal is a very unusual dal so think outside the box and give it a try. Just another fantastic and tasty way of getting your share of proteins. Watch this how-to video to get the recipe and instructions on how to make urad dal.
There a very few people who don’t like gulab jamun, as for us, we just love them. It is a perfect dessert for any occasion - wedding, birthday party, potluck or a romantic dinner for 2! Watch this how-to video to learn how to make gulab jamun, a delicious Indian dessert.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
How to Make a Firecracker Out of Things That Any One Can Get. First Gather Your Equiptment, You Will Need: Matches and a Match Box or Flash Powder, Hot Glue Gun, Sparklers, Paper, PVA Glue, Container, Masking Tape.
This instructional cosmetics video demonstrates how to create an Amy Winehouse inspired look. The Amy Winehouse look involves hick black eyeliner with red lips. Products used in this video are BYS Eyeliner Duo Thick and Thin - Black, Exhibit Liquid Eyeliner -- Black, BYS Shimmer Powder -- Black Beauty, BYS Waterproof Mascara - Black, BYS Long Life Lip Colour -- Hot Chilli, and BYS Blush and Bronze Compact -- High Shine.
Dan Vincent, a bartender in Laguna Beach, CA shows you how to make specialty martinis for you, your family and friends in this video cocktail-mixing tutorial. This martini is every bit as decadent as a real creme brulee dessert. To make a creme brulee martini, you will need vodka, kahlua, half and half, and a dusting of powdered cocoa.
There is nothing tastier than homemade Italian sausages. Watch this how to video and learn how to make homemade Italian sausages from scratch.
Spend some time in the kitchen with your kids and teach them how to cook. In this how to video two girls show kids how to make an Indian style curry chicken. This is a great recipe that only requires 5 ingredients.
This tutorial video will teach you to make a banana chiffon cake. The ingrediants of this cake are: 1-banana, 6-white eggs, 4-yolks, 175g-sugar, 70cc-salad oil, 25cc-water, a pinch of salt, 2 spoons-baking powder, 140g-flour, and vanilla oil.
This tutorial video will teach you how to make kimchi. For this Korean recipe, you will need cabbage, Korean radishes, salt, sugar, ginger, garlic, sweet rice flour, fish sauce, hot pepper powder, oysters, green onions, onions, and possibly rubber gloves.
This how-to video stamping tutorial demonstrates two methods of heat embossing using a heat gun or heating tool, stamping powder, a rubber stamp, Versamark watermark ink and a pigment ink. Heat embossing is a great technique to multi-task rubber stamps and create some texture in card-making or scrapbooking projects. Learn how to do two different methods of heat embossing with an embossing tool by watching this how-to video.
Tired of the same old deviled eggs? Then watch this how-to video and learn how to add a twist to the classic deviled egg recipe. Make deviled eggs with smoked salmon instead of the traditional ingredients. For this recipe you will need hard boiled eggs, smoked salmon, mayonnaise, olives, relish, horseradish powder, dill, hot sauce, and black pepper. Mix your ingredients and stuff the egg whites with the mixture.
This is a fabulous meat dish with an amazing aroma! Watch this video tutorial to learn how to make Indian lamb curry. You will need: boneless leg of lamb, onions, garam masala, ground cumin, tumeric, chili powder, salt and plain yogurt.
This tutorial makeup video will show you how you can apply an exotic and beautiful pink and gold Arabic makeup look.
Learn how to achieve Rihanna's look from the video "Take a Bow" with this makeup tutorial. This how to video uses the following products:
Some of us have spare eyebrows, and need to fill them in with makeup. This video makeup tutorial demonstrates how to fill in your eyebrows using an angled brush and brow powder.
Sometimes, smokey eyes just aren't appropriate to wear. This is a tutorial on how to create a natural glowing makeup look ideal for formal daytime events, such as weddings.
This yummy Japanese pound cake has a light consistency and a subtle green tea flavor. If you'd like a stronger tea taste, double the amount of powder required in this recipe.
Do you love Batman? Watch this video to learn how to paint a Batman mask on your face.
If you have ever wanted to learn how to cook Indian food, then this is the video for you. Watch as our host Manjula demonstrates how to prepare gulab jamun, a popular Indian dessert.
Watch as Manjula shows you how to prepare a delicious Indian dish. In this video she makes sooji halva, a cream of wheat dessert that is offered to gods and goddesses before prayers.
Here is a tutorial on how you can achieve narrower looking nose by using contouring and highlighting powders. You can achieve this by using the Sculpt & Shape duo, or matte eyshadows.
Watch this cooking tutorial to learn how to make chicken curry soup. Ingredients:
Make flour tortillas with 5 ingredients: 2 cups flour, 2 Tb baking powder, 1 1/2 tsp of salt, 1/3 cup shortening and hot water. Cook these up on a griddle and make some quesadillas.
This appetizing dish can be found in any Laotian restaurant and it's so good. You will need chicken wings, oyster sauce, garlic powder, sugar, salt, flour, cornstarch, and cooking oil. Watch this video cooking tutorial and learn how to make kai toss, Laotian chicken wings, from Thai chef Kai.
Tadka dal is a very healthy side dish that comes from India. Made with tovar dal, tomato, chillies, turmeric powder and jerra this lentil soup is served over rice and garnished with curry ander leaves for a wonderful presentation.
The Singapore Sling is a smooth, slow, sweet cocktail. Serve it at your next party or enjoy it as a nightcap. You will need gin, fresh lemon juice, simple syrup, powdered sugar, club soda, cherry brandy and a lemon wedge and cherry to garnish.
Customize your kitchen or bathroom with your favorite tile. Learn how to grout tile to get professional-looking results. You will need several large buckets, several sponges, several rags, clean water, grout in powder form, a grout float, a triangular trowel, and a dust mask.
While topping your cake or cupcake with icing is easiest done using storebought icing, we're sorry to inform you that most grocery store icing has high amounts of saturated fat and even trans fat, both of which clog your arteries and contribute to heart disease. Not so appetizing now, is it?
Cavities are an unfortunate sideeffect of our sugar-infused society, and getting them filled is time-consuming, expensive, and requires a trip to the dentist. Do you have some serious courage and want your dental work done on the cheap? Watch this video for an amazing guide to filling your own tooth cavity at home using simple and cheap ingredients. It's amazing what you can do with a little DIY know-how.
In this video, we learn how to make a double chocolate malt shop cupcakes. First, make the batter by mixing together malt powder with chocolate chips, sugar, and the rest of the ingredients. These flavors work well together and will make a classic cupcake! Cook these in the oven until the cupcakes are fully cooked all the way through. When these have cooled, test each of the cupcakes to make sure they are baked through. Next, you will mix together your cherry butter cream frosting and place i...
In this tutorial, we learn how to make a funnel cake. To start, you will make the mix by combining 3 c flour with 2 tsp baking powder, 1/2 tsp salt, 1/4 c sugar, 2 c milk, and 3 eggs. Then, you will need to heat up some canola oil to 350 degrees in a large pan. After this, drizzle the dough into the pan and cook on both sides until it's golden brown. This will go very quick. When finished cooking, let the oil drain on a paper towel. Then, serve this with your favorite toppings and eat!
We can't guarantee you'll look exactly like Penelope Cruz after completing this makeup look, but we can guarantee you'll learn her makeup tricks and secrets.
Looking into farming your own beehives to make honey but aren't sure how to recover the honey from the beehives? No worries, check out this video. In it you will learn how to extract the beehives, remove the wax caps, and use a honey extractor to retrieve the honey.
Pectin, which comes from the cell walls of plants, is used as a primary gelling agent in many james and preserves. Most jam makers go to grocery stores to purchase pectin in powder form, but it's much healthier to make it yourself. Check out this video to learn how to produce pectin from underripe green apples.
