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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.
Reading people's minds is something that most inquisitive and sensitive people have wished that they could do at some point. Well, what if you could? This video will show you a great multipurpose bar trick that will allow you to appear to read the mind or body of people in a variety of situations. It's really remarkable how easy this is and how well it works.
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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
You have to be careful not to accidentally sew in a short circuit when you are working with connective thread. This tutorial shows you how to sew in a connection to an arduino, a buzzer and a battery on a glove.
The success or failure of your sewing project relies only in part on your skill - if you choose the wrong fabric, it won't matter how good you are. But picking the right fabric will forgive many small errors you might make. Also, learn the difference between woven and knit fabrics.
Don't let your window pane become a window pain in the ass to look at. Windows should give us clear views of the beautiful world outside, but without regular maintence they can become splotchy and muddled. Check out this video for a quick way to clearn your windows.
No, it doesn't use actual dragonscales. This technique actually uses two different sizes of rings with the proper aspect ratio (at least three of the larger rings have to fit through the smaller ones). If you have enough rings, then just follow along to master this challenging technique.
This tutorial shows you how to make an elven style of chainmail. This is an intricate style of chainmail that is nevertheless very sturdy and gives good coverage. Good for anyone looking to make their own armor for Renaissance Faires, larps, the SCA or other historial costuming events.
If you're a man who likes to crossdress or a small-breasted woman, you've probably yearned for larger breasts at some point in your life. In this video you'll learn how to use makeup to highlight and accentuate your cleavage quickly and easily.
Quinn Fabray, as many of you probably already know, is the reformed bad girl on "Glee." Formerly a haughty cheerleader, she's now a mom and sings for the glee club happily.
Contrary to popular opinion, Chinese food does not only consist of orange chicken and friend rice (though, admittedly, they are quite delish). In fact, there exists quite a variety of elegant, delicate dishes for the picky gastronome.
Pint sized vampire Jane from the "Twilight" series can literally slay others with a glance, but we think she could knock others spellbound with her deviously good looks just as easily. Played by Dakota Fanning in the movies, Jane likes to wear makeup shades in line with her coldhearted character: deep pewters, smoky grays, and of course black.
In this episode of Show Me the Curry, learn how to make traditional Indian snack food, Sav. This recipe is for a hot and spicy sav but if you are not big on the spice you can adjust the ingredients to your liking. Enjoy this crispy treat as a satisfying mid-day snack anytime! Yum!
A memorable and well thought out Father's Day present doesn't have to be expensive or outrageous. In fact, some of the most cherished gifts are handmade, espeically when it comes to gifts that feature warm family photographs.
If you have upgraded your Windows to Windows 7 and want to stay current with all the new operating systems and software but hate it when you're faced with all the changes upgrading brings, you can download the 7 Taskbar Tweaker to configure your taskbar to your preferences. If you liked the old feel of Windows you can change that by choosing the option, you can also change what happens when you click on certain buttons to make your computer user friendly.
Without speed, you'd swim like a turtle at your swim club races, which is okay if you're into leisurely paced losing. Whether you're navigating away from a hungry shark who likes your "Family Guy" swim trunks or trying to finally snag that "First Place" trophy, speed is something you can always improve on.
Nobody likes having bad breath. Not only does it leave you with a bad taste and scare away potential suitors, it can be a signal of more serious dental issues. This helpful video from Colgate offers up some tips you can use to cure your bad breath and improve your overall health.
Who likes Pizza!?! Well, a pizza wouldn't be a pizza without the dough. It's the major piece of the pizza pie puzzle. Learn close-up how to make pizza dough from scratch with this video recipe tutorial. This Susan's Cooking School video demonstrates each step in the process of making a versatile yeast dough.
No one likes having their food messed with. That makes it all the more fun to do so right? This video will show you some fun pranks that you can pull to mess with the food of your friends and neighbors. They include making surprise disgusting layer dip and ordering unusual combinations of items at the grocery store, but are all freakin' hilarious and require relatively little setup or risk.
Do you like music? How about the acoustic guitar? How about Brenda Lee? How about a Willie Nelson, Elvis Presley, or the Pet Shop Boys? Well, this video tutorial will show you how to play "Always on My Mind," most notably by Elvis Presley. This instructional guitar lesson will teach you a few tips and tricks for playing an arrangement of the famous song.
In this video from theXBox360GameReview we learn how start and join an Xbox Live party. Once signed into Xbox live, scroll to the friends channel, and select the friend you want to have your party with and press Y. Now that you have a party going, you can play some Halo wars. If you want more friends to join the party go to your friends list using the guide button and tap X to select who you want to invite. If you want everyone in the party join in, select Party and choose Invite Party to gam...
You don’t have to be a psychic to read someone’s mind – or, at least, to make them think you’re reading their mind, as shown in this how-to video. You will need one card with an "X" on back, an envelope with "you will choose (blank card)," a duplicate of the third card, and a flat surface. Watch this video magic tutorial and create the illusion of reading someone's mind while performing a card trick.
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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).
It's a timeless doggie no-no, and one that has been paradied in numerous dog scenes in movies: A plate of delicious fried, steaming food is left by the owner on the table. The owner then leaves for a brief moment. His dog, smelling the delicious goodness, seizes the moment and quickly jumps up, snatches a piece of chicken, and devours it under the table.
A tutorial for the Harry Potter fan who likes to play with eyeshadow! This will look great on skin tones that do well with green (of course). Give yourself a green and golden look inspired by the colors of Slytherin house.
Nobody likes a wasted battery. That's why it's important to make sure you close all of the running Android apps that you don't need. On the new Samsung Galaxy Tab, it's easy to eliminate those battery-draining apps via the Task Manager. See how to access it and how to clean up the mess!
First comes navigation, then comes customization. That's how it always works. You need to familiarize yourself with the workings of the new Samsung Galaxy Tab first, then learn to customize the Samsung Galaxy Tab operating system to your liking. See how to customize your five homescreens!
Is the default TweetDeck notification sound driving you crazy? Change it to something of your liking. It's an easy process and this video presents a complete, step-by-step overview of what you'll need to do. For more information, including detailed instructions, and to get started changing the TweetDeck notification sound yourself, take a look.
Everyone is excited about the new iOS 4 update for the iPhone and iPod Touch, right? Well, if you have installed it and decided you liked the 3G version better, check out this clip. In this tutorial, learn how to get back to your familiar 3.1.3 version of iPhone firmware and back into your comfort zone.
Learn how to add numbers using the SUM and AutoSUM functions within Microsoft Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started adjusting the MS Excel 2010 Ribbon bar to your own liking, watch this free video guide.
Get those annoying wisps of hair out of your face in time for your afternoon pilates session while still looking put together by braiding your bangs into a hair headband.
Love is one of the most confusing parts of life. There aren't any set rules for trying to figure out if a girl or guy likes you. In this video tutorial, you'll find out exactly just that. How to tell if a guy has a crush on you. This is just one way out of many to tell if a guy likes you. So good luck and enjoy!
To create red and gold acrylic nails start by prepping a sanitizing your finger nails and applying the tips. after you have trimmed you nails to the desired length apply primer to you nail bed. With your brush gently apply the gold glitter to the tip of you nail and brush downwards toward your nail bed. Apply your red glitter the same way under your gold glitter. With your brush create what Jennisse calls a smile under the glitter to your liking. Cover your nail evenly with a thin layer of pi...
Learn how to make stuffed pizza pockets for your kids. A delicious snack or meal. A larger version of this Italian recipe is often called a calzone. Vary the fillings to your families liking and you will win raves at the table.
An instructional video by tradigital artist Merrill Kazanjian. Step 1- Scan the image
Just a fun Medusa snake mask for halloween. Halloween is a fun time for makeup artists, and everyone who likes to dress up. Get them creative juices flowing this Halloween. Be bold, be brave! Enjoy this Halloween makeup tutorial and learn how to paint some sinisters snakes on your face.
When you meet a dog, the first thing you do is pet the head and the dog likes it, right? Wrong. Most dogs don't like being pet on the head, even if you think they do, and they're constantly sending signals that they don't want to get a head patting. Learn how to read a dog's body language to find out whether or not they want to be pet on the head by watching this instructional video.
Flashback Max ties Barry's Pike Fly, so watch and learn. He likes the saltwater hooks, because they're stronger, but if you want to do it with a cheaper, weaker hook, well, don't come crying when it doesn't work.
The act of liking someone's really old Instagram post is called "deep-liking," which is pretty apt if you think about it. While going "deep" into older posts on the feed of your ex or crush or whoever, your finger may slip accidentally and double-tap on a photo or video that you'd rather not let them know you're looking at.
Finding the right theme can be a pain. Some are too gaudy or simple, while others look like they were thrown together as a joke. So why not try your hand at making your own?