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...
This video in the Software category will show you how to remove pimples and wrinkles in Photoshop. Yanik from Yanik’s photo school presents this video. Select the photo you want to work on. First you duplicate the layer by ctrl+J or select from the dropdown menu. You start off with removing those pimples that you want to remove completely. Select the spot healing or the regular healing brush. Yanik prefers the regular healing brush. Also choose a small brush size. To select a source point, ho...
This video is about how to make earring from spoons. So to do this, just follow these simple steps. Things you'll need:
Let FiveSprockets help you get rid of the green screen effect in your videos and add great backgrounds to your movies at home! By using the Final Cut Pro program, follow along as you set your green screen clip in the display. From there you select the Effects, then Video Filter and follow it down into the Key menu. Grab the eyedropper and select the green color and make it fade away with just a few simple clicks. You can crop out any areas that didn't fade away, or use the softening tool to f...
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 the author shows how to stretch objects and text in flash. To do this open the flash tool and select the radial gradient. Pressing shift key draws a shape. Go to frame 30 and create a key frame by pressing F6. Now similarly do it at frame 15. Now at frame 15 select the free transform tool and stretch the image. Now create the shape twins in the locations shown in the video. Repeat the same process for a text starting with adding some text to the scene. Finally convert i...
Tasktutorial will teach you how to create a nice vector cartoon flower using Adobe Illustrator. Start by selecting Rounded Rectangle Tool, and draw a black rectangle. Then select multiple points and move it according to the video, using arrow keys. Then draw an ellipse with the Ellipse Tool, using the Shift key. Watch the video to see the remaining easy steps in creating a vector flower using Adobe Illustrator and also get some cool tips and recommendations for best results.
clipping mask Sponsored by SimpleRetouch.com Start by creating a task with the name Mask, then Choose a color and a font size.
Want quick access to your voicemail using your BlackBerry device? Instant voicemail access is available on the BlackBerry device. But how? Best Buy has answers. The Best Buy Mobile team explains how to quickly dial your voicemail on a BlackBerry by using the shortcut of holding down the "1" key.
This video tutorial demonstrates a mouse-hacking simple prank sure to annoy any friend or colleague. To replicate this hack, you'll need a mouse and a musical key chain. The steps are roughly as follows: First, open up the mouse. Looking inside, find and remove the scroll wheel, then pull out the mouse's old cable. Take a musical key chain and open it up. Find the musical module with two red LEDs. Carefully glue them to the right-click. Then put the LEDs where the mouse's laser is before fitt...
What if you could have a secret hard drive connected to your computer that only you could activate? You can! Samimy shows you how to hack a remote controlled toy car and make a super secret hard disk drive in your computer, accessed via a secret activation key. This hidden emergency HDD can only be controlled by your key, regardless of how many people use your computer.
If you didn't know already, December 5th, which is today, is the Day of the Ninja. It's an unofficial holiday where people across the world dress like a ninja, engage in ninja-related activities and spread information about ninjutsu online. But for web-gamers, the Day of the Ninja is the best time of year to get some Ninja Saga action in.
The truth is, it's not about how many repititions of an exercise you do; it's about how well you hold the form and what kind of exercise you do. Heck, you could probably do 1,000 sit ups a day and still have some extra flab on your belly. That's because sit ups only tone the upper portion of your core, making the rest liable to grow chub.
Daniel Martin, a magician and escape artist, explains his technique for getting out of thumbcuffs. Disclaimer: We're pretty sure it's not illegal to know HOW to escape from thumbcuffs... but we're 100% sure it's illegal to actually escape when detained by law enforcement (just sayin').
Watch this science video tutorial from Nurd Rage on how to make silver different colors by electrochemical anodizing. Without using paint, you can give a silver surface various colors by anodizing it.
This video tutorial is for educational purposes only. See how to pick a normal lock with a tension allen wrench and a small screwdriver.
Many have tried to prove (or disprove) that tennis ball lock picking really works, but it still seems up for debate. Mythbusters have supposedly debunked this technique (watch the video). Someone over at the Auto Blog also has tested this car lock method with failed results (watch the video).
Want to master "Tighten Up" by the Black Keys? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and its constituent riffs. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Tighten Up" on your own guitar, just take a look!
In this video, we learn how to access Casio G'zOne Brigade QWERTYShortcut. From your idle mode with the flip open, press the middle button. Then, press '9', which is settings and tools. After this, press '7' or scroll down to 'phone settings'. Then, press '2' for shortcuts and then press '3'. After this, go up to text message and select the center key to set. Now, from the main screen you will be able to start composing a message just by selecting any key. This makes it easy to write a text q...
In this video, we learn how to take apart a computer's keyboard & clean it. First, turn the keyboard upside down and remove the screws from the side with a screwdriver. After this, flip it back over and remove the keys from the top. Put the keys into a bowl of soap and water and let them soak. Then, remove the screws from the top of the keyboard and set them aside. Open up the keyboard and then dust and clean the inside of it until clean. Next, you will replace all of the parts you removed in...
In this video, we learn how to create a melody around a vocal in FL Studio. Start to play around with the melody to the song and change the tempo to how fast you want it. Then, move around different sections to create the exact sound that you want. Finish editing all of the bars on the song until you have it to a sound that you like. Use the keys on the left hand side of the screen to help show you where you are editing the keys at. Then, use the different filters to make the song sound how y...
In this tutorial, we learn how to make a piano sound for a breakdown in FL Studio. First, create chords using the keys that are on the left hand side of the screen. After you have created all the chords that you want, then copy the notes and space them out so they are in the order that you would like them. Next, you will need to make sure each of the keys are in tune by tuning them one by one. When finished with this, add in effects that you would like for the song. This will finish up the pi...
In this tutorial, we learn how to make an emotional anime beat in Fruity Loops. Start out by playing the different keys on the side of the screen where the keyboard is. After you have found a combination of keys that you like, start to add in different effects to this. You can also use a template that has an emotional beat already created on it. Use piano, drum, tempo, and anything else to change the sound of the beat as you would like it. Edit small parts of the beat as you continue through ...
In this tutorial, we learn how to fix a leaking faucet. You will need: a utility knife, screwdriver, Allen key, socket wrench, and adjustable wrench. After you have these, turn off the water to your house. Then, cover your drain so you don't have any parts fall down it. After this, use your screwdriver to take the handles on the faucet off. Then, use your socket wrench to remove the screws from the insides of the handles. Next, use the Allen key to remove the inside gasket from the inside and...
Giant Steps is quite popular for being an incredibly difficult song to play seeing as it's a string of II, V, I chord changes in three different keys, among other changes that are inherent in the song. Thanks for making our lives more difficult Coltrane! If you're having trouble making your way around the neck and improvising this video can help! He talks about similar tonalities out of each chord change and scale connection between different keys. Just be careful because the audio goes out o...
Unless you're a music theory buff or taking AP Music Theory in school (forced or otherwise), then the only word in "diatonic circle chord progressions" that makes sense to you is "circle." But the fancy schmancy term is just an elaborate way of saying you're playing chord progressions based on the circle of fifths.
In this tutorial, we learn how to rotate and revolve cameras in Maya. First, go to create primitives on the menu at the top. Next, create a camera and pull it out onto the circle. Now, click the camera and then the circle, then hit the 'p' key on the keyboard. Now, you can rotate your circle around and it will rotate on the y axis. To set this, click on 50, then type in 360 on the 'y axis' space. After this, hit 's' an you will have a key frame. You can change the settings as you prefer, then...
In this video tutorial, viewers learn how to choose a drill. There are 3 types of drills: cordless drills, electric drills and rotary hammer drills. cordless drills run on batteries and have a hammer setting. cordless drills are able to drill into concrete with mason drill bits. Electric drills last much more longer than cordless drills, but are limited by the extension reach. Rotary hammer drills are only used to drill into concrete. Some drills require a chuck key. Others have a key-less ch...
In this tutorial, we learn how to balance your plate to lose weight. These are keys that dietitians say are the keys to losing weight. When filling your plate for a meal, always fill half of the plate with fruits or vegetables. Fill 25% off the plate with protein (meats) and the other 25% with grains or starchy veggies. This will help you lose weight and eat more nutritionally when you see more food on your plate, but it's healthier food instead of junk food. When eating breakfast, don't just...
In this Software video tutorial you will learn how to use tool shortcuts in Final Cut Pro. To change opacity and the volume limit, click the little mountain button on the bottom and you will have two lines in the clip representing audio lines of two mono tracks. And you also have opacity located above the audio lines. With the help of the slide bar you can set the opacity. To get the pen tool press 'P'. To get out of any tool, press 'A'. To delete the entire audio track, select it, lock, dele...
In this video tutorial, viewers learn how to minimize or close multiple windows on a Mac computer. The technique shown in this video allows the user to simply close or minimize all the opened windows all at once. To close all the opened windows, hold down the Option key and Close button. To minimize all the open windows, hold down the Option key and Minimize button. This video will benefit those viewers who use a Mac computer, and would like to learn how to close or minimize all the opened wi...
Football is a dangerous sport, but playing smart and safe is the key to making sure you're not being hauled of the football field on a stretcher or in a neck brace. It's not one-hundred percent preventable, but how do you minimize the risk of potential deadly injuries to young football players? This video will show coaches a few drills to teach their young athletes to minimize catastrophic neck injuries. And the key is staying low at the line.
In this video, we learn how to create a picture frame on a photo using PhotoShop. First, open up the program and open the picture that you want to change. Next, select the rectangular marquee tool from the toolbar on the side. Now, create a selection of what you want to frame. Then, click with the right key and select "inverse". Click again with the right key and choose "layer via copy". Now, click 2 times on the layer to open and the layer style menu will show up. Now put the contour to crea...
When it comes to confidence you must first understand where you are confident and where you are not confident. The video talks about people asking how to get confidence. If you are asking that question then you must be aware of an area of your life you are not confident. Also there must be areas of your life that you are confident even if it is by yourself making a cup of tea. If you are just being you and not measuring yourself against something or someone else then chances are that you will...
The video shows a quick tip on how to get the best value out of one's BlackBerry Calculator. First, it instructs one on how to access the calculator application from the home screen:
In this how to video, you will learn how to open a locked zippered luggage bag. This is very useful if you plan a trip and forget the key to the lock of your luggage bag. All you need is a normal pen. Remove the lid of the pen. Apply pressure in between the zipper. Once you get through, slide the pen all the way around to open the luggage. This will open the luggage and you will have access to the entire inside. Once you are done, you can close it back with the pen or the zipper. It will be u...
How to make a Prima "Pastiche" Paperbag Album. The demostrator shows us how to make a Prima "Pastiche" Paperbag album. Take a french paper, apply fix some pearls, old keys, artificial flowers, key mantle, all this for the back cover of the album.
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
This video shows the method to suture arterial lines using a curved needle. We will use the new arterial line kit for our demonstration. We will use a curved needle as it is safer than the straight needle. Hold the suture with the hamostat at about sixty percent from the tip of the needle. Do the turn the key method to bring the needle out from the other side. Unclamp it and re-clamp it at the tip of the needle. Continue the turn the key method. Pull the suture up and through. Cut the suture ...
This video teaches how to build up finger speed on the piano. First they start off with simple exercises. The five note scale starts with middle C, and plays the five notes up to G and back down. The key to building up speed is to start off slow. Make sure all of the keys are the same volume and then go faster. Now use your other hand. Then use both hands to make the high f octave scale. Change it up by adding a blues song scale, this is useful for playing a blues song and adding a fun sectio...
