If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Give a bird a home with help from this handyman tutorial! Learn step-by-step how to build a professional looking Bluebird nesting box bird house. To build this nesting box you will need the following tools & materials: rough cedar or pine, a tape measure, pencil, speed square, hand saw, compound miter saw (if possible), exterior wood glue, drill bits, screw gun or drill, paddle bit, coarse thread drywall screws, deck screws, galanized finished nails, and a hammer.
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 333th installment in their series of digital spreadsheet magic tricks, you'll learn how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF & ISERROR functions.
Learn how to open up an Apple iPad case. All you will need is a flat tool to pry open the casing and you have access to the inside. Don't act too hasty, this video will demomonstrate exactly how to open an Apple iPad casing.
Whether you're new to Adobe Photoshop 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 make fast work of common design and production tasks like image re-touching with magical content aware fill in Photoshop Extended, creating complex shapes with Shape Builder tool in Illustrator, and intuitive object-selection features in InDesign and more.
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.
Whether you're new to Adobe Photoshop or a seasoned graphic arts professional 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 use the new Protect Detail feature in Photoshop CS5 to prevent artifacts in your digital images when using the Sharpen tool.
Nick from Greyscale Gorilla shows you a few simple methods to replace a boring sky with one that is more visually interesting. Using various selection tools you can be your own manipulator.
Nick from Greyscale Gorilla demonstrates how to master the Ambient Light and Area Light feature in Cinema 4D. These are great tools for creating believable and organic lighting effects.
Have you ever wanted to create a background with one of your photos? This video shows you how to use one of your photos to create a photo background using Adobe Photoshop. It will show you how to use the free transform tool, overlay blend modes, hue and saturation, drop shadows, and other cool effects. Learn all about creating photo backgrounds with this video tutorial.
In this Photoshop tutorial, learn how to use the software program to remove tan lines from a photo subject. To complete this editing process in Photoshop, follow the steps in this tutorial to learn how to utilize a layer mask, eye dropper tool, and adjust colors. By following the steps in this Photoshop tutorial, you can tan the parts of a subject's skin by learning how to blend colors within the software program so that someone comes out with a more even skin tone.
Thread and clothing designer, Kenneth D. King, give quick instruction to us on the importance of our cutting tools, more especially the serrated scissors. Here we learn what makes this particular style of scissors so efficient and necessary to our sewing work, as well as what types of materials they ought to be used on. He also gives warning that we should never use our fabric scissors on paper. Great tips for the beginning designer in us all.
Do you want to know what's the secret to a great looking lawn ? Then you have to watch this video in which Lowe's home improvement expert Mike Kraft explains how to sharpen or replace a Lawn Mower blade. Mike will share with you all the tips and the secrets of this simple and yet crucial operation. From the tools required to the safety measures, everything will be explained to you in this video with all the steps actually executed and filmed right in front of you.
Do you find your tool shed to be a little disorganized? Do you find yourself frustrated over is at least once a week? Ron Hazleton is here to help you, getting your screws, bolts, nails, fasteners, hardward (and more) neat and tidy using plastic food containers for storage.
Ever desired your very own masquerade mask? ThreadBanger takes us through the fun, multiple steps to acquire your very own custom-fit plaster mask! Materials needed include plaster wrap cloth, water, scissors, petroleum jelly, spray paint (in your color choice), sand paper, paint sealer spray, and decorative additions to personalize your mask! This project will need to dry overnight, so be sure to leave enough time before your party or event.
Do you have a broken NES system lying around somewhere at your house? This video shows you how to fix it yourself with very few tools required.
Donnie Hoyle sounds off on his return home. See how to not suck at Photoshop with Annotations in this Adobe Photoshop video tutorial.
2 roommates play a prank on another roommate that is away, they build a wall over the door to his room. This is a long and arduous process that involves lots of sheet rock, spackle and tools. You essentially need to cover his doorway building a false wall that blends in with the rest of the wall. This makes it look as though the wall was never there.
After Effects Apprentice Video Tutorial #3 Chris and Trish Meyer | 03/01- 11:36 AM
In this video tutorial from 8BITches, 8BIT Ché explains how he uses Little Sound DJ, or LSDj,—the Game Boy/Game Boy Color tool of choice for amateur & professional musicians and composers—to make hot beats! Big Pick Zel expounds on his knowledge of Gameboy history, and Li'lBIT eats dinner. For more information on making beats with LSDj and a Nintendo Game Boy, watch this video tutorial.
This how-to video is a guide on how to make a Jack-O-Lantern of Barack Obama, the Democratic Presidential Candidate, in spirit of the upcoming election and Halloween. You will need a pumpkin, a picture of Barack Obama, carving tools, and newspaper. This is one jack-o-lantern you'll want to keep up after Halloween. Watch this video tutorial and learn how to carve a Barack Obama pumpkin for Halloween.
This software tutorial shows you how to use the Knoll Light Factory Pro plug-in for After Effects. Knoll Light Factory Pro is the industry's favorite tool for creating lens flares, sunsets, photon torpedoes, stars and other effects. It offers a custom lens editor, auto tracking, alpha channel support, and pinpoint control over dozens of settings. If you haven't used the Knoll Light Factory Pro plug-in yet, watch this After Effects tutorial and get started.
Are you not satisfied with haphazardly folded laundry? Learn how to make a handy tool out of cardboard and fold a t-shirt with exactitude. Make sure every t-shirt you fold is perfect.
Secret Ingredient host Scott Herbert prepares cheddar cheese biscuits using a non-food secret ingredient: a cast iron skillet. Learn why cast iron skillets have been an essential kitchen tool for hundreds of years and why they can be a healthy choice for your kitchen too. Follow along and see how easy these cheddar cheese drop biscuits are to make.
Discover one of the new 3D features in Adobe Photoshop CS4 Extended. In this tutorial you will learn how to wrap an image around the inside of a sphere, to create a 3D panorama in Photoshop CS4 Extended. Then, simply step into this digital space and use some of the new Photoshop CS4 tools to look around your newly created world.
Sculpting UV's? Absolutely. You can pre-process a mesh with any modeling tools before you lay down UVs in modo 301. This is an incredible time saver and brings UV editing into the 3rd dimension! See how to UV sculpt in this modo 301 tutorial.
For both reflection and refraction scenarios, ray diagrams have been a valuable tool for determining the path of light from an object to our eyes.
Watch this instructional blacksmithing video to forge a high carbon steel striker for flint and steel. The flint and steel striker served as the original portable lighter. Flint and steel lighters are also used on outdoor trips to light camp fires. These detailed instructions will allow you to begin the craft of metalsmithing and forge a useful tool.
Sometimes, a project requires you to go back and fix or adjust something you created in Photoshop. Today, Bert takes us with him as he fills a once empty water glass, and fixes a reflection on one of his older pieces using the spherize tool in Photoshop.
In this Adobe Photoshop tutorial, Bert invades Tinseltown. Create your own movie poster simply by using a few Photoshop tools - colorize, hue/saturate, and gradient color levels. It's show time. Create your next blockbuster movie poster in a flash.
In this Houdini 9 video series, you will take a look at the new dynamics shelf tools and see how easy it is to create fairly complex simulations very quickly.
This motorcycle parts tutorial shows you how remove the steering stem (fork and triple tree) on a Kawasaki KLR650 bike. If you are replacing the steering stem or just doing work on your KLR 650 and need the steering stem off, this video will show you how to remove the steering stem. Make sure the front wheel is removed before starting.
This automotive installation tutorial shows you how to install cruise control in a Toyota pickup. For many vehicles cruise control is something that's just there, but if you don't have it in your pickup and want to install cruise control check out this tutorial.
Baby showers can be a lot of fun, make it even more fun by making a diaper cake. This Cake Decorating how to video demonstrates how to put this diaper cake together for any baby shower. All you need for the diaper cake is: diapers, rubber bands, white fabric elastic, safety pins, ribbon and white tool.
Follow along through the creation of a fictitious customer portal to learn about master pages, themes, membership, roles, site navigation, user profiles, and the Web Site Administration Tool in this ASP.Net video tutorial.
To help you compare and manage groups of similar shots or of images shot in a rapid sequence, Aperture provides stacks, an organizational tool that allows you to group related images.
Aperture's advanced filter and search tools make it easy to find an image or a group of images within a single project or album, a folder of albums, or across your entire library.