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...
The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
Digital copies are being used more and more on DVD and BluRay releases. They may cost a little bit more, but they are so worth it. After you transfer the movie's digital file into iTunes, you can easily make a copy to play on your Apple iPad. This video will demonstrate exactly how to transfer a digital copy movie to an iPad.
In this video, it teaches you how to do a dance move called the windmill. To start out you use the basic move with your right hand turned and left hand straight your elbow goes into your stomach. when you get into this position you lift your right leg up then your left leg and your right leg swings under. You want to turn yourself and push off with your arm that is in your stomach. It shows hints to make it easier for you to do and teaches you that the first windmill is the one you have to le...
Backpacking through Europe is an exciting and affordable way to see a new country. This video tutorial shows female travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. As a general rule, include clothing that may be easily layered for colder climates.
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 lesson will show you how to breastfeed when you are just starting out. Breastfeeding offers babies and mothers remarkable health benefits that are lifelong. A new born baby is ready to breastfeed. But, it may not come naturally to all babies. A baby is born well fed, but, it is a good idea to bring the baby to the mother’s breast as soon as she is born. This will help the baby to connect with the taste and smell easily. A mother’s breast should be the first thing to reach a baby’s ...
Why buy something when you can just make it yourself? Instead of a store bought mini dog/cat bowl, you can easily make it for yourself. Buy some polymore clay and roll it into a very small ball. Now take your finger, and press it down on the clay until its flat, not too thin although. Next take a marker and with the bottom of it, press down so you have the bottom of it, make sure you don't go right through it. Next center a circle cutter around the pen and cut straight down and through the cl...
Want to create scenery to decorate your scrapbook? You can use torn paper to create this effect cheaply and easily. This video describes how. For example, if you want to create mountains, choose some brown paper, and tear in a jagged pattern, using your finger as a guide. If you want white-capped mountains, tear with the front side facing you. If you don't want white-capped mountains, turn the paper over and tear. You can also create other scenery. The woman in the video creates scenery such ...
Learn how to toggle layer visibility in Photoshop in this video tutorial. Nocole Young will show you how to do this easily. When you are working on any image in Photoshop, you usually create a number of layers. You would like to see what the image will look like before you start editing the image. You can always toggle the visibility between the layers by clicking the ‘eye-ball’ toggle on the right hand side of the page on the layer panel. Click the ‘eye-ball’ toggle next to a layer and you w...
Rather than throwing out your old furniture, learn how to give your old dresser a modern makeover by following this video tutorial. To begin, pull off all of the old drawers and other pieces that do not work. You will need to sand down the frame of the dresser and then replace all of the problematic parts. You may also need to rebuild the center supports so that your dresser drawers slide in and out easily. Wipe down the dresser with a cloth and then coat it with a latex primer. The primer is...
In this video tutorial, viewers learn how to tie a scarf into a bow. Begin by finding a long rectangular scarf of your choice. Now slightly twist it up a bit. Then put it on the neck and wrap it around from the back once. Finish the procedure by tying the ends into a bow. To make a bow, create 2 loops and cross them over each other. This video is very simple, easy and fast to do. This video provides step-by-step instructions for viewers to easily understand and follow along. This video will b...
Making cold brew coffee can be done simply with only a jar, water, a coffee filter, and ground up coffee. Though it seems like it would be more complex, the procedure to making cold brew coffee can be easily achieved in just a couple basic steps. The steps do not require too much work and can be done in a matter of minutes. Simple measures are taken to making cold brewed coffee, such as by mixing the coffee and water through shaking up the jar. Using a coffee filter, just pouring the mixed gr...
This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...
Go to the Menu and click the Start button. Now select Control Panel. In the Control Panel, you can see the Option Programs. Now you can see Uninstall Programs in small letters below the Programs option. Click on Uninstall Programs. Here you can see the list of programs installed, when they were installed, what is the size of the program, and which version of program is installed. To uninstall a program, simply click on the program you wish to uninstall. Some options get displayed above the ta...
In the video 8-year-old Emma makes the play dough. The ingredients needed for the play dough are flour, water, salt, oil, cream of tartar, and some food coloring to give it the color.
A wedding budget can quickly get out of hand as your planning progresses. Things like centerpieces are a major cause of skyrocketing wedding costs. If you have a little time and want to easily trim down the cost of your wedding, think about making your own floral centerpieces. You'll learn how to with this simple tutorial from EZ Bouquet. You'll soon see how easy it is to make a beautiful floral arrangement in an open container and how to secure the arrangement in the base of the container. A...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
This is an instructional video on how to decorate a cake with icing in a basket-weave pattern. You start out by measuring out the cake and placing evenly spaced marks along the side so you know where to put each line in the weave pattern. You then use a flat, rigged tip and drag the icing horizontally from one of your lines to the next line. They suggest using a turn table so you can easily access the entire cake. Then they teach you how to put a "shell border" on your cake by using a differe...
This video will show you how to tie a thick string or cord into a snowflake-like knot. Be sure to take your time, as there are a lot of loops to make. Also, you'll have to lightly pull the knots into shape a few times to retain the snowflake style. The instructor takes extended pauses to ensure that you can follow along easily. Near the end of the video, there is also a variation on the last few steps to make a slightly different knot. Whether you're a pro or novice at knot tying, you'll be m...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
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...
In this video tutorial, viewers learn how to make "Filipino Bicol Express". The video provides all the ingredients that are required to make it. The ingredients required include: 6 cups of coconut milk, 2 lbs of pork cut into strips, 1 cup of shrimp paste, 1 tbsp minced garlic, 6 pieces of Thai chili peppers, 1 cup of grated ginger, 1 large cubed onion, 2 long chili peppers, 2 tsp of cooking oil, salt and pepper. The video contains slow pace and step-by-step instructions that allows viewers t...
In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...
Now you can easily animate gradient image using Flash. For this you need to open flash, and then import an image which you want to work with. Create a new layer. Draw a rectangular. Go to color option and choose liner. You have to keep alpha in one side of gradient. Ad few key frames and use motion tween. Now go to your picture. You also make the same key frames of that. So it will be regular. After watching this tutorial you will be able to make nice gradient animation using Flash.
In this video tutorial, viewers learn how to play the song "Don't Look Back in Anger" by Oasis on the acoustic guitar. This video reveals all the string movements and the order that the notes are needed to be played, in order to execute the song. The video is at a slow pace and provides a visual demonstration for viewers to easily follow along. This video will benefit those viewers who enjoy playing guitar and are willing to learn how to play a new song.
Learn how to make old style traditional bread easily at home. 1 Prepare your ingredients and let them come to room temperature. 2 Attach a dough hook to your mixer. Put all the ingredients in your work bowl and mix for 3 -4 minutes on low until the dough pulls away from the sides of the bowl. 3 Let the dough raise for about one hour and twenty minutes. Punch down the dough for a second time. Let the bread sit about 10 minutes. 4 Preheat oven 375 degrees. Place bread in baking pan. Cook for 35...
A few tips and tricks in cooking involving artichokes. A simple trick of the trade made to use while cooking at home or even if you are out preparing artichokes on the grill. One of few examples that artichokes are known for in cooking is first by steaming the artichokes for about 35 to 40 minutes, or until you could take a knife and if it easily penetrates without being tough your artichoke is ready. This video gives you a small demonstration on what you could do with your artichokes. You co...
In this video tutorial, viewers learn how to play the song "Sad Song" by Oasis on the acoustic guitar. For this song, viewers are recommended to tune down a semitone. This video reveals all the string movements and the order that the notes are needed to be played, in order to execute the song. This video provides step-by-step narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit those viewers who enjoy playing guitar and want to learn ...
This tutorial explains how you can divide integers. Dividing integers is similar to multiplying integers. A positive divided by a positive gives you a negative number. A negative divided by a negative gives you a positive number. And a positive divided by a negative, or a negative divided by a positive, will results in a number. Some examples: -15 divided by 3. In this problem we're dealing with a negative divided by a positive. So, the answer will be negative. The answer is -5. Another examp...
This is how you can learn how to easily accomplish a parkour rail balance. When you first start out, use a rail that is close to the ground; you will probably fall several times while practicing. As you get more used to it you can use rails that are higher. Start out by walking across the rail slowly; keep your feet forward or curved, whichever you prefer. Eventually you will get faster and be able to jump from rail to rail. Just keep practicing and you will get the hang of it quickly.
The video is a straight forward Photoshop tutorial on how to create a Christmas ornament. The video shows you how to do this with very simple shapes, gradients, and a few layers. All you have to do is keep up the simple instructions. The finished product is very pleasing to the eye, a glossy, shiny, Christmas ornament. The video also provides a link to an external website where the Photoshop project files can be downloaded for reference and are easily customized.
In this video tutorial, viewers will learn how to make two pairs of simple earrings. The video provides all the materials required to make the earrings. The materials required include: freshwater pearl disk, 4 mm Swarovski crystal, bally bead accent, 2 mm silver bead, head pin, flat nose pliers, round nose pliers and wire cutter pliers. This video provides step-by-step instructions and a visual demonstration for viewers to easily understand and follow along. This video will benefit those view...
Dawn5377 teaches you how to make a pink sweet treat cup door. You need a stamp from the sweet center set and you use it on a small piece of pink cardboard. You punch the middle out. Also punch the middle of another piece of pink cardboard. Insert the treat cup door and stick it in. You use dimensionals to hold a white piece of paper, which acts like a tray under the plastic dome. You add some sweet treats inside and stick the other pink piece (with the heart) on the other side. Also remember ...
Do you want to compress your video files less than five times the size while keeping the same quality? If yes, then this video shows you how. By compressing video files you can save a lot of space. Then, it can be easily burned to a DVD or even uploaded to a file-sharing website. To do the compression, you need to use Windows Movie Maker software. Open the video file in Windows Movie Maker. Now, move all the clips into the story board. Open the option "Save to computer". Now, Windows Movie Ma...
In this video tutorial, viewers learn how to use divs in Adobe Dreamweaver CS4. Divs are container elements that are called Layers in Dreamweaver. In HTML, div elements are used where parts of a document cannot be semantically described by other HTML elements. Dreamweaver is a web development application. This video provides 14 steps for viewers to easily follow along and learn how to use divs. This video will benefit those viewers who are are interested in web designing and and want to learn...
In this video tutorial, viewers learn how to create a cartoon cloud using Adobe Photoshop. Adobe Photoshop is a graphics editing program. In this video, viewers will learn how to use multiple layers, layer options, how to create a lighting effect and use of gradient options. This video provides voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit those viewers who enjoy designing and creating cartoon or animation images on the c...
In this video tutorial, viewers learn how to weave a pouch for an MP3 player. The video lists all the materials required to make the pouch. The required materials include: cardboard, a ruler, scissors, yarn needle or bodkin, scraps of yarn or 10 crochet yarn and a marker or pencil. This video provides voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit those viewers who enjoy homemade accessories. This is for those who enjoy we...
In this video tutorial, viewers learn how to make a black and white Hollywood style glamour portrait, using Adobe Photoshop. Adobe Photoshop is a graphics editing program. Viewers learn how to create a vintage, golden age Hollywood headshot look, with just a couple layers. This video provides step-by-step instructions and a visual demonstration for viewers to easily follow along. This video will benefit those viewers who enjoy photo editing and enhancing images to the best of their ability.
OceanMistFarms, teaches you how to bake or roast an artichoke in the oven. Baking an artichoke is as easy as baking a potato in foil. Preheat the oven to 425 degrees. Spread open the petals of each rinsed and trimmed artichoke. Between the petals add olive oil, vinegar and sea salt. Stuff mince garlic between the petals. Double wrap the artichoke in heavy duty foil. Place the artichoke in the oven and leave it there for an hour. If it's a large artichoke you should leave it a little longer, a...
