Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
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.
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 League of Legends champion Kayle, or Judicator, received a rework a while back and now plays slightly differently because of that. Take a look at this champion spotlight guide by Riot Games on how to build Kayle as a hybrid support champion using the right runes and masteries. Be sure to take advantage of her ult so that you can save someone at the right time with invincibility!
While you can always view traffic information by visiting Google Maps, wouldn't it be better to be able to see what the traffic is like in your area all the time, simply by glancing at your desktop?
Want to play "As Time Goes By" by George Gershwin on the ukulele? Learn how with this video tab from Glen Rose of Jazzy Ukulele, which presents a complete breakdown of the song's component sections, chords, and strumming & picking patterns. For all of the details, and to get started playing this popular jazz standard on your own uke, watch this free video ukulele lesson.
Want to play "Autumn Leaves" by Joseph Kosma on the ukulele? Learn how with this video tab from Glen Rose of Jazzy Ukulele, which presents a complete breakdown of the song's component sections, chords, and strumming & picking patterns. For all of the details, and to get started playing this great French jazz song (originally titled "Les feuilles mortes") on your own uke, watch this free video ukulele lesson.
Want to play "Corvacado" by Antonio Carlos Jobim on the ukulele? Learn how with this video tab from Glen Rose of Jazzy Ukulele, which presents a complete breakdown of the song's component sections, chords, and strumming & picking patterns. For all of the details, and to get started playing this great bossa nova song on your own uke, watch this free video ukulele lesson.
Want to play "Girl from Ipanema" by João Gilberto on the ukulele? Learn how with this video tab from Glen Rose of Jazzy Ukulele, which presents a complete breakdown of the song's component sections, chords, and strumming & picking patterns. For all of the details, and to get started playing "Girl from Ipanema" on your own uke, a song made famous by Stan Getz & Astrud Gilberto, watch this free ukulele jazz lessons.
Want to play "Days of Wine and Roses" by Henry Mancini on the ukulele? Learn how with this video tab from Glen Rose of Jazzy Ukulele, which presents a complete breakdown of the song's component sections, chords, and strumming & picking patterns. For all of the details, and to get started playing "Days of Wine and Roses" on your own uke, watch this free video ukulele lesson.
You can create a free website using HTML. HTML is hyper text mark up language. Create a folder "my webpage" with all of the images and information for the webpage. Use notepad to write the HTML for the website. Notepad plus is the best which can be found on Sourceforge. Open the browser and the notepad and begin to construct. These codes will help in the creation of the page: <html> opens instructions </html> closes instructions. These are called tags. One opens the commands or instructions a...
In this clip, you'll learn how to set up and use free wireless tethering with a Motorola Droid 2 Google Android mobile phone. Whether you're the proud owner of a Moto Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started turning your own Droid 2 into a wireless hotspot, watch this...
In this clip, you'll learn how to set up and use free wireless tethering with a Samsung Epic 4G mobile phone. Whether you're the proud owner of a Sprint Epic 4G Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including a complete demonstration of the rooting process and detailed, step-by-step instructions, and to get started turning your own Epic 4G into a wireless hotspot, watch this hacker's how-to.
T-Pain, Cher, heck, most of the new artists these days use auto-tune, some over use it. With technology it isn't so much of a question of, "do we need to do it?" and more of "why aren't we doing it!?" Well, if you're looking for an easy way to add auto-tune to your vocal tracks, or your voice in recordings, and are looking to spend the fantastic price of FREE then check out this video! You will learn what programs you will need to download (Audacity, Audacity VST, ect.) and then how to set yo...
Looking for instructions on how to do USB tethering with a Samsung Vibrant smartphone? You're in luck. This free video tutorial will see that you need everything you need to know. (Note, however, that this hack will require you to download the free Samsung Kies application.) For more information, including detailed, step-by-step instructions, and to get started using USB tethering on your own Galaxy S phone without rooting it, watch this guide.
Vegan baking is complicated, requiring substitutes for starch, flour, and just about everything else, but the result is 100% animal product-free goodness.
See how to apply exponent rules to simplify radicals or square roots with this free video math lesson from Internet pedagogical superstar Simon Khan. Looking for a primer on how to solve matrix problems using a TI-89 graphing calculator? See how it's done with this free video algebra lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follo...
Know your knots! With this free video tutorial, you'll learn how to tie a perfection loop fisherman's knot. To tie a perfection loop fishing knot, you're basically going to put an overhand knot into your fishing line. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a knife lanyard knot. A knife lanyard knot is best suited for decorative purposes, such as attaching pendants to chains. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful crafter's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a surgeon's loop knot. The surgeon's loop knot is a fishing knot that uses polyamide filament or braided filament. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a twisted leader knot. When tying a twisted leader fishing knot, you'll probably use a small amount of filament and attach it to a larger braided fishing line. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a an Albright fishing knot. An Albright fishing knot is a nice quick way to tie your leader onto your line. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a simple cat's paw fishing knot. To tie a cat's paw, you need to make sure the lines are crossed. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a Homer Rhode loop knot. Homer knots are typically used with heavy monofilament and work really well for fishing. The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
