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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.
Jailbreaking an iPod Touch or iPhone can have its advantages. Some apps that you wouldn't be able to use before could be downloaded without a problem. Issues that you may have had with yoru phone about design or looks, gone! In this tutorial you'll find out how to jailbreak dna unlock your iPod Touch/iPhone with 3.1.2 firmware. But be advised that doing anything with you phone like this, can potentially damage it so be careful!
Do you think you need to spend a hundred bucks to have good cup of coffee? This is not the case! All over Europe, they have been using the French press forever, and now you, too, can take advantage of this energy saving method. This is one of the cheapest ways there is to make a fresh cup of coffee and it is extremely easy to use.
If you have just gotten a Netbook and need to install Windows on it, check out this tutorial. In this video, you will learn how to get Windows XP onto a Netbook using only your USB input and a thumb drive.
Rooting a cell phone can give you so many different perks and advantages that you wouldn't normally have. But at the same time it can also cause damage to the phone itself that it may even cease to function properly causing any money that you spent, to go down the drain. This tutorial shows you how to root your T-Mobile G1. Be careful and good luck!
Your home router is automatically programmed to run firewalls to protect your computer from viruses. Unfortunately, these firewalls often mistake programs needed for online gaming as intruders and block them.
By jailbreaking your iPod Touch you can take advantage of tons of cool apps that aren't available on a regular Apple grade model. This tutorial will take you through the process of jailbreaking an iPhone 2G, with a very easy, 100% safe method. So, whether you are looking for cool apps or want to use your iPhone with a network other than AT&T or O2, you will need to jailbreak it. Grab your phone and turn on this video for all the tips you need.
There are a lot of advantages of cooking in a wok as they are healthy and less fussy. A wok can be used to stir fry, stew or for any type of cooking. Kikkoman shows in the video how cooking in a wok is done. He demonstrates how to cook stir fry chicken in a wok. First you have to rinse the chicken and slice them into thin strips; two tablespoon of corn flour is mixed with three tablespoon of teriyaki marinade and grated ginger add crushed garlic and sliced onions and mix well, finally add the...
This video tutorial shows how to connect to the Internet using the Wii video game system. The advantage of connecting to the Internet with your gaming system is to play games, such as Animal Crossing or Call of Duty, with other players. You can also get the Internet Channel which allows you to watch YouTube videos and do other tasks you would normally do on the internet. You will need a wireless router to do this. On the Wii home menu, click on Options, Wii Settings, and scroll once to the ri...
This video explains the importance of marking your ball on the putting green. If someone else is also playing golf, and theirs hits yours (and it isn't marked), its a two stroke penalty. In order to mark the ball, set a coin directly behind the ball onto the green. Then when you replace your ball, set it directly in front of the coin. It is important to always put your ball in front of the coin so you don't accidentally gain or lose advantage. When putting your marker in place, make sure to n...
The video shows how to finish garments with serger or French seam. If you have a serger sewing machine then you can straight away place the seam along the seam and stitch on the machine. The advantage of this machine is that it gives 3 fledge serger stitch at one go. If do not have a serger machine then you can use the French seam. First the rough seam is stitched on the wrong side of the fabric and frayed edges are trimmed. Now the fabric is turned over and ironed over the stitch and a strai...
Have you ever thought of tuning your ukulele or guitar with your personal computer? Why not? One of the advantages is greater accuracy. Don't fiddle around too much with the instrument - just select the correct notes, and you're well on your way to a finely tuned ukulele or guitar. Get the most out of all your tools! Watch this video to learn how to tune your instruments properly!
WhatEverHD shows how to shoot your javelin using a turret in modern warfare 2. This is made possible by using a glitch in the system that allows you to use the turret as a mechanism of projecting your javelin. You can walk up to the turret, zoom in and do what is instructed in the video to throw the javelin. The video states that the only advantage of this method over the normal javelin shooting is that you have a turret to use it on and thus the javelin travels a longer distance. You need to...
Danny Lipford shows us how to filter rocky soil in a flower bed in this informative video. By stapling 2 pieces of 2x2 to a hardware cloth, a mesh is produced that can be clipped onto a wheelbarrow. A home-made sifter of this variety, without a solid frame has the distinct advantage that you can pick it up and toss the filtered out rocks to the side after use. The sifter could also be used to filter the clumps that appear in fertilizer bags, or even masonry sand. The resulting filtered soil i...
Dan and Jennifer discuss not responding to messages in a timely manner when online dating. A lot of men are terrified and want to play it cool so they don't come across as desperate when dating online. If a woman writes you a message, don't hesitate to immediately respond to her message. A woman who sends you a message is interested and you should take advantage of it. Don't listen to what your buddies say. If you want to date a woman and don't respond to her message, some other guy might and...
First neatly draw the outline of the pig, then color the outline with a darker shade as this is the base of the character. Next draw the eyes, nose, and the small curly tail which complete the outline of the pig. For the base color a slightly bright pink color should be selected to shade the inner part of the pig i.e. the stomach, legs, and face. A shiny touch should be added to the face to give it a brighter and happier appearance. The background must be colored also with blue and brown. The...
In this video the instructor shows the different methods of solving quadratic equations. There are many methods to solve quadratic equations each with its pros and cons, each method suitable for a particular situation. The first method to solve quadratic equation is factoring. The advantage of using this method is that it is quick and easy. But the problem is not all equations can be factored very easily. This method requires a lot of practice and intuition. Use this method when the discrimin...
Take advantage of this unique opportunity to prepare for the Advanced Certification exam in an interactive day long, live session with an Advanced Certified Pro advisor! Get a jump start on becoming a QuickBooks Advanced Certified Pro Advisor. Learn how advanced certification can help you grow your business and continue to improve your skills. You will understand what advanced certification is, why it is important to your practice and how it can benefit you and your clients. Learn how to effi...
In this video, dating coach and expert David Wygant will teach you all about how to attract women using only your body language. This video takes you right into the action and is a live, on the field look at an attempt to pick up women in action! This will give you a real life example through the windows of a shopping store. David narrates a situation between a guy and a shop-girl. Within the video, he will teach you how to be open, charming and captivating while flirting with a woman in your...
How to use Toyota 4Runner heated seats in this short video, we find out from Toyota one of the many benefits of owning their 4Runner SUV. In selected models of the 4Runner there are heated seats. If you are confused at all about operating the heated seats, this should put you at ease. It is no more challenging than turning a dial. The team at Toyota has added this feature and you can learn how to most effectively take advantage of heated seats, which will come in handy for that next blizzard.
Do you have a smart key but are not aware of its advantages? Here are some tips. Put your foot on the brake pedal. A green light will illuminate the start/stop button. Then press that button and the engine will start. To start other accessories, leave your foot off the brake pedal and click the start/stop button. An amber light will illuminate. If the battery is low on the smart key, then touch the smart key to the start/stop button and the engine will start. This provides quick ways to start...
This video describes how competitive it is to become a runway model. It tells you exactly what can help you become a model. Different designers look for different things in models. You should be prepared, practice your attitude, and know what the designers want. Commercial designers want you to smile while edgy, designers want you to be strong. Models with experience don't necessarily have an advantage as designers are always looking for new faces. Be patient and practice to get into the mode...
How do you know that your "used" DS game is actually real? What? There are fake DS games out there on the market? Unfortunately, yes, there are. And this two-part video will tell you how to spot a fake Nintendo DS game. Don't get screwed. You're game may not work properly, maybe it won't save… and you don't want that! This is very informative about making sure you don't get taken advantage of.
Did you know you can set your homepage on your Motorola Droid just like you can set up a homepage on Firefox or Safari? This video tutorial will show you step by step how to change your browser homepage on the Droid. The Droid is a very cool smartphone with the ability to run multiple apps, so why not take advantage of all of its features? If you want to personalize your homepage on Droid, check out this tutorial and you will be on your way. Your new phone will feel like home in an instant.
For quarterbacks who want a competitive advantage over their opponents, Dub Maddox shows, how to throw a football using playaction. Maddox reiterates throughout the tutorial the importance of set, show, snap, and sell when learning the handoff of the football. With a step-by-step live-action tutorial and real game examples, Maddox shows ,how the four key steps are used in games. Those four key terms provide the foundation of mechanics that a quarterback must exercise on every run play if he o...
The big perk that comes along with purchasing a Nintendo DSi instead of a regular Nintendo DS is the Internet capability. With Nintendo's new DSi model you can go online and surf the web as well play other users over an Internet connection just like you would on an XBox or Nintendo Wii. Setting up and connecting the Internet on your DSi is quite easy to do and you will want to set this up right away to take advantage of all of the fun features.
The video is very informative about the using of a Stampin' Up. The blogger explains the different parts of the system and how to use them. She first shows the finished product, in this case a label or gift tag. She then explains the process of how to die cut the various parts and how to use the dies and machine to cut out the shapes. She then explains how to put the Tags together. She then shows how to finish the product. All through the process the video also has pop ups with a brief write ...
This video is about the use of PhotoKey. It is surely an excellent sales pitch. The video clearly depicts the benefits and advantages of PhotoKey. The easy and short ways to edit background, delete objects and also adjust light to make the photo look more real. PhotoKey is very user friendly and does magic to the project for which it is used. The video by itself makes the viewer feel that this is the best and easiest tool available to edit pictures to their own needs. It also gives informatio...
Check out this video to learn how to make some easy fabric ornaments for Christmas. Decorating will be a snap, not a pain, when you take advantage of the scraps you have lying around from past projects. Let your holiday spirit out!
The javelin glitch in Modern Warfare 2 is currently being exploited for great and evil purposes. Watch this video to learn how to take advantage of this glitch, for both the XBox 360 and the PS3. Fair warning, though: doing this glitch could get you banned by the powers that be at XBox Live.
Impress your friends! Learn the game of kings and queens. Step 1: Set up the queens and kings
Forget what your mom told you about being yourself—there are definite things you can do to tip the odds in your favor! Check out this Howcast video tutorial on how to make yourself irresistible to guys.
To be the best at the Madden NFL video game, you have to be willing to get advice, but not just any old advice... professional advice. To beat everyone, you have to be ruthless and know all of the strategies and gameplay tricks. To master Madden 08, check out this quick, football game, video tip from Madden Nation (EA Sports and ESPN) with video game pro Steve Williams (or Coach or The Old Skool Gamer).
To be the best at the Madden NFL video game, you have to be willing to get advice, but not just any old advice... professional advice. To beat everyone, you have to be ruthless and know all of the strategies and gameplay tricks. To master Madden 08, check out this quick, football game, video tip from Madden Nation (EA Sports and ESPN) with video game pro Charles James (or Chuck Hollywood).
Final Effects Complete 5 AVX brings Ball Action, Mr. Mercury, and 100+ other legendary visual effects to Avid editing and finishing systems as an AVX 2.0 plug-in set. Supporting both Windows and Macintosh (Universal Binary), the new FEC 5 AVX takes full advantage of AVX 2.0's power and performance. New features include support for 16 bit-color processing, AVX 2.0 real-time filters, native on-screen controls, multi-processor acceleration, a number of new wipe transition filters, and hundreds o...
Core Data is a powerful data-management framework introduced with Mac OS X v10.4 Tiger. When you take advantage of Core Data, it slashes the amount of custom code you need to write in order to manage application data. Opening, saving and undo management can all be handled by Core Data, freeing you to concentrate on creating unique features for your application. This video tutorial, which presents a general introduction to using Core Data, will walk you through the process of building a simple...
This software tutorial shows you just how easy it is to design a great looking logo in Adobe Illustrator. As with any other software package, it's all about getting to know the interface; and then from there it's all about developing your design skills. As with most others, I started out designing logos in Photoshop because that's the only program that was available to me. But Illustrator offers one advantage when it comes to designing logos, and that's one of being 100% vector. You want a lo...
Learn chess from Grandmaster Alexandra Kosteniuk. This chess video tutorial will show you how to play a game of chess, like the masters. See how to catch Black from all sides to win the chess game.
In this video tutorial, Chris Pels will show how to use the aspnet_merge.exe utility to combine assemblies that have been compiled using the aspnet_compiler.exe utility. First, view the output of the ASP.NET compilation process to learn what assemblies are created. Next, learn the mechanics of using the aspnet_merge.exe utility to merge assemblies from the compilation of a web site, first seeing how to control the compiled assembly names with the –prefix option. Then see how to merge all the ...
Lisa shows us how to clean up spilled candle wax using an iron and a paper towel, a trick from Japanese Urawaza.
