In this video tutorial we learn how to assign a macro to a button or a check box in Excel. The first thing you want to do is to place the macros you want to use in the spreadsheet. You can assign a macro to any object within Excel. Next draw the shape in the spreadsheet that you will want to assign the macro to. Then, right click on the shape that you've drawn. Then go down to assign macro and select your Macro in the pop up box and click OK. Now, anytime you click on the button the Macro wil...
In this video, we are shown how to create and utilize a pumpkin-themed mat and some pumpkin seeds in order to teach young children how to count. Using a mat with a picture of a pumpkin on it, as described in the video, you should have a few squares with numbers on it which the children can put on the mat. Then, using a bowl of pumpkin seeds, have the child pick up the seeds and place them on the mat, having them pick the correct number of seeds as correspond to the number of the square they c...
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. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
This video shows the method to install 'Installous' on your iPhone and iPod Touch. The first step involves opening up 'Cydia' on the iPhone or iPod Touch. After opening Cydia go to manage and then go to the option of 'Sources'. The resultant window will show an option named hackulo.us. Add this cydia.hackulo.us to the source. The resultant window which opens shows various sections. Find the section of Hackulous in the window. Go to the Hackulous section and find the option of 'Installous'. In...
In this two part video series, BBQ pit master Rick Browne shares his tried and true method to making sweet, succulent brown sugar ribs. Follow the instructions in this video and you will surely have the most popular dish at the next BBQ.
Skype continues to be one of the most convenient and widely used methods of keeping in touch with people all over the world. For those of you on the go, having Skype on your Blackberry could prove to be an invaluable communication resource.
In this Arts & Crafts video tutorial you will learn how to baste a quilt for free-motion quilting patterns. This video is presented by craftygemini. This method of loading your quilt onto your quilting frame is known as floating where the quilt top and the batting are floated. Neither the top nor the batting are rolled and pinned onto leaders like a backing fabric. First go to the top center point of the quilt top, put the pressure foot down and take a stitch. Bring the bottom thread up, hold...
Danny Lipford and Joe demonstrate how to make a bicycle rack out of repurposed closet racks. Closet brackets can be used to store bicycles. Instead of hanging the bicycle on the ceiling for long term storage, fasten closet brackets to your garage wall to more practically easily access your bicycles on an everyday basis. First, drive drywall screws into the wall studs. Space the brackets about 16 inches apart. Hang the bike right on its crossbar from the brackets. This method only works with b...
This video demonstrates that just because a shoe feels loose doesn't mean it's the wrong fit. Many shoes have a back eyelet that rarely gets used, but if you put your laces through it before tightening, it will raise the fabric of the shoe to give more support to the heel. If your shoe doesn't have this extra eyelet, you can create false eyelets by creating loops with your laces on the top two eyelets of the shoe, then lacing them through those fake eyelets before tightening. Both of these me...
This shows how to loosen up the laces of shoes with an over under technique. It is important to not have any pressure points and discomfort. The first lacing is over at the end then it is moved under the eyelet and makes a cross under. Then it is alternated back over and under. The show is then tied up normally on top. Because the show is not laced on the underside it gives more room for the person wearing the show. This technique for lacing is especially helpful for those who have a high ins...
This video in the Education category will show you how to find a percentage of a number. For example, what is 12% of 56? The simple way to do this is to find 10% of 56; which is 5. 6. Then you find 1% of 56 is .56. Then you add 10% plus 1% plus 1%, that is, 5. 6 plus .56 plus .56; which is 6. 72. And that’s the answer. The other way to do this is to make decimal out of 12; which is .12. Now multiply .12 by 56 and the product is 6. 72. These are the two methods of finding out a percentage of a...
There's nothing like milking a dairy cow straight from the teat. Of course, before milking you'll need to sanitize the teat with a sterile solution and paper towel. This video tutorial demonstrates the proper methods of milking cows using a standard milk machine pulsator for professional results.
This is a video about the topic "Yeast in Your Toilet". It is quick tipped video clip and the tip to add the yeast in toilet in order to increase the growth of micro-organisms in the toilet and your septic tank systems. To perform this quick tip process, flushing one or two tablespoon of Brewer's Yeast down the toilet for every months and do not stop the process and check the septic tank systems regularly. This method will extend the life of the septic tank systems because of the grown level ...
Algebra – The Distance Formula.
Many of us have grown up being wary about using pressure cookers, thinking the food doesn't come out tasting as good as it does through other cooking methods. No need to worry! Gourmet Magazine explains that it's not the pressure cooker that's the problem; you just need to pick recipes that benefit from the use of the pressure cooker. Here to show us how with a simple and delicious lamb and bean recipe, you will be taken through the recipe step-by-step. The ingredients are simple, including l...
Once you get started with the concept of "stair step" cards - it is hard to stop! It would be fun to try a double set of stairs, add another row for five letter words and cut letters into the bridging circles. Cut the extra panels for the front and emboss them with the Divine Swirls 'Cuttlebug' folder. Then use the Stardust 'Stickles' on the swirls to really make them pop! The extra letters from the name cutout were perfect for the envelope. Emboss the envelope with the Birthday Candle 'Cuttl...
Learn two different ways to create wavy hair in just a few simple steps. One version creates a looser and softer wave, while the other creates a more crisp and tight wave. This video emphasizes the importance of using a heat protection spray to protect your hair from the extreme temperatures. To create tight and crisp waves, use a triple barrel iron. To create waves that are smoother and looser, you can use a simple straightener. Both methods include only two steps to produce beautiful and sm...
This video explains the method making heart shaped cupcakes or Valentine Day's cupcakes. At first take the mix here the moist deluxe cake mix is used. Using that mix make the cupcake mix, for a particular pack of mix 3 table spoon of oil is added then add egg white to the mix. Then to the mix pour some water of about half or quarter of a glass. The water poured mix is mixed with a mixer. Then pour the mix in the cup cake plate placing a cup cake paper in it. Then shape it in the form of heart...
Chef Allen Susser first tells us about many different kinds of mangos and that he uses them often in his cooking. He then demonstrates how to select a mango, and then properly cuts it. Learn tips such as signs when a mango is ripe and how to choose the right one, as well as various methods of cutting and preparing mangos for cooking. You will learn how to slice or dice a mango in just seconds with a few excellent techniques. Cutting and preparing mangos for cooking is easy after watching this...
The video describes a method of doing the twiddle scratch on a DJ turntable. The sound one gets is like a double-click flair, as it’s similar to the double-click flair. In order to do the twiddle scratch, keep your stronger hand (the hand u frequently uses) on the dies while your other hand is on the log. Keep your thumb against the log lightly, and tap back and forth with your two fingers while scratching the disc with your other hand. The whole procedure is given step by step.
Chef Dennis Pitchford demonstrates his method for making this classic cocktail, which originated in Cuba. He calls it his In the black-berry mojito. He starts by putting half of a dozen mint leaves and five or six blackberries in a glass; then he adds some simple syrup and crushes this all together to release the juices. He then adds some light rum, some creme de cassis, and fresh squeezed lime juice. Finally he puts in some ice cubes and club soda, and gives it a good stir. He garnishes it w...
The author in this tutorial shows how to convert mixed numbers into improper fractions. A mixed number has a big number to its left, a numerator for the fraction part and a denominator too for the fraction part. Now to convert the mixed number to improper fraction we first have to multiply the denominator with the big number and add numerator to it which results in a new numerator. Now the improper fraction is the new numerator divided by the previous denominator. The author explains this con...
A hole in your wall may in fact be easier to fix than is seems. After cutting a rectangular piece of drywall to patch up the hole, cut out another thin piece of drywall to use as a backing. By inflating a balloon and placing it in the back of your hole, the pressure caused by the balloon will allow you to put your backing and piece of drywall in place effectively, allowing you to cover up and sand over any holes in your wall. Using this innovative method, anyone will be able to fix holes in t...
An educational video from Math Problem Generator that shows how to multiply variables. It is a very short video - about 1 min in length.
Have a 3 dimensional figure that you can not figure out the surface area? This video teaches the fundamental concepts and techniques of figuring out the surface area of a 3 dimension figure. In this video, the specific shape will be a rectangular prism. The video will assist its viewers in understanding and learning the process of how to find the surface area of this 3 dimensional figure. The method is simple and easy to learn. This is highly recommended to anyone with an interest in math.
In "How to Make Crepes", a video by Cayley Waldo, she describes one of the methods used at the Baker's Crust restaurant chain to create elegantly designed crepes. She starts by describing how to create the wrap to be used with the crepe as well as demonstrating the way to fold the crepe and also how the contents should be arranged. For the Example given, the crepe is filled with chocolate mousse and strawberries. The video then goes on to show ways that the plate can be decorated so to increa...
There are literally hundreds of thousands of ways to make a chili dish. Craig from Craig's Kitchen will be showing you one of the many ways to make a great tasting chili. His method generally takes very little time and is a great recipe for when you are on the go. This recipe calls for using chili powder or chili sauce instead of the traditional fresh chilies and dark kidney beans. Craig's special recipe is a must for chili lovers everywhere.
In this home scientist video the instructor Robert Bruce talks about cheap sulfuric acid. He says that sulfuric acid is very important in any lab both as a reagent and a precursor for preparing other chemicals. He points to the battery acid saying that it is a good source of sulfuric acid which is 35% concentrated. Now he shows various methods to obtained sulfuric acid and shows how to test one of the thus obtained sulfuric acid for its concentration. In this video the author talks about sulf...
Ever try your hand at betting on the ponies? It's a hard sport to bet on if you're just starting, and you should know everything you need to before you start, or you're just going to be throwing your money away.
In this tutorial, the author shows how to determine if a point lies on a given line which is in Point Slope Form. To show the method he takes a sample point order pair and an equation of a line in its point slope form. Now he substitutes the value of the x, y order pair and the equation of the line, and solves the equation on both the sides. If both sides match it means that the point lies on the given line, or else it does not lie on the current line. In this video, the instructor shows how ...
Many people will agree that their favorite meal to go out for is crab legs. With this video from Chef Jason Hill from CookingSessions.com, you can learn to cook crab legs at home for a nice dinner that costs a lot less than going out to a fancy seafood restaurant. Instead of the typical boiling method, we see how to cook them on the grill! He also explains how to make homemade garlic butter using butter, garlic, rosemary and thyme.
In this how-to video, the author, , Davitily, has a simple drawn out diagram of a cone figure and it's measurements, and also has the mathematical formula of how to find the surface area of this and any other cone figure.
In this video the tutor shows how to graph a straight line using the rise over run method. The rise over run trick allows you to graph a straight line as long as you have a starting point and a slope value in the form of a fraction. The first step is to graph the starting point. In the second step he states that the numerator of the slope is rise and the denominator of the slope is run. He says that the rise is vertical and the run is horizontal and shows how do rise and run using those value...
In this tutorial the author shows how to find out the missing part of a triangle that is similar to another triangle. He explains the concept of similar triangle diagrammatically by showing that similar triangles have similar angles and parallel sides. Now he labels sides of similar triangles and marks the value of unknown side as variable x. Now in similar triangles as the lengths of sides of proportionate he shows how to write a equation of proportion and solves it finding the missing part ...
Love doing science experiments? Want to impress your friends with your science skills and look good? Then you must watch this video.
By watching this lyndapodcast tutorial you learn how to use the quick file function in Microsoft OneNote 2010. This feature eliminates to regroup information, so you can send notes obtained from multiple sources to a selected page of a note book. This method called quick filing lets you send the information from the program that your using directly to One Note seamlessly.
You need an uneven number of stitches for this method. See how to do the half fisherman stitch when knitting, with this easy, up close demonstration by Judy Graham, Knitter to the Stars.
This video is truly a god send for the ladies and gents who wear glasses, and want to look good wearing them. The lady in this video explains and teaches about the various types of makeup that is good to use, especially if you wear spectacles. The lady in the video tell people who, wear glasses about the makeup they can use to look better wearing glasses, alternative makeup for different types of spectacles is the agenda, methods about how to make your eyes look smaller behind those big focal...
how-to Backup and Restore Your Bookmarks in Internet Explorer ClearTechInfo shows you how to backup and restore all your precious bookmarks in Internet explorer. These bookmarks can be used on another computer or can be restored onto the same computer if and when the bookmarks get erased or corrupt.
In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...
