If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...
A pyramid is a three dimensional figure with the base in the form of a triangle and three slant sides to it. To find the surface area of a pyramid you have to find the area of the different pieces that make it up. The pyramid base can be triangle or even other geometric figure like pentagon. So first draw the base of the pyramid separately and compute its area first. Now compute the area of each sides separately. The area of each side can be same if the pyramid is a regular pyramid. Some time...
A wallet is something everyone carries around. Stand out with this wallet which you can make yourself! Start with a regular eight and a half by eleven inch sheet of paper. Fold it in half width wise. Then open it out again. Next fold the paper into fourths by folding the halves over. When you open the sheet back out you should have four equal, long rectangles. After that, take one edge of the paper and fold it over half way into one of the four rectangles. Watch the rest of the video to compl...
In this how-to video, you will learn how to remove permanent marker sharpie marks off a whiteboard. This is useful if someone accidentally used one on the dry erase board. To erase the marks, you will need a regular dry erase marker. Color over the top of the permanent marker thoroughly with the dry erase marker. Next, take a rag and wipe the marks off the board. Both markers will come off easily. The color of the markers do not matter at all. This video shows you a simple way to deal with th...
In this video tutorial, viewers learn how to perform a sumo squat. It is the same as a regular squat, except the legs are extended more wider. The bar should be setup a little bit below your shoulder level. Go into a split stance when picking up the bar. Keep your core muscles tight and keep the bar stabilized. Spread the legs wide, pass the shoulder width. This exercise target the leg muscles and helps strengthen them. Inhale when going up and exhale when going down. This video will benefit ...
Changing your car's cabin filter and air filter is a really important part of its regular maintenance. Doing this simple maintenance task does not require a professional mechanic, so save your money and watch this video to start saving money today and changing your own cabin and air filters. This video specifically covers changing the cabin and air filter in a Honda Element. You can pick up the parts from your local Honda dealer. Typically, you should change your filters every two years.
In this video we show you how to take a normal eraser and turn it into a cheating device. As usual, we will do this by taking a common object that no one will think twice about and altering it to fit our needs. Cheating on tests is a serious offense - be careful!
You may remember the recipe for a basic non-Newtonian fluid from grade school science experiments (one part water to one and one third part corn flour or cornstarch), but those trials probably stopped at squeezing the mixture in your hands. While a regular fluid's viscosity wouldn't allow you to walk on it, a little bit of technique and the magic of physics will have you walking on a non-Newtonian fluid as well as Jesus. This video science experiment shows how to use 50kg of corn flour/cornst...
Watch this instructional cooking video to cook a favorite Japanese dessert. Make two types of Kudzu mochi. Each recipe serves two.
Sulphur Hexafluoride is actually heavier than air, leading to some very amusing phenomenon such as changing your voice. Try this little experiment at home with sulfur hexafluoride gas from a balloon, and then try it against regular air. What's the difference.
In this pilates how-to video you are shown two exercises which strengthen and stretch your upper body. Learn to open your shoulders by doing the overhead and shoulder stretch on a regular basis. They can be done with a wooden pole or a thera-band. If you don't have either available you can use bathrobe belt or leash to do pilates shoulder stretches.
The pilates teaser exercise is tough. This pilates how-to video demonstrates some prep exercises to help you master this challenging exercise. Do the prep work for the teaser on a regular basis to work your way up to the full version of the teaser movement.
You are stuck in the middle of nowhere and can't see a thing. Luckily you have pencil and your car battery. You can create 20 minutes of bright light using the graphite from a regular pencil, wired to the positive and negative of your car battery. Basically, the graphite serves as a bright filament for your emergency light. Follow along with this how-to video tutorial to learn the step by step process of turning a pencil into an emergency light.
Serve your friends and family turkey this year in a nontraditional way by baking and decorating these turkey cupcakes. Turning ordinary and very blah chocolate cupcakes into feathered birds requires only some chocolate icing, candy corn, and sprinkles.
Soymilk is a well known alternative to milk for those who are lactose intolerant or just tired of regular dairy. You can spruce up regular soymilk by maing your own healthy recipe at home with oatmeal in addition to soybeans.
The video helps us to make sterling silver hoops earrings. It is one the popular style of earrings. These earrings can be made of different sizes, shapes, forms whatever we like. This art and craft work is shown by Natalie.
In this video, Betty shows you how to make a great eye of round roast beef in a crock pot. It's so simple: you prepare it in the morning and it's ready to eat when you return from work or school.
Brian Brushwood teaches you how to do the hot seat card trick. You need a regular deck of cards and the 10th card from the top should be the 3 of spades. The spectator chooses a number between 10 and 20. He takes the cards and deals down that amount of cards from the top. Next, add those two digits and deal that amount of cards. There's a piece of paper in plain view the whole time with the card prediction. Write the 3 of spades on the piece of paper using a regular pen. On top of it write 8 ...
Having less-than-brilliant teeth doesn't have to mean a trip to the dentist or a whitening kit. Try this all-natural remedy instead. Watch this video to learn how to whiten teeth naturally.
On Monday, the social media giant Facebook suffered a massive outage that, as of this writing, is still in effect.
For most of us, the primary reason we capture videos on our iPhones is to post on one of the various social media platforms out there, like Facebook, Instagram, Snapchat, or Twitter, providing instant gratification by receiving a proverbial nod from our followers.
Welcome back, my hacker novitiates! A short while ago, I introduced you to regular expressions. Regular expressions are a language that is particularly useful for finding complex text patterns in streams of data.
Learn how to make this spooky, amazing floating static orb. This is so simple, and so cool. It uses static electricity to make a tinsel orb levitate above a PVC pipe. We've gotten the orb to float for over 10 minutes. We just discovered you can use a regular balloon instead of the PVC pipe, but we like the pipe best. Watch the video, and then make your own!
Celebrites make party hopping look so easy. Flitting around from red carpet event to after party to after after party, they always seem to look so flawless in their pictures. But here's a little secret: They have some help from Hollywood's top hairstylists.
Cupcakes are so overdone. Sure, they're cute and bite-sized, but why not start a new designer dessert trend? Check out this dessert video to learn how to bake and decorate delicious chocolate chip cookie dough Christmas truffles.
Glyph puzzles are a regular feature in the Assassin's Creed series, and finding and solving all of them is just one of these games' many awesome diversions. This video will show you where to find and how to solve each of the game's 16 glyph puzzles.
Want to earn the "Sally Likes Blood" achievement on the Regular difficulty setting in the single-player campaign of Call of Duty: Black Ops? Here's how you do it.
French braids are timeless hairstyles that make you look elegant and put together whether you're simply headed for Biology class or you're assembling a beautiful hairdo for a wedding.
Seitan is known as gluten meat, or wheat meat. Basically, it's a vegetarian and vegan substitute for regular meat. Since National Vegan Day was November 1st, commemorate the holiday by making this delicious vegan seitan, kale, and squash dish.
Apple chai-der is a delicious blend of the two most delicious fall beverages, apple cider and chai tea. The drink starts off with regular apple cider, then kicks things up a notch with warm spices like nutmeg, cinnamon, and clove.
French braids are undeniably the older, more put together and elegant sister of regular braids. This makes French braids a beautiful alternative to normal braids for times when you want to look gorgeous with minimal effort.
One of the rituals of homeownership is regular yard work. Central to this yard maintenance is the awesome art of mowing the lawn. Just make sure you're not "scalping" your grass! Lowe's has the advice you need for mowing your landscape.
Grapes as dessert? After watching this food video you'll think twice about these juicy purple orbs. While we think popping some grapes into our mouths is delicious enough as it is, this recipe combines grapey goodness with icy coldness for a delicious, almost popsicle like snack.
It doesn't take a nutritionist to know that eating too much meat is not good for your body. From hormones added to the feed for cows and chickens to contamination from bacteria, it's a good idea to integrate lighter vegetable dishes into your diet on a regular basis.
In this tutorial, we learn how to draw graffiti lettering. To do this, you will use a pen and draw out your letters adding a graffiti flare to them. Do not draw regular letters, these have outlines and a flare out to the ends of them. This is very similar to the graffiti you will see written outside, but used with spray paint. Fill in the middles of the letters, then draw lines around it to make it look like it's standing off of the paper. use a marker to outline the sides of the letters so e...
Zucchino pancakes are certainly a lot healthier than regular doughy pancakes, which is why we're digging this recipe! Healthy food doesn't have to taste like a jail sentence, as these lovely pancakes prove.
In this tutorial, we learn tips on how to avoid skin irritation while shaving. For women, this is a necessary thing they must do everyday, but irritation occurs often. First, shave only in the shower. In the beginning, use a cleanser on the area you are going to shave. During the course of the shower, your skin will soften. Now, take shaving cream and rub it onto your leg. Now, take a regular razor and have with the grain, then against it until your legs are smooth. When finished shaving, dry...
In this tutorial, we learn how to use salty hashes to keep passwords secure. A hash is stored in a database that is hashed with an algorithm, so not everyone can see exactly what your password is. When you type your password into a website, it doesn't actually register as words, it registers as a hash. This keeps your passwords secure so not everyone can see them. Salting is when you use random pits and attaching them to your regular hashes so not every password is the same. The salt is what ...
Father's Day cards that tell you up front that they're Father's Day cards are pretty boring. After all, about 95% of these cards either say "Happy Father's Day" on the front or inside.
Ah, bunting. In the crafting/Etsy world, bunting is one of the simplest pieces of decor to make as well as one of the cheapest, yet because of its minimalistic simplicity it's also one of the prettiest crafts ever.
