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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
This makeup style is fun and vibrant, without being too over-the-top. This "fresh berries" makeup look plays around with layering colors, which create a unique effect when you turn your hair, making the colors gleam. This berry fresh look is great for spring or summertime (probably because it's reminiscent of fresh and delicious looking berries).
This video shows the method to create a messy bed hair for men. Straighten your hair with a GHD ministyler. The product to be used to style your hair is ID hair dusty Bronze "clay wax". This should be applied in dry hair. You can wash the wax out by shampooing your hair twice. The shampoo to be used is Crew or ID hair peppermint. Put the finger in the wax and take out the wax. Rub the wax in your palms and apply it on your hair. Apply it in the front, back and sides. Use the wax again if it i...
This video shows how to make a men's hairstyle called a faux hawk. He uses a product called Renati Rock Hard along with got2be glued spray. Take a dab of the Rock Hard and rub it through your hair and make all your hair stand straight out, then spray it. Add more Rock Hard and style it by flattening the sides and pulling the top stright up. Pull the bangs forward and off to one side and make them spiky. Use a hairbrush on the sides to brush the hair forward, keeping it flat against the sides ...
This video shows how to make buttons from paper scraps. You need some patterned paper scraps left over from scrapbooking. The best working surface is a Teflon sheet. You also need some shiny glaze product, a pin, and a punch, for example a circle punch, but square, hearts or flowers will do just as well. You need scissors too. Cut or punch out several button shapes. Use a small hole punch to make two holes or four holes in the centre of the button. Use the pin to clear the glaze nozzle. Add t...
Joico Spiker takes the time to show us how to style a mans hair so it is spiky and textured. It's very easy to get the gist of it even though the video is in a language other than english, . He recommends his hair styling product for this. He uses 3 separate stages of applying the hair gel, all three stages use about a nickel size dollop of gel. For the first stage you apply it over as much of an area as possible, setting a base for the second two stages. Next, you apply the second dollop of ...
There are many different types of daylilies, and this video shows the different varieties and how to care for them. First they show a variety called Double Cutie and explain that you need to take off the wilted blossoms to get more blooms the following year. If the leaves are striped, it means there is an iron deficiency in the soil, and there are products you can get for that. There is a variety of daylily that is almost white, called Tuscawilla Tranquility. There are no daylilies that are p...
Here's a quick and easy way to make 3D glasses. Supplies needed to make 3D glasses are: transparency paper, red and blue marker, scissors and an old pair of glasses. Pop the lenses out of the frame of the glasses. Take the lens and trace them with a marker. Color the left eye lens with the Red marker. Then color the Right eye lens with the blue marker. Put the lenses back into the correct frames of the glasses (Left eye Red, Right eye Blue)And there in your hands is the finished product. Your...
This video is a tutorial on how to start growing tomato plants from seeds. The instructor first explains that it is important to make sure your seeds are fresh and within the proper date frame and that you pick a good artificial soil mix for proper growth. The tutorial goes over a few different fertilizer products that you can choose from, yet they are not completely necessary for growth if the soil is of a high quality. The instructor then fills plastic mini pots with soil and then uses a pe...
In this Home & Garden video tutorial you will learn how to care for your garden In March by applying insecticides. John White presents this video. During this time roses get a good growth and along with growth come aphids. For tackling aphids you can a variety of insecticides. One such insecticide is called Rose Defense whose main ingredient is ‘neem’ which comes from the neem tree. You can also use Rose Food insecticide. This is also the time to fertilize rose plants since they will be getti...
Ever wonder how to make your very own faux night vision goggles? Well, Mr. G shows you exactly how to make your own night vision "glasses". Step by step, soley using household products. This experiment is just too good to be true. A foolishly easy experiment that will make you laugh and cry at the same time. This video is just for fun, don't let it fool you!
Watch this video to learn how to make glow in the dark goo with household products. Add 1 teaspoon of Borax to 1 cup of warm water. Add 1/2 tablespoon of Glow powder and mix for 30 seconds. Pour the contents of a 4 ounce bottle of glue into a measuring cup, fill the container with water to get all of the glue out until you have 1 cup of water and glue, then mix with a whisk. Add the Borax to the mixture and add color mixture (any) too. Play with the goo to mix the color and add to a light to ...
Head Judge for the World Latte Art Championship, Paul Meikle-Janney, shows how to make a latte using the Brasilia Opus Sublima espresso coffee machine. Paul briefly explains that the process is somewhat similar to creating a cappuccino, noting that the major difference is how much foam you'll be creating on top of the beverage. This video shows the necessary steps taken to create the latte, creating the foaming texture and the single espresso at the same time. During this process, Paul offers...
This video tutorial shows you how to use a long wrap product to dress yourself while creating a secure carrier for your baby. The long wrap is brought forward from back to front and round your belly button, criss-crossed over your back and brought forward and criss-crossed once more, then tied. The two criss-crosses (in the shape of an X) help hold the babies legs, as the pass through the criss-crosses and support the baby. You should then try to bring the fabric down as far as possible to su...
This how-to video is a vibrant and animated tutorial on how to paint children’s furniture: in particular, a little girl’s tea table and chairs. It’s fast paced yet easy to follow. The video couple takes you from the taping and preparation of the table and chairs to the completed and professional quality finished product, which would thrill any little girl. Their method of communicating the most important steps is to race to the camera and speak to the audience, in an amusing sort of wink, whi...
Cinema Makeup School instructor Greg McDougall goes through the steps your need to know in order to create a silicone wound on a student. He starts off by explaining the products needed in order to get the best results. Greg then proceeds to apply and explain how to place a prosthetic piece on your face and how to get it to blend into your skin color. After apply the prosthetic he begins to color in the wound to make it look more realistic. To finish off and get the best result you apply fake...
This step-by-step instructional video shows how Photoshop can be used to purposely over-process a photo and give it a more gritty effect. First, a High Pass filter is applied to give the photo a gray buzz. Next, hard light blend layers are applied to give the photo more contrast. A few approaches for applying noise filters are described next. Finally, de-saturation is applied to produce an amazing finished product. A must-see video for anybody looking to add a fantastic grunge effect to a photo!
Lowe's presents a video that can give you a few tips on removing wallpaper from a room. First off you do not want anything to be in the way so clearing the room out is a must. This video shows you a abundance of products that can help you with the task. Also it shows some safety precautions to take before you take on this task. This video will show you a few different methods that can help you when giving a room a new look.
In another great video from FashionFace TV, we get a full face look inspired by the iconic beauty of Raquel Welch.
In this three-part carving tutorial, Valerie Jones demonstrates her chip-carving techniques on Mahogany wood. Using an X-acto knife, she carves the wood by hand & describes how to carve German-style, geometric patterns into the wood after stenciling the pattern on the outer wood surface. Later, Valerie talks about her methods when chip carving wood: how to hold the knife, how to guide the blade, finishing the final product, how to follow a stencil pattern & goes over more useful information.
Fashion Face shows us how to create a 30's all over face look inspired by Marlene Dietrich. To create this look you will need full coverage foundation, concealer, a range of matte eyeshadow from taupe to brown, eyeshadow brushes, brow highlighter, mascara, liquid eyeliner, false eyelashes, pressed powder, beige contouring powder, powder and contouring brushes, highlighting powder, red lip liner and red lip cream or gloss. Specific brands are used and suggested, but you could create this look ...
This video shows you how to fold origami boxes. You will only need a single square piece of paper. The process requires simple folds. This project can be done by people of all ages. The video has both audio and video instructions and is very clear about what needs to be done. The final product is a box with an open top. In order to create the lid, you repeat the process. It is suggested that you use a different color or patterned paper for the second box. The second box just gets tucked over ...
This how-to video is about how to make a Stinger cocktail with cold cognac.
Whether you love Nancy Ann Grace or hate her, you can't deny that her eye makeup is always amazing. Watch Princess Pinkcat in this tutorial video about creating her Nancy Grace makeup look. She didn't curl her hair for this video, just tucked it under to make it look more like Grace's hair length.
Watch this video and learn to be happy with stretch marks and the appearance of your body. -It is normal to have stretch marks, 78% of women have stretch marks.
The Wedge ROP is a render output driver, which can be used to change variables on the fly while rendering. This can be very useful when simulating, in that you can test out different parameters to see the different results. It's a relatively new feature in Houdini 9.5.
In this tutorial, make-up artist, Kandee Johnson shows how to get Walt Disney's Snow White look down next Halloween! The following products were used of achieve this look: Ruby Woo lipstick by MAC, Chesnut lipliner by MAC, Lise Watier Concealer, false eyelashes, any white eye shadow, Copperplate eyeshadow by MAC, Cork (warm brown) eyeshadow by MAC, rice paper by MAC, and liquid black eye liner.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
PowerBook Medic is the ultimate resource for Mac computers and electronics repair. They have helpful tutorials on most Apple products including the MacBook, MacBook Pro, PowerBook, iBook, iPhone, iPod, and more, covering topics from disassemblies, to RAM upgrades, to replacement hard drives.
