How To: Create a dynamic data validation list in Excel
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.
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.
Have you ever wanted to knit with double pointed needles? Don't be intimidated by them anymore! Follow along in this great how to video, and you'll be on your way in no time! Learn how to knit with double pointed needles: We are starting with forty stitches. Be sure that stitches are divided as evenly as possible. Transfer ten stitches onto to another needle. (Slide the stitches down the needle so they don't fall off). Using another needle, slide another ten stitches to it. Repeat this until ...
Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!
In this video the author shows how to make a never ending foam snake. He starts by speaking about how hydrogen peroxide can be fun. He starts with the requirements first which are a dish soap, a bottle of hydrogen peroxide, some dry yeast, and a red fruit color. Now he fills up a cup with hydrogen peroxide, adds the color and two table spoons of dish soap. Now he shows how to use yeast which is used to remove the oxygen from the hydrogen peroxide. And finally he demonstrates the never ending ...
An expert on card tricks demonstrates this trick. Fan out the cards on the table and ask a spectator to pick a card, and then put that card in the center. He explains that he forced that card by demonstrating to the spectator that he should pull a card out, and actually taking a different card than the one the spectator chooses. He puts the spectator's card second from the top and holds his hand in such a way that he makes it look like he's taking the second card. This video should be watched...
Here is a quick and easy way to fold a T-shirt in less than 5 seconds, all in one quick motion. Laying your shirt down on a table or flat surface, simply pinch your shirt with your left hand about halfway down the line of one of your sleeves. Crossing over with your other hand, grab the shirt by the collar and pick up the shirt. After laying down the shirt, you should have a perfectly folded shirt in one quick motion. This technique should be very useful if you ever want to fold your laundry ...
This how-to video is about how to make Filipino style stir fried beef. Ingredients required:
Are you a pool shark? Then you have to watch this amazing video. You will learn how to do an advanced and difficult shot. Start by making sure you hit the ball exactly in the center. Aiming your shot is probably the most difficult part of this shot and you will learn tips and techniques to accomplish this. Establish a goo, stable bridge hand, then shorten your regular stroking technique. Actually, you will need to shorten everything you do. Last, you will see a perfect shoot over the ball tha...
In this video tutorial the author shows how to convert between customary units. He gives a chart which contain various convention tables showing the equivalents of various measurement units. He says a general rule that when converting a smaller unit to large unit we divide the numbers and when converting a larger unit to smaller unit we multiply the numbers. He takes a few examples and shows how to convert between various units like feet, yards, inches etc. This video shows how to convert bet...
This video shows the viewer how to create a stylish centerpiece for a wedding reception using commonly available items. This is done by first placing a square mirror on top of a larger piece of light pink tulle. Then an artificial plant was selected and a number of glass beads were secured around the piece using another piece of tulle and a ribbon; this is to stop the plant floating. The plant is then placed in a tall square vase that is filled with water. A single drop of food dye is then ad...
Have some dirty silver laying around the house? Not sure how to get that sterling silver sparkling like it's brand new? Use this easy method to clean tarnished silver.
The video shows you how to do the 3-6-3 cup stack. Beginning with a stack of six cups, create a pyramid using the cups. To begin, have two cups in the right hand and three in the left, and one in the center on the table. Stack one cup from each hand on each side of the center cup and then stack one cup from each hand in between each cup so that they are on the second level of the pyramid. Stack the last remaining cup in hand on the top level of the pyramid. To take down the stack, simultaneou...
To prepare the tuna, start by cutting the jugular to bleed the tuna out. Cut right at the top of the gill plate and cut up toward the eyes. Do this on both sides of the tuna. Then, cut a circle around the anus to free up the guts. Go back to the gill plate and cut the membrane in the gut cavity on both sides and, with one swift pull, the head and guts come out of the tuna. Then, you will pack the core very tightly with ice to keep the core cool. It is now ready to go on the table for sushi.
Chef Michael Smith on Food Network Canada tells you how to avoid serving up a solid mass of pasta with sauce sticking to it.
Make a fabulous honey mustard sauce or dip with this video tutorial. Put one third of a cup of mayo into a bowl. Add yellow mustard and Dijon mustard into the bowl. Next add a little hot sauce. After adding the hot sauce you will add honey and one table spoon of rice vinegar. Use a whisk and mix it all together in the bowl. You can adjust the amount of mustard, hot sauce, rice vinegar, and honey to suit your taste. Once it is mixed together it is ready. All you need now is your favorite dippi...
Handling a 15 pound watermelon is no easy task. This video offers a demonstration on how to create a beautiful centerpiece for your table using basic strategies and handling techniques on your watermelon.
Feel you have too small of a kitchen to keep everything you need inside it? Not true. Even if you have a small kitchen and a small budget, you can still save money by stocking it efficiently.
Holidays such as Thanksgiving are doomsday for most garbage disposals due to clogs. If you're garbage disposal is clogged, check out this video to see some helpful tips on how to fix it.
Learn Arabic words using the Learn Arabic with Pictures series from ArabicPod101.com. Beautiful images clearly show Arabic vocabulary divided into units by topic.
Optical illusions don't require fancy techniques; this one relies entirely in the details. Gather up a pen/pencil, paper, and a pair of scissors. Draw a parallelogram to be used as the template for both tabletops in this sketch. By varied angling, leg lengths, and color, the table top takes on a different appearance. Watch this video drawing tutorial and learn how to recreate this cool, artistic optical illusion.
Be the life of the party – without wearing a lampshade or starting a conga line – by getting an egg into a bottle.
A sweet and spicy milk-based tea from India, chai is a tasty alternative to coffee. You Will Need
Watch this cooking video tutorial on how to make Polish coffee cakes - kids can cook! You will get all the necessary information to make this Polish coffee cakes recipe, including a list of all the ingredients needed, all right in the video.
Try these simple fixes to salvage your specs. Learn how to fix your eyeglasses with this helpful guide.
Utilizing X-Rated Fusion, this drink brings many flavors to the table, most through the alcohol itself. With a bit of Peach Schnapps and pineapple juice, the only thing to make this drink complete is a bit of 7UP to lighten the mood.
Although not made of electricity, the electric lemonade brings a lot of cool colors, carbonation and alcohol to the table. A bit o' rum, some blue curacao and a little sweet sour and you're rocking.
This is Brian Brushwood with Scam School. The trick is called 'In the bank'. This week we've got another puzzle with a setup that sounds absolutely impossible.
Learn how to play "She's Everything" by Brad Paisley, an acoustic guitar tutorial. Follow along with this demonstration, lyrics here:
It's the perfect game-day food: tacos, chips and guacamole all in one bowl. Follow along as Rachael Ray shows you how to make taco bowls with guac-a-salsa. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that her dazzling dishes w...
Try any combination of cheese and herbs for an easy appetizer. Follow along with this video cooking lesson as Rachael Ray shows you how to make easy grilled green quesadillas. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that h...
Keep everyone happy with a build-your-own burrito bar. Follow along as Rachael Ray shows you how easy it is to cook for a large crowd. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that her dazzling dishes will never take more t...
For casual entertaining, Rachael Ray suggests a taco bar. Watch as she shows you how easy it is to cook for a large or small group. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that her dazzling dishes will never take more than...
Rachael Ray whips up a quick treat-on-a-stick that all ages will love. Follow along as Rachael shows you how to make peanut butter banana sticks. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that her dazzling dishes will never ...
Rachel Ray prepares her mom's specialty, shrimp with sage and pancetta. Follow along learn how to prepare this shellfish and ham recipe for your mom. This cooking how-to video is part of 30 Minute Meals show hosted by Rachael Ray. Would you believe you can make impressive and delectable meals at home in less time than it takes to get takeout? Let Rachael Ray show you how easy it can be. From comfort food to sophisticated fare for entertaining, Rachael promises that her dazzling dishes will ne...
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how you can use the audio FX on the SVM-1000 Pioneer mixer. You can use these with a conventional CDJ or vinyl T-table and with the DVJ-1000 player. Remember all effects are good, but not if you use them all the time! Watch this DJ tutorial and you can learn how ...
Watch Tracy cook some authentic Jamaican Jerk Chicken. Ingredients for Jamaican jerk chicken:
Stretching the spine will help align back muscles. Learn how to stretch the spine in Hatha yoga with this video clip. Take action: begin in Table Pose, extend one leg back, lift opposite arm and reach, and exhale and stretch. Cindy Mastry, the instructor in this how-to video, has practiced yoga since the age of eight, and also has a background in Jazz and Ballet. Active in the fitness industry for nearly twenty years, she teaches aerobics, kickboxing, and yoga at many fitness centers in the T...
So many bench-top style tools are available today it's easy to accumulate several, including table saws, jointers, sanders, scroll saws, planers and others. With either purchased or shop-made individual stands, the tools can take up a lot of room. In this video tutorial, you'll learn to build a roll-around tool cabinet that can easily be rolled out for access to a variety of tools placed on top. It features a large bench top with locking rollers, and a huge storage cabinet beneath, which prov...
Controllerism is a lot like turn table-ism, except through its exclusive use of controllers and music software. Take a look at this instructional video and learn how to turn a simple and inexpensive MIDI keyboard into a custom audio controller. First, you'll want to rearrange the keys to line up with the knobs. Then, cut up an old DVD case and a bicycle tube to glue the rubber onto the keys to make it more tactile. Lastly, you'll need to set up the software to assign the keys with controls on...
Woodturning is a hobby that involves wooden items like bowls using various tools on a lathe. Learn about mounting and roughing blanks from a woodturning expert in this free crafts video series.