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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
Don't overpay for a marked up baby blanket at a department store or fancy boutique? You can make a beautiful blanket for your newborn and future family heirloom right at home. All you need are some basic sewing materials and your imagination. This video will show you how to sew a dream catcher baby blanket.
Need a little help in the fraction department? Don't sweat it. Luckily, there is this two-part math tutorial on the subject of dividing fractions to help you along the way. In part one, learn how to divide proper fractions an in part two, learn how to divide mixed numbers with whole numbers.
Burglary is common, but is also quite preventable with these tactics. You Will Need
If you're an out-of-work Californian, take advantage of the benefits provided by the Employment Development Department (EDD) of California. If you've already followed the directions for applying for unemployment insurance benefits, then there are a few more steps involved in getting and maintaining your monetary unemployment reward.
Bob and Leslie of the Washington Township Fire Department demonstrate how to choose the right fire extinguisher for your home. Fire extinguishers come in a large range of sizes so be sure to choose one that you can easily handle. If it’s too heavy you won’t be able to use it properly. Fire extinguishers are labeled according to the type of fire they are used on. A is for ordinary combustibles such as wood or paper; B is for flammable liquids such as gas, grease or oil; and C is for electrical...
L4D2: One of the best horror video games of all time. Check out the tips and gameplay for Campaign 1: Dead Center - Mall. Restock on supplies and head out of the safehouse. Feel free to kill any zombies trying to reach in the door before you unlock it. Hang right and make your way up the giant escalator in the middle of the floor. Loop around and exit Kappel's department store. Go down the first escalator you see. Watch out for zombie attacks from the floor above. They will jump down and catc...
People like Ralphige and The Jerky Boys have elevated prank phone calls to an art. Here’s how you can get in on the fun.
He's not exactly demanding sexual favors, but his flirting is getting really gross. What's a girl who likes her job to do? You will need diplomacy and documentation. Assess his behavior. Now, don’t be offended, but we have to ask: Is he really coming on to you, or is he just a sociable, flirtatious kind of guy? If it’s the latter, just ignore it. Do your part to keep the relationship professional. Don't chat about how your last two boyfriends cheated on you and then expect him to know that di...
Safe motorcycle riding requires knowledge and skill. Testing two-wheel vehicle operators is the best measurement of the skills necessary to operate safely in traffic because people often overestimate their own abilities.
You probably remember Jessica Simpson best from her "mom jeans" fiasco when she gained a bit of weight, wore unflattering jeans, and looked like - gasp! - a real woman, but what the girlfriend lacks in the fashion department she makes up for in her great taste in hair.
Buying authentic antique furniture requires a lot of furniture knowledge and keen eyes. If you need a little help in this department you've come to the right place. THis video will give you tips for authenticating the antique status of all kinds of antique furniture.
YourProduceGuy has some tips and information about determining the ripeness of Crenshaw melons in the produce department of your local grocery store. Crenshaw melons are a part of the muskmelon group, which includes honeydew melons, also. Watch the video and find out how to tell if it's ripe or not yet ready to eat.
One of the hardest fruits to determine the freshness of is the watermelon. It's the biggest question in the produce department of grocery stores, so you're not the only one having problems. This video from YourProduceGuy gives you the tips to finding out what to do when picking out a fresh and perfectly ripe watermelon and the local store. There's a sweet spot for every fruit.
Looking for a really good lesson on how to draw cartoon animals? Look no further. From Toonseum, Pittsburgh's museum of cartoon art, learn how to draw an adorable cartoon monkey, suitable for any cartoon strip or drawing! Get skilled in the cartooning department with help from an expert!
There's no doubting that when it comes to style, there are so many different variations and ways to express yourself. Sometimes clothes at local department stores or clothing shops just can't cut it. Maybe the best option is to make your own piece of clothing that you'll be proud of This tutorial will give you the tools needed to help make a simple dress. Enjoy!
Get a leg up on the competition with these wardrobe tips. You Will Need
The Oregon Department of Transportation shows you how to install cable style tire chains in this video tutorial for the winter. These are tips and techniques for cable chain installation and removal from your auto's tires. The winter is here, and driving safely means protecting yourself against the snow and ice. Tire chains on your automobile is the perfect solution.
This video sewing tutorial shows a clear and complete demonstration of how to correctly sew a railroad zipper. Included are tips and materials needed. Watch and learn with the help of the Fashion Design department at OTIS College of Art and Design.
Here is some smart talk about love. Is your man doing a little double dealing in the love department? Watch this how to video to find out if your partner is cheating. Get helpful tips on hint that he might be giving you about his cheating habits.
Check out this video from Berkleemusic.com and watch as Larry Bayone, Chair of Berklee's Guitar Department, explains how to find the notes of the guitar scale from memory by practicing the major scale in a variety of different positions and registers on the fret board.
The JANE beauty department shows you how to get Michelle Pfeiffer's killer look from the classic movie.
Want to spice things up a bit in the hair department? If you have naturally dark, medium, or light brown hair then going red may be a fun option to consider.
Jennifer Aniston is one of the few actresses out there whose name is synonymous with a hairstyle. Like Halle Berry and Farrah Fawcett before here, "The Rachel" has become a celebrity in its own right. But Jennifer Aniston has a lot more to offer in the hair department than simple, shoulder-length layers.
In this tutorial, we learn how to attract a woman with your body language. If you see a woman that's bored, immediately walk up to her! You can do this with a girl that works in a department store, because she'll be bored. Spring into action and talk to that girl about anything! The girl has been spending the day bored, so she wants someone to talk to. Once you're in the conversation with her, she will start to smile and laugh. This will start you on a good track to get her number and possibl...
There's no need to drop mad stacks at a department store in order to wear clothing that looks fashionable. In fact, you may not know it yet, but you probably have a few gems waiting to shroud your figure in your garage.
It's safe to say that this is one ape that you won't soon see climbing the side of the Empire State Building, terrorizing Wall Street snubs and taking damsels in distress at his whim.
Be as lazy as you want the rest of your life when it comes to makeup and hair, but on your wedding day you better be amping it up in the style department. If you're looking for a not too hard hairstyle to sport on your big day, check out this elegant side twist updo. You've probably seen it on the likes of old Hollywood-inspired stars like Gwen Stefani and Rachel McAdams.
In this video, we learn how to get credit when you don't have any. Most credit agencies are now gathering information about younger people to figure out if they are allowed to get credit cards, which will help them build a credit score. There is a website, PRBC, where you can start a file and enter your information, and it can verify all the information you report. This information will be given to credit reporting agencies, and give you more of a chance to get credit. Next, you can get depar...
They may not come in sparkly, 24K packages like department store brands, but drugstore beauty goodies can often perform just as beautifully for a fraction of the price. You just have to know which particular drugstore products work.
Sometimes shopping at old department stores or thrift shops can lead you to a gold mine of possibility. Everything there can either be worn for its intended purpose or it can be altered to fit what you think it could be. In this case, taking a long skirt and transforming it into a beautoful stylish dress. So sit back and find out how to make one of many stylished dresses. Enjoy!
Being in the wilderness for an extended amount of time can be bad for your health. One thing it can do for you is cause major problems in the personal hygiene department. Find out how to keep yourself nice and clean by using a yucca plant.
Eric Rochow of Real World Green gives us advice on making our computers more environmentally friendly. This video first explains that screensavers are not green. Screensavers require a computer to use its processor. Ideally, when you're not using your computer it should be in sleep mode and your monitor should be in sleep mode as well. This saves a lot of energy. Also, at the end of the day, turn off your computer and monitor. Don't let them run all night. An interesting fact from the Departm...
In this video the instructor gives tips on how to erase a PC hard drive. An MIT study shows that 74 percent of the discarded hard drives contain private data on them that can be read and recovered by others. So you should learn how to completely erase all the data so that no one can recover or read from it later. Now formatting the drive or deleting a few files wont do it. For this you will need to have a proper software that meets or exceeds that US Department of Defense standards for data r...
Want to create the look of expensive Hollister designer jeans? Fancy department stores, specialty jean stores and boutiques sell them for outrageous prices. Now you can create them at home with simple supplies, a little practice, careful observation and some "elbow grease". The creator of this video uses common hardware store supplies to complete the task. With the help of the video's host, the right sandpaper and with the right moves, you can create all of the most common styles of Hollister...
Recycling your garbage is noble and, in many places, mandatory. But it also can be very confusing. This guide will clear up the rules.
This video goes over cover letter formats, specifically in Full Block Style. Cover Letters accompany resumes in job applications. They should be sent ahead of the resume. They go over your experience, desires and objectives. The cover letter is important to both employers and employees. A human resources or HR department often receives thousands of letters that it must review before granting a job candidate a job interview or even reading their resume. This is a LIAD Production for World of W...
Many believe breakfast is the most important meal of the day. Breakfast gets your metabolism going in the morning. After you fasted all night, it actually is your break from your fast. Try these tips for buying breakfast foods in this nutrition how-to video.
Young children have growing bodies and need healthy snacks for supplying nutrients and energy, especially preschoolers. Their little stomachs just can't handle it. Therefore, it's very important to incorporate some snacks into their daily routine. Try these tips for buying snacks for preschoolers in this nutrition how-to video.
Biotin is a water soluble B-complex vitamin important for synthesizing fatty and amino acids and maintaining blood sugar. It's important for the synthesis of fatty acids and amino acids. Try these tips for buying biotin enriched foods in this diet and health how-to video.
