Heather Gold teaches us how to use "tummeling" in conversation mechanics in this tutorial. When you are having a conversation with someone, you need to know that it is not all about you. You will need to appeal to other people's interests and shift from everything being about you to the other party involved in the conversation. When you are performing or speaking in a large group, you will want to talk like a realistic person and make sure you are not saying something that isn't interesting o...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
This video tutorial is in the Computers & Programming category where you will learn how to use caret browsing. Caret browsing is a method of selecting text on any web page. You can activate caret browsing by pressing the f7 button on your computer. It is available in Internet Explorer and Firefox browsers. Normally, for selecting text on a web page, you highlight the text by clicking and dragging the cursor and then you can copy and paste it in to a text editor. While doing this, if there are...
In order to prevent accidental CAP LOCKS, you can use a number of new, innovative and free software solutions. With your Windows 7, there are functions available to assist you.
Make sure you take good care of your new bike. Just like a car, every once in a while you will need to tune up your bicycle.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
In this video tutorial, viewers learn how to fix a frozen iPod or an iPod with water damage. Begin by shifting the iPod into hold mode. Then push back the hold switch. Now hold the center and menu button until the apple logo appears. To take care of water damage, put the iPod in a bag of rice for about 1 day or as much time needed until the water is completely gone. This can also be done with other water damaged electronics. This video will benefit those viewers who have an iPod and want to l...
This is a terrific video on how to whiten yellow teeth in Photoshop, taught by Link. First, he zooms in on the teeth and uses the quick selection tool or magic wand. This is a pretty easy task. You just have to click and drag. If you put too much of the gums, you can hold down alt, then drag the areas you don't want. Make sure you use a small brush when using these modifications. All you have to do then, is go into the heat saturation and select shift-control-I, which inverts the selection. T...
In this tutorial Photoshopuniverse describes how to create dotted lines in Adobe Photoshop using the brush palette. First create a new blank document in Adobe Photoshop. To open brushes palette, go to menu Window - Brushes. By adjusting spacing and hardness of brush under Brush Tip Shapes menu you can draw desirable dotted lines. To get uniform circled dots uncheck Shape Dynamics box. By holding the shift key click and drag to get a straight dotted line. To create bullet holes or perforated h...
Who would you back in a race between a scooter and a sports car? And which would you rather be driving? Changing speed is at the heart of top-level soccer performance, so every player needs a smooth-changing gearbox to win the races that matter over ninety minutes. Nike Bootcamp's High Gears drill gives you the tune-up you need to shift up and down the gears with ease when that match-winning sprint is on – for the loose ball, the last-ditch tackle, or that glimmer of a goalscoring chance. Nik...
BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a feeble grind on a BMX bicycle.
When it comes to working with people, the photographer can face quite a challenge. Everyone has a mind of their own, and with these few tips you will know how to advise your subject so they look fantastic in a picture. Join Erin Manning, professional photographer, as she shows us 5 handy tips for working with people.
Gypsies have been regarded more with disdain and whimsy in the past. But recently, with the arrival of Shakira's music video "Gypsy," gypsies seem a lot hotter as well as beautifully whimsical (of course, Shakira's gyrating hips may have had something to do with this shift in thinking).
The first License Tests in Gran Turismo 5 on the PlayStation 3 to unlock are the National B License Tests. Once you've unlocked them (which can be done by simply purchasing a car) you can start playing the challenges. This video will show you how to get the gold trophy on the third one (B-3).
In this tutorial, we learn how to operate the backup camera on the 2010 Prius. The Prius models can come equipped with a navigation and a backup camera. When you shift into reverse, the navigation screen will change to show what the camera sees behind the vehicle. You will also hear a repeating beep to indicate that you are going in reverse. This is a great tool to use while you are backing up your vehicle, which can help you avoid small things in the road. This is also a great tool to help a...
You can resize keyframes in Adobe Flash and you can do this for anything like images, animation etc. So to do this first click on your first keyframe and hold down the shift key and then click on the last keyframe. Now select the free transform tool and resize that as showing in the video but it only resize the keyframe on which the header currently is. So now this time right click on the keyframes and choose copy frames. Now make a new layer and hide your old one. Now select the pencil tool ...
In this tutorial, we learn how to create a cool blend text effect in Illustrator. First, open up Illustrator and draw a path, then change the color to black. After this, click on the line and type in your desired text. Increase the font size to 36 points, then select the red color. After this, copy your path and select the duplicate button. Now, move the duplicated path and change the background color to yellow. Now, scale the path and resize, then place on to of the red path. When finished, ...
In this video, we learn how to clear Firefox location bar and browsing history. To get rid of an individual one, use your keyboard to go to the one you don't want. Then, press shift+delete and that one will be deleted. To remove them all, go to tools then click on "clear private data". Check the box of the browsing history, then click on the button to clear all the data. If you still have items in the list on your browser, then that means you have those websites bookmarked. To remove those, y...
In this video, we learn how to do the rack and crucifix jiu jitsu position. Start by starting in the cross position with your grip around the opponent, pushing their arm up. Now, lift up your forearm and it will prop them up to their side. Now, swing your legs over and catch over top the arm on their body. Now you can swivel to perform a neck crank. From this position, there are a lot of submissions you can do. To get the crucifix position, shift your leg back and fall backwards. Triangle you...
In this C4D user's guide, learn how to ctrl-drag axes to bypass the object axis tool; how to change a group axis with several selected items; how to set a light to negative values to make darker areas; and how to undo camera (view) moves by choosing "shift-command-Z." Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more i...
In this video tutorial, viewers learn how to lift a dropped motorcycle. Begin by turning off the motorcycle engine. Make sure that you don't have any health issues including a bad back or knee. Check the motorcycle to see if there are any leaking fluids. Make sure the bike is on an incline or decline. Pull down the shift lever to put it in gear and pull the side stand down. Now put your body against the motorcycle seat. Use your hands to grip the motorcycle ad legs to lift it up. This video w...
It's not easy being a cat. After all, sleeping twelve hours a day really takes its toll on your body after a while. Give your cat a break from her difficult day shift by crafting one of these adorable felted cat chew toys.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
This video illustrate us how to hit the baseball the right way. Here are the following steps: Step 1: First warm up your body as hitting the baseball requires a lot of your energy.
In this video tutorial, viewers learn how to use the Filter Key features on a Windows 7 computer. Begin by opening Control Panel and select Ease of Access. Under the Ease of Access Center, click on Change how your keyboard works and click on Set up Filter Keys, at the bottom of the window. Now check the box beside Turn on Filter Keys. Users are provided with several options for he Filter Keys such as: turn off the Filter key wen Shift is held or 8 seconds, display a warning message when turni...
In this how to video, you will learn how to practice without a Bodhran and make your own tipper. This is useful if you do not have enough money to buy a Bodhran or you want to practice silently. To make a tipper, buy skewers from any place. Take about 14 and put the together. Tie them together with 2 rubber bands. You can get different sounds depending on the distant of the rubber band from the end of the sticks. Next, you must get a practice board. A clip board can be used for one. You can m...
This video shows you how to keep your itunes library, music information, and song ratings intact after reinstalling your computer's operating system. Before you begin the reinstallation process, you must make sure your music is in the same location and will be in this location after the reinstallation process. After reinstalling, open itunes while holding down the shift key. In the window that pops up, click on the "choose library" button. Locate your itunes library file. This should be an "i...
This video tutorial will teach you how to use the onscreen keyboard on the HP touch smart. Very informative video that goes through several steps including teaching you how to add an event to your calendar. It starts by showing you how to add the event and then takes you through the keyboard and teaches you how to capitalize your words using the shift key as well as caps key. It demonstrates the input panel tab and how to move your panel as well, teaching you all the techniques for good use o...
In this how-to video, you will learn how to downgrade an iPhone or iPod Touch to 3.1.2. First, download the correct firmware model. Hold the home button and power button. Release the power button when the screen turns off. Make sure the device is plugged in while doing this. This will put the device in recovery mode. In iTunes, hold shift and click restore in the device screen. Next, navigate to the firmware you downloaded and click okay. This will downgrade the device to the firmware you dow...
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
Open your first image and go to the rectangular marquee tool and select all of the image. Next click command or control C to copy image. Then go to your second image and click command or control V to paste the image. Select both the layers (hold down shift when clicking the layer), then go to edit, auto align layers and choose the top option then click ok. Last add a mask to your top layer, this is done by selecting the gradient tool (make sure its set black to white, the mode is normal and o...
In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...
A step by step video tutorial that shows you how to change the tire from a Triathalon or road bike! Don't get stuck with a flat tire in the middle of nowhere! Gear West Bike and Triathalon show you how to: shift into the smallest gear, release the brake, open up the quick release and remove the wheel, remove the tire and tube, inspect the tube and tire, Install a new tube and remount the tire, reinstall wheel with quick release and close the breaks. Very basic, easy to understand instructions...
Learn how to make an owl Halloween card using the Cricut Storybook cartridge: Mary explains how to make a 5 x 5 inch square Halloween card in a few simple steps. On page 34 of the Cricut Storybook manual you'll find the owl. Cut the owl at 3 inches out of the darker brown by hitting shift and the owl. Then cut the owl out in the shadow and layer it. Give the owl big google eyes. Cut a tag out of Tags, Bags, Boxes and More at 4 inches. Then run it through the crimper. Then cut the letters W-H-...
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.
Do you want to add some 3D effects in your 2D designs? Open illustrator and draw an oval tool holding shift key. Then draw an ellipse with a different color and place it on the oval. Take blend tool,then click on ellipse shape and then oval one for a gradient effect. Draw another oval with a gradient and give it screen. Your glossy sphere is ready. Adding gloss, specular highlights as well as shadows adds some realism to one's art work.
Want to create some cool effects in illustrator? Create a new layer. Draw the ellipse tool and add radial gradient, then go to transparency and select screen. Then create the star tool and deselect stroke. Drag and place the star shape on ellipse and group them. Then duplicate that layer to make multiple sparkles on different layers. Resize other sparkles by holding down shift key. One can change colors of other sparkles. This will help you in making a good background.
