Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
In this Computers & Programming video tutorial you will learn how to remove the LCD display from a G5 iMac. This video is from powerbookmedic.com. First, loosen the rubber band around the display by inserting a pointed object and freeing it slightly with your fingers. On the bottom, free the lower end of the sheet and lift it up. Now remove the two screws and dismantle the part as shown in the video. Then on the top of the display unstuck the two stick pads and remove four screws from the fro...
In this tutorial, we learn how to make guilt free chocolate truffles at home. Cocoa powder, coconut oil, Stevia, dates, coconut oil and apple sauce are used in this recipe. First, take your sugar free chocolate truffles you created and chill them in the fridge for a few hours, so they are hard. Once your truffles are made, you can now dip them into your choice of toppings. You can choose chopped nuts, coconut or any other topping that you enjoy. Once you're done dipping, you can place into tr...
In this Autos, Motorcycles & Planes video tutorial you are going to learn how to clean your car windows so they are streak free. You will need ammonia solution and a mixing bottle. Mix one part ammonia with ten parts of water in the mixing bottle. Make sure you take sufficient quantity of ammonia. Then get a spray bottle and pour the solution into it. Get a piece of rag and a micro fiber towel. Spray the window liberally with the solution and wipe with the rag. Now wipe with the micro fiber t...
What if you're in the middle of a call before you enter your car? Ford's new SYNC system has a solution. As long as your cell phone is paired with SYNC, you can continue the conversation uninterrupted. See how to use hands free calling with Ford SYNC.
Learn how to score with Free Kicks in Fifa 09 (PS3/Xbox 360). Mastering all of the different techniques takes practice but it's well worth it! Learn methods to spin, curl, adjust power and distance.
As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.
Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.
In this soldering tip video brought to you by BEST, Inc. Norman Mier explains how to converting a lead solder tip to a tip that will be utilized for lead-free soldering.
This is a tutorial on how to free up more space on your hard drive. Some of the issues that take up space include system restore, disk cleanup, wallpapers and personal information.
Cheaply, easily and quickly build an HDTV antenna that outperforms amplified store-bought antennas! This DIY antenna has amazingly good reception for your television. Quit paying your cable company when you can get HDTV for free!
Learn how to get free electricity from your home telephone line just by watching this video. Save money on your power bill, and hack into the electricity coming out of the phone jack. The phone company doesn't monitor electricity usage, so you can probably get away with this con. Check out this video tutorial and learn how to tap into the electrical energy source in your phone line.
The iPhone 4 for Verizon is already old news, thanks to Sprint's unveiling of the Kyocera Echo smartphone last Monday.
With new iPhone models out, you'll have updated cameras to try out, a faster processor, and new colors to choose from. The only thing that could stop you from picking one up yourself is, well, your current iPhone. Here's how to check if you're eligible to upgrade to iPhone 11, iPhone 11 Pro, iPhone 11 Pro Max, or any other iPhone still being sold.
The gig economy is thriving, and if you aren't already making money with your phone, you could be missing out on easy residual income. Some people just want extra cash, and some even manage to completely ditch the 9–5, enabling them to work at their own pace and set their own hours.
If you're looking for a new Reddit client on your iPhone, look no further than Apollo. Launched with iOS in mind, Apollo is a free app that offers an exceptional Reddit experience, but some of its excellent features — as well as some necessary ones — are hidden behind its "Pro" paywall. Are these extras worth your money?
Snapchat is in the midst of a massive redesign — one that not everyone loves. Still, it's clear that this is a decision fueled by money, and Snap Inc. believes this redesign will help attract more advertisers. Even so, Snapchat has a few more tricks up their sleeves to make a little extra dough. And while the average user couldn't care less about ads, they very easily could care about custom Filters and Lenses.
When it comes to your security, you want the best of the best. Why settle for mediocre service with something as valuable as your protection? Malware continues to make its way onto the Play Store, leaving millions of devices vulnerable. You need an app that will shield your devices from both the latest malware threats and threats nearby. And when it comes to antivirus apps, there is only one choice.
The world of augmented reality has seen a myriad of different products, from sensor-laden smartphones to robust holographic headsets, but Google Glass's failures nearly killed the middle ground.
Windows 10 has proved to be immensely popular (free upgrades certainly don't hurt), and with back to school time, there's a good chance you have a new computer running Microsoft's latest OS. You maybe you decided to go with a clean installation rather than an upgrade, or just haven't used your computer for much more than surfing the web and watching Netflix.
In a 10 button Nesquik vending machine or other 10 button vending machines, you can hack to get credited for free drinks.
While the Google Play Store is filled with big name magazines like Time, Forbes, Sports Illustrated and Maxim, it also panders to smaller audiences, like with Coin Prices, Soap Opera Digest, Watch Journal and Quilter's World (which yes, is all about quilting). If you have a select few that you enjoy reading, prices aren't usually a problem; issues range from $1.99 to $4.99 for each one, or from $19.99 to $39.99 for yearly subscriptions. If you're someone that is a magazine connoisseur, prices...
Instead of paying for expensive patterns that might not even fit you perfectly, create your own! This tutorial shows you how to take your own measurements and then draft a bodice pattern. It's very easy, and a great way to get lots of free patterns!
In this tutorial, we learn how to get rid of fruit flies cruelty-free. First, you will need to put a sweet mixture of things that the flies like to eat inside of a cup. After this, place a cylinder piece of paper into the cup. The flies will be able to fly into the bottom of the paper to get what's inside, but most likely won't figure out how to get back out of it. After this, you can let the flies go free and you will have let them survive without killing a ton of them! This is also free of ...
In this tutorial, we learn how to remove and install a free wheel. First, take out the skewer from the wheel. Then, take off the nut from the inside of the hub with a cone wrench. After this, go to the other side of the axle and loosen it up. Now place your free wheel tool onto the wheel. Firmly secure the free wheel tool onto the wheel until you're sure it won't come off, with any tools you have available. When you are finished, put your nuts and bolts back onto the axle, then use bicycle lu...
In this tutorial, we learn how to get free custom brushes for Adobe Photoshop CS3. Go to the website, BrushesDownload. on this site, you will see a large selection of different brushes you can download. You will be able to open the zip file that they come in, so make sure you have that software beforehand. When you find a brush you like, download it and then you will be able to use it in Photoshop. There are free software programs you can download to unload these brushes, including the websit...
Want to make a cartoon representation of yourself? See how to create free cartoon avatars that can be customized to represent your unique personality or interests across the social networks or chat clients you frequent with this video guide. For more information, including detailed instructions, take a look.
Big fan of Ana Free's successful 2008 single "In My Place"? In this tutorial, learn how to play this Portugal born singer-songwriter's hit with a little help from Ana herself! Be sure to watch both part 1 and part 2 from this lesson to get this heart wrenching song mastered!
This how-to video is about how to bake salt free chocolate free chip cookies.
Professional truck driver, Yesterday Irmani, teaches us how to tie a time honored, weight sustaining knot, for transportation purposes.
Learn how to bake a perfect gluten-free pie crust with this cooking video. This gluten-free pie crust recipe is brought to you by Linsey Herman on How2Heroes. Search How2Heroes on WonderHowTo for more cooking videos.
Gunmetal gray is one of the coolest, most biker-chic finishes out there when it comes to jewelry making. If you enjoy working with filigree pieces in your bracelets and necklaces, why not make them less granny fantastic and more urban chic by adding a nickel-free gunmetal finish?
In this video, you'll learn how to convert format files accurately and for free in two different ways. You can use a program called Format Factory, which you can download here, or you could use a website called Zamzar.
You can get your energy to go beyond your maximum! Earn over one hundred energy, even if your maximum is much less! Here are some tips to accruing free energy - always visit your neighbors, and maintain a stable of horses and full grown animals.
There are many music programs beyond Audacity which you can download for free, and which will allow you to mix and edit your own music. This tutorial shows you where to get these programs, like ROC, Myna, FreeSound and FlashKit, and how to use them for your own projects.
This tutorial has been designed for those who are using iTunes on a Mac computer. You can get ringtones for free and download them onto your iPhone, just through using iTunes. This short tutorial demonstrates exactly how you can make this work for you.
This tutorial is for PC users who have both iTunes and an iPhone, and shows you how to get iTunes ringtones on your phone for free. All you really have to do is convert your chosen track to the right format, then clip and download onto your iPhone!
Tired of having to install multiple files every time you set up a new computer? This tutorial shows you how Ninite.com to set up a free installer so you can install all your free software applications at once (like web browsers, iTunes, GIMP, etc), instead of having to do it one by one.
In this video, we learn how to create a free Weebly website. First, type a title in that you want for your website. After this, you will be brought to a new page where you can change the elements and designs. The design can easily be changed until you find one that works for you. After this, you can start to customize the template that you have chose and add in new paragraphs, columns, pictures, and more. Next, you can change the pages and add in links and more information. Adjust the setting...
In this free video exercise lesson, you'll learn how to do a lateral raise lifting routine with free weights. With weight lifting, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. For more information, and to get started using this weight lifting exercise yourself, watch this handy home-fitness how-to.
