Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
In this free balloon art tutorial, learn how to twist and tie a balloon flower perfect to present to a crowd during the spring! To make this balloon creation, you will be using the complex and adaptable "April Flower Technique".
In order to make Pork Noodle Soup, you will need the following ingredients: noodles (any variety), sliced pork, vegetables (cabbage, bok choy, etc.), sesame seed oil, shallots, ginger, white pepper, green onions, salt, and chili sauce.
In order to make your own Yummy Cottage Cheese, you will need the following: milk, water, rennet, sea salt, 1/3 of a cup of cream, and cheesecloth.
Lila from Asian Cooking Made Easy shares her recipe for Singapore Noodles, which she makes with shrimp, chicken, rice noodles and a semi-sweet curry sauce.
In order to prepare Stir Fry Beef with Orange, you will need the following: 12 oz. of lean beef, 2 tsp of dark soy sauce, 2 tsp of rice wine, 1 tsp fresh ginger (finely chopped), 1 tsp of corn flour, dried red chilies, fresh orange peel, sugar, salt, peppercorns, and 1 tsp of sesame oil
Ching-He Huang shows us how to make a Five Spice Chicken Stir-Fry. Start with chicken breast, oyster sauce, corn flour, carrot, ground white pepper and salt.
This video describes how to prepare the tapioca sago. First take 2 cups of tapioca and wash, drain and soak in ¬O cup of water. Soak it for two hours minimum. Then the tapioca will become softer and become larger in size. Next take a pan and take 2 table spoons of oil and one table spoon of oil in that heat it for a while. Next ¬O teaspoons of cumin seeds then add green chilies and then add 2 table spoons of peanuts. Once the peanuts are fried, add the slices of potato. Next add the ¬º spoons...
In order to prepare Rhea‚Äôs Cherry Pie, you will need the following ingredients: 1 ¬O cups of flour, 1 tsp of salt, ¬O vegetable shortening (chilled), water, 3 tsp of sugar, pitted cherries, 1 T. butter, and ¬O cup of half and half.
Jad Cooper shows us how to make perfect couscous. First, soak the chickpeas, then peel and cut some turnips, a cauliflower or cabbage, some zucchini, sweet potato, green peppers, onions and tomatoes. Wash some cilantro and tie it up with string so it doesn’t fall apart during the cooking. Put the onions, tomatoes and cilantro into a large pot for the base of the stock.
Ryan Archer shows viewers how to make a slow cooker pot roast in your crock pot! First, chop up your onions, two tomatoes, three sticks of celery, 2 cloves of garlic and potato wedges. Put all of your vegetables in your crock pot first. Also, put in four whole carrots. Turn a skillet on high. Next, put all-spice on your roast, black pepper, sea salt and paprika. Rub these spices into the roast and repeat this process on the other side of the meat. Now, sear your meat on both sides for about o...
Stuffed squash is a delicious and healthy alternative to many fattier stuffed dishes. In this two part tutorial, learn to make Moroccan style squash with cous cous and plenty of veggies.
In this tutorial, Sandra Lee shows us how to make a family favorite rump roast with a new twist. Sandra adds a tangy Madeira wine sauce to her roast and creates an unexpected dinner. Try this twist next time you make a roast and you will surely impress even the pickiest eater.
This video describes how easy to make a pure vegetarian Indian food called Mooli. For this, take 2 bunches of red radish cleaned and washed. The other ingredients are 2 garlic pieces, about 5 green chillies, 2 big tomatoes, 1/4 teaspoon of turmeric powder, and 1 teaspoon of salt. Then put the pressure cooker on the stove with a little bit of water in it and put the steamer in the pressure cooker. Put the radish, tomatoes, green chillies to the steamer and then cook them for 8 minutes. Remembe...
Sfehmi teaches you how to make chicken kofta curry, an Indian dish. You need two pounds of skinless boneless chicken breast, one onion, half a cup of cilantro, one third cup of roasted chick peas, one third cup of almonds, one teaspoon of chili peppers, one teaspoon of poppy seeds, one teaspoon of salt and one half teaspoon of freshly grated nutmeg. Almonds and chickpeas should be blended with the onion and the chicken, plus salantra. Mix them up and add the spices. Make meatballs and leave t...
Learn how to make an egg omelette following a few simple steps. The ingredients you will need is two eggs, salt, black pepper, cheese, oil, and slices of tomatoes and olives to use as a garnish. -Break the eggs into a bowl. -Beat the eggs really well. -Add one tbsp of water. Beat. -Add 1/2 tsp of salt. -A couple grinds of black pepper. -Use any kind of cheese you would like, grate. -Turn the stove on high heat and place pan over it, coat it with olive oil. -Once pan is ready, turn heat down t...
Sfehmi teaches us how to make a vegetarian puff pastry. It's an appetizer. You get to large potatoes, you skin and steam them. You will need a small amount of mustard seeds and 3 curry leaves. Also you should have turmeric, crushed chili peppers and salt. The puff pastry itself was covered with a damp cloth until it was ready to be used. Crush the potatoes and add the turmeric, chili peppers and salt, one tablespoon of each. Take a frying pan, turn on the heat and gently brush it with olive o...
This is a video demonstration of an easy way to make dahi vada. She uses urad powder, adds cumin seed, baking powder, crushed chili pepper, salt, and garlic. She then shows how to make chutney. She uses tamarind paste and palm sugar. She goes back and mixes the dry ingredients to make a batter, and cooks spoonfuls of it in hot oil. In another pan, she melts the palm sugar on low heat. When it's melted, she adds tamarind paste and water, and lets it boil for five minutes, adds chili powder, an...
The lady in the video teaches how to make Fish kebabs. White firm fish, such as cod fillets are used to make the kebabs. One teaspoon of mint garlic, one whole jalapeno pepper, three cloves, two cut up small potatoes, salt, chopped cilantro, and a blend of Indian tart spices. The fish is cooked in a pressure cooker, and the potatoes are added. The green peppers are added, and the garlic is also added. The three cloves also go in, with half a cup of water. A level teaspoon of salt is added. Th...
Anuja and Hetal teaches to make an Indian chaat: Ragda patties (pattice). First add the soaked vatana with 6 cups of water and salt in a pressure cooker till a whistle blows and let it till the pressure goes down. Now add mustard seeds in a pan with some oil in it and heat till the seeds pop. Add cumin seeds and when it turns into golden color add peanuts, sesame seeds and let it to pop. Add turmeric powder, curry leaves, ginger, garlic, green chilies and onion. Mix it till the onions become ...
Anuja and Hetal from Show Me the Curry! teaches how to make a vegetarian Indian dum aloo. 2 lbs. Baby Potatoes, boiled and peeled, 2 Tbsp Oil, 1 inch piece Cinnamon Stick, 1 Bay Leaf, 6 Whole Cloves, 1/4 tsp. Asafoetida, 2 tsp. Ginger, minced, Salt, Red Chili Powder, 1 tsp. Roasted Aniseed Powder (Star Anise), 2 tsp. Roasted Coriander Powder, 1 tbsp. Paprika, 1 Cup Yogurt, 1 Cup Water, Cilantro and Ginger (Julienned, cut into matchsticks); for garnishing. Preheat oven to 400 degrees Fahrenhei...
This how-to video is about how to color correct photos using Photoshop levels.
Take 2 cups of baisan in a large bowl. Add salt, 1 teaspoon of chili powder, chopped coriander, 2 chopped green chilies, 1 teaspoon baking soda and one chopped onion.
Are you ready to learn a scrumptious new recipe to add to your repertoire? Impress your friends by making the perfect vanilla panna cotta with the executive pastry chef, Heather Bertinetti at Marea, a New York Times 3-starred restaurant. Check out the recipe below, from the Dairy Show!
Professional Raw Food Chef, Elaina Love, shows us how to prepare this raw vegan sour cream using coconut flesh. It sounds tasty already!
If you're wondering what FoWsc stands for in Guild Wars and what it's all about, here's your lesson. Dooom Box teaches us everything we need to know when it comes to Fissure of Wo Speed Clear: The basics, the parts, the teams, and more.
Wondering how you can finally use that Paragon? Dooom Box shows how to finally start using the Paragon using the Imbagon build in Guild Wars in what he calls the "Imbaguide".
In this video, Dooom Box shows us how to farm raptors quickly an easily using a warrior necro. Clear the raptor cave in under a minute in hard mode using a WARRIOR! Farm.
Curious about the Norn Fighting Tournament? In this video, Dooom Box gives some great tips on the Norn Fighting Tournament in Guild Wars, and some great insight on how to beat Magni The Bison.
Chef John from FoodWishes prepares a grilled halibut steak with corn and chanterelle mushrooms. You can find chanterelle mushrooms in most upscale markets. Before cutting into chanterelle mushroom make sure you remove as much dirt as possible by using a brush or the edge of a fork. Next, cut chanterelle mushrooms into thick meaty slices.
This video tutorial shows you how to cook braised beef shanks. Ingredients:
Mr. Paul Righetti teaches us a Santa Maria BBQ tritip lesson. The beauty of Santa Maria Style barbecue is that it delivers big flavors while being relatively easy to prepare. You can even take some flavorful shortcuts with Santa Maria Style Barbecue products by Susie Q,s Brand and Cowboy Flavor, among others. So fire up the grill and let'€™s get started!
Seared scallops with orange and jalapeno are a quick and easy appetizer to try. The ingredients in this dressing will surprise and impress your guests. It may be just the right holiday recipe.
When it comes to Photoshop, if you can imagine it then you can make it. Of course, more complex objects (and more realistic objects) take longer to complete, but the results are totally worth it. Just check out this lifelike coin, for instance. This Photoshop tutorial will teach you how to produce realistic coins via applying textures to a 3D cylindrical object.
Watch this science video tutorial from Nurd Rage on how to make silver chloride for a photochemistry test. They show the chemistry of photography using silver chloride that they make themselves from table salt and silver nitrate.
Check out this Make Magazine segment on building mini robots. Then you can move onto huge ones like Big Dog!
One of the best extensions for Apple's Final Cut Studio is the visual effects and digital compositing application Shake. Shake is an image compositing package used for post-production, and it enables complex image processing sequences to be designed through the connection of effects "nodes" in a graphical workflow interface.
Tune into this hot dog how-to video and watch host Scott Herbert get frank about his passion for Chicago-style hot dogs. Also, learn the secret to a frosty root beer float that's especially sweet when made with Whole Foods Market's 365 Everyday Value root beer crafted with cane sugar, not high fructose corn syrup.
This tutorial video will teach you to make Temaki sushi, also known as Japanese hand rolled sushi. Ingredients for Temaki Sushi
