New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
Patent is the best way to keep what is rightfully yours. 1. You need an experienced patent attorney who knows the ins and outs to get you through the gatekeepers. 2. Gatekeepers are the patent examiners who make sure that already existing patents are not copied. 3. Register the idea to the USPTO to get the credit. 4. Once pending, the idea is ready for manufacturing. It can be sold to companies. "It is better to patent your ideas before someone steals it from you. "
This video demonstrates how to edit a video using Pinnacle's "Studio B2" software. Once the video has been uploaded to the program, you can edit it in a number of ways using the "smartmovie" feature. For example, the program will automatically add fade transitions and special effects to your video from a list of presets which fit your movie type (e.g.: music video). You can also add music which you can chose from your own source, or some provided by the software. The software allows you to ad...
Just because fixed rate mortgage rates have dropped to historic lows doesn't mean that you should automatically refinance. With the economic climate you might not be able to refinance because many banks have tightened the rules for refinancing. As for who is eligible, you will need a 700-720 on your credit score to get the best rates. To refinance at all you need at least a 600. Generally it is worthwhile to refinance if you can save at least a half point off of your current rate. But you do ...
Do you have PDF documents that you want to make sure people know belongs to you? Don't want people to use your PDF documents without permission? Well, this video will teach you exactly how to add watermarks to your documents using Acrobat 9 Pro. The watermarks will stay on the documents, so that who ever uses it will know who the document belongs to. This is very useful in protecting your content from being used without your permission or credit. This is a short 3 minute video, the steps are ...
This video shows how to clean old records using Titebond II wood glue. He has the record turning slowly on the turntable, and while it's turning, slowly squeezes a line of glue around and around onto the surface of the record, starting from the middle. He explains that it takes between four and twelve hours for the glue to dry completely. After the glue is applied to the entire record, he takes an old credit card and spreads the glue evenly onto the record, all the way out to the edge. When t...
As one of the sexiest, most passionate things you can do while still standing upright, the tango takes romance. It takes drama. And it definitely takes two. You will need a dance partner, patience and melodrama! Did you know? Buenos Aires is credited as the birthplace of tango, and is still a global destination for learning and performing the dance. This is a helpful videos for beginners looking to learn the basics of the tango.
Ever wanted to learn how to pick a lock? Well, there's no better time than now to start learning the craft of so many locksmiths out there... lock picking. Just watch this video tutorial to see how to make micro picks for lock picking.
Check out this video tutorial on how to make cheap dragon wings, controlled by body posture. You can do this project for $18 if you use plastic garbage bags and Scotch tape for the membranes. You'll see how to make very light and strong costume wings. How strong? That strong.
Lemonade is a refreshing drink that you can enjoy any time of the year. Learn to make lemonade using fresh lemons and a simple syrup.Lemons are actually a hybrid fruit and it is believed they were invented by combining citron and mandarin in central India. Lemonade traces its roots to several places. Some credit the Egyptians with inventing it and other sources say it stems from 17th century Paris. In any case, lemonade is one of the most popular soft drinks worldwide, and it's so easy to mak...
When the amount of memory on your computer sucks, you either have two options: Buy more RAM, or make use of the storage space you've got by compressing your files. One program that will become your new BFF should you choose to do the latter is WinRAR. WinRAR is a compression and packaging software that makes it way easier to store large files on your computer.
The iPhone and its cousin the iPod Touch are products of genius design, but sometimes we get a little bored of all that black and white with nothing in between. Inject some personality into your mp3 listening or phone calling by simply switching up your black plate, or the back cover.
If you're looking to expand your viewing space, and haven an iPhone, iPad, or iPod touch, you can follow this how-to and learn how to do it. You'll need to get an app from the Apple App Store called SideMonitor. With this little app, you'll be able to connect your Mac or PC to your hand held device to get a bit more viewing room. It seems like you can never have enough viewing space, so don't poo poo the idea of hooking up some smaller devices.
If you've just gotten yourself an iPhone and are unfamiliar with what the hell Cydia is, here's a little breakdown: Cydia is a software application that lets you install applications and software packages on a jailbroken iPhone or iPod Touch.
Anytime you hit the grocery store you can find an entire aisle dedicated to quick fixes, meals-on-the-go, and pre-mixed cake batter. While these options are great if you're looking to add polysorbate 60 and red 5 to your diet, if you're looking for a more natural foodstuff then you should make it at home.
We can't get enough of fresh herbs in our cooking, but that's just the problem: About 2 days after we purchase our sprigs of thyme and sage they look sadder than Ashton Kutcher's last romantic comedy.
This video series is a complete tutorial, showing you how to construct your own wooden clothes hamper. This is a stylish and elegant way to keep your clothes - or store anything else you need a little extra room for!
During the holiday season you're probably more than used to seeing baked goods at your grocery store shaped into wee little Christmas trees or Rudolphs. But what if you celebrate Hannukah? Chances are there are going to be few Star of David themed baked goods anywhere you go.
If you're a baby boomer or at least older than 40, then you probably remember the Five and Dime stores around your neighborhood street corner. Carrying kitchy knick knacks like masks and cheap candies that even little kids could afford, they were quite the sensation in their day.
While fanciful store bought gifts like boxes of chocolate, roses, and spa certificates are great presents on Valentine's Day, when it comes to dinner and dessert homemade is usually best - and most appreciated.
Google Maps is much improved in Android 2.3 (Gingerbread). And even better on the Nexus S. This smartphone can do many things, but the best feature is still Google Maps, which will appear shortly on all Android devices when Gingerbread is officially released.
Remember Pamela Anderson's "Baywatch" days? Yeah, Pamela Anderson is a little washed up now, but back in the day there was no one hotter in a one-piece swimsuit. And whether she was rescuing a very thankful (and probably turned on) teenage boy from the water or simply hitting up the grocery store, she always wore her signature smoky eye with buxomlips.
Why do you need a table saw sled? A table saw sled allows you to have significantly more control over your cutting projects than you would just with your hands, and allows for special cutting angles. A table saw sled also holds your work in place.
Nice, professional holiday wreaths can cost upwards of $80 if you get them at stores or specially made. And with all the money you'll be spending over the holidays on presents and food, who needs to go bankrupt over a wreath?
Thanksgiving is just around the corner, so it's probably time to start thinking about what you'll be serving your friends and family at the dinner table on Thanksgiving night. Of course, all the classics must be included, like the centerpiece turkey, mashed potatoes, and cranberry sauce.
Thanksgiving is coming up in a matter of weeks, which no doubt means you'll be consuming lots of pumpkin pie. And while pumpkin pie is heavenly on its own, adding a dollop of whipped cream on top makes it simply godly. But don't waste your time on those yucky whipped cream cans you can buy at the store.
Bohemian ware is all the rage these days - from bohemian headbands to necklaces to hemp jewelry, the braided, slightly undone look is all the rage. Get in on the trend without dropping mad stacks at a store by creating this cute spiral braided bracelet.
We know the easy thing to do when you desire a fruit topping for your ice cream or dessert is to run to the store and purchase that squeeze bottle of strawberry "jam." But with all the gnarly chemicals and high fructose corn syrup that composes most of these toppings, you're probably getting more artificial gunk than actual strawberries.
Neutral eyeshadows don't necessarily equal a boring, blah everyday look. In fact, neutral shadows in taupe, gold, and gray make fantastic backdrops for more dramatic eye embellishments like liquid liner and false lashes.
You know that pizza dough you buy pre-made at the grocery store? We can bet you it's been sitting there on that shelf for at least a couple of weeks, which means it's far from fresh and also far from delicious.
Facials are like magical wonders in a jar - slather some on at home, or get one professionally done at a spa, and you instantly go from tired and beat to a girl ready to take on the world. But purchasing a spa-quality facial, or even buying a "facial in a jar" at a store, can cost quite a lot of money.
When you were a little girl, dressing up as a devil lady meant painting your face red with that kit you got from the Halloween store, clipping on some horns, and giving your best snarl. But these days we think you can do the devil look in a much sexier and chicer way.
Zombies will probably not be as popular a Halloween costume as vampires or werewolves this Halloween, which means all the more chance for you to stand out and look spectacular if you're dressing up as one! If your little kid has his heart set on becoming a flesh gobbling undead then check out this Halloween makeup tutorial for creating a rotting green zombie look.
Winter's coming, and when it's over you'll be back to mowing your lawn in no time. To make sure your lawn mower is up for the job, Lowe's has some great maintenance tips for you to perform to completely winterize your mower.
Traveling often is super fun, but sitting through 13 hours on the flight from California to Bangkok is killer on your skin, especially since the airplane recycles air and therefore dries out your skin.
In this video, we learn how to make a multi-pocket/tag envelope page for mini scrapbook. To start, you will need to put the different pieces of paper together. You will need to use a standard number 10 envelope, then trim off each end so that the envelope body is nine inches long. Then, stick down the flap and then score from one end out four inches to the middle. Then, fold this down. After this, you will cut the ends off and two pockets will be created. Now, cut out half circles to create s...
This video is in the Language category where you will understand how the proposition "at" is used in English language. "At" is used to indicate either location or time. A few examples of using "at" for indicating location are; "I am at school", "You are at home", "She is at the store" and "They are at the park". To indicate exact time, the preposition "at" is used. A few examples are; "The movie starts at 6:15", "You have to be there at 1:30" and "Let's meet at noon". You can watch the video ...
In this video, we learn how to fertilize your lawn. First, you need to pick out what kind of fertilizer you need. You need to know how to read the numbers that are on the bag, so you can choose the right kind for you. After this, go to the store and look at the different fertilizers that are in stock. Look at the back of the bag and read to see if it's the correct type for your project. After this, look up the right time to apply the fertilizer to your project. When spreading it, make sure it...
Before you get down to grilling, learn the difference between the three different types of ribs at the grocery store. One kind is country-style ribs, which really aren't BBQ ribs, they're more like pork chops. The two that are good for BBQ are baby back ribs and spareribs. Baby backs are a little leaner than spareribs, but spareribs are easier to barbecuing. Now that you know a little bit about ribs, learn how to prepare the spare ribs with a dry rub of your choice (no barbecue sauce!) and th...
This crafty project is inexpensive, it's easy to do and it's really handy for attaching things like letters, photos and to-do lists. This isn't like a cork memo board, because you won't need any push pins or cork pins! Watch and learn how to make this French memo board. This is the pretty alternative to drab store-bought memo boards.
