New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special values.
Learn from Betty Crocker Kitchens, how to easily and quickly make a dinosaur birthday cake. You do not need a special cake pan for this recipe. She uses two 9" round cakes, to cut all the shapes you need to make the dinosaur. It is only required to cut out 3 shapes, and you can print the templates from their website. After the shapes are cut, you use the frosting to "glue" the cake to the platter you are working on and then spread a thin layer of the frosting all over the cake to seal in the ...
In this video, we learn easy cake decorating tips and ideas. To make a pastry cone, you just need parchment paper! First grab a square of parchment paper then fold into a large triangle. Now, open the square up and cut where the line is in the middle. Grab one of the triangles you just cut and wrap it into a cone shape, taping the tip so it will keep shape. You can now add icing and will be able to pipe and write words with ease. Cut a small hole depending on what type of piping you want to d...
In this video from RadioLynxContent we learn how to make a cucumber mojito, which is a local special in Whistler, Canada. For this you use fresh mint and a couple of slices of cucumber. Place in a glass and press down on the mint leaves and cucumber while they're in the glass. Next add 2 shots of Bacardi White. Then next add simple syrup which is half sugar, half water. Add 1 oz of that. Then add a bit of fresh lime juice and pomegranate juice. Top it with ice and give it a good strong shake....
In this fascinating "how to" video, you will see how a simple process creates the illusion of ice that is burning. Only a few items are needed to enact this scientific experiment. As the narrator describes, "Calcium carbide reacts with water to form acetylene gas." To illustrate, the video shows a bowl of ice cubes, to which the special ingredient is added. As the ice melts into water, it reacts with the calcium carbide, forming the high flammable acetylene gas, which is often used in welding...
In this video tutorial, viewers learn how to change a car's headlight and taillights. There are 3 types of headlights for a car. The 3 types are: sealed beam, halogen bulb and HID lights. This video shows viewers how to change halogen bulbs. Begin by opening the hood of the car. Remove the fastener or wire harness and then remove the bulb. Now replace it with a new bulb and put the wire harness or fastener back on. This video will benefit those viewers who have a vehicle and would like to lea...
Curtis Smith, an extension horticulturist talks about using cages for your tomato plants. He says that some people like to stake tomatoes, some like to cage them and some even just let their tomato plants sprawl. He talks to a local gardener who has built his own tomato cages out of concrete wire. The gardener shows his cages, which he built 10 years ago and they still look sturdy today. Curtis gives a few tips like wrapping the cages with a special fabric that lets air and light through, but...
In this video, you will learn how to draw the Lewis Dot structure for CH3CH2OH, or drinking alcohol. To draw the first type of alcohol, draw H, C, C, O, and H horizontally. Now draw, an H above and below both C. Draw the dot structures in between each letter. Hydrogen has one valance electrons, Carbon has four, and Oxygen has six. Now, connect the Lewis Dot Structures. If you are given C2H6O, write down C, O, and C horizontally. Draw a line between the O and the C's. The Carbons will have thr...
When entertaining, it's great to have fun, colorful ideas to make drinks feel special. By adding a simple slice of fruit or vegetable to a glass of water can impress your friends and make you feel like you're at the spa. It is very important to drink water, and flavoring it with lemon makes it easier if you're not a water drinker. The host cuts slices of lemon and lays them on top of the water or the side of the glass to garnish, and squeezes the rest of the juice into the water. It can be ma...
This video demonstrates how to do a wet foot test and how to choose running shoes with the results of a wet foot test. The wet foot test is simple. Get your foot wet and place it on a piece of heavy duty paper which will create a foot print. The foot print shows what type of arch you have. There are three types of arches: high, medium and low. High arches require a lot of cushion for running. Medium arches require a reasonable amount of cushion for running. Individuals with low arches or flat...
Modern Warfare 2 Look Ma Two Hands Trophy Guide Video. The Akimbo weapons in two hands and the trophy associates the guide during rushing in bomb squad and the gun has 10 rounds after that press and hold a control key for a new automatic weapon. The Akimbo hand guns really prevent and protect to move forward and the options will automatically ask for the good pistols and weapons. Machine guns and sound are added to the special effects for this trophy warfare game. Finally this game must provi...
Skip Steele and Terry Black of the award winning Super Smokers BBQ Team share their method for making championship barbecue ribs.
Properly measure liquid and dry ingredients Diane Morgan describes the basic technique for measuring ingredients, which is critical to baking. There are two types of measuring cups, one for liquids and a different type for dry ingredients that need to be leveled off, such as flour or sugar.
Make the perfect cake for any little boy or girl with Sesame Street character cake toppers! In this two-part video tutorial, learn how to make a baby-version of the Cookie Monster out of fondant icing and gumpaste. To make Elmo, carry out the same technique & instructions but with red icing. Give that little special someone in your life a cake they will cherish!
Learn how to use the navigation system in a new 2010 Toyota Prius in simple steps. It has DVD based navigation system with easy to use touch screen display. All the navigation routes of USA, Hawaii and parts of Canada are available in it supporting English, French and Spanish languages. When you start the car it opens the map and you can input the destination using voice command or entering text. You can also input your home address and five other special location address.
There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...
This three and a half minute video talks through the basics of hand massage. With close-ups of the action, the instructor talks through the basic technique and progression for hand massage, providing details and emphasis. All the various strokes are covered: stretching strokes, circular compression, squeezing and kneading. There's no lotion or special materials you need - just your hands, and the hands of a lucky subject. If you want to learn a new way to please your friends or partner, take ...
The Video On Demand highlights how amazing backgrounds are inserted behind characters and will show you how to composite video so your characters can seamlessly move in front of these images. Computer generated video objects may be superimposed over a background video image so as to create the illusion of a single composite scene. The leading edge of an object is detected and for a period of time the object and background video signals are mixed. After that period, only the object video is tr...
Rick Vanman reveals the secrets to professional video effects using your own computer software. Position your model houses into a setup of your liking. Take a picture of the houses with a digital camera using the macro setting. Edit your picture in Photoshop. Disguise any unwanted objects with the cloning tool. Separate the foreground and the background of the picture into 2 different layers. Film yourself in front of a green screen. Key out the green with your video editing software. Using y...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
Being able to create documents that stand out and impress is the theme of this how-to video on creating 3D text. Using an open Photoshop window, the pleasant sounding narrator guides you through the process of turning regular text into 3D. The narrator also supplies helpful tips to further enhance 3D text by adding color, glow and special effects like reflection. If you're a visual learner, you will appreciate this straight forward, clear and detailed how to video on creating 3D text.
Would you like to craft perfect 3D origami works of art? In this helpful tutorial, Jewellia7777 demonstrates how to use recycled paper to create your own elegant "green" works of art in no time. Learn to easily construct a stunning table centerpiece of paper that would let you contribute your own artistic touch to any special event, formal or informal. This great video will have you stunning your guests in no time with the impossibly beautiful flair of this fun project.
Your wedding day is vastly important and every bride would like the wedding pictures to reflect how beautiful they felt that day. In this tutorial presented by Smashbox Cosmetics, learn how to get the perfect camera-ready makeup look, perfect for your special occasion.
Steal this look: The metallic smoky eye! With the help of Smashbox Cosmetics, this video goes through the step-by-step process of taking this look into your own home and making it your own. Using Smoke Box from Smash Box, a metallic smoky is born that will leave you look sultry and sexy for your next special event.
What's a proton pack without a ghost trap? Useless, that's what. Don't pay megabucks for some fake Ghostbusters costume when you can build your own with household materials.
Home security is as important as having a job. You have to protect your family and your valuables. If you can't afford a high tech security system, then maybe a fake security camera will do the trick. This security camera dud is also a cheap alternative for a film prop. Watch this video tutorial to learn how to build a fake cardboard security camera.
If you have questions, Redbook Magazine has answers. "Love your life." Redbook is for the woman juggling family, career, and her own own needs.
Street Fighter IV : Blanka, the Brazilian Beast unleashes havoc upon the World Warriors once again. Street Fighter IV is a 2008 fighting game produced by Capcom. Street Fighter IV is currently released for PlayStation 3 and Xbox 360, with a Microsoft Windows version in the works as well.
Street Fighter IV : Vega, the beautiful Spaniard delivers gruesome damage. Street Fighter IV is a 2008 fighting game produced by Capcom. Street Fighter IV is currently released for PlayStation 3 and Xbox 360, with a Microsoft Windows version in the works as well.
This instructional video, produced by Jewish Pathways, demonstrates how to perform Havdallah after Shabbat ends. Hadvallah is a Jewish religious ceremony that marks the symbolic end of Shabbat and holidays, ushering in the new week.
This instructional video, produced by Jewish Pathways, demonstrates how to put on a tallit for Jewish prayers. The tallit (or tallis or tallith) is shawl used for Jewish prayer, worn while reciting morning blessings and well as in the synagogue on Sabbath and holidays.
This instructional video, produced by Jewish Pathways, demonstrates how to light the Shabbat candles. The lighting of Shabbat candles not only ushers in the Holy Day, but is also a special time of spiritual contemplation for Judaists. It is the pivotal moment when we cross over from the weekday into the holiness of Shabbat (or Shabbos, the Jewish Sabbath).
This homemade cake mix can turn your least kitchen-savvy friend into a star baker. And you’ve done 90 percent of the work, which is the greatest gift of all.
They don't call them salad days for nothing; you probably can't afford to eat anything else. But there are ways to trim your food budget—and they're even good for you. Learn how to eat cheaply on a budget.
Have you ever wondered what your DNA looks like? You have probably heard that DNA is a double helix, which is a pair of parallel helices intertwined about a common axis, but how do we know that? How can people look at DNA?
Craving some delicious Indian desserts? Then you've come to the right place, follow along with this cooking how to video as Manjula takes you into her kitchen to show you how to make gujia. Gujia is an Indian stule puff pastry filled with an aromatic nut mixture. Gudjia are traditionally made for special holiday, try making some today.
Make your own backyard biodiesel with the help of Kipkay. It's easy to make a small batch that will work in any diesel engine. You won't need any special equipment--an old juice bottle will serve as the "reactor" vessel--and on such a small scale, you can quickly refine your technique and perform further experiments. Thanks go to Rob Elam for the original article in Make Volume 3To download Making Biodiesel MP4 click here or subscribe in iTunes. Check out the complete Making Biodiesel article...
If you're looking for some natural dog food recipes or homemade dog food, this recipe from the Natural Pet Food Cookbook is a great start. Chef Jason Hill of Chef Tips puts Bandit's Beef Stew to the test, and this dog food recipe was approved with enthusiasm by his family's Shih Tzu puppy, Sugar. This recipe can be prepared as an organic dog food with the right ingredients. Just choose canned organic vegetables when preparing this meal. It's also a human grade dog food, as Chef Jason Hill att...
In this video tutorial, Chris Pels will show how to extend a standard ASP.NET server control and customize it for a specific purpose. Specialized controls provide an convenient way to implement standardized user interface elements for multiple web sites for individuals or teams of developers. In this example, see how to extend the DropDownList control to create a special purpose year selection control. Learn how to add properties for custom attributes that control the behavior of the range of...
Get the shoulders of a boxer without ever entering the ring. This exercise builds your shoulders with a series of classic boxing moves, with weights in each hand to up the ante. Learn how to do dumbbell punches (the four types are: side-to-side, cross up, cross down, and hooks). Presented by Real Jock Gay Fitness Health & Life.
