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
First of all you need to have some warm water in glass. Now take an ear bud and dip into the warm water. Now apply some soap over it. You can use the hand soap also for this purpose. Insert the bud in your nostril and then rub it around the pierced skin. Remove all kinds of particles accumulated at this portion. Now clean the other nostril as well. Now hold your pierce ring with your two fingers and give it shake. This shall remove all solid pieces from the area. Otherwise these may go down i...
It is easy to prepare the coconut milk on our own. First take coconut and break it into two pieces. Then collect the coconut water from it, keep it aside. Then take the pieces of coconut and remove the peel of it and just grind the coconut. Then mix the powder with the coconut water which you have kept aside and stir them with your hands. Then take a bowl and remove the solid part from the mixture and collect liquid and that is our organic coconut milk.
In this tutorial, you will learn how to model this cool looking diving knife. The model can be set apart into two pieces, blade and handle. Both having some nice features.
So we got half a Maya model...now what? We mirror it over and merge the vertices, all with one command, to get us a solid object. We use the dolphin from our organic polygon modeling series, but the technique can be applied to any polygon model. Watch and learn how to mirror geometry the new school way in Maya (with the mirror geometry tool!) NOTE: there are often problems with this method of mirroring, but don't worry, they're covered.
Watch this instructional hobby video to properly set up and fly a remote control helicopter. Transmitter switches and servo wires should all be set up this way. Charge the flight pack and you are ready. If you are a beginner, leaving the flybar weights at the outer position will dampen the controls and make the helicopter easier to fly. As you improve, move the weights in for quicker response. The swashplate has a metal ball for reduced wear and precise control. The servos are screwed to the ...
Are you a foodie? Then chances are that you wear out butcher boards faster than Paris Hilton goes through men. Perfecting your cooking skills is a great thing, but you can definitely preserve your butcher block for longer than you think. Take a look at this video to learn how to clean, sanitize, and seal your butcher block so it lasts for many years.
This is a simple trick that can amaze, and only requires about a 1/2 hour of solid practice, more or less.
Velodyne wants to set the standard for the driverless industry when it comes to LiDAR. To do that, the Silicon Valley-based team just announced its next step — create a low-cost, fixed-laser sensor that can be embedded into a wide range of automotive and autonomous vehicles. That next step is named the Velarray. A sturdy, compact, and affordable LiDAR laser.
Gatorade and football go hand in hand, from player endorsements to the traditional Gatorade shower that coaches get at each Super Bowl. So, get in the game-day spirit with these Gatorade-infused drinks, desserts, and snacks. The good thing about Gatorade is that it comes in every color of the rainbow—so feel free to make these in your favorite team's colors.
Unless you're vegan or lactose intolerant, butter is an indispensible ingredient. However, butter is no one-trick pony. It can take many forms that make it even more versatile and useful in the kitchen. Clarified butter has many advantages over regular butter—but there are certain cases where you shouldn't use it. More on that later.
How to find a stud in the wall. How would you like to be able to find a stud in a plaster wall / drywall wall, easily and every time without an expensive stud finder? Let's look at how to find a wall stud using three conventional methods then l'll explain my foolproof method of how to find a stud in the wall without a stud finder.
Gunmetal gray is one of the coolest, most biker-chic finishes out there when it comes to jewelry making. If you enjoy working with filigree pieces in your bracelets and necklaces, why not make them less granny fantastic and more urban chic by adding a nickel-free gunmetal finish?
Just because a person is cordial enough to knock at your door doesn't mean that he isn't a conman or burglar out to knock you out and steal all your belongings. So you can probably understand the usefulness of a spy hole, or a door viewer.
When it comes to losing weight, cardio is your BFF. When you combine cardio with strength training you achieve what is known as solid gold fitness: The perfect combination of sweating (and fat loss) and muscle building so the fat slides off and your toned muscles come out.
In this video, we learn how to turn a composition book into a decorative notebook. First, measure your composition book, then measure out that same size on a piece of decorative paper. Next, put adhesive on the back of this on all four edges, then diagonally. Now, you will have a solid attachment for the paper to be placed on top of the composition notebook. Use a straight edge to push it down and it's completely flat. Then, use scissors to cut any excess paper off of the edges and corners. Y...
Oobleck, a word coined from the Dr. Seuss book "Bartholomew and the Oobleck," has contemporarily come to define the substance created from mixing cornstarch and water. This mixture is notable for its dilatant properties, and as an inexpensive and non-toxic Newtonian fluid. While seemingly liquid, under pressure, the substance reacts as a solid. Gentle treatment, however, will allow the material to remain in its fluid state. More simply put, this sh*t is crazy.
Before watching this video, we thought there was only one type of butter: The kind you buy in sticks or in plastic containers at the grocery store and toss into all your foods for extra flavor. But apparently butter is a much more complex foodstuff than we thought.
In this video tutorial, viewers learn how to jump start a car. When purchasing a jumper cable, don't purchase the cheapest set. It is also not necessary to purchase the most expensive. Begin by connecting the black cable on the negative terminal of the healthy car. Then connect the positive side of the red cable to the positive terminal of the healthy car. On the dead car, connect end of the cable to the positive side of the battery again, except this time you connect the negative end to a so...
In this Home & Garden video tutorial you will learn how to build your own windmill with household materials. Materials needed for the windmill are a template, scissors, straw, some yarn, some pennies, a paper cup, rubber bands, pencil, single hole punch, a skewer and thumb tacks. Take the template, cut it out along the solid lines and punch holes on the corners as shown in the video. Now with a thumbtack and a pencil make a nice hole at the center of the template. Fold the template along the ...
Forget dogs - tripods are a man's best friend (well, if he's a photographer). Eliminating many of the factors that create crappy photos, including the instability of holding the camera up by hand, photo blurs, and general strain of weilding those hulking digital SLRs, tripods are always there to lend a helping leg. Or three.
Check out this tutorial for steps on how to perform a very cool slight of hand trick. In this video, learn how to take a solid sugar packet, toss it in the air and catch it - like a ring - around your pointer finger. Your audience will be totally amazed, but you will know the secret.
Humans don't really have the strength to rip a solid apple in half.. or do they? In this video, learn a cool trick for separating any apple with nothing but your bare hands. This comes in handy as a magic trick, or, more practically, as a way to enjoy a fresh apple without a knife.
In this video tutorial, viewers will learn about decorating bag basics. A decorating bag is used to pipe semi-solid foods by pressing them through a narrow opening at one end for many purposes, including cake decoration. Viewers will learn about the types of decorating bags, how to add a coupler to a decorating bag and the proper way to fill a decorating bag with icing. This video introduces three different types of decorating bags. The bags are the feather white bag, the disposable bag and t...
This video is a bass lesson that demonstrates how to use a two-handed tapping technique often used by Eddie Van Halen and others on guitar. To do this on bass, you should put your middle finger over the top of your index finger to make a more solid tapping finger, and put your hand up the neck with your thumb on the back of the neck. Land your finger to tap, and pull to pluck the string. He places his left hand on the frets in anticipation of pulling the string with the right hand. He demonst...
Over medium heat warm a small amount of oil or butter – perhaps 1 ½ tsp – in a small (8 inch) skillet, or spray the pan with nonstick cooking spray. Crack an egg into the pan. Cook until the white appears solid (for about 3 to 4 minutes). For basted eggs, put 1 tsp or so of melted butter over the yolk. For eggs sunny-side up, remove the egg from the pan with a spatula and serve. For eggs over easy, carefully flip the egg over onto the yolk side and cook for another minute or two. (You will pr...
This video shows us how to create an amazing 3D design using a single sheet of paper. You will need: cutter printed template of the 3D design. Procedure: Download the template using this link. Print the template. Cut all the solid lines on the template. Fold all the broken lines on the template as shown. Arrange the paper in such a way that it looks like the 3D design shown on the video. Follow these steps and you will have your very own amazing 3D paper design!
After watching this video you will have a better understanding of this sport and how to ride your bike in the best way possible. Balance is key to solid bike riding. The girls go over fore and aft movement, side-to-side lateral movement, and up/down movement which is used for better pressure control used for better weight control on the wheels. You can see how your body should be positioned for better control and stability taking corners or riding over rocks in this short discussion of the ba...
This video illustrates how to make napalm. You will need a petri dish, gasoline, and styrofoam to create napalm. Combining the styrofoam and gasoline in a petri dish you allow the styrofoam to dissolve and become a semi-solid substance. It will have the consistency of chewing gum and it will be highly flammable. This substance will be sticky and if lit it should be lit outside and at a distance from anyone as it will produce a gas that is toxic.
On this episode of Scientific Tuesdays, Dylan shows you how to create a non-Newtonian fluid using corn starch and a little water. A non-Newtonian fluid is any fluid that does not follow the laws of physics.
Learn the hand method for applying gold leaf gild to a solid surface such as wood, stone, or metal. • You will need imitation gold leaf, metal varnish, hot hide glue, gilder’s size and brick red synthetic enamel.
Watch this video as it gives easy instructions on how to make a mini paper airplane that flies far. -Get a small piece of paper. 4X8" would be best.
Check out this masterclass on Houdini 9.5 and how to rebuild the fire simulator. Houdini's Fluid Tools offer a powerful simulation environment for visual effects artists. Senior Mathematician Jeff Lait introduces you to the basic building blocks for generating fluids and low level tools that make it easier to control the simulations.
Learn how to crochet using a graph or chart in this six part vieo tutorial series. Filet crochet is lacy stitch - an easy technique - that can have beautiful results. Filet crochet patterns are usually made up of open meshes & solid meshes. Get the free simple heart chart used in this video here.
Here are some instructions on heat embossing on polymer clay. This video includes tips for embossing both baked and unbaked clay. You will need polymer clay, a rubber stamp, pigment ink, embossing powder and a heat gun. Roll out the clay onto a nice thin sheet of clay and bake the selected piece. Then stamp the baked clay with ink as desired. Sprinkle the embossment powder onto the stamped area, and tap off the excess powder. Next, heat the embossed area with the embossment gun and watch the ...
Plug this baby into your FiOS-powered computer and simulate the real-time climate of any location in the country -- rain, lightning, fog, sunshine.
We recently ran down several hidden features on the Galaxy S9 — items that are buried deep within the settings menu that can be tricky to find. One thing that many users cannot find is the option for a black navigation bar. Unfortunately, this option does not exist in Samsung's stock settings. But this is Android, so with a bit of developer magic, we can easily regain the black navigation bar in no time.
Bigger and faster. Two words that are pretty much always wanted no matter what the scenario is. The new PlayStation 4 has been out for only a few hours now and people are already looking for ways to one-up their friends and upgrade their already awesome systems.
In this Windows 8 Tutorial you will learn how to disable automatic maintenance. Their are really two situations I can think of when you would want to disable automatic maintenance in Windows 8. The first being if your Windows 8 computer came with a Solid State Disk then you will probably want to disable automatic maintenance. The reason being is that a solid state disk does no benefit from defrags and the automatic maintenance automatically defrags your hard drive and this will take away from...
Old newspapers come in handy for many different uses around the house, from birdcage liners to shipping cushioning and even a little fish cooking. But for backyard rocket scientists like Markus Bindhammer, they're more suitable as an ingredient for rocket propellant.
