Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This medical how to video demonstrates how to take an arterial blood gas sample. The purpose or arterial gas sampling is to assess the patient's respiratory status as well as the acid/base balance in their blood. To perform this medical procedure you will need the following instruments: protective eye wear, gloves, alcohol, iodine, arterial blood gas sampling kit, gauze and a bag of ice. Please not that this video is intended for medical professionals only.
A kaju burfi is a classic Pakistani dish based on cashew nuts. It is a smooth and delicious dish with just a hint of sweetness and a lot of creamy. This meal is very easy to make and can be enjoyed any time of the year.
The creative Suzy Banyon describes in detail the process of applying a leopard print manicure in this easy to follow step by step video. She details the process vividly, from applying fake nails and filing them into shape, to what type of base to use and how to go about creating the leopard print pattern with the use of a fine point Sharpie pen. This video is great for those of you looking for new and different ways to apply unique nail art at home!
MatttChapman shows you how to add a simple dutch tilt to your filmmaking bag of tricks. Tripods conventionally only pan and tilt, but this trick adds an extra dimension. All you need is a tripod and a camera! It's just a matter of messing with the base plate to get this simple dutch angle.
NordicSkiSource.com owner, Doug McSpadden, instructs how to apply a hard wax to your cross country skis. Great informational video for the beginner to advanced skier. You need to have a good iron and patience. Wax the groove of the ski before you place the iron on the base. Make steady consistent passes on the ski.
NordicSkiSource.com owner Doug McSpadden illustrates basic practices for caring for your XC skis. The more wax you have the faster your skis. Do not ski through dirt; it will ruin your bases. Keep skis waxed when travelling to keep them from drying out. Don't walk across a parking lot.
If you're a serious film buff then these glasses will totally give you a cinemagasm. This polarization filter uses a pair of 3D glasses as a base and combines the glasses with a lens cap to reduce glare and any reflections that could tamper with your viewing experience.
Fun tutorial on japanese anime drawing. "Chibi" is a Japanese term for "short person" or "child". All the chibis in this video are based on characters from Miki Falls, a book by Mark Crilley, the creator of this video. The music was created in Garageband 2.0.2. Learn how to draw different emotions for manga characters.
This new and way more extreme form of BASE jumping involves a modified jumpsuit that makes you into a human airfoil. Called a squirrel suit or bird suit, this new sport is as close as man has got to flying. The barrel roll is a sweet stunt that involves a huge level of control and skill. Reach terminal velocity pretty easily in a jump.
This web development software tutorial shows you how to slice a site design in Photoshop, and then export the resulting images and HTML to Dreamweaver. This is an ideal method for creating newsletters, as the resulting HTML is tables-based, and better suited to email clients. Learn how to create HTML pages with this Photoshop and Dreamweaver tutorial.
In this ASP.Net video lesson, you will explore the new membership capabilities of ASP.NET 2.0. In addition, you will learn about role-based security, and how you can use roles to control access to your Web site.
In Final Cut Server, you can create metadata subscriptions, an automation that triggers responses based on changes within asset or production metadata. For example, you can create a metadata subscription to automatically encode an asset to H.264 and send it to a website.
Many video camera companies are beginning to manufacture tapeless camcorders, which record footage as files on hard disks, solid state drives, or optical disks. It's easy to transfer file-based footage to your Mac using Final Cut Express. Just connect your camcorder to the USB port.
Xeni checks in with the authors of the forthcoming O'Reilly HOWTO book "iPhone Hacks" (David Jurick, Adam and Damien Stolarz) for a demonstration of how to unlock and jailbreak your iPhone or iPod Touch. The authors promise to teach you how to coax more out of these devices: little-known features, performance tweaks, and tips on great web-based apps to install -- video game emulators, IM and VoIP apps, and media players that can handle a wider range of filetypes.
In this soldering tip video brought to you by BEST, Inc. Bob Wettermann demonstrates how to repair damages that have occurred to the based printed circuit board laminate materials as well as to PCB corners.
Lawrence Perez, from Saddleback College, and his assistant Charlie, give this intermediate-algebra two-part lesson on logarithmic applications, chemistry acids and bases. If you've never taken chemistry, well, you should probably go and take it first.
Have you ever found your video images over-exposed? Or under-exposed?
Balloon twister Addi Somekh shows us how to make and play a Balloon Bass. The instrument is based on the balloon resonator originally conceived by Canadian twister Sean Rooney. This is a very popular technique among younger children.
This video is based on similar ideas from Dr. Ken Blackburn's world record paper airplane. You will need a sheet of paper and a flat surface. After you have completed the plane throw it over your head to get a smooth and slow glide. Your will find the video easy to follow and your plane will fly with style and stability.
Bring a little bit of the excitement of Las Vegas to your Minecraft world. Watch this video to learn how to build a working slot machine, based on a random number generator, in your Minecraft map. Luck be a mob tonight.
Love champagne but getting a little bored of having the same bottled stuff over and over again? Then kick up the flavor a notch or two by mixing this champagne-based drink.
In this video, you'll be learning how to crochet a very beautiful lace pineapple pattern. Use this pattern as the base for an afghan blanket, a scarf, or anything your heart desires. Mikey takes you through the process step by step, so just watch the video!
This tutorial comes just in time for Halloween, but you can use it for cosplay as well. This is a very easy costume to make - all you need is a basic black outfit, and then assemble the blue rectangles to make the mask, obi and tunic.
More duct tape fashion accessories! This tutorial shows you how to make a tote bag or a beach bag out of silver duct tape. You don't need a pattern or base, just grab a roll of duct tape and follow along!
Scroll panes can create frames within your website, which can be condensed and then scrolled through. Scroll panes help you optimize the screen space without losing out on content. Follow along with this tutorials and add a scroll pane to your own website or other Flash-based content.
If you don't want to use a preloader bar, you can use the circular animation instead. This tutorial shows you how to code a circular preloader and have the animation go either clockwise or counterclockwise using a mid-level masking technique in Action Script 3.0.
After Effects is a powerful software program that will let the user create animations, as well as providing motion tracking and other movement-based graphics. If you've just installed After Effects on your computer, this tutorial gives you a good introduction and shows you around the program.
Whether you find clown hilarious or absolutely terrifying, you're probably familiar with the squirting flowers that they so often have mounted on their lapel pins for soaking circusgoers. This video will teach you how to create a similar set of squirting flower, except based in a pot rather than your clothing.
Need help finding yourself around the Nuke 6 GUI? This quick clip from the folks at Lynda will help to orient you. Whether you're new to the Foundry's popular node-based compositing application or a seasoned post-production professional just looking to better acquaint yourself with Nuke 6's new features, you're sure to be well served by this video tutorial. For more information, including a detailed overview, watch this free video guide.
YUM. Truffles. Start out this recipe by first making the filling, which is done by combining a melted chocolate (bittersweet chocolate in this video) and a very thin caramel base. When that's all done, you'll chill it while you prepare and roll the truffles into pretty shapes for Valentine's Day. This is a wonderful desert, and it doesn't have to be Valentine's to enjoy it.
In this clip, you'll learn how to create grungy, typographic posters in Adobe Photoshop. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
Has you rent check bounced again for no apparent reason? It happens to everyone, but if you're roommate needs the money fast, you need to fix it fast, and wire transfers are the fastest way to give money to someone else. Executing a wire transfer is as easy as making one phone call.
In order to reach high levels of polygons while sculpting in Blender 2.5, it is important to start from a base mesh, versus the default cube. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
Learn how to animate twinkling stars in Adobe Flash CS3, CS4, or CS5 very easily. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started making your own Flash-based twinkling starscapes, watch this video guide.
Trapster is a cool website that works just like Google Maps or MapQuest, with a twist! In addition to turn by turn driving directions, you will also get the locations of police speed traps along your route. Stay safe and in control- and avoid a costly ticket - with this free web based service.
See how to work with (and for) CSS when using Adobe Fireworks. Whether you're new to Adobe's popular bitmap and vector graphics editor (formerly known as Macromedia Fireworks) or are a seasoned web design professional simply looking to become better acquainted with the application, you're sure to benefit from this free video software tutorial. For more information, including detailed step-by-step instructions, take look.
She how to use the 3D bevel and embossing tools in Adobe Illustrator CS4 to create 3D text-based logos. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.
Learn how to make use of the Rebuild and Change Degree tools in Rhinocerous 4. Whether you're new to Rober McNeel & Associates' popular NURBS-based modeling application or a seasoned 3D arts professional just looking to better acquaint yourself with Rhino 4's new features, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Learn how to troubleshoot solids and Booleans in Rhinocerous 4. Whether you're new to Rober McNeel & Associates' popular NURBS-based modeling application or a 3D arts professional just looking to better acquaint yourself with Rhino 4's new features, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.