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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.
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 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.
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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
Get a vase and a bouquet holder with dry flower foam inside. Put the bouquet holder in the vase. Place one gardenia in the center hole of the dry flower foam. Then place three gardenias in the holes around the center(odd numbers are good in floral design), evenly spaced apart. Once you are done with that, place a gardenia in the hole in between each of your three outside gardenias, but push them in further, so that they are slightly lower than the other three gardenias. In the remaining holes...
blockvideos shows how to build a cinderblock compost bin for recycling needs. The builder will need 20 corner blocks, 36 AB York blocks, 12 AB Dublin blocks, 17 wall caps, 5 fifty pound bags of crushed rock, and and 2 tubes of masonry adhesive. To begin, find a location to build the compost bin and lay out the first layer of back wall and side wall blocks, lining them up straight. Check the dimensions of the layout. Once confirmed accurate, use a shovel to mark the grass around the blocks. Re...
In this how to video, you will learn how to make a croissant. You will need 130 grams of sugar, 100 grams of butter, 250 grams of butter, 200 grams of flour, 500 grams of milk, 20 grams of salt, 3 eggs, 1 kilogram of plain flour, 50 grams of yeast, and 1 vanilla pod. First, melt 100 grams of butter for about 15 seconds in the microwave. Add the melted butter into the mixer. Add the 3 eggs, sugar, vanilla, and salt. Mix everything together. Next, add the yeast and then continue to mix. Add mil...
This video shows you how to properly shuck an oyster. You will need oysters and a shucking knife. A glove is also useful for safely doing this procedure. A towel can be used to place the oyster on. You can either hold the oyster or place it on a towel. Oysters have a cup, a flat side, and a pointed end. The pointed end is wear the hinge is. Hold the oyster with the flat side down and the pointed side towards you. Place the knife inside the point and twist until you get in. Make sure only the ...
In order to decorate a Perky Petals Tiered Cake, you will need fondant, a pastry roller, floral wire, 3 cake layers in different sizes, tracing wheel, floral cookie cutters, a decorating spatula, a mat, royal icing, dowel rods, a knife, cake boards, and a dog-bone tool.
BBQweb.com presents a delightful video on how to make "Jack Ribs." The ingredients needed for Jack Ribs are: 4 ilbs of country style pork ribs, three- 8 oz bottles of your favorite bbq sauce, 1 onion, 12 oz of beer or water, and an optional basting sauce. You will also need aluminum foil, an aluminum pan, and a grill to complete the ribs. The first step in making "Jack Ribs" is to get your coals nice and hot. Next, cover up your grill and turn your attention to preparing the meat. Place your ...
In order to prepare Rhea‚Äôs Cherry Pie, you will need the following ingredients: 1 ¬O cups of flour, 1 tsp of salt, ¬O vegetable shortening (chilled), water, 3 tsp of sugar, pitted cherries, 1 T. butter, and ¬O cup of half and half.
Want to maintain strong abs during your pregnancy? You've come to the right place. This free maternity fitness guide demonstrates a simple standing exercise routine that will strengthen your abdominal muscles without putting pressure on your vena cava. Learn how to keep your abs strong during pregnancy with this video exercise lessson.
You can't be a proper Scene chick without a MySpace - they're the perfect place for Emo style. Who needs boring Facebook with its white and blue dullness? MySpace lets you design your own world of sweet Scene style. Check out this tutorial and get advice on how to rock MySpace in a truly Emo way.
Steal a makeup look from right off the runway with help from Fashion Face TV makup tutorials. Rule your school, party, event with this impeccable blue smokey eye and dark gothic magenta lip. The following makeup products were used in this video:
This video on typhoon preparedness comes from Andersen Air Force Base in Guam, where typhoons are common. The key to surviving a typhoon or other disaster is preparation. Stock up on enough food and supplies to last your family for about a week. Routinely check expiration dates on food, water and batteries and rotate your stock. Be sure window screens are in place and in good condition in the event the power is off for several days.
Steve with Eikenhout Educational Video Series and Paul Griggs with PGriggs Construction demonstrate how to install new windows during a new construction application. You will need a level, a utility knife, a caulk gun and a hammer to install the windows. First, cut the house wrap away from the area where the window will be placed. Next, properly flash the opening to protect it from water by starting at the window sill. Next, verify that the sill is level. Next, caulk around the window opening...
If you're like most busy workers, your day doesn't get started until you have your first jolt of fresh coffee. When you are feeling extra sluggish and need a boost, try a strong Cuban coffee that is sure to start your engine.
Save yourself a fortune by making your very own homemade oatmeal facial mask. Place 6 teaspoons of sweet almond oil into a small bowl. Add 2 drops each of pure violet oil, lavender, neroli oil to the bowl. Add enough oatmeal to the mix and make a paste. Pat onto your face and lay down for 20 minutes. Rinse clean with warm water.
Your quick and easy guide to styling side swept bangs within 2 minutes. After blow drying your hair, take a round brush and roll your bangs up, under and to the side that you want your bangs to sit. Comb your bangs down over your forehead, then comb your bangs to the side. Using some styling product, such as molding gunk, paste or wax, take a small amount of product and rub between your hands to ensure even distribution. Using your fingers, work the product through your bangs, starting at the...
Need a way to hide your small pricey or memorable objects? Well, what better place to hide those cherished items than in a burning candle? Unless your robbers have a thing for scented and aromatic candles.
Check out this DIY video tutorial from Curbly, the best place to share pictures of your home, find design ideas, and get expert home-improvement advice.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Try out this science experiment... watch this video tutorial to learn how to illustrate the scientific concept of conservation of mass. This is purely educational, and not as exciting as some other demonstrations, but this does clearly illustrate the concept of conservation of mass.
NordicSkiSource.com owner, Doug McSpadden, instructs how to apply a hard wax to your cross country skis. Great informational video for the beginner to advanced skier. You need to have a good iron and patience. Wax the groove of the ski before you place the iron on the base. Make steady consistent passes on the ski.
Ex girlfriend tracking you like a stalker? Find the leaks. She may be going through your email or phishing some information. Does she want a confrontation? Lure her to a public place then get her to cause a scene in front of security. Or last case scenario, fake your own death!
Chris Cosentino cleaning a beef heart. I have received a lot of questions about how to butcher a beef heart. I recently made a video to answer these questions. After the break you will find a recipe for beef heart tartare.
Watch and learn with the GOMI crew. This instructional arts and crafts video shows you how to turn your empty cans into cool, beautiful flower bouquets. Recycle cans and make a fun flower design for your bedroom, dorm room or front porch. Place the aluminum flowers in a recycled glass bottle to use as a vase for your beautiful bouquet.
This brief video tutorial will give you the tips on how to fix your V-Cube 6 puzzle pieces that mysteriously pop out. For some pieces on the Rubik's Cube-like puzzle, it's as easy as simply popping them back into place, but when more of those V-Cube pieces fall off, you might have your hands full... of puzzle pieces.
This video knitting tutorial shows how to stitch the cross-over cable. All the action takes place in rows 2 and 3, while rows 1 and 4 are worked in ribbing. Watch this instructional knitting video and learn how to stitch a cross-over cable pattern.
Photoshop wizard Bert Monroy shows you how to use Photoshop's cloning tool to remove people, places and things from your photos. Eliminate modern elements from your streetscapes to make them look old. This Photoshop tutorial shows you how.
If you are having a difficult time drawing a patients blood, you might want to considering doing the butterfly procedure. Watch this instructional medical how-to video to learn the proper way of drawing in blood with this method. The butterfly procedure involves drawing blood from the back of the hand. Start by placing a band around the wrist, palpating the back of the hand and identifying the direction of the veins.
This how-to video demonstrates how you can build your very own seedbombs using clay, fertilizer and seeds (naturally). These "bombs," in turn, can be thrown in hard-to-reach or otherwise inaccessible places, creating green where there once was none. Get started guerilla gardening with this tutorial. Just add rainwater.
When there isn't space in a garden for favorite plants, they can be planted in containers and placed on a patio or deck. This how-to clip provides instructions for how to plant a beautiful and functional container garden.
This video shows the proper way to hold a knife and the proper technique for slicing and dicing. Watch and learn how simple it is. Make the knife an extension of your arm by pinching the blade with your thumb and index finger, proceed by placing your other three fingers on the handle of the knife.