Whether you're the proud owner of a Microsoft KIN One smartphone or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of the phone's various features. Specifically, this video demonstrates the unit's Phone, Spot, Loop and Theme functionalities.
So you want to be a rock star? You can either go The Ramones route and pick up a guitar and make some noise... Or, you can do what (in most cases) might be best and learn how to read tablature. In this free lesson, learn how to read and understand tablature.
Are your wreaths looking a tad shabby? Make your own Christmas wreaths this holiday season with help from Mary Fletcher Jones and materials readily available at any Michael's craft store. To complete this beautiful wreath, you will need the following items:
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 43rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the MATCH function to find the ordinal position (relative position) of an item in a list.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 46th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use MS Excel's CHOOSE function.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.
Are you struggling to get mom a unique gift this Mother's Day? Do you always get her flowers or chocolates? Break out of the "same old, same old" and make a decorative tin for mom shown here in this video. By picking up just a few materials from your local craft store, you'll be one step closer to creating the best homemade gift mom has ever received!
To make this pop-up card, you just need two sheets of card stock. This pocket pop-up card is made specifically to hold money, which works great for birthdays and holidays, especially Christmas. This super simple pop up pocket card is easy to make, and it doesn't just have to hold money… it can hold gift vouchers or plastic cards, also. Super base for decorating either with stamps or designer papers.
In this Arts & Crafts video tutorial you will learn how to do the Cuttlebug 'smoosh' technique. For this project you will need a brayer, ink pad, an embossing folder and a Cuttlebug. Ink the brayer well and with it apply the ink on the embossing folder. Make sure the ink is applied thoroughly on the whole surface. Get the Cuttlebug ready, place the card stock inside the embossing folder, place a couple of ‘C’ plates in the Cuttlebug, put the embossing folder with one more ‘C’ plate ab...
You only need one single sheet of paper for this card fold, so grab it an watch this tutorial to learn how to make a diamond pop-up cracker card. Don't know what a cracker card is? Watch thee video and find out what this 3D homemade card is all about. You only need a single strip of card stock (10cm x 29.7cm). So quick, so simple — so make one! This is a great little crd that's easy to send through the post office.
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
Make some Chicken Pot Pie to warm your heart! Melt butter, add flour, and use a bit of chicken stock concentrate. Gives it a savory taste. Then whisk milk. This is the base. The chicken, ham, and peas should be mixed together in the base. Put it in your pie crust. Make a layer of crust to put on top. Cut off the extra dough and pinch it around. Slash it atleast four or five times so that the steam can come out. You can personalize with little batter cut outs. And splash with a little egg was ...
In this video tutorial, viewers learn how to cook cook kale, collard, mustard or turnip greens. The ingredients required are: frozen greens, chopped onion, chopped carrot, chopped celery, 2 cloves of garlic and 1 1/2 cups of chicken stock. Begin by putting the frozen greens into a pan and then add all the ingredients into the pan. To add flavor, add in 1/2 tsp of salt, 1/4 tsp of pepper, 1/4 tsp of freshly grounded nutmeg and 1/2 tsp of grounded mustard. Then cook it at low heat for 3 hours. ...
In this video tutorial, viewers learn how to make a shimmer mist mixture for cards. Begin by filling a small spray bottle with rubbing alcohol. Now add about 1/2 tsp-tbsp of Champagne Mist shimmer paint into the spray bottle and shake it to mix it. Users can also use frost white or platinum shimmer paint. To apply the shimmer mixture on a card, spray the mist in the air and wave the card stock into the mist. The alcohol will help dry the paint faster. This video will benefit those viewers who...
In this tutorial, Chef Ken Hom shows us how to make stir fry rice noodles with vegetables. First you will need to take 8 oz rice noodle and soak them in water until they are soft, then drain them. Now you need to prepare your vegetables. You will need: bean sprouts (8 oz), red peppers (4 oz), shredded water chestnuts (8 oz), spring onions (6 of them finely shredded). Now, stir fry your vegetables in oil and add in 1 tsp salt, 2 tbsp of soy sauce, 3 tbsp of rice wine, 2 1/2 tbsp tomato paste a...
In this Arts & Crafts video tutorial you will learn how to create a box to hold a mini album or small cards. Take a shiny card stock 10.5 x 6 inches. On the 6" side, score at .5" and 1" on both sides. On the longer side, score at 3, 3.5, 7.5 and 8 inches. Cut out the corners on the flap side of the card as shown in the video. Do a step cut on the other side of the card as in the video. Round the four corners with a corner rounder. You can do some stamping now if you want or you can also glue ...
In this Arts & Crafts video tutorial you will learn how to use clear stamps & make a card. You will need acrylic stamps for this project. The products used in the video are from papertrayink.com. The stamps are clear and have a sticky back with which you can attach them to an acrylic base to make the stamp block. Then ink the stamp and stamp it on the paper. Since, it is clear, you can ass and align it properly on the paper. The other cool thing about acrylic stamps is that you can take more ...
Shrimps can be easily stir-fried and watching this video will tell you exactly how to do it the easy way. 1 pound of raw, washed and deveined shrimps are used for this recipe which is marinated in 1 tablespoon soy sauce, 1 tablespoon cornstarch and 1 teaspoon salt. For the sauce, combine 1 tbsp paprika or hot sauce, 1/3 cup of water or stock, 3 tbsp ketchup, 2 tbsp soy sauce, 2 tbsp red vinegar, 2 tsp sesame oil and 2 tsp sugar in a bowl and mix well. Heat a pan and add 2 tbsp of cooking oil ...
Even if you are just starting out, you can still install an easy full lace wig. Just pick up a tube of adhesive cream and put it on the easy way. Ms. Lola will take you step by step through the process for beginners. People are going to wonder how you got such a hot look and you can proudly tell them you did it yourself!
Childcareland demonstrates how to make a cupcake shaped book in this video. First, make a pattern page from a regular piece of paper. It should be designed like a cupcake. Place the designed pattern on top of a thicker paper like construction paper or card stock. Place five pages of regular paper behind the thicker page and finally place another thicker page at the back of the stack. Glue the cupcake pattern to the top, thick page, slightly to the left side. Then staple down the length of the...
This video demonstrates how to determine if your Ugg Boots are counterfeit. If you purchase Ugg boots on the Internet and you are wondering if they are fake, you should examine the box closely. Uggs are made in Australia. If there are any labels affixed to the side that indicate other countries (e.g. China), then they are fake Uggs.
In this video tutorial, viewers learn how to make a Halloween lanterns. Users will need to visit this website: jennadeangeles/] and download the Halloween template. The materials required for this project are: download template, vellum, poster, rubber stamps, metal ruler, glue and orange card stock. Begin by cutting out the lantern with the openings as well. Now stamp the vellum with some black acrylic paint. Finish by closing the lantern with glue. This video i...
The chef shows how to prepare and cook a perfect roast chicken. Begin by rubbing sliced garlic over the skin of the chicken. Then place the garlic into the cavity, along with some thyme and sliced lemon. Rub the chicken with olive oil and sprinkle with pepper and rock salt.
This is a great tutorial for making a simple tote bag from household items. Pick a basic fabric and you're on your way with a lightweight and versatile catch all for books, groceries, etc.
In this video tutorial, viewers learn how to cut a scarf joint in crown molding and coving. Scarf joint is simply two flat planes meeting on an angle relative to the axis of the stock being joined. Users will need a magic miter. The magic miter is a miter box for cutting miter joints at any angle in crown molding, baseboard, chair rails and more. Adjust the machine to a 45 degree angle and lock it. Put in the mold and cut it. Repeat the same step for the other side. This video will benefit th...
Amelia Ceja prepares delicious filet mignon with roasted potatoes. She starts by placing the sliced potatoes on a baking sheet. Then she adds some garlic cloves and sprinkles with olive oil, then some fresh cracked pepper, cayenne pepper, kosher salt and fresh rosemary and thyme. This goes into the oven to roast for about 40 minutes.
Goldiestarling teaches you how to apply a snowflake fairy makeup look. You first need to draw the snowflakes on some card stock and then cut them out. Apply those to the face using eyelash adhesive. Use a moisturizer and then a blue powder using a short haired brush. Apply a frosty white metallic color around the eyelids. Also add a darker blue around the snowflake edges. You can also add small rhinestones and glitter to the snowflakes. Use a light brown lipstick for the lips and blend it wit...
You start off with a printed design on your doll. Use regular paper, but you have to print the doll in individual pieces - body, hands, legs, head. You stick those on the front of hard materials like thick card stock or some thick fabric. Now you can putt the doll together and make adjustments. You put the doll together by using small thumb tacks. It's even better if you have ones that have a rhinestone on them. Once you've done the joints, you can also add a little tutu or some fairy wings. ...
A step-by-step video tutorial presented by Andrew Wasson shows the basics of playing the slide guitar for beginners. First, choose what kind of slide you want. Metal slides are known for their high-end treble sound, while glass slides are a little warmer sounding. Andrew goes on to teach you what gauge of strings are best suited for slide playing, as well as how to pick which finger to use your slide on.
The template for this heart-shaped window card can be found at [www.stampininspirations.blogspot.com stampininspirations.blogspot.com]. You will need the template and cardstock and the other usual materials needed to make a card. You can re-size the template to about 5 1/2 inches across by about 5 1/2 inches high. Cut out the heart and remove the center heart as well. Take an 8 1/2 by 11 inch piece of red card stock and fold it in half, then trace the inside and outside of the heart-shaped te...
Vijay Wanchoo of the Imperial Hotel in Janpath, India shares this recipe. To make the concasse sauce he removes the skin of the tomatoes by putting them into hot water for a few seconds, then immediately into cold water; the skin then peels off easily. The tomatoes are then sliced, seeded and cubed.
Learn how to cook Southern green beans with ham the quick and easy way. 1 Chop the onions and wash and peel the potatoes. 2 Cut two to three cups of ham into bite sized piece. 3 Heat oil and pan and sauté the onions. Add the ham when the onions are translucent. Add the potatoes and beans. 4 Season and add water or ham stock. 5 Cover and reduce the liquid until the potatoes are cooked through. 6 Serve with cornbread.
Demonstrator Dawn Griffith offers a short tutorial on how to make a simple and cute birthday card. First you will use white paper to make your base card. Then use a scallop edge punch to scallop some green designer paper, which you will glue to the top of your card. Tie some white ribbon around the top and trim for a clean look. Use a greeting stamp to stamp a message onto the bottom right front of your card. Create a center image by adhering white paper on black card stock, stamp the white p...
Our host Dawn teaches how to use the Versa Mark resist technique when stamping a card. Dawn teaches the technique on a Christmas card to create a snowflake background. The basic idea behind this technique is that the Versa Ink is clear and will resist any other ink you put down, so you can stamp a pattern and then go over with a flat coat of regular ink, and you will be left with a white pattern where you made the Versa Ink stamps. To complete this specific craft, you will need a Versa Mark i...
This tri-fold card idea can be used to make an assortment of great cards for any occasion. This card design may look a bit difficult but in reality it isn't at all. Once you get your card in the accordion fold you are ready to decorate. This video will demonstrate how to fold your card stock into this awesome fold design and make a tri-fold shutter card for any occasion. This scrapbooking design will awe whomever you share it with, just make sure to decorate it to the tee.
