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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
Looking for your next craft project? Look no further. This crafty person's guide will walk you through the process of making a custom felt flower pin with supplies from your local craft store and about 45 minutes of labor. For more information, including a list of necessary materials and step-by-step instructions for making your own floral pin, watch this free video tutorial.
Need to iron a shirt for an important occasion? Smooth out your ironing technique with this housekeeper's how-to, which demonstrates the proper technique for pressing a men's dress or sport shirt using an electric iron and ironing board. For more information, including a step-by-step breakdown of the process, watch this free video tutorial.
Want to slim down? Feel the burn with this easy, five-minute exercise sure to help you trim or otherwise tighten up your hips. For complete instructions, including a step-by-step overview of this simple exercise, watch this home fitness how-to. Lose weight and feel great with the routine demonstrated in this free video guide from Brooke Burke.
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 327th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color.
The key to being a good doctor is great patient care and thoroughness, and those are exactly the skills you will learn in this video lesson, as you learn to perform a cardiovascular examination on your patient. This is a great, step-by-step resource for the proper examination procedure. Every medical student should know these techniques, and nursing students could benefit from this knowledge, too. Every cardiovascular exam should include inspection of the pulse, blood pressure, carotid pulsat...
While big parts of copyright protection are applied automatically to creative works like songs and beats (hence the need for orginizations like the Creative Commons), registering your work with Copyright Office is useful to the extent that it can allow you to seek greater damages in the event of an infringement. For more information, including how to register your own songs with the US Copyright Office, watch this free video tutorial.
Whether you're new to Adobe InDesign or a seasoned digital video 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 create a more engaging experience with web DVDs that include a search interface for viewers to jump directly to content of interest.
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 join Terry White as he runs through his 5 favorite Photoshop CS5 features, including the new enhanced selection abilities and noise reduction tools.
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 join Terry White as he walks you through using the new Photoshop CS5 and Photoshop CS5 extended (including the new Mini Bridge, which can be used across the full creative suite).
Oftentimes, a photo may not capture the true vibrancy of color in real life, but Photoshop can fix that. Photos with lots of color can be given even greater hue saturation by adding extreme contrast in Photoshop. By using multiple effects, including overlay blend modes and noise across multiple layers, a picture's color intensity can be made more bold with these techniques. By following the steps in this video, colors can be made more vibrant using extreme contrast with Photoshop software.
Acrobat 9 Pro is an essential tool for creating, reviewing and sharing comments with others you work with. In this video you will learn about commenting PDF files and the methods for including others in your review process with Adobe Acrobat and Adobe Reader. Learn how to use comment tools and review cycles in Acrobat 9 Pro as well as how to collaborate via email or Acrobat.com and share pages.
Looking to get super creative with your shoelaces? In this video, fifteen different shoelace styles are gone over with diagram as to how they were done. Such styles include the checkerboard, the double back, loop back, sawtooth, riding bow, twistie, lattice style, footbag, ladder, bushwalk, bi-color, display, hidden knot, and the zipper style. Use two different colored laces when doing these styles to jazz things up!
L.A. Lakers superstar Kobe Bryant shares some tips with TIME Magazine's Sean Gregory on how he puts his best foot forward everytime he steps onto the court. Areas gone over in this video include: The proper grip & shooting form, attack the foot & sell the fake, the pull-up jumpshot, the art of the foul shot, playing to the opponent's weaknesses, getting in character, and stretching.
From Food Wishes, chef John shows us how to make Huckleberry jam! Ingredients needed to make this delicious spread include huckleberries, sugar, powdered Pectin, water, and some fresh squeezed lemon juice. Use it on your toast in the morning or on top of freshly made waffles for one sweet breakfast!
In this tutorial from Food Wishes, Chef John brings us a great recipe for Clams Casino... A classic appetizer for those special holiday parties, or any other time you want to impress your guests. Ingredients include: neck clams, bacon, butter, red pepper, two cloves of finely minced garlic, bread crumbs, a pinch of salt, a couple drops of Worcester sauce and finely grated parmesan cheese. Bon Appetite!
Want to make a neat gift for a friend? In this Curbly video tutorial, steps are given on how to make an accordion style photo album without any glue or tape. Materials needed include: light to medium weight poster board (24x4.5"), a scoring tool & board, an Exacto knife, scissors, a hole punch, 0.25"x7.5" piece of elastic, and brad clips. Put photos of you, friends, and family on both sides of the accordion to make for a great keepsake.
MAKE zine aims to bring the DIY aesthetic and mindset to all the technology in your life. They want you to break open things and put them back together in a better way. In this video, MAKE and KipKay show you how to build a lost screw finder attachment. It'll help you find any screw, including plastic ones that a magnet would not be able to pick up.
See what you can do to impress your friends with a hammer and a ruler. This magic illusion is sure to impress your friends. Watch the hammer hooked to the foot-long plastic ruler dangle and balance from the edge of a countertop.
Understand how binary numbers work, including how to read binary numbers, and create your own. This mathematics or computer programming tutorial is a zip to get through. It covers practical and theoretical use and need for binary code understanding. Binary means zeroes and ones in a series. This is paramount to digital transmission versus analog that transmits in a sinusodial wave form.
Learn how to do the standard skills in Fifa 09, it looks like every player in the game can do these. These are special tricks, but they are necessary if you want to play online or ever score. This includes a foot flick, slide tackle, 360 roulette and reverse stopovers.
This instructional video, produced by Jewish Pathways, demonstrates how to tie your own tzitzit (or tzitzis). Tzitzis are fringes or tassels worn by observant Jews on the corners of four-cornered garments, including the tallit (prayer shawl). They are considered a time-bound commandment, which means they are worn only by men. This Judiasm video will help you learn how to tie, knot and twist strings - tzitzit - to a garment.
No one likes having their food messed with. That makes it all the more fun to do so right? This video will show you some fun pranks that you can pull to mess with the food of your friends and neighbors. They include making surprise disgusting layer dip and ordering unusual combinations of items at the grocery store, but are all freakin' hilarious and require relatively little setup or risk.
In today's time of rampant IT crimes, including identity theft, security is more important to the average computer user than ever. This tutorial, which was recorded and encoded for the Internet usingly only open source tools, demonstrates how you can use GnuPG to secure and verify data on your GNU/Linux box. Secure your Linux computer with this how-to.
This science video tutorial includes step-by-step instructions for extracting DNA from wheat germ, the embryonic plant attached to the wheat seed. Individual wheat seeds, or kernels, separate readily from the plant. This kernels have a tough outer coating called bran. If you want to know more, just watch this science experiment.
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
Real airplanes can't take any sort of crashes whatsoever. Lighter model planes can take a bit of roughing up, but nothing severe. If you crash all the time this may help ease the learning curve process, which includes some necessary crashing. This video shows you how to keep the wings from folding in tight loops, how to beef up the tail feathers and tail boom, and how to get more elevon movement for tighter turns and loops.
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.
This music production software tutorial shows you how to create Glitch-type effects for use with your drum patterns in Reason 3.0. It is an advanced tutorial only because of the speed at which he has to cover the material. In this example Ace Pincter will be adding glitch effects to drum patterns using Dr. Rex, but you can use any Reason drum pattern. Included: RV7000 Gating, Automation, Matrix offsetting, Filtering by gate, and Distortion.
Watch this instructional drawing video to begin drawing with a mental philosophy. Drawing is not like photography. You have to decide what is important to you and what details you will include in your drawing. Every line you draw is important only in relation to the other lines you have drawn. Here is an explanation of what might go through your head as you learn to draw.
This video sewing tutorial gives a clear and complete demonstration of how to correctly sew an invisible zipper. Included are tips and materials needed. Learn how to sew with the help of this instructional video and OTIS College of Art and Design.
Databases allow you to store data in a systematic and organized format, making it easy for you to search, sort and edit.
Watch this piano tutorial to learn how to play "Apologize" by OneRepublic or the remix by Timbaland on piano. Instruction includes detailed descriptions of intervals and chords on the staff. The tips in this how-to video will help you play "Apologize" quickly, even if you are new to the piano.
Watch this music how-to video to learn how to read musical notation or sight read. This instructional video is very detailed and includes types of notes, tempo, and the staff. Reading music will be easy once you've watched this helpful music notation tutorial video.
This is an instructional video on how to put together a fire starting kit. The kit includes everything from a lighter to fatwood. The second video in this sequence will show you how to use the items detailed in the fire starting kit.
A nice easy song for beginners that includes F chord. The strumming pattern is easier than the Animals' original version. Chords are open chords. Progression: Am, C, D, F, Am, C, E, Am, C, D, F, Am, E, Am, E...etc.
With Aperture, you can include IPTC metadata when you export a version of an image and embed it when you export a master file.
When you're ready to create a slideshow, just select the ones you want to include. It's easiest to create an album with all of the photos you want in your slideshow. You can even add music to your slideshow.
After you've created a song you're happy with, you'll probably want to use it with your other projects, including iPhoto, iDVD, and iWeb projects, or just listen to it on your iPod. You can easily export your song from Garageband to your iTunes library.
With a keyboard, you can enhance your song so it includes more than just the premade loops in Garageband. Just attach a USB or Midi keyboard to your Mac and let the fun begin.
