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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
This video explains how to keep a dog calm and to be less reactive to objects that it is not used to including baby strollers, hats, canes, and a few other items. Starting with a few tips on how to get a dog used to the item in question such as keeping a leash on the dog and far enough away from a person the dog trusts and loves so that the dog will associate the object with a person. There are many aspects when training a dog in this way and each method can be tried if one does not work. Aft...
Learn how to do a tribute run through the Dire Maul dungeon on World of Warcraft. The run involves bypassing as many mini-bosses as possible and heading straight to fighting King Gordok. you'll need a few frost trap items and Orge suit items before you go on this run.
This how-to video shows the best way yet to get whiter teeth using cheap household items! The preparation and time to do this is less than 5 minutes. Watch this video tutorial and learn how to whiten teeth.
Hello! My name is Nicole Valentine and on behalf of Expert Village, I'm here to talk to you about how to coordinate birthday games for a birthday party. Now we're going to discuss the game can you read my mind. This game has a little bit of mystery flavor to it. You'll see what I mean. In this game, you need to utilize 2 rooms. In the first main room, you have all the guests of your party. Then later we'll instruct the guests we're going to play a game called can you read my mind and the goal...
In this video from DiscountTrendsetter we learn how to organize your closet! First take inventory of what you have an eliminate items you don't need. Place items such as oversized t-shirts in a drawer or in a bag. Keep your closet for your trendy stuff. Items that are ripped, torn, bleached, etc, get rid of them. Items that are still trendy, but you know you won't wear again, get rid of as well! If you haven't worn something in 2 years, give that item away! Now what you have left are the item...
You would think that recovering your smartphone or another important item that you leave behind in an Uber ride would be a simple process, but it can actually be a pain in the ass. You have to find out how to report it to the driver, hope the driver is honest, pay a fee, and contact Uber directly if none of that works. But we're here to help make this process as easy as possible for you.
Android's share intents system is great in theory, but the execution can sometimes be frustrating. When you tap the "Share" button next to a link, app, or file, you see a list of apps you can share that item with. But it seems like every time you use this function, the list of apps is in a different order — especially when it comes to the Direct Share targets at the top.
Market boxes are an integral part of the player experience in Animal Crossing: Pocket Camp, but using them effectively can be a tricky task. The item-trading tool between human friends is the locale for both junk and diamond-in-the-rough deals, and it can greatly increase the number of bells you earn if you play your cards right.
Want to spice up your origami cranes? MIT's High-Low Tech Group made two electronic origami cranes that flap their wings when you squeeze their tails.
You can use this trick on either a Mac or PC, and you don't need any of the DLC to do it. Get an expensive item, which makes the glitch work faster. Clicking on both mouse buttons lets you sell an item twice - then buy it back and resell!
Wish there were a way to remove less-frequently-used items from the Firefox right click menu? Well, there is! And, with FfChrome, it's easy! For all of the details, and to get started deleting things from your own Firefox context menu, take a look.
The great thing about crocheting is the ability to add certain things to items that have already been created. One of the most common things would be fringe. It can be easy to add on to certain items, especially scarves. So check out this tutorial on how to make a crochet fringe. Enjoy!
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
In showing how to unclutter the bedroom, the information provided focused on jewelry rather than other areas of the room. Tarsa Mar, the host of the video had a huge jewelry collection and showed the various ways to store those items. One of the boxes she shows is a wall case. One of the features of this item is the fact that necklaces hang. This prevents them from becoming tangled with other necklaces. There was space for rings and bracelets but the main objective was keeping necklaces separ...
Learn how to teach your dog how to ring a bell when he wants to go out. 1 Attach an item to a bell with a string. 2 Introduce the new item to your dog. 3 Ask your dog to use his paws to touch item to ring the bell. When he does, reward the dog with food. 4 After your dog masters ringing the bell, switch the reward of food to the reward of going outside.
This is how to retrieve an item dropped down the drain. Did your ring slip down the sink? You can get it out with these handy plumbing tips designed to get your valuables out of the pipes without a problem or damage to the diamonds.
Saying that people have too much stress these days is an understatement. With Twitter, Facebook, and a variety of electronic gadgets occupying our time, there's hardly room to breathe or to relax. This means that more and more of us are finding it difficult to fall asleep.
The archenemies of cell phones— puddles, toilets, swimming pools— can cause serious damage to your gadgets. And if your mobile phone has taken the dive, don't panic— there's hope for recovery.
In this two-part lesson, you'll learn how to edit a simple beat when writing electronic music in Logic Pro. Whether you're new to computer recording, new to the Apple Logic DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial from NextStepAudio.
Have you ever been in a situation when you needed to remember something real important, but you didn't have you didn't have your trusty cell phone or other electronic savior with you?
If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyone who does find your phone won't be able to access your files) and you can also set up a locator. By using the location app, you can text your phone from anywhere else and set off a search alarm so you will be able to fi...
In this how-to video, you will learn how to organize your closet. You will need motivation first and foremost in order to fully go through with this project. The closet of course is the best way to motivate yourself to clean your entire house. First start by getting rid of the items you do not wear or do not like anymore. You can easily get rid of things you do not love by doing this. Next, purchase matching hangars. You can even just rework what hangars you are currently hanging. Items such ...
In this video tutorial, viewers learn how to perform different soccer skills in the game FIFA 10, part of Electronic Arts' series of football games. The video shows a variety of different skills to perform followed by a controller that reveals the button sequence. The skills in this video are taught on the XBox 360 version of the game. The moves in this video include: ball roll fake, TATW (juggling), drag-back fake, ball roll heel chop, first time flick, fake shot and bridge. This video will ...
Soldering properly is a skill every electronics and computer hobbyist needs. Proper soldering appears deceptively simple, but it requires practice. One has to do the steps below to solder the wires which is as follows, First Clean the area you wish to solder and scrape the wire down to the metal and then wiping it clean with alcohol or acetone. Then you want to use a rosin-core solder for electronic applications, which comes normally with coils. Tin the tip of the first Wrap one or two inches...
This video is a quick overview of the construction of a Blubberbot, an artificial "life form" that uses electronic sensors to seek out lights, sound, or cell phone signals.
Shatter glass with your mind!… Um, no… with speakers! This little video shows you how to shatter wine glasses with your own speakers. Yep, those normal, everyday home speakers that you have can break a wine glass just like a jackhammer.
Hey guys. Here's a guide to making the best green screen studio without paying too much cash! Not cheap like our first one, Today we're balancing price AND quality. Can't use green poster board forever.
Check out this Make Magazine segment on building mini robots. Then you can move onto huge ones like Big Dog!
In this music production tutorial you will learn how to initialize setup and get a basic understanding of Midi Keyboards control with Reason 3.0. Learn the basic technology and effects that go along with creating electronic music from keyboards and other MIDI sources in Reason 3.0 in this three part tutorial. Part one covers basic setup, part two covers LFOs, Sequencer edits, and use of the Pitch bend / Mod wheel and part three covers understanding control knobs and the automation thereof.
Like it or not, Apple rules the world right now. Well, at least the electronic gadget world. Every single person and his or her mother has some sort of i-device: iPhone, iPod, iPad. So don't go iBroke the next time you want to add more songs to your iPhone or iPod by transferring all of your media files into iTunes readable formats.
eBay has been around for over ten years yet there are many people out there who are afraid to use it, or haven't had a chance to use it, due to negative hearsay. This video tutorial presents a guide to buying items successfully—and safely! There's a lot of things to consider when buying an item in an eBay auction, so make sure to pay attention to all of these four tips.
Check out this video to learn how to use TerrariaViewer to edit your inventory in Terraria 1.0.5. You can outfit your character with any items you want, control the game in a whole new way with this Terraria cheat.
Watch this video to learn about all of the new armor and vanity gear in Terraria 1.0.5. Learn how to get all of these items and what to do with them once you have them. Good luck collecting all these items!
Wouldn't it be great to have unlimited health and mana? How about as much of whatever item you want, whenever you want? If that sounds like something you might be interested in, then check out this video to learn how to hack Terraria.
Looking for a rare item in Terraria? This video is guide to finding and getting the Wizard Hat which will increase your magic damage. Learn what to do and how to do it by watching this Terraria video game guide.
Playing Minecraft on your Mac? Wondering how to install the Too Many Items mod you've been hearing so much about? Check out this video to learn how to download and install this Minecraft mod and take your Minecraft 1.6 experience to a whole new level.
Minecraft is a game about finding and gathering stuff, so of course you'll always want more stuff. This tutorial shows you how to use the game hacking program Cheat Engine to hack into Minecraft and increase all your available items.
This only works on single player games. You can use the free program Cheat Engine to hack into Minecraft and use it to duplicate items in your inventory. Get as many diamonds, obsidian blocks or gold ingots as you want!
