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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
This video illustrates the method to Set up a Remote Desktop connection on a Windows PC. This process is composed of the following steps: Step 1Install "TeamViwer" software on the PC's which would be involved in this process.Step 2Create a connection between the computer you want to access remotely and the one which would be used to gain remote access. To create a connection , you need to connect them through Wi-Fi, LAN or through the internet.Step 3Open the TeamViewer software from the compu...
Whether you're new to Adobe InDesign or a seasoned graphic artist after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to get all the benefits of real-time, on-set logging even when working with tapeless cameras with OnLocation CS5.
It's summer again and it's time to get out of the house and there's no better way than with a fun game like some improvised baseball. You don't need a whole team of people all you need is a bat, a ball and another person to play with.
In this tutorial, Sandra Lee shows us how to make a family favorite rump roast with a new twist. Sandra adds a tangy Madeira wine sauce to her roast and creates an unexpected dinner. Try this twist next time you make a roast and you will surely impress even the pickiest eater.
This video is on Golf and will show you how to use the variable tee drill to cure a pull shot in golf. This video is from Golf Link. A typical problem for somebody who tends to pull the ball is they position the ball too far forward. So, when they are setting up, the shoulders are actually looking left. By the time the club head reaches the ball during the swing, they are swinging around to the left producing the pull. The variable ball position drill will cure this problem. Place a club on t...
This video shows you how to light a bottle with long exposure in photography. The end result is to have a picture of a bottle with glowing edges with a black background. For starters you set your SLR camera settings to a 30 second manual shutter speed and a f5. 6 set aperture. Put the camera on a tripod for steadiness and set up your subject. For the subject, on a table, place your bottle in front of your chosen drop cloth. It is best to choose a color similar to the bottle. Then you use a li...
Tass is here to show viewers a video walk through for the game Horror Plant, revealing both endings. The focus of this game is to set up victims for a meat eating plant to devour along the journey. Starting fires, setting up gruesome traps and fooling poor souls is the name of the game. The horror plant is also revealed to be something of a hero to other non-human comrades as it saves and even shares meals with them along the way. One ending shows how adding certain ingredients to another vic...
Open your internet browser, type in the address bar 192.168.1.1 and enter your user name and password to access. Look in the right and search for Port Forwarding / Port Triggering. Click on Add Custom Service. Type a name to the service, like XBox Live, now access HushedCasket and scroll down to see the ports you need to open. Go back to the setting and select UDP in Service Type. Put 88 in Starting Port and Ending Port. Go to your XBox and enter in System Settings, go down to Network Setting...
Learn how to avoid dry skin that develops on extended airplane flights. 1 Buy a small sprayer (under three and a third ounces, due to airplane security) and lip balm. 2 Every hour that you are on the airplane, spray your face once with the sprayer's fine mist setting. 3 Do not wipe off the water and apply a thin layer of oil free moisturizer. 4 Apply lip balm every hour.
Mother and daughter duo Christine and Kim show techniques on how to cook bacon the right way. Place the bacon and space it properly on a cold pan. Slowly turn on the heat and put the timer on 4 minutes. Let the bacon cook and avoid touching it until the 4 minutes are up. Using a pair of thongs, make sure to flip the bacon so that it falls flat on the surface of the pan. After turning down the heat, set the timer to 3 minutes and let the bacon cook. Flip the bacon one more time and set the tim...
In this video from Dehstayne101 we learn how to create a scene hair style with clip in extensions. For this you will need conditioning hair wax, styling mousse, blow dryer with a cold setting, hair spray, and a teasing comb. Part your hair and tease where the clips will go so they do not fall out. Tease it again, then put the clips into the teasing and snap it in. Then put in iridescent gloss polish for a nice shine. Then use styling mousse to spike your hair a bit. Now blow dries on cold to ...
In this video the author shows how to install any version of Linux from a USB thumb drive. He gives the requirements, which are a USB drive, the ISO of the Linux OS and a program called UNetbootin. He shows how to download the program from Sourgeforge.net. After installing it he shows how to set the version of Linux in the program. Later he shows how to format the USB drive quickly and he goes on to set the USB drive option in the UNetbootin program. Now all the Linux OS will be copied to the...
Learn how to create glowing text in Photoshop with this awesome video! 1. Write any text using text button T on the selected image as a background. Write a suitable text and place it somewhere. 2.Select the text and make it Bold. 3. right click and set Opacity and Fill options. Opacity changes the color of the text as well as its effect. Whereas Fill changes the color only . If you have set it to 0% then you can't see the text if its exist also. Set Opacity to 100%. 4. For glowing text select...
This video tutorial is about adding an infrared effect to an image using Photoshop. First of all, open the image to which you wish to add the effect. After that, create a duplicate layer. Then go to the image option and click on it. A drop down menu appears. From that menu, click on adjustments and from that, select the option channel mixer. In the small window that appears, first tick the monochrome option. The idea of the channel mixer is that the total percentage of the colors must add up ...
This video shows how to properly set up a green screen, to set up the screen we are taking into account this four factors:
New user to Windows 7? Microsoft has put out a series of video tutorials explaining how to maximize your Windows 7 experience. Follow along with this computer lesson and learn how to:
Let's set the scene: Great New York loft space, with seemingly A+ hosts and dinner party guest Sam Fogarino (of the band Interpol) making the main course: Pasta Pomodoro. Um, may we say très chic? So upper east side. Enjoy this video which acts as a great how to on how to throw a great dinner party, mixed with a delicious recipe for Pasta Pomodoro.
Many people use mastic when applying ceramic floor tiles, not realizing that mastic will never completely set and is thus vulnerable to cracks if you put a lot of weight on it. Thinset is actually a much better product for a job like this. In this video, Tim Carter, of Ask the Builder, will show you how to use thinnest to apply floor tiles.
Ever wonder how screen printed t-shirts are made professionally? This awesome tutorial takes you through the process, starting with the design on the transparency screen, to printing, to the press bed, then to dry. Make sure to listen for advice on how to keep your ink on your t-shirt by heat setting the t-shirt after you're done screen printing.
This trick can be done anytime, anywhere, with one of the easiest props ever: a matchbox. The props couldn't be simpler: just find an empty matchbox that has the same design on both sides. Set it on the table with the inside tray facing up (we'll call that "right side up") and start making a simple game of balancing the box with one side on the edge of the table and the other on your fingertip.
Team USA's Stefanie Nation on setting up properly in the stance. Pick up some bowling tips and tricks to improve your game, whether you are a beginner or a competitive bowler in a bowling league. Learn how to use the proper bowling stance with this bowling video.
This video instruction shows you how to hit a forehand lob in squash. 1. With the lob, set your racket early
Need rope, but don't have any. This is a great emergency trick for making rope with plastic bags. This video demonstrates a simple method for converting your used plastic bags into rope. It requires only bags and a working set of hands.
Basic 1pt and 2pt perspective drawing. This is a CAD video, but it is designed to teach you how to hand draw everything. The draw three dimensions, off the paper and in the Z plane, one must have a very good idea of how the setting appears.
Imagine a game almost anyone can play that combines the best of skee-ball, bowling, and shuffleboard. Welcome to the ancient sport of bocce.
Customize your vehicle, watch this video tutorial on how to install a billet grille set on a 2008 Toyota Tundra. This shows the process of installing the complete Carriage Works brand billet grille on your Tundra.
From the Fallout 3 SuperGuide on MyCheats. MyCheats staff writer Mike Nelson talks about his favorite exploits and tricks in Fallout 3.
Petrilude brings you this Halloween makeup tutorial on how to create a ventriloquist dummy look. Ventriloquist dolls have really deep set creases and lines, so emphasize this with makeup. Ventriloquist dummies make great Halloween costumes, so follow along with this Halloween makeup tutorial.
In this software tutorial Barton Damer explains the hidden secrets behind Adobe Illustrator's pattern brush. Watch and learn how to create an intricate and unique pattern with the pattern brush in Illustrator CS3. Some of the graphic elements used in the tutorial come from the Go Media arsenal sets.
This software tutorial series teaches you how to box model in 3DS Max. Specifically, you will learn the basics of box modeling in 3D Studio Max, then box model a jet and animate it for PaperVision3D.
This music production software tutorial teaches you how to achieve realistic, humanized scratches in a recordable, metered way in FL Studio. The lesson includes a brief introduction to the FL Scratcher and a few ideas on setting up FL Studio for maximum versatility.
Check out this instructional video to learn how to hack a prop ghost to fly continuously for your Halloween display.
Check out this instructional video that shows how to set up a prop static ghost for Halloween.
This tutorial shows you how to download, install and use the free program Stop Motion Animator. See how to set up and configure your animation settings, how to set the proper compression and then use the camera on your computer to shoot the frames for a stop motion animation. When finished, just output directly from the Stop Motion Animator software and you'll have your stop motion film done. Stop Motion Animator makes creating films as easy as this three minute tutorial.
This video tutorial demonstrates how to make a flying tea bag. You only need is a cheap tea bag and a match to set it off. The tea bag remains are so light that the hot air produced from the ashes is enough to make them lift into the air. This experiment is slightly dangerous, so be careful!
This how-to video shows a guaranteed, never fail way to get even the hottest girls at the bar to talk with you for at least 20 minutes.
This video explains how to vanish the deck and reappear it again. Easy to perform, but it takes some set up and practice.
This video demonstrates how to set up your computer to play WoW with a Wii remote. The video walks you through downloading the correct programs to your computer, connecting the Wii remote to your computer, and playing WoW with the Wii remote.
Learn how avoid getting drunk and look like you are drinking while still staying sober. Avoid getting drunk at business meetings with a client who wants to booze it up. This is a great set of instructions from Burn Notice resident ex spy Michael Weston.