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 657th installment in their series of digital spreadsheet magic tricks, you'll learn see howto calculate Invoice Due Dates & Financial Statement Dates using the EOMONTH function including end of the month and beginning and ending dates for each quarter.
Former "Hills" hottie Lauren Conrad is the type of girl you'd bring home to your parents. With girl next door wholesome looks, a can-do attitude, and charming demeanor, Conrad has undoubtedly been the most successful "Hills" star, garnering a book deal and a Kohl's clothing line as a result of her sensibilities.
In this clip, learn how to be a real coupon diva! This episode of coupon divas focuses on Walgreens drug stores and will show you how to combine things like register rewards, coupons, sales and other deals to walk out of the store with a full cart for virtually no money! Get your coupons to outnumber the cost of the items and go home with a bunch of free goodies. Kitty will show you the basics and how to stay organized with these strategies.
Unfortunately kidnapping is a sad reality. Millions of children are abducted around the world every year by both family and non-family members. In this tutorial from Metro Parent, get advice on what to teach your kids about strangers and how to keep them safe. You will also get advice just in case the worst happens and you find yourself dealing with a kidnapping. So, take a few minutes to watch this clip and help avoid every parent's worst nightmare.
The beauty of crochet patterns can only be compared to the delicacy of snowflakes. A talented crochet veteran can craft motifs that mimic and rival patterns found in nature.
Mac or PC? PC or Mac? The debate rages on? Unfortunately, this can mean a lot of headaches for you when dealing with different file formats. If you work on both types, you might very well have to open the same file type on different computers. This can be a problem if you are using .rar files. But this video can help you. This tutorial will show you how a simple download can enable you to open .rar files on a Mac.
Here's a great tutorial by the fellows at Achievement Hunter showing you where to find another Just Cause 2 easter egg on the Xbox 360. This time they are dealing with the mechanical shark easter egg. Now, usually easter eggs are pretty cool and have some sort of secret message, but most of the time are there for fun. This easter egg just seems kind of pointless. Anyways enjoy the tutorial and good luck!
Going home for the holidays? Flights during this time of year can get pretty pricey because air carriers know that a lot of customers will need to fly. There are ways around the fare hikes though. In this tutorial, Rick Seaney, CEO Farecompare.com, an airfare shopping site, and columnist on ABCNews.com breaks down how to get a cheap airline ticket for the holidays. Follow along and get some quick tips on exactly when and where you should buy your ticket this year so you still have money for g...
In this video, Extension Horticulturalist Curtis Smith talks with Master Gardener Marsha groves about controlling harmful pests that are damaging to plants throughout the year in both outdoor garden and greenhouse environments. The first part of the video covers the issue of plant eating snails, and how they might best be dealt with. Smith explains that there are a number of non-toxic methods which one can use to rid a plant of snails. The process of introducing predatory creatures such as tu...
Home repairs might seem foreign to some people, but it's not as hard as dealing with contractors. If you have to patch up some holes in your drywall but don't know how, let this video series be your guide. In these videos, lean how to fix a drywall hole using a lath strip piece of wood.
Home repairs might seem foreign to some people, but it's not as hard as dealing with contractors. If you have to patch up some holes in your drywall but don't know how, let this video series be your guide. In these videos, lean how to fix a damaged corner bead on drywall.
Home repairs might seem foreign to some people, but it's not as hard as dealing with contractors. If you have to patch up some holes in your drywall but don't know how, let this video series be your guide. In these videos, lean how to patch around an electrical box on drywall.
This is a video that demonstrates how a card trick is done. It shows a trick in which the presenter does a card trick and then explains how it is done. The trick is one where the person guesses a card and it deals with a red deck and a blue card. The person guesses a number in the deck and that number is the card. In this case it was the queen of hearts. The card is then placed back into the deck and when the presenter lays out the cards, the blue card becomes the queen of hearts. The trick i...
In this video you learn how to make a digital pinhole camera. The video begins with an introduction addressing the main themes to be dealt with in the video - tight budgets, photography and specialized lenses. In this video, Kai modifies a photo lens cap by poking a large hole in it. After making this large hole, he makes a smaller hole in a thinner material and lines the hole up in the center. He calculates the size of the hole he needs based on the wavelength he will be photographing. He us...
PGA Professional Rick Sessinghaus discusses three different tips that can help all golfers, from the amateur level to the tour professionals, can do to help improve their putting. The first tip focuses on improving hand and eye coordination by simply looking at the whole the proper way. The second tip deals with the reading the speed of the greens while putting. Finally the third and final tip helps the learner better read the line of the put. Rick believes following these three tips will hel...
Betsy Sell and Tom Wilt of AAA Travel Services present this video to teach you how to plan for international travel. They teach you how to prepare the right documents, explain how to get a passport, and discuss travel insurance. They also discuss how to plan for emergencies and how to deal with different kinds of money such as travelers' checks. They also discuss how to pack, what to do when documents are lost, and safety tips. This video is the introduction in a series with this information ...
There are a number of ways to deal with screw holes that are visible. You can buy some wood buttons and put them in the holes. You put a little wood glue in the hole and then tap the wood buttons into the holes using a hammer. This is a decorative solution to cover up screw holes. If you want to completely cover up the holes completely put a plug cutter on your drill and cut a plug out of a piece of wood that matches the wood that the hole is in. Take the plug put a little glue on it and tap ...
Have an interest in nukes? Look no further. Learn about nuclear reactors, bombs, & reactors in this six-part video lecture by Professor Richard Muller of the University California, Berkeley. This lecture is from the spring 2006 webcasts of "Physics For Future Presidents". From the videomaker:
Forget expensive steadicams! Save money on your film budget and make a DIY steadicam that's almost as effective as the real deal. Chappy shows you how to make one for only 30 bucks! You can make this steadycam with parts from your local sporting goods or hardware store.
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.
Each year an apple tree should produce three things: new growth, fruit buds on last year's and older growth, and fruit on those fruit buds formed in previous years. In order to keep an apple tree in balance and fruiting, one must prune. However, pruning is too often done poorly. In this, the second installment of his series on practical apple tree pruning, Stephen Hayes of Fruitwise Heritage Apples looks goes over what to look for in a good secateurs, or pruning shears, and how to thin out sp...
My name is Ruben Garcia and I'm a meteorite hunter. These videos are of a two day meteorite hunt. Just me and my video camera out in the wilderness!
Alright, there are lots of videos out there dealing with Master combination locks, but this how-to video will show you how to open a Dudley combination lock. These locks are commonly used in schools, so you've likely seen one there. This method opens the lock permanently, meaning you won't be able to close it afterward. You'll need a flat head screwdriver and a little patience. The method involves prying off the style, allowing you to get to the insides of the lock. After that, you'll be push...
If you're wondering about the field of psychiatry, this video will teach you what you need to know. Dr. Ogan Gurel talks about the field of psychiatry and how it works. Psychiatry is a field of medicine that deals with mental disorders and looks at signs and symptoms. As you begin to understand the different aspects to the behavior, medication is entered into the equation to help out the behavior of the person. He explains that you must understand the biological symptoms of people as well as ...
The Enzo Milano curling iron is revolutionary in that it is clipless. If you've curled your hair a few times before then you know that a great deal of curling irons always have a clip attached that holds in the hair, keeping it in place when you curl.
Adamantine is the best, most versatile metal in Dwarf Fortress, but discovering and using it bears great risk. This video will teach you all about adamantine and how you should react to ensure you survive what happens after you find it.
Don't waste money on pricey mechanics! Doing your own vehicle repairs can save you tons of dough, but just because you're avoiding the mechanics, doesn't mean you can't learn a thing or two from them. In this video, a professional shows you the quick steps to changing out the front brakes on a Ford Escape. After taking of the front wheel, you'll have to deal with the calipers and the brake pads, along with a few other things. But don't worry. Any do-it-yourselfer can change brakes. And the Fo...
In this video, we learn how to know how often to talk to the girl you're dating. Make sure you aren't texting the girl too much, you want to talk during one point of the day so you have a lot to say. If you're checking in all the time, you are not having a real conversation. Don't rely on the internet to communicate with her because this is very interpersonal. Talk on the phone and in person so you can get a better feel for the person. If you skip a day, it's no big deal, just pick up on wher...
A sleeping prank victim is much easier to deal with than an awake one. They can't prevent the prank, and afterwards are usually too disoriented to respond violently with any effectiveness. This video will show you several pranks to play on sleeping victims, some of which you've probably seen before and a couple we're betting you haven't.
If you own a Saturn S-series and have found out that you need to replace the radiator and/or fan motor, this next tutorial is right up your alley. In this video you'll find out how to replace both parts to your vehicle. They're pretty important for helping a car run, so replacing them as soon as possible is a pretty big deal.
In this tutorial, we learn how to find the area of a rectangle. First, you will need to know the formula, which is length times width. So, first find the length and width of the rectangle. After this, you will multiply the length and width together. Next, write down the units so you don't forget. When you are finished, you will know the area in just a few easy steps. This is a basic formula that is easy to understand and can be done quickly. When you are finished finding this, make sure you w...
If you've ever seen the movie, There's Something About Mary, you must remember the scene where Ben Stiller get a fish hook caught right in his mouth. No? Well in this tutorial you'll be dealing with the removal of a fishing hook to your body. This is a painful experience and can cause even the toughest men out there to cry. This video will show you how to remove it easily from any part of your body. So good luck, be safe, and enjoy!
ISO or .iso files are disk images or archive images for your PC. If you use Linux as your operating system and would like to learn more about .iso files, check out this tutorial. In this video, learn how to mount ISO files without using any disks or burning any CDs. The trick is to convince your computer that you have done this without actually doing so.
The Crip walk, or C-walk, is a popular west coast dance move that requires a great deal of balance, buoyancy and switching of the feet. Learn about different foot exchanges that are used to C-walk with help from this free lesson given by an expert.
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. In this Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...
This tutorial explains how you can divide integers. Dividing integers is similar to multiplying integers. A positive divided by a positive gives you a negative number. A negative divided by a negative gives you a positive number. And a positive divided by a negative, or a negative divided by a positive, will results in a number. Some examples: -15 divided by 3. In this problem we're dealing with a negative divided by a positive. So, the answer will be negative. The answer is -5. Another examp...
For most people who deal with seasonal cold weather, it makes sense to prepare one's car brakes/ABS for the winter weather. Ed Kriston from AAA Mid-Atlantic discusses typical brakes and anti-lock brakes. Kriston goes over the general makeup of how brakes work and what components make up the brake system. He goes over how to tell if there is sufficient brake pad to get you through the winter. To make sure your car brakes or anti-lock brakes are prepared for the cold weather, follow the steps i...
This video shows the procedure to draw a face. The video shows various stages to draw a face. These include drawing an egg on the paper, dividing the egg into various parts by horizontal lines, drawing the nose and lips, drawing the eyes and ears. The video cleverly deals with issues relating to the evidence of not being a professional. The video shows the various choices that can be made by the artist in drawing the face like the pencils to use.
This is an educational video from The Free Math Tutor which explains how and why should we expand fractions. This video is basically for kids who have just been introduced to fractions in mathematics.
