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 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
Whether you're new to Adobe Photoshop or a seasoned graphic design professional after a general overview of CS5's most vital new features, you're sure to be well served by this (17-minute) official video tutorial from the folks at Adobe TV. In it, you'll learn how to do each of the following: realistically blend colors on canvas with the new Mixer Brush; create superior composites for print or web layouts with new technology that makes it easy to select even the trickiest image elements, like...
In this video tutorial series, DJ Sarah Main explains how to become a working professional DJ. She offers tips on how to set up your digital DJ rig, cueing up tracks in the mix, and cataloging your music library. In the second half of the series Sarah shows how to mix tracks with the cross fader, and progressively layer audio elements.
Head Judge for the World Latte Art Championship, Paul Meikle-Janney, shows how to make a latte using the Brasilia Opus Sublima espresso coffee machine. Paul briefly explains that the process is somewhat similar to creating a cappuccino, noting that the major difference is how much foam you'll be creating on top of the beverage. This video shows the necessary steps taken to create the latte, creating the foaming texture and the single espresso at the same time. During this process, Paul offers...
In this video from modernmom we learn about doing abdominal exercises when pregnant. These exercises prevent lower back pain during pregnancy and when you're ready to push the baby out makes it a bit easier. On a mat, place sit balanced with your butt on the mat and place your hands behind you. Stick your leg straight out. Pull it in and crunch and lean back. 10-15 on each leg is good. This is all done sitting. Think about pulling your belly button in. Next is double leg pulls. This is a bit ...
This how-to video is a vibrant and animated tutorial on how to paint children’s furniture: in particular, a little girl’s tea table and chairs. It’s fast paced yet easy to follow. The video couple takes you from the taping and preparation of the table and chairs to the completed and professional quality finished product, which would thrill any little girl. Their method of communicating the most important steps is to race to the camera and speak to the audience, in an amusing sort of wink, whi...
Learn the freestyle move called "around the world" or also known as ATV. This is done with a football or as Americans would call it, a soccer ball. Newer freestylers should start this trick from foot stop which is just balancing the ball on the top of your foot. In the video it is done while bouncing the ball on the foot which is more advanced. A common mistake to avoid is to kick the ball up and then move your foot around, you need a single fluid movement. ATV can be done either inside or ou...
Professional trainer Joel Harper shows us how to do the Tick Tock runner's ab workout. -Put your feet all the way together, put your hands in prayer position and bring them above your head.
Make the perfect decorative cake for a soon-to-be-mom's baby shower with an impressive baby-themed cake topper! In this two-part video tutorial, learn how to shape a mini baby carriage out of gumpaste for an exquisite cake decoration, sure to impress any party! Learn step by step how to assemble, mold and shape this cake piece to lend professional-looking results.
Looking to make your next cake stand out? How about giving it that extra "umph" with a unique cake decoration topper? In this three-part video tutorial, learn how to make an adorable angel cake topper out of fondant icing. Get step by step instructions on how to take pieces of molded frosting and turn them into this perfect & professional looking cake accesory.
To do the samurai chop grab a medicine ball with both hands. Put your feet adjacent to each other (keep them very close). Lift the medicine ball up and to the left of your body. Then bring it down and to the right of your body. After this you can do it on the others side, up to the right and down to the left. For beginners 6-10 repetitions recommended for each side and for the more advanced 11-14 repetitions. If this is too easy lift your left food up and then bring your medicine ball up and ...
Got a new Vivitar 285HV and having trouble using the flash? No problem! This video will describe how to use the flash on your new camera and gives some other great tips for new owners! The flash on this camera can be a little different to use than an automatic flash because you have to manually set the settings. Since you can see what the picture looks like if you aren't satisfied you can use the tricks in the video to play around with the flash settings until you get the perfect shot.
This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...
In this video, viewers learn about factory maintenance schedules and how to care for a vehicle. The series explains the differences between repair and maintenance, and the difference between do-it-yourself repair and professional auto repair services. Tips address choosing an auto mechanic and following factory and maintenance schedules. Increasing your vehicle's safety, reliability and longevity through proper maintenance also is discussed. This video will benefit all viewers who own a vehic...
This video speaks about removing sensitive information in Adobe Acrobat 9. The viewer might get a very obvious idea of removing sensitive information by redaction. Redaction is the process of permanently removing sensitive information from a PDF file. This is done by opening the Advanced menu, clicking "Redaction" and then clicking "Show redaction tools", which can be in any format, images or text. The viewers will definitely get a clear idea of removing such sensitive information by redactio...
Photoshop Universe shows you how to add a simulated ray of light to your photos. They give you advice on how to use levels, the radial blur filter, and the lighten color blend mode. You can give your pictures a nice added touch by learning this simple and easy to understand technique. A great tutorial for beginners, and a useful tutorial for even more advanced users, these are easy to learn and extremely useful tips and tricks that all Photoshop users should know.
The Video On Demand highlights how amazing backgrounds are inserted behind characters and will show you how to composite video so your characters can seamlessly move in front of these images. Computer generated video objects may be superimposed over a background video image so as to create the illusion of a single composite scene. The leading edge of an object is detected and for a period of time the object and background video signals are mixed. After that period, only the object video is tr...
Rick Vanman reveals the secrets to professional video effects using your own computer software. Position your model houses into a setup of your liking. Take a picture of the houses with a digital camera using the macro setting. Edit your picture in Photoshop. Disguise any unwanted objects with the cloning tool. Separate the foreground and the background of the picture into 2 different layers. Film yourself in front of a green screen. Key out the green with your video editing software. Using y...
Even if your Photoshop knowledge is lacking, you can still learn how to make a 3D image into a 2D one. This video is on the long side, but it is also very informative and makes it so anybody can understand the lesson within. As you watch, not only will you see the steps needed from beginning to end, but you will also hear the directions in clear and easy instruction. You will learn to make a 3D butterfly and 3D fire. Great for beginners and advanced learners, too.
This video, produced by Photoshop Universe, teaches how to reduce beard stubble or 5 o'clock shadows from male pictures. We are shown how to use the dust and scratches filter, layer mask, as well as the advanced layer style command "blend if" on the underlying layer helps us to make this possible. The first step is to duplicate the layer and then select filter, noise, and dust and scratches. The second step is to apply some dust and scratches to the beard selection. Finally we blur the layer ...
This video shows an explanation for an Advanced Edge Pairing method for the 5x5x5 Cube. The method used is as follows. First, you should match up edges on the middle layers (in the build ring) to form complete "tredges," or triple edge pieces. Then replace and store these tredges on the Up and Down faces of the cube. This method CAN be applied to any size big cube!
Correct the midtones (the coloring) of your photos with this easy to follow guide on using the Photoshop program. Make the true colors shine through and brighten those washed out photos with just a few simple steps. He shows you how to make the improper colors show themselves with just a few clicks of the mouse and then how to fix them with ease. Don't waste precious money having a professional retouch your photos when you can do it from the comfort of your own home by calibrating the color o...
This how-to video shows viewers how to create their own custom paint job at home by yourself. The segment is a continuous video in fast forward. The video explains how to do everything from taking molding off, sanding the old paint, fixing the dents with bondo, to the actual spray painting of the car. The person in this video uses an airbrush, spray-paint, paint markers and canned paint to create his custom paint job. The artist paints a picture of pirate ships, skulls, and other various obje...
Photoshop is a wonderful tool for photographers, from amateur to professional. If you have photos of waterfalls that you would like to tweak to make the water appear smoother, this video will walk you through the process step by step. If you are using a digital camera or don't want to use a tripod, then the only way to smooth out the waterfall is to use editing software like Photoshop. By following the easy to understand instructions in this video, you can edit your photos to look exactly how...
With yet another great instructional video Lowe's home improvement expert, Mike Craft, hosts this do-it-yourself demonstration brought to you by home improvement retail outlet, Lowe's on how to replace or install a new bathroom ventilation fan. The video will give you all the information you need on how to complete this project at home, and without hiring a professional. Providing a detailed list of the tools, supplies, and tips you will need, Mike shows you how to complete this project and h...
Ron Hazelton shows you an easy an effective way to wash windows. In a warm bucket of water you add one tablespoon of dishwashing solution, a scrubber with sleeve is used to apply the solution to the window, and dried with a professional quality squeegee. Each step is shown and explained in full detail to ensure the best possible completed outcome. After watching this video and walking yourself through the steps a few times you can wash a good sized window in about a minute.
This quick and simple technique shows viewers how to acquire a good manicure. After washing your hands and removing any existing nail polish, mix oil and sugar in a bowl and put it aside while filing your nails. Scrub the oil and sugar mixture over your hands and then submerge your nails in hot water for a few minutes. Push back any cuticles you may have and massage your hands in oil. Wet a damp cloth and put it in the microwave for a few seconds, then wrap it around your hands. If desired, a...
For people who would like to learn how to make a professional tattoo, this is the tutorial to watch. For making a basic arm tattoo, the subject should be seated upright in a military position. You should apply some alcohol and then some antiseptic to the area to disinfect the area and place the stencil over the area. It is suggested that the subject shave his or her arm in order to get the best effects. The tattoo stencil should be placed over the center line of the arm and align it properly,...
Sick of paying people to do things you could do yourself if you knew how? In this five-part video tutorial hosted by the Handyman Teacher learn how to install a brand new garage disposal in your home with the help of your own two hands. Don't waste your money on hiring a professional, learn how to do it yourself!
What could possibly make shooting home videos even easier than they already are? A camcorder handle. This is a cheap, easy, legit way on making a camcorder handle.
If you have some hybrid golf clubs, then you need to know exactly where to place the ball for correct contact. Learn to make solid contact with your hybrids by mastering ball position. Frank O'Connell shows us the proper stance and position for hitting hybrids.
Are you having trouble with your green reading? It's not an easy task, but you can learn it. Green reading doesn't start when you get to the green. In fact it starts when you approach the green. In this video, Rick Sessinghaus divides the art of green reading into four parts, from approaching the green to standing over the ball. See how to read the green on a golf course.
Check out this short video tutorial from Rouxbe on how to cut fancy citrus fruit wedges. This video will support your cooking experience and will provide you with additional relevant information during your culinary time cutting citrus wedges.
Get that very "right now" green smoky eye with some help from the professionals at Smashbox Cosmetics. By starting with cream liner Midnight Green and applying little smudges along the line, go back to smudge with your brush to create a smoky effect. Stand our this fall with vivid color and this soft, not-so-innocent makeup look.
Want to learn how to get that high fashion kind of smoky eye you see on the fashion runways? Smashbox Studios has a new name for it and it's called the "Smoldering Eye". The smoldering eye is a more diffused version of the smoky eye, with less definition. In this video, learn step-by-step, how to get that beautiful, sultry look with a little help from our friends called: the professionals.
The odds are that you'll never find yourself being held prisoner with your hands bound together with zip ties. But if you ever are, you'll be very grateful for the info you learned from this video. In this tutorial from the folks at ITS Tactical, you'll learn how to escape from zip ties using shims. You can use all sorts of things for shimming, from professional equipment to your own fingernails.
These Apple Shake 4.1 tutorials shows you the basics how to use the Stabilize Node in Shake 4.1 for match moving. Apple Shake 4.1 is a high-end compositing and visual effects package, which can help you make your graphics look as professional as possible. This tutorial also shows you how to use Shake 4.1's color correction to make the image blend. For more advice on using Apple Shake 4.1, search for Shake 4.1 on WonderHowTo.
Lindyhopper49, a huge fan of the "King of Pop", will teach you how to dance like Michael Jackson. He's not a professional dancer, but he does have some great advice and information on how to to Jackson's most famous moves.
Lindyhopper49, a huge fan of the "King of Pop", will teach you how to dance like Michael Jackson. He's not a professional dancer, but he does have some great advice and information on how to to Jackson's most famous moves.
