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.
Other World Computing provides a guide for advanced users demonstrating the upgrade or replacement of a hard drive in a Mac Mini Server computer. This comprehensive video takes you through all steps from tool selection to re-assembling the Mac Mini Server and it is recommended that the video is watched right through before attempting the procedure. In particular, it demonstrates the difficulty of opening up a Mac Mini using a small putty knife. Once the case is off, the three wireless antenna...
In this video, learn how to convert the American pound (lb.), a United States customary unit of mass, into kilograms (kg), a metric unit of mass in the International System of Units (SI).
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
You know it's not safe to drive and oeprate your cell phone, so why not learn how to take advantage of the latest voice features on the Samsung Rogue? Just watch this video and you'll be dictating, and voice commanding and controlling in no time. Give your thumbs a break, dictate your texts - the Rogue even recognizes commands such as "smiley face" and translates them into the appropriate emoticon. Cool!
In this video, learn how to send & receive text messages from your computer (Mac or PC) using your email.
Want to protect your investment and add some personal style to your cell phone, but aren't quite sure how to install that cool new skin? We've got you covered - just check out this quick video on how to install and remove an iPhone case. If only getting ready for work could be so easy!
If you're a geek, then this power pack will give you a total techgasm. The power pack allows you to charge pretty much anything you can fit into a 12 volt power jack in your car (where the cigar/lighter receptable goes). The power pack is a portable battery, so no need for charging your gadgets - like your cell phone - at home first before you head off to work.
Basal cell carcinoma and squamous cell carcinoma are the two types of non-melanoma skin cancers. Luckily, there are many options for treating them.
Every year, 250,000 Americans are diagnosed with a form of skin cancer called squamous cell carcinoma. What exactly is SCC?
Secretly shoot your voice across the room in stealth mode on a laser beam in this fun and easy project! Make Magazine and Kipkay present this cool spy trick. Build a simple laser communicator that transmits your voice across a room. You need an amplifier, radio, laser pointer, battery pack and a solar cell.
The Origami Spiked Pentakis Dodecahedron is an excellent Paper Christmas Decoration Star made out of 15 paper squares. In spite of the large paper size I was defeated by the last module after nearly 2 hours (!) of trying to lock the last unit in place each time another one dislodged. Never mind, it is still a remarkable sound structure once (nearly) completed and you can not see which one is not locked anyway.
Whether your scavenger hunt is for group competition or just fun, add a tech twist and let the games begin.
In this case modding video tutorial, you'll learn how to install a cigarette lighter-style 12-volt accessory outlet into a PC case. Charge your cell phone and other accessories directly from your case with the hack outlined in this video. For detailed, step-by-step instructions, take a look!
This innovative handset makes user convenience its priority. Created with the aim of overcoming the limitations of existing mobile phones, every function is available through a flexible layout of navigation keys. Fixed keypads are a thing of the past with the LG KF600 Venus cell phone.
This innovative handset makes user convenience its priority. Created with the aim of overcoming the limitations of existing mobile phones, every function is available through a flexible layout of navigation keys. Fixed keypads are a thing of the past with the LG KF600 Venus cell phone.
Check out this quick video tutorial on how to install Opera Mini 4 on the T-Mobile Shadow cell phone.
If you own a BlackBerry or any other wireless phone, then why not install the application Yahoo! Go! on it?
We've all seen the popcorn cell phone video. Now, we have the exclusive inside into how those videos were created. A microwave magnetron is strapped covertly to the bottom of the table. Then the prank is ready. Gather the phones and wait for the exciting reactions.
Not all bacteria in the eyes cause infection. A group of researchers from the National Eye Institue has shown that not only is there a population of bacteria on the eyes that reside there but they perform an important function. They help activate the immune system to get rid of bad, potentially infection-causing — pathogenic — bacteria there.
About a third of the methane released into the environment comes from the production and transport of natural gas. The gas leaks as it moves along the transport chain from gas wellheads to market.
With a death rate of one in five, sepsis is a fast-moving medical nightmare. New testing methods might improve your odds of survival if this infection ever hits you.
Do you ever wonder how all these celebrities continue to have their private photos spread all over the internet? While celebrities' phones and computers are forever vulnerable to attacks, the common folk must also be wary. No matter how careful you think you were went you sent those "candid" photos to your ex, with a little effort and access to public information, your pictures can be snagged, too. Here's how.
Is your garage a little more cluttered than it should be? Well, it's time to get organized! And Lowe's is here to help! In this video, Mike Kraft gives some great tips for shaping up your garage or basement, in a neat and organized room that you can finally walk through.
Celebrate the 4th of July by making holiday earrings. You will need:
The video shows how to calculate weight if the mass is given and vice versa.Later on in this unit you will learn about Newton's laws of motion and Newton's second law of motion gives us a way to change mass into weight and vice versa.This law will tell you what is happening to objects when the net force on the object is not equal to zero and the easy way to say what will happen is that the object will accelerate.But how much the object accelerates depends on two things,firstly the mass of the...
Now that you've got your Nikon SB-900 professional-grade speedlight, make sure that you get the most out of it with this free photographer's guide, which will walk you through the flash unit's basic features and functionalities.
These are the steps required to set your D80's pop-up flash. First, go to the "Custom Shooting Menu." Then you choose #22 on the screen: "Built in Flash." Choose the "Commander Mode" option. The modes that are available for the pop-up flash include TTL, AA (Auto Aperture) M (Manual) and Off (no flash). If you are using an external flash unit, you use either group A or B. The light frequencies and proper settings are related to how much light compensation is needed. +3. 0 is high power, 1. 1 i...
Danny Lipford gives us tips on setting up and maintaining a portable generator. Set-up usually includes assembly of things like wheels and handle kits. Most portable generators come without oil so you will need to add it. Be sure to check the owner’s manual for the proper type of fuel to use.
Learn how to make and use a hydroponic seed starter to produce seedlings with this video tutorial. This is a very easy setup to make. Start with a basic metal shelving unit. Hang florescent lights above each of the shelves on the shelving unit. Make sure the lights are balanced for day time. Put a plastic container on each shelf that is about the size of the shelf and tall enough for the rim to sit just below the florescent light tubes. You will need some pecks tubing and some plastic clamps....
If you’re still living in the Ice Age—that is, with a non-defrosting freezer—you’ll need these ancient skills. Learn how to defrost your freezer.
The Hyco cold vaporizer. This is a cold vapor unit which can give 50-80 % fuel mileage plus, if done to the instructions on the video.
Whether you want to search the web or just the contents of your phone, the Desire HD's searchbar widget is the way to go. Learn how to use it with this quick, official guide from HTC.
Organize your contacts list by merging duplicate entries. Learn how with this quick, official guide from HTC.
Spice up your digital photos with filters and effects. See how with this quick, official guide from HTC.
Get turn-by-turn directions and find places of interest with the Locations app on your HTC Desire HD. See how with this quick, official guide from HTC.
Personalize your Desire HD's home screen with custom widgets! See how with this quick, official guide from HTC.
A slingbox takes content from your TV or cable box and then 'slings' it to another location - such as your smartphone or computer. This tutorial shows you how to set up a slingbox for your home entertainment network and then start using it!
Interested in using your Google Android cell phone to read your eBooks when away from your Amazon Kindle eReader? With the free Amazon Kindle app, it's easy. And this brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started reading books on your own Google Android smartphone, take a look.
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 705th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Ctrl + ] to find dependent or
