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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.
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 213th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a non-array formula to extract data dynamically using two different methods.
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
Educational Specialist, Jennifer Taggard shows her viewers a very easy and accurate process to making non-toxic flea killer. This flea killer will not harm children in a household or any dog being treated. To make the flea killer, 1/2 of a cup of baking soda and half of a teaspoon of orange essential oil was used. The two ingredients were mixed together and simply applied and rubbed into the dog.
Bring a simple paper to life by making it into an origami flower. This video shows you how to literally add life to a flat white sheet of paper with simple folds and precision you'll make a beautiful origami flower. You can give these hand made beauty to your mother, grandmother, wife, girlfriend, or even your boyfriend. Perfect for any occasion this is a sweet and simple gesture right from the heart. It may take you a few tries to perfect, but like with everything practice makes perfect.
In cooking, making a perfect baked potato is one of the simplest and easiest dishes to prepare. Most of the people would chip the potato with a fork on its surface and cover with some silver foils and would keep in the oven. But, this should not be done as it could result in dump inside the potato when you cut it with knife. Instead of this keep the potatoes for 10-20 Minutes in an oven without foils, which could give you a better and soft layer inside the potato. But in need to get a crispy ...
On this episode of Scientific Tuesdays, Dylan shows you how to create a non-Newtonian fluid using corn starch and a little water. A non-Newtonian fluid is any fluid that does not follow the laws of physics.
This music production software tutorial is a demonstration and explanation of the usage of Dr. Rex as a melodic instrument or otherwise in FL Studio. See how to use the drum pattern maker Dr. Rex for non-pattern sounds in FL Studio.
This how-to video will show you how to zap charge a non-rechargeable battery with only two wires and a car. Sounds cool, and fun, unless of course you zap yourself. Watch this video circuitry tutorial for more information on this simple, money-saving hack.
What would a New Year's Eve party be without alcohol? Well, it certainly wouldn't be a party. Get your party juices flowing by juicing up with this perfect gin martini.
This technique is a simple way to get easy, perfect circles when trying to build in MineCraft. You can make a good template or stencil just by using the circle tool available in MS Paint. Then transfer the pixel data from Paint to MineCraft!
This is a perfect gift for the Wiccan or pagan on your holiday gift list - make a wall hanging or wreath shaped like a pentacle. A perfect blend of Christmas and Yule! You will need 16 gauge wire, along with your favorite ribbons and beads.
With a few hosting tips, you will perfect your Thanksgiving season! This craft shows you how to make some elegant place cards, some easy and beautiful napkin rings, and custom-made deocrative candles. Be the perfect host or hostess this Thanksgiving season!
In this free video language lesson, you'll learn how to count from one to one hundred in perfect French" While French isn't necessarily a very difficult language for an English-speaker to learn, many stumble when it comes to pronunciation. Fortunately, the Internet is awash in clips like this one, which make learning both vocabulary and proper pronunciation a very easy task.
This drawing lesson from Merrill is split up into three parts, each one focusing on a different view on the human ear. If you've ever had trouble sketching the human ear in the past, these videos should clear things up for you. You'll learn the three most basic views— 1) 3/4 view, 2) side (profile) view and 3) front face view.
In this knot-tying tutorial, we learn how to fasten a perfect "good luck" knot—a knot so named because it is said one requires quite a lot of luck to tie it properly. Not so, says video creator TyingItAllTogether. For all of the relevant details, and to get started tying this knot yourself, take a look.
The holiday season is soon going to be upon us, which means there will soon be 30 pound turkeys on tables everywhere. Turkey is the centerpiece of a satisfying Thanksgiving table, so it's important to make sure yours is juicy, tender, and roasted just right.
Roast chicken is one of those essential dishes you should have in your recipe vocabulary because it's simple, delicious, and a great go-to recipe for times when you're just not in the mood for trying hard.
Interested in making candy apples this holiday season? With the right ingredients and technique, it's easy! And this video guide presents a complete, step-by-step walkthrough of the process. For all of the details, and to get started making perfect candy apples yourself, take a look.
Can't seem to perfect your authentic Italian spaghetti recipe? Well, this video shows you an Italian-style spaghetti recipe with delicious heirloom tomato sauce on capellini pasta, garnished with fresh basil. This paste recipe cooks in minutes! Side with a nice healthy salad and you have the perfect Italian dinner.
You work five days a week, and each day you try, try and try again to get the perfect makeup. Once you find that perfect look, it's your go-to makeup style for not just work, but any everyday, routine event. Well, this video tutorial might be your answer. See how this girl applies her daily work makeup that she pretty much uses every day.
Jennifer Lopez made this hairstyle possible, because this elegant summer hairdo was inspired by one of J.Lo's famous updos. This elegant deceiving updo look with a fishtail braid that goes do the small of your back, is perfect for special occasions. This is the perfect classy look for those with long hair.
In this free video language lesson, you'll learn how to say "thank you" in perfect Japanese. With Japanese, as with any other language, a few key nouns and phrases (and knowing how to properly pronounce them) can go a long way. For more information, and to get started speaking Japanese yourself, watch this video tutorial.
In this free video language lesson, you'll learn how to say "I want to" in perfect Japanese. With Japanese, as with any other language, a few key nouns and phrases (and knowing how to properly pronounce them) can go a long way. For more information, and to get started speaking Japanese yourself, watch this video tutorial.
A hand-tied bouquet could really show you care. It's one for the prettiest ways to give a beautiful bouquet of flowers to your loved one. Hand tie the with ribbons for the perfect touch. Watch this video for the know-how on making hand-tied bouquets, perfect for any bride or any recipient.
Interested in grilling a filet mignon to perfection (i.e., à point)? With the proper technique, it's easier than you'd think! So easy, in fact, that this free video cooking lesson can present a complete overview of the cooking process in about five minutes. For more information, including full instructions, and to get started making your own perfect steaks, watch this video guide.
One activity (perfect for Father's Day) to do with your children is making cards. The card in this video is a "shirt and tie" greeting card that's perfect to make with you children. To make this paper kids crafts shirt and tie card, you'll need to have a few materials: colored paper, 2 buttons, glue and scissors.
In this clip, learn how to roast perfect peppers with the Food Network's Tyler Florence. All you need to do is chop up your veggies and lay them on the grill and you will be eating a delicious salad with roasted peppers in no time. This dish is so healthy and perfect for summertime. Yum!
This cake is the perfect way to celebrate the love and commitment that is involved in fifty long years of marriage. A 50th anniversary is a huge event and only the most beautiful cake will do. In this clip, learn to make a cake from start to finish. Save all the money you would pay a bakery and add a personal touch to your celebration. Enjoy!
Dolls may freak the rest of us out, but for a lot of girls in Japan looking like a doll - scarily large, beady eyes, perfect ringlets, and porcelain skin - is its own beauty and style trend.
Learn how to factor perfect square polynomials and how to solve equations using the square root property. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
Sick of runny eggs? Make perfect eggs everytime with help from this video presented by Cooks for Cooks. Watch and learn how to make A+ scrambled eggs with help from Antony Worrall Thompson who will show you how it's done - master chef style!
Love the decadence and richness of cheesecake? Instead of buying your cheesecake from a store or supermarket, why not try your hand at making a homemade cheesecake that is sure to have bellies applauding. In this video, learn how to make the perfect cheesecake for any occasion.
Strawberries are one of the most delicious and nutritious fruits. Not only does it offer the body a good helping dose of vitamin C, they go great with many dishes like cereal, pancakes, ice cream, or even chocolate. In this tutorial, you'll find out just how to make a perfect set of chocolate dipped strawberries. Sit back and enjoy
Why buy the store bought thank you cards, when you can make your own! In this video, learn from Angie Kennedy of My Chic n Scratch (and who is also a certified Stampin' Up! demonstrator] how to make a thank you card perfect for anyone: mom, dad, husband, or friend. Get tips and tricks on how to create this picture perfect card with help from an expert!
Being Scene is all about the look. You need to get it perfect so that you blend in with all of your other Emo friends. Check out this video and learn how to style yourself Scene and rock your new punk style.
If you're just starting out using Adobe Photoshop, then this is the perfect thing to try out. Creating a smiley face is one of the easiest things you can do in Photoshop, so it's the perfect design project to learn from. Just follow along with the steps in the video, and you'll have your very own, shiny, smily face icon.
Producing a friendship bracelet is made easier in this step by step video. After picking your colors and cutting the thread, you can follow this video exactly for the perfect bracelet. If you already know the basics of the forward and backward knots, you will have no trouble repeating the steps of the crisscross design in this special friendship bracelet. All you need to do now is pick your colors and your on your way to creating the perfect gift of friendship.
Denim is built tough enough for cowboys, miners and motorcyclists, but it's cool enough for just about everybody since James Dean. In this video from Put This On web series on dressing like a grownup, see how to buy the perfect pair of denim jeans and also some tips on how to care for them. This is the ultimate denim guide.
Homemade whipped cream is the perfect topping for holiday desserts. Use these tips to get perfect results every time. Whipping cream is generally made from heavy cream. It takes patience and attention. If you beat it too much you'll get something closer to butter than light and fluffy dessert cream.