Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment in their series of Excel magic tricks, you'll learn how to do just that.
A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.
The video's author teaches how to quickly remove the seeds from a pomegranate without difficulty. Begin by slicing your pomegranate in half, exposing the seeds. Palm the fruit with the rind side in over a dish. Rotate the pomegranate half while tapping it from the side with a hefty spoon.
Looking to take up a new sport? How about ice skating? Ice skating is great for the legs and body, and great fun! Follow this advice and you will soon be gliding like a champion.
Nothing says style for miles like a perfect smoky eye. Here we have makeup artist, TiffanyD showing us how to get that sultry look using bluer tones, rather than black. Apply navy shades to get a sexy look for this fall!
Trying to trust again after your loved one fell into an emotional affair? It can be incredibly difficult, so here is some advice from two "love experts" who say if you can't get over it, to cut that person loose. Watch this YourTango advice video to see why it might be the best alternative.
We've all had it happen before. You fall asleep drooling in class, resting your head on your hands. Or you use your hand to lean on as you browse websites on the computer. Once you move out of your position, all you feel is an unsettling, nervous numbness and tingling. Rather than freak out, check out this video to learn what you can do to relieve this numbness.
Watch this video tutorial to learn how to build a shelter in the forest. If you get stuck in the woods, you'll need to know how to protect yourself from the elements.
Check out this 2 part walkthrough video series from Resistance 2 level Battleship. Resistance 2 is a sci-fi first person shooter video game. Resistance 2 is the sequel to the best-selling exclusive PlayStation 3 launch title Resistance: Fall of Man.
Invented by Alan "Ollie" Gelfand in 1977, the Ollie is a skateboarding trick where the rider pops the tail of his skateboard into the air and then jumps with the board ‘stuck’ to his or her feet. Learn how to do an Ollie. You will need a skateboard, a flat & dry surface, lots of practice, and courage, stamina & the willingness to fall down a lot.
Drawing three-dimensional shapes requires paying attention to the shadows and light that fall on the object. Find out how to draw shapes with a three-dimensional quality with tips from a professional illustrator in this free instructional video on drawing. Drawing 3d will never be easier.
Sadly, into each life at least one mean, nasty, low-down, no-good boss must fall. When it's your turn, you'll want these survival tips. Trying to remain calm and protecting yourself are important strategies to protect your career. Watch this video job skills tutorial and learn how to cope with an unfair boss.
See how to tie a knot in your thread for hand sewing. This knot can easily be hidden inside a quilt. This is a simple quilting lesson, but worth taking the time to learn properly. You don't want your quilt falling apart at the seams.
Announce your arrival home in style by stepping in via a brand new door. Whether you're tired of your old one or it "fell" off during a particularly heated argument, installing a new door helps to instantly update a room.
This how-to video from a Piece of Craft shows a way to take some fall seasonal gourds to make a decorative centerpiece for you Thanksgiving tabletop. You will need artificial leaves and berries, candles, and gourds. Watch this video hosting tutorial and learn how to craft a turkey shaped Thanksgiving table-top centerpiece.
This photo retouching Photoshop tutorial is not cleaning up blemishes, but modifying the overall look of a photo. Bert's example in this episode takes a snow covered window eave and adds some children and their reflections to the inside along with falling snow on the outside. Change a photo to any scene or look you need with this Photoshop tutorial.
Instead of buying photo albums, make your own to get exactly the size and style you want. Book bindings require a little technique to maintain the right size of the page, without ruining the edge or making something that's going to fall apart. Watch this video book-binding tutorial and learn how to bind a photo album insert.
The summer heat may have scorched your grass and all the foot traffic might have compacted the soil underneath. Make your lawn happy with this lesson on getting your yard autumn ready. Watch the how to video and learn how to ventilate, fertilize and re-seed bare spots.
RC Car Action Magazine Editor Paul Onorato shows you how to anchor an antenna tube to keep it from falling out. A piece of fuel tubing will solidly affix the antenna to the chassis of the remote control car. Watch this video tutorial and learn how to secure an antenna tube to the body of a remote control vehicle.
This video cake decorating tutorial shows how to design piped scrolls of frosting on a cake. Start with a tube 44 or 43 at one point and twist it at the top, allow the tail of icing to fall on the edges to cover the edges of the cake. Repeat the same process around the cake. Piped scrolls are easy enough to replicate, just watch this instructional video and find out how it's done.
If you're like me, you put some or all of your houseplants outside for the summer. Now that fall is here, it's time to think about moving them back in for the long winter ahead. This how to video shows a few steps you can take to prepare your plants for indoor conditions. Following these easy steps should help ensure your plants winter over successfully, so you can get them outside again next spring.
Don't get chained to the wall when you want to come out of a headstand. It is time to let go. Watch this yoga how to video to learn how to practice headstands off the wall. Face your yoga headstand fears and learn to fall with grace. Never be stuck on the wall again after practicing headstands.
This is a brief how-to video to show you how to rig a tube fly for Steelhead and Migratory Brown trout. The guys at "Tight Lines" fish a lot of these all fall and winter. These can really help improve your game, and make you catch all those fish you really wanted.
In this how-to you will learn to do a corkscrew. The corkscrew is a great trick to learn for Parkour. When learning this trick make sure to be safe and practice with a place you don't mind falling on.
Fall in love with organic heirloom sun dried tomatoes. Tanja shows you how to grow and cultivate organic heirloom sun dried tomatoes on one of the many wonderful freshtopia videos.
"Miki Falls" manga creator Mark Crilley presents a tutorial with tips on how to render a male body in proper proportion to the head. Learn how to sketch for anime or manga by watching this video drawing tutorial.
The Aries man or woman can be tough to figure out, but this video shows how to push all the right buttons. To trap an Aires you will need a love of athletics, a go with the flow attitude and a thick skin. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with an Aries work.
Aquariuses have high standards, but anyone with the right drive can meet them. Use your creativity, knowledge of art and music, and good social skills to trap that Aquarius. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with a Aquarius work.
Check out this SEO video tutorial on Google's supplemental index. What could cause your webpage to fall into the supplemental index? There's duplicated content, content taken from other sites, too many query strings in the URL, etc. See what you can do to get them out of Google's supplemental index, with some good search engine optimization.
Here is a brief video on how to start doing the forward roll in Jiu Jitsu. Ukemi (rolling and falling) are very important in the martial arts and often neglected.
Learn how to speak English with falling and rising intonation or cadence. This is a lesson in four parts.
"Miki Falls" creator Mark Crilley embarks on a quest to study one hundred styles of manga eyes. Watch to learn how to draw them all.
Do you grip a knife like a club? Do your tomato wedges fall apart in seedy clumps? Recent Top Chef winner Hung Huynh demonstrates his famous knife skills. The quicksilver cook showed how to julienne squash and a speedy way to slice meat. Definitely try this at home.
"Miki Falls" manga creator Mark Crilley presents part one of a tutorial on how to draw an "angry young man" in the manga style.
"Miki Falls" creator Mark Crilley presents another drawing demo, this time with an emphasis on rendering clothing and using lines to suggest a three-dimensional surface.
"Miki Falls" manga creator Mark Crilley presents a tutorial on drawing three different facial expressions, showing the transition from surprise to anger.
"Miki Falls" manga creator Mark Crilley presents a tutorial with spoken explanation on how to draw his character, Miki.
Mark Crilley, creator of "Miki Falls" shows tips on drawing a face in profile!
"Miki Falls" manga creator Mark Crilley presents a lesson on how to ink a manga illustration, with special emphasis on crosshatching techniques.
Watch to learn how to say the names of the seasons in French. l'hiver - winter
