New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
Joel Harper from Runners World TV is going to show you how an ab workout properly named the "karate kid". For this ab exercise you are going to need a small medicine ball preferably one with sand inside and you are going to want to place it between your two feet while standing. Now, you want to squeeze the ball with your feet and then jump and try and toss the ball as far as you can into the air. Depending on the health of your knees you can work on flexibility also by after throwing it into ...
Are you looking for a way to take your salad to the next level? Try making your very own vinaigrette salad dressing to impress your family and friends. This great recipe will give you the inspiration to be creative in the kitchen.
Looking to make your next cake stand out? How about giving it that extra "umph" with a unique cake decoration topper? In this three-part video tutorial, learn how to make an adorable angel cake topper out of fondant icing. Get step by step instructions on how to take pieces of molded frosting and turn them into this perfect & professional looking cake accesory.
Hands are a tricky thing to draw. Not everybody can get them right. It takes times and practice to draw hands realistically. This particular tutorial will show you how to draw a hand making a "peace sign". Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
CHOW member Eric Higgins uses whole canned tomatoes to cook. As their seeds spoil the food by giving a bitter taste, he gives us step-by-step instructions to remove them using a salad spinner.
Don't have the extra cash to spend on a shell case to protect your iPod? In his ongoing duct tape tutorial adventures, DuctTapeStuff reveals a cheap way to make a shell case for your iPod out of duct tape and a few minutes of your time.
If you have questions, Redbook Magazine has answers. "Love your life." Redbook is for the woman juggling family, career, and her own own needs.
This subtle trick will lengthen your school report without your having to write a single extra word. Learn how to extend the length of your papers with this simple video. You will need a paper and flexible ethics. The trick is to enlarge the font of all the periods in your paper! Fact: If you have a 16 page, 12 point paper, changing the periods to 14-point will stretch the paper to 19 pages!
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
The Windsor knot, also (wrongly) known as the "Double-Windsor" (a non-existent enormous 16-move knot), is the most well known knot in the world. The Windsor is a large, symmetrical, self-releasing triangular knot. The tie was named by Americans in the 1920-30's after the Duke of Windsor. The Duke was known for his fondness of large triangular tie knots, but didn't in fact invent this particular knot. His secret was a specially tailored tie with an extra thickness of material.
Want to boost your WiFi reception? Have an extra wok or parabolic collander? This video tutorial demonstrates a simple hack that will allow you to build an effective radio antenna that will significantly increase the gain of your WiFi signal. To replicate this hack at home, you'll need the following items: (a) a piece of parabolic cookware, (b) heavy tape, (c) a USB WiFi stick, (d) tin snips, and (5) a USB extension cable. For detailed instructions on building your own wireless signal extende...
When it comes to quirky homemade DIY, cords - made from rope, twine, or other materials - aren't usually used in many projects. Other than tying nautical knots, it seems they're quite defunct.
The trouble with jewelry that's been made by a mass retailer or even a hipster/indie artist is that it's made without any care to your wrist, neck, or finger size. Often this means that bracelets may sling too big, or necklaces wrap around your neck too tight.
In this video, we learn how to make organic vegan quinoa salad. This super food is a complete protein that's rich in amino acids and protein. First, rinse the quinoa in a strainer, then put into a pot with 2 cups of water. Bring this to a boil while covered, then when the liquid is absorbed it's done. Now, chop up some bell pepper and cucumber and mix it up with the quinoa until it's well combined. Next, add in some roasted pistachios, cranberries, extra virgin olive oil, and maple syrup. Aft...
Generally we recommend you keep your eye makeup natural when going out to the office or even out for cocktails (easy transition from daytime makeup, and also you could pair it with a red lip).
In this video we learn how to make a dress out of an old flannel & t-shirt. First, measure your body on the bust. Then, take an old shirt and mark the measurement on there. Then, cut where you marked the shirt leaving 1/2" extra. After this, attach the top of the dress to the flannel by sewing it with either a needle and thread or a sewing machine. After this, take the part that you cut off and sew it to the bottom of the dress. When finished, try this on and enjoy wearing your new homemade d...
In this video, we learn how to make a feminine, long fitted sweater. First, lay out your fabric and use a pen to trace the lines for the sweater, measure it out so it's a good fit. Make sure to cut around the edges so you have room to sew. Now, sew along the edges and then turn the shirt inside out. Then, take extra fabric and cut out rectangular pieces that you will then attach to the bottom of the sweater by sewing them on. Once you are finished with this, try your sweater on to see how it ...
In this video, we learn how to install a vanity and sink with Lowe's. A great way to give your bathroom a makeover is to give it a new vanity and sink. First, turn off the water from the water line, then take down the pipes from under the sink. Use a bucket to catch extra water that's falling out. Next, separate the top from the base and then remove the old vanity. Remove the old base unit from the bathroom and then install the new vanity. Measure out the area to make sure it will fit. Place ...
Getting your tenderloin steak trimmed at the butcher is what most of us do when we're craving steak for the night, but why spend the extra bucks when you can trim that tenderloin at home?
Summer has almost come to its close, so celebrate the last remaining days of warm weather and fresh eats by making this delicious and creamy fava bean soup.
To do the Presto Printo Card Trick, you need to begin with a deck of standard cards and a deck of plain white cards, which have been cut to the same size as standard cards. You will need to print the effects that you want to achieve on the cards in advance. You will need extra blank white cards to conceal.
In order to perform the Four Kings magic card trick, you will need to begin with the set up. Remove the four kings for the deck. Place the four kings on top of the deck. When they pick a card, force your king as their card. Make it look like you are pushing their card into the center of the deck, instead, put it at the bottom of the break: i.e. underneath the 3 other kings. Show them the top four cards and show them that one of the cards is theirs, but peel off 7 cards, showing them their kin...
Before watching this video, we thought there was only one type of butter: The kind you buy in sticks or in plastic containers at the grocery store and toss into all your foods for extra flavor. But apparently butter is a much more complex foodstuff than we thought.
Seated dips are one of those exercises that looks easy but is a real pain to actually do. While you can do seated dips on the floor, doing them on a bench with your feet flexed adds an extra dimension of height that will increase muscle intensity and heart rate.
In Hollywood, not many celebrities embrace either their natural hair color or their natural hair. So starlets who have naturally curly locks (think Nicole Kidman and AnnaLynne McCord) straighten them and starlets with naturally straight locks (think Hayden Panetierre) love curling them up for extra volume.
Breakfast in America is poop when compared to breakfast in Morocco. While we're nomming on whatever expired cereal we can find in our pantry while still in our sleepy mole-person state, ladies and gents in Morocco are sipping on sweet tea and eating sweet, fluffy pastries stuffed with apples and figs.
In this video, we learn how to fold a ring out of a one dollar bill. First, fold the white edges in at the top and the bottom. Next, fold it in half and then spin it around 180 degrees. Next, fold it in half again, then take the white edge on the right side and fold it down until you can see the 1. now, make a backwards "L" shape and fold it back down, then curl it up. Now fold the L underneath and curl the extra part underneath the 1. Now, place this on your hand and you can wear it as a ring!
Don't get us wrong: We adore gift boxes, as they let us both conceal a gift and make the gift look more appealing by wrapping up the box in pretty wrapping paper and smacking a bow on top, but there's one big gripe we have about them. They either come in Small, Medium, or Large. So if your gift doesn't exactly fit one of those predesignated sizes, then the box is either too small in areas or too large, which is a pain.
Here in America, we have this idea that the bigger, the better. Why purchase large fries when you can get them supersized for just $40 extra, for instance, and why not buy the value pack of salsa to save some money when compared to buying individually?
Smoking food is one of the best ways you can prepare food, since it both imparts a rich, wood grainy flavor and treats food without needing to add excess oils (which also add extra calories and fat). But what happens if you don't have a large backyard and smoker?
In this video tutorial, viewers learn how to find the circumference of a circle. This task is very easy, simple and fast to do. To find the circumference of a circle, multiple Pi with the diameter of the circle. The value of Pi is 3.14. The diameter is equal to 2 times the radius. Simply multiply the radius by 2 to find he diameter. The diameter is the straight horizontal line in the center of a circle. This video provides a demonstration for viewers to easily understand and follow along. Thi...
If you're having a problem with your vacuum cleaner's internal hose, this video may help. In this tutorial you'll find out how easy it can be to replace the internal hose on a Dyson DC07 vacuum cleaner.
