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.
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.
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...
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.
Your tooth is throbbing, your head is pounding, and the oral surgeon can't see you until this afternoon. You'll need something to take the edge off until the good doctor can fit you in.
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.
Learn how to do alternate lockout push ups on dumbbells or a medicine ball. Presented by Real Jock Gay Fitness Health & Life.
When it comes to global warming, most of us think of carbon dioxide emissions. While carbon dioxide is the most important greenhouse gas, carbon dioxide emissions have stayed constant for the last three years. On the other hand, methane, the second most important gas, has been steadily rising since 2007.
The first public beta of Android O, (most likely to be called "Android 8.0 Oreo") was released on May 17, bringing tons of new features and goodies for Android enthusiasts with supported devices. However, not all of Android O's features were available to try out right off the bat. Possibly the single biggest feature announced during the developer preview of Android O, Picture-in-Picture mode, is nowhere to be seen.
There's something magical about homemade foods, especially when they're items that most people don't make. Even the simplest bread tastes divine when you've mixed it yourself, kneaded it yourself, and gotten the dough stuck underneath your nails.
If you're anything like me, clutter scattered across the bathroom counter, on the shower floor, or on any other available space is maddening. Who enjoys a mess of shampoos, scrubs, and sponges strewn around their feet or just out of reach in the shower? What can you do when space is limited?
How to build a set of strong, stackable sturdy sawhorses. Let's face it, one of the most useful pieces of carpentry equipment would have to be a set of sawhorses. Every worksite, garage or workshop needs a set of sawhorses. They have numerous uses from stacking timber on, using as painting racks, to using as a temporary workbench by laying a door or some ply across two sawhorses. You can even use them as trestles for a dining table!
One of the most common complaints about the Nexus line of devices is that they don't have expandable memory.
Last week, I showed you why your refrigerator is one of the best tools in the kitchen when it comes to saving money and preserving food at its tastiest. But did you know your freezer is another underutilized ally in the cooking game?
