Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
Take a look at this video from Nokia to discover how to add a shortcut to your desktop on the N900's launcher screen. Now you can quickly access your favorite web page or load an application directly from the home screen on the N900 smartphone.
This is a pretty obscure Dragon Age 2 glitch that could save your life in some difficult battles. The video maker discovered it in Loose End, a sidequest, and it works in many other open combat environments in the game where there's somewhere to escape to. If you escape far enough (really not far enough) the game thinks the fight has ended and resurrects your whole squad AND brings them to your, all while the baddies are still on you. This video will demonstrate.
Photoshop remains one of the coolest digital editing tools of all time, and if you're a user, you're likely discovering new tricks every day. One of the most helpful tricks is removing a shadow from an object, such as a face, a car, a cat, a dog or like this tutorial, a child. This excellent tutorial walks you through each and every step to show you how to use Adobe Photoshop to make those shadows vanish. Check it out and clean up your photos today!
If you've ever gone Christmas tree shopping before at a Christmas tree lot, then you're probably more than familiar with Noble Firs, Douglas Firs, Grand Firs, and maybe even Blue Spruce and boxwood (used for wreaths). But have you ever considered using other varieties of evergreens in your decorating?
Discover one of the many joys of Portugal— chicken piri piri. Once you've tried this tasty chicken dinner, you'll never want to try another recipe! It's a wonderful mixture of spices that coat the chicken, which is cooked in a skillet with a little white wine. That's all there is to it. Some of the spice include chili powder, ground cumin, cayenne pepper, salt and garlic powder. Robin Benzle of Chow Time shows you the secret to this simple Portuguese chicken piri piri dish.
Sometimes we need to load our computers in safe mode to see if we can fix major computer failure and discover other major problems. But if you're stuck in safe mode and not sure how to load up in normal mode again check out this video. In it, you will learn how to get your computer to boot in normal mode again. Good for Windows XP, Vista or 7.
Sounds and sound effects are important to add to any animation project in Adobe Flash CS3. This tutorial shows you how to add sounds and sound effects to your animation library or your project's timeline. You can also use Flash to discover the properties of your chosen sound file.
In this clip, you'll learn how to get started using Blue Coat PacketShaper on your Microsoft Windows PC. It's easy! So easy, in fact, that this helpful how-to can present a complete overview of the app in just under four minutes. For more information, including detailed, step-by-step instructions, take a look.
Discover the power of raspberries! Literally. In this NurdRage science video, learn how some crushed raspberries and some titanium dioxide (TiO2) can create a powered dye-sensitized solar cell. Inside a raspberry is something called anthocyanin, which is a flavonoid pigment. Commercially purchased solar cells are way more powerful than this DIY solar cell, but with a little improvement, who knows. Nurd Rage also lets you know how this works.
Merrill is quite the artist, but he, like everyone else, must "draw" from inspiration. And he has discovered a new technique from Igor Kazarin's YouTube channel Portrait Drawing.
If you ever find yourself surrounded with a bunch of bored people (jury duty anyone?) this trick may be a perfect way to break the ice. In this tutorial, you'll discover how to perform a simple four aces card trick using a simple deck of cards. It's easy to understand and with enough practice, will make you look like a pro in no time at all. So sit back and enjoy!
If you have been a victim of identity theft, you are not alone. This happens to millions of people every year.
Did you know you can fix a damaged disc with toothpaste? Well, you can! In this video, discover how to use that old tube of Colgate or Crest for more than cleaning your teeth. It's easy, quick and could save you a ton of money, you would've spent replacing those discs.
Benjemorawr has just the right advice to discover if a guy really likes you or not. He gives several tips, all of them easy to execute and really just common sense when you think about it. He tells us to note his body language, pay attention to his eye contact, and see if he's trying to impress you. By following the tips and advice in the video, one can become an expert in knowing just what's on your crush's mind.
Tired of chicken? Discover duck! The Maple Leaf Farms corporate chef will teach you how to properly cut up a whole duck (also called deboning). Cooking duck is easier than you think. Maple Leaf Farms is your one stop for duck cooking tips and duck recipes. Make it a meal to remember with duck.
Tired of chicken? Discover duck! The Maple Leaf Farms corporate chef will teach you how to properly score a boneless duck breast like a pro chef. Scoring the duck breast helps render the fat and make the skin golden brown when cooking. Watch as he goes through the steps of cooking a duck breast.
Take a look at the first place winner's tutorial on making a dress out of old tees for the Generation-t tee recon contest! Follow along with the steps in this fashion design video and make your very own quick and easy dress.
Discover the top ten tips for communicating effectively with the elderly and disabled.
Lab Coat Cooking! Discover how to have fun with cheese. Surprise your friends with this new spin on a classic Caprese Salad. Learn how to make a Mozzarella Balloon. This how to video turns a boring Caprese Salad into a party hit with a little help from some fresh mozzarella cheese, roasted garlic, and a little nitrous oxide. This is a lesson in Molecular Gastronomy.
Protect your most important investment with seasonal maintenance. A regular schedule of periodic inspections and maintenance of windows can help prevent the most common, and costly, problems before they occur. Organized by season, this workshop covers topics such as repairing walkways and steps, cleaning out gutters, and checking the heating, AC and plumbing systems--everything you need to maintain your home year-round. Discover tips for checking window seals to save on heating in this how to...
Installing Internet cable is easy with these tips from AsktheBuilder.com host Tim Carter. Discover how to hook up computer Internet wiring in your home. Internet cable installation is a job you can do.
Discover proper golf grip and golf grip pressure techniques, as well as helpful techniques to aid your handling of the club.
Check out this video to learn how to bind off and weave in ends while knitting. Learn different binding off methods to discover which is easier for you.
Scented candles can do much more than add ambiance to a room, they can actually change the way you perceive it. And to discover how scented candles affect how you perceive a room, Meghan Carter visited Yankee Candle Company.
Home organization can be made much easier with the right techniques, and to discover the best home organization techniques, Meghan Carter visited professional organizer and owner of White Space Cynthia Ivie.
Do it yourself closet organization can be quite a journey, even with the best advice. Meghan Carter discovered first-hand the trials and tribulations of closet organization as she put herself under the scrutiny of professional organizer Cynthia Ivie. But in the end, Meghan not only organized her closet, but found a great excuse to go shopping.
Learning how to make a bow is very easy with these instructions from Meghan Carter. She will walk you through the steps of how to make a bow, and you'll also discover multiple ways to style your bow. Whether you want an elegant bow, a casual bow or a double bow, you'll easily be able to make many bows to use around your home and on gifts.
Discover the process of making a simple tumbler with experts at The Corning Museum of Glass.
In this video, you'll discover how to upload files to your own website or blog using FTP.
Watch this video to learn some basic embroidery tips. Discover how to thread a needle the easy way, how to use an embroidery hoop and how to finish off your work.
Mar Jennings shows you how to create a unique votive candle holder.
Bored of the same old tie knot? Now, add a little edge to your look with these unique knots that are so easy to make.
Video: . What is an isosceles trapezoid. The video goes over the properties that are unique to an isosceles trapezoid.
This tutorial video will show you how to find first tweet of any user in Twitter. You have to type first-tweets.com in address bar of your browser. The site will be redirected to discover.twitter.com/first-tweet page. Just type any user name and twitter will show the first twit of that user. Watch the video and try it yourself.
This video will show you how to see first twit of any user in twitter. You could type https://www.first-tweets.com in address bar and the site will be redirected to another place https://www.discover.twitter.com/first -tweet page. You have to enter the user name and twitter will fetch the first twit of that user. Watch the video and employ it yourself.
Video: . In this video, discover techniques of painting a Fashion sketch. Paint yourself a Fashion sketch with abstract leaves.
In this video, discover the techniques of painting a Fashion sketch. Equip yourself with watercolor.
I've discovered something in minecraft! Invisible pressure plates!!! Pretty excited!!