New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
This video shows how to make a eco friendly plant holder. The first thing you do is trace a fabric around the tin can this is to give it a better look. Then stamp the letters on the fabric of what you want to name your plant. After that poke about ten holes at the bottom of the can. Then glue the back of the fabric to place it on the can. Now wrap the fabric around the can on the sticky side. Lastly tie twine around the can for extra protection to hold up the fabric. Then put in the plants an...
To straighten frizzy hair with a flat iron, first wash your hair and towel blot it dry. Then, part your hair down the middle. Massage a product like Chi Silk Infusion through your hair by first applying a little bit to your palm and then working it into your hair. Use a flat rectangular brush and blow dry your hair. Separate your hair into sections. Use a flat iron and a comb to straighten your partitions of hair. Tilt your hair straightener at an angle when straightening the ends of your hai...
These days, everyone is looking to save a few dollars. In this 2 part tutorial, learn how to cut a man's hair, and save those extra bucks you would've spent at the barber shop. The process is quite easy, and its always fun to learn a new skill. So, grab your son, brother, nephew, boyfriend- anyone- and start snipping!
This video is about how to make a story board craft. In this case the story is about Alice in Wonderland. In this case 3 Eco art boards are taken of a suitable size of 2 1/2"X3 1/2" the left edge is decorated with a lace spray painted with Memorie mist spray, the rest of the card is also spray painted. Now from Queen Kat Designs the stampings are selected and stamped on each board as per the story. Whilst stamping Indian stamping ink is used as it does not smudges. For extra decoration paper ...
In this Arts & Crafts video tutorial you will learn how to do Whipstitching. The video demonstrates how to stitch the bottom of a cloth basket to the sides of the basket. A whipstitch is a very basic stitch. Start at one end of the basket; attach the bottom to the sides with a pin. Pass the needle from the inside so that the knot is hidden. All you have to do is taking the thread and whipping it around the edge. At the beginning, give it a bit of binding stitch before stitching the rest of th...
This video shows you how to make slime, flubber or goop. Take two ounces of glue and one quarter cup of water. Pour the water into the glue and stir the mixture. Pour in a few drops of paint and keep stirring. The more paint you add, the darker it will be. Take one quarter teaspoon of borax and one quarter cup of warm water. Add the borax powder into the warm water and mix together to dissolve the borax. It is ok if not all the borax is dissolved. Pour the borax mixture into the glue mixture ...
This video demonstrates that just because a shoe feels loose doesn't mean it's the wrong fit. Many shoes have a back eyelet that rarely gets used, but if you put your laces through it before tightening, it will raise the fabric of the shoe to give more support to the heel. If your shoe doesn't have this extra eyelet, you can create false eyelets by creating loops with your laces on the top two eyelets of the shoe, then lacing them through those fake eyelets before tightening. Both of these me...
This video shows how to get more value on your GoDaddy account. You have to have a deluxe account to share domains. You have to pay an extra $2 a month to get this account. Once you sign in go to "hosting" then my "hosting account". To add another domain you move it over to a new folder then put the site files in there. To do this, click add domain then go to bulk. Then create a folder and name it what you desire. Sometimes the file folder doesn't always appear immediately, but it is there, i...
In a tool shed there are two gentlemen discussing how handy a well organized tool shed or tool box is. One man starts to say that he has come up with a easy and in expensive way to keep hand tools organized. Find a old simple nail apron and draw some lines down the pouch. This lines will later turn into places to put tools so it is a good idea to think ahead about what tools you will end up using and adjust the size accordingly. Next, snitch up those lines that you have drawn. Finish up by pu...
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
The linked video shows how an elderly woman named Clara makes pizza from scratch. The first thing she does is flatten out the dough using a roller and then she places it on a pan as she continues to flatten out the dough with her hands, and she suggests that you use extra virgin olive oil on the dough. She then puts her homemade sauce, anchovies and both powdered and small pieces of block cheese onto the pizza. Clara then cooked the pizza at 350 de...
Watch this video to learn how to make simple turquoise hoop earrings. Start by taking some 20-22 gauge wire and wrap it around a soda bottle cap. Overlap the wire a little bit so that it forms a complete circle plus a little extra. Clip the wire off just a little bit past the overlap point. Do this twice so that you can make two earrings. In one end of the wire make a little loop and bend it back just a little. Put the beads that you want on the earring onto the wire loop. Put a slight bend i...
Julie Hasson of Everyday Dish TV teaches how to make rosemary garlic crackers. Ingredients: 1 cup all-purpose flour, 1 cup white whole wheat or whole wheat pastry flour, 2 tbsp nutritional yeast, 1 tsp baking powder, 2 tsp dried rosemary, 1 tsp granulated garlic, 3/4 tsp fine sea salt, 1/4 tsp ground pepper, optional (but good!), 1/2 cup water, 3 tbsp extra virgin olive oil, coarse sea salt crystals, optional. Put all the ingredients in a bowl. Mix. Knead the dough using both hands. Put it on...
In this video, Marty Schwartz shows us how to play "I Gotta Feeling" by Black Eyed Peas on guitar. This song is 3 chords and Marty explains everything so clearly so that even the most novice guitar player will learn how to play this song. He explains the placement of fingers for each chord and takes you through the main chord progressions which are G, C, E minor, back to C. After he teaches the basics of it, he tells us how to add a cool extra sound to it by adding a suspension to the G chord...
Larry Cook gives the low-down on how to make a nutritious Tempeh and Shiitake Mushroom Stir-fry. Tempeh is an Indonesian based dish made out of slightly fermented soybeans that are shaped into a patty. It can be used as a meat substitute and the mushrooms and asparagus add antioxidants to your meal. You can add extra spices and liquid marinades as shown to jazz up the taste of the Tempeh. Larry also demonstrates how to make a healthy salad that pairs perfectly with the stir fry.
In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...
We tend to sympathize with those who get hurt. Do you want some extra care and affection from somebody you love? Then here is one great idea to make anybody give you their shoulder to cry on. This video helps you to make a prosthetic scar on your leg. Create a gory looking bruise with modeling wax, liquid latex, skin color makeup and coagulated blood. For best and genuine scars, make the cut look real deep and oozing with blood. Show it to your friends and see the results for yourself.
You'll need to head back to the prison car at the end of this mission in The Saboteur for the Xbox 360. The ninth mission in Act 2: Rolling Thunder is where you need to talk to Bishop, and then find Skylar near the Arc de Triomphe. This is a big mission. First, Skylar goes with you to sabotage a bridge. You need to find the four points (highlighted with red lights) to plant sabotage. You're not using dynamite this time. You'll see little ghosts of the sabotage at the exact points to plant the...
Enjoy your time with Margot on this mission in The Saboteur for the Xbox 360. The fifth mission in Act 2: Fahrenheit Four Fifty is easy. Now that Margot is on your side, you can do some side missions for her. This is a nice easy one. Travel to the Arc de Triomphe and get a disguise from one of the guards patrolling on the outside. Now slip in behind the tank and place some dynamite on the back Run off to the right and out of the way and you'll completely avoid detection. For more info, watch ...
1. Recall previous dreams. Start by working on backwards through the dreams and after waking; write the dream down in a journal.
To make a wasabi vinaigrette salad start with some lettuce. You can use a variety of different salads such as romaine, black eyed Simpson, bib lettuce, and four season lettuce. You can also add arugula and other herbs, freshly grated Parmesan, fresh sausage, avocado, goat cheese, salami, and pesto sauce.
To make the fish stew start by taking a sauce pan and put some butter and olive oil in the pan. Put in cut up one white onion, one cut up rib of celery, and a pinch of salt and sauté on medium low heat for six to seven minutes until the onion is soft and golden but you don't want to brown the onion. Next put five cloves of minced garlic into the pan and sauté it for one minute and then add two cups of a good white wine. Bring the heat up to high and simmer the mixture. Add in a bay leaf, some...
How to conjugate in the subjunctive in Spanish for the present tense.
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
Everything tasted better homemade than out of the package. For your next fiesta, why not make your own tortillas? With this descriptive tutorial on how to make homemade flour tortillas, the process is easy and requires no special equipment. To make homemade tortillas you will need 3 cups of all-purpose flour, 2 tsp. baking powder, 1 tsp. salt, 2 tbsp. vegetable oil, and extra flour. Equipment needed includes: a large mixing bowl, a pastry or cutting board, plastic wrap, a griddle, spatula, an...
Everybody is going digital these days, so everybody has a reason for software like HandBrake. You can save your entire DVD collection on your computer in digital files, and you can convert videos into different formats. Check out this video tutorial on how to rip DVDs and convert videos on Ubuntu Linux, Windows, and Mac.
Save the trees! Have a few extra wire hangers hanging around? Make your own retro Christmas tree for your next holiday season out of old hangers, wiring, and shiny tinsel. With help from ThreadBanger's Decor It Yourself, your new Christmas tree will be done in no time, standing tall and eco-proud!
ThreadBanger give us a great recipe to make a unisex bomber hat using just a flannel shirt, white faux fur, a measuring tape, the bomber hat pattern, a sewing machine, and two and a half hours of your creative time. Add pom-poms at the ears to give it extra flavor! Super cool look for both dudes and ladies.
Don’t wait for Cinco de Mayo to enjoy a Mexican meal – tacos are a tasty addition to any table any time.
Need a pinata for Cinco De Mayo or special occasion? This week Meg of Decor It Yourself shows you how with some simple house hold materials. Piñatas are a fun Mexican tradition, and are as easy to make as any paper mache project. Check out this how-to video to get ready for your next fiesta!
Lure luck your way at your workplace by arranging things according to the ancient Chinese design philosophy known as feng shui. De-clutter your desk and workspace, which is the most important thing you can do to balance the _chi_—or energy—in your office. Repair or get rid of anything that’s broken—like a pen that’s out of ink or a flickering desk lamp. They block your chi. The placement of your desk and chair should allow you to see who’s coming into the room. Business and opportunity symbol...
Create a bootable USB flash drive to keep an extra OS of Windows or Ubuntu. You always want to have a copy of your Linux or Windows operating system on a separate device other than your computer. Because even if your computer or laptop is relatively new, it's very easy for some random fluke - an internal error or virus - to completely shut you down when you least expect it.
This is an instructional video on dancing the Tango, specifically the footwork. This elegant dance instructional goes over the High Back Boleo. Boleos from back ocho with leg in air. Also with extra tap. Music: Que Te Importe Que Llore (Calo)
Cranberry sauce is one of the most important side dishes to any Thanksgiving dinner—even Christmas dinner! And if you're like me, you usually buy a can of cranberry sauce for the holidays because you don't have the extra time to go homemade with the turkey stealing the show.
Ochos with cha cha cha -- it is a '1-2-3, 1' rhythm, as in 'step-2-3, step'. The 2 tiny extra steps are embellishments that the lady can add in as the man leads a back or forward ocho.
Watch this instructional ceramics video to learn how to trim a large tiered bowl with Simon Leach. With a thin bowl, one needs to be careful when balancing the upside-down bowl on the bat. Leach trims each individual tier with a large trimming tool. The large and possibly wobbly ceramic bowl can become once again even and graceful with some adventurous trimming. As we can see from the trimming process, when throwing a tiered bowl, it helps to leave some extra bulk.
This instructional ceramics video shows you how to trim a round bowl. It is much easier of you have a centered pot to begin with. It is also helpful to leave a bit of extra clay in the base so that one can trim more freely. Once the clay is semi-dry, you can begin trimming. After trimming, smooth the trimming marks out using a rubber rib. A touch of water on the rim will re-elevate the rim after trimming your round pot.
Those born under the Taurus sign need to be handled with kid gloves. To trap a Taurus you will need a loyal nature, a strong sense of self image an a respect for money. Take the tie to look extra special for your Taurus since they pay particular attention to appearances. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with a Taurus work.
Carrier-branded Galaxy S9 models come with a ton of bloatware that you usually can't get rid of without rooting. With a little digital elbow grease, however, there is a way to disable bloatware on your S9 or S9+, and it's a lot safer that attempting to root and modify you precious device.
