Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
In this Film & Theater video tutorial you will learn how to make a documentary film step-by-step. The various steps involved in making a documentary are defining the documentary, stylizing the genre, shooting and finally editing. A documentary is a movie that documents reality. It is based on real life situations or people. The three most sub genres are the observational documentary, the expository documentary and the participatory documentary. The different styles can be sit-down interviews ...
In this clip, learn how to be a real coupon diva! This episode of coupon divas focuses on Walgreens drug stores and will show you how to combine things like register rewards, coupons, sales and other deals to walk out of the store with a full cart for virtually no money! Get your coupons to outnumber the cost of the items and go home with a bunch of free goodies. Kitty will show you the basics and how to stay organized with these strategies.
Don't fret too much if your watermark is barely noticeable when you're finished with this project - the less obvious it is, the better a job you've done. Watermarkers are present in many types of paper, especially the monetary kind. If you hold up a ten dollar bill you'll see a watermark of Thomas Jefferson's face on the right, proving the bill is real.
There are many ways to enjoy books on your Nook. One of these options is through Adobe Digital Editions. Digital Editions is a way to buy and transfer real life books onto your computer and then your e-reader. You can do this with rented library books as well. Check out this clip and learn how to transfer a DRM book to your Nook fast and easily.
This video demonstrates how to make a defense-splitting pass. You need to see three very important factors. The first one is you need to see the opportunity. Secondly, you need to choose the right moment. And third, you must be able to put the right weight on the pass. Learn to control your ball so that you are in the position to make a killer pass. Train yourself to be able to improve on these aspects. The more you train yourself the more you will be able to successfully do it in real matche...
A TIE Fighter might not ever see the light of day outside of the television. Not a real starfighter, anyway. But you can model our very own Star Wars TIE Fighter with some simple paper. It might take a while, but folding this origami Star Wars TIE Fighter will be worth every second. Use the origami diagram, from Star Wars Origami. You can find two different versions there.
Swarovski crystals don't need to be confined to delicate jewelry pieces and Victoria's Secret Fashion Show bras! These little jewels are expensive than their cheaper plastic rhinestone brothers, but so worth it. Multifaceted, these Swarovski crystals glow like real diamonds and and a gorgeous sheen to any craft project.
Night vision goggles are one of the iconic pieces of equipment of the modern military. Getting a real pair is prohibitively expensive, especially if you just want to use it as a prop in your film instead of actually seeing at night. This video features instructions for making your own set of prop night vision goggles for cheap, giving any action or spy movie that you are making a much more modern, authentic feel. Also, now your characters can see at night, opening up all sorts of potential sc...
Complete your knight costume - or damsel in distress who's really a kick ass swordsman in disguise costume - with this cardboard Medieval sword. Sturdier than paper and much safer than the metal of a real sword, this version can be used by kids without risk.
Are you using your website or blog for exposure or business? If you would like more people on the web to notice your masterpiece, check out this clip. In it, you will get real, helpful tips on how to get people to your site, so they keep coming back. There are plenty of ways to promote yourself and you will learn all about them here. So, grab a pen and take some notes and get ready to become the next Internet superstar.
Looking for a cool trick to impress your friends? Check out this tutorial from Stephen Ablett. In it, he will show you how to stick a pen through a dollar bill and take it out again, leaving the bill totally intact!
When you do a magic trick, people will automatically try and guess your secret. This makes it difficult to do complicated tricks that must be performed from a distance to look real.
The key to many coin based magic tricks is proper "palming". In this tutorial, learn the basics of how to palm a coin and open the door for many tricks to follow.
There's hardly a celebrity who steps foot on the red carpet without hair her mama didn't give her. Extensions are a natural part of life for Hollywood stars, and no wonder: even a few clip-ins amp up volume and make your hair look healthy and lustrous.
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...
In this culinary how-to from the Food Network's Ellie Krieger, you'll learn how to bake delectable, almost-healthy carrot cupcakes using whole carrots, lemon zest, canola oil, brown sugar, two eggs, 3 quarters of a cup of whole wheat pastry flour, 1/2 cup all-purpose flour, 1 teaspoon of baking powder, 1/2 teaspoon of cinammon, 1/4 teaspoon of nutmeg and a 1/4 teaspoon of salt.
This video teaches English-language learners how to respond to questions beginning with the words "How do you like". There are two types of questions in English that begin with the words "How do you like". The first kind requires an answer in the form of an opinion. The second requires that the answer come in the form of giving instructions. The video explains the difference, then gives several examples for each to model practice. For example, "How do you like the weather?" is a question whic...
This video describes how to edit images and videos in MS Power Point 2010. For example, we will take a slide with picture added. If you want to edit the picture, first go to the "Picture Tool" button and click on the format tab. If you want to change the contrast and sharpness of the picture use the "Corrections" menu, and to change the saturation, tones, and to do recoloring we can use the color option tab, and then the "Artistic effects" which can be used to see a real time preview like usi...
This video teaches the secrets of applying flawless false lashes. An excellent summary is given below. First hold the lashes with tweezers to your eyelash to check the size of it. Cut it off a bit if the false lashes are big compared to your eyelashes. Now apply some glue carefully to the base of the false eyelash. Close your eyes and stick the false lashes to the base of your eyelash and hold it for a few seconds to let it dry. After the glue gets dried blend the false lashes to match with y...
This video explains how, with the help of paper, we can make a beautiful butterfly. Now take a square paper; you can have a nice one so that it looks beautiful. Now fold the paper into half and again fold the paper in half. Now make triangles by folding again. Now open from between and shape up the wings. This nice butterfly can be used to decorate cards and folders and gifts, too. This looks so beautiful just like real one.
Working with the Python programming language is hard if you're not familiar with it, and working with it in Houdini is even harder if you don't know what you're doing. So familiarize yourself with some Python and follow this masterclass for Houdini 9.5 on programming with Python. You will get comfortable with writing Python code and some simple scripting involved.
In this four-part science tutorial, learn how to make a model of a hand that works like a real hand: with tendons that move the fingers. This is a great tool to teach kids the body's inner workings. Part 1 includes an introduction and parts 2-4 include the step-by-step instructions to contruct this learning tool.
Long-time packeteer Bob Bruninga, WB4APR, developed the Automatic Packet Reporting System (APRS), which allows packet radio to track real-time events. It deviates markedly from the usual message- and text-transfer activity. Instead, APRS concentrates on the graphic display of station and object locations and movements.
Getting weird looks from the other dudes at the bar? Maybe because you're ordering a sex on the beach like the other women. Spit out that tropical drink or wine spritzer and throw away your stemware. It's time to put some hair on your chest, hoss.
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.
Forget expensive steadicams! Save money on your film budget and make a DIY steadicam that's almost as effective as the real deal. Chappy shows you how to make one for only 30 bucks! You can make this steadycam with parts from your local sporting goods or hardware store.
This video explains how to fold the Spiral by Tomoko Fuse. You need 4 sheets of paper of different colors of any combination of your choice. 2 sheets of 2 colors each would give you a dual colored spiral.
The one card trick that every street magician or street hustler needs to know is 3 Card Monte. With the help of this video tutorial, you'll see exactly how to perform the three-card monte throw. There is no real magic here, it's all just a sleight of hand, which is needed for any magic card trick.
This video shows you how to make a fake "virus" that shuts down the computer of your victim when they open it. This video also shows you how to email or AIM this prank virus to a friend.
This is a step-by-step instructional on how to make a potato gun, otherwise known as the spud gun, potato launcher, potato cannon, etc. Although this can be a fun activity, it is still dangerous, just like a real weapon.
Street Skateboarding: Take It to the Streets The guys on the prefab ramps and half-pipes make the X Games headlines, but the real frontier of the skateboarding world is out on the street, where everyday obstacles become the tools of the trade. Find out here how to turn your street into a house of shred. Watch this video tutorial to see how to perform a kickflip on a street skateboard.
Street Skateboarding: Take It to the Streets The guys on the prefab ramps and half-pipes make the X Games headlines, but the real frontier of the skateboarding world is out on the street, where everyday obstacles become the tools of the trade. Find out here how to turn your street into a house of shred. Watch this video tutorial to see how to perform an ollie on a street skateboard.
Street Skateboarding: Take It to the Streets The guys on the prefab ramps and half-pipes make the X Games headlines, but the real frontier of the skateboarding world is out on the street, where everyday obstacles become the tools of the trade. Find out here how to turn your street into a house of shred. Watch this video tutorial to see how to perform a half cab kickflip frontside & backside on a street skateboard.
Street Skateboarding: Take It to the Streets The guys on the prefab ramps and half-pipes make the X Games headlines, but the real frontier of the skateboarding world is out on the street, where everyday obstacles become the tools of the trade. Find out here how to turn your street into a house of shred. Watch this video tutorial to see how to perform a frontside boardslide on a street skateboard.
Street Skateboarding: Take It to the Streets The guys on the prefab ramps and half-pipes make the X Games headlines, but the real frontier of the skateboarding world is out on the street, where everyday obstacles become the tools of the trade. Find out here how to turn your street into a house of shred. Watch this video tutorial to see how to perform a 50-50 backside on a street skateboard.
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.
You're driving down the road and all of a sudden SNAP—your alternator belt just snapped. You're losing power fast and need a quick fix, but there's no mechanic in sight. If you have a woman in the car, you may have a simple quick belt replacement—pantyhose. That's right, some simple pantyhose can act as a makeshift alternator belt until you find a proper solution, i.e. a real alternator belt. Check out this video to see how it's done!
Turn yourself into an electromagnetism maestro with one of the simplest motors known to man—the homopolar motor. It's the "simplest motor" because of its absent polarity change. The magnetic field does not change the direction or strength. It consists of only three parts; copper wire, round magnet and battery. It produces really low voltages, which means there's no real practical application for this motor, but it sure is fun to make! Try your hands at the homopolar motor—watch the video and ...
There's an easy time hack available for Candy Crush Saga that let's you bypass the time restrictions to you can play more games faster, and this video guide from KiboshGaming will walk you through it on both Android and iOS devices.
