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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
How to pick the right RAM for your computer
Bartender Gene shows you how to make a unique, healthy, ginger infused cocktail. Simmer 1/2 cup water, sliced, fresh ginger and sugar to make a ginger infused syrup. Remove from heat, let cool, then add 1/2 cup vodka and refrigerate. When your syrup is cool, strain out the ginger and throw it away. Place candied ginger at the bottom of the glass and pour in about a tablespoon of the syrup. Top off with sparkling wine and serve. Follow these easy steps to create a celebratory, unique, good for...
See how to make some cool gift / party favor bags for any occasion. They are made with envelopes. You can make them from nearly any size and type. The ones in the video are made with some surplus greeting card envelopes. Sometimes you can purchase "leftovers" from an office supply or drug store (any store that sells greeting cards). "Left-overs" mean that the cards get damaged or lost but the envelope is left. Just ask the manager if you can purchase them.
"Free Weezy" is the catchphrase no longer necessary, unless you're talking about making November 4th Free Weezy Day, to celebrate Lil' Wayne's release from Rikers Island in New York City.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
If you want to make cakes that look professional and almost good enough to sell, then meet gumpaste, your new BFF. A mixture of sugar, water, egg white and gelatin, it's a sweet, pliable cake decorating material that's as easy to shape as polymer clay.
In this tutorial, we learn how to grind your own spices. Spices grow all over the world, which can give them all unique tastes. Start off by grabbing the spices that you want to mix together. Use your favorite spices to make your own unique tastes. If you are roasting, you should not roast or toast the spices all together at once, so they don't incorporate smells. After you do this, you will use a mortar and a pestle to crush down the spices. Start pounding on the spices to release the oils a...
An old glitch seems to have carried itself over from Fallout 3 right into Fallout New Vegas! Not surprising as they used the same game engine and resources, but regardless of that, you'd think that the Q&A team would have caught it. In this video you will learn how to exploit this glitch by purchasing a cheap item and then selling it back for more than the original price over and over and over again. Details in the video!
In this tutorial, we learn how to write a unique personal statement essay. Personal statement is the heart of the application where you can give voice to your accomplishments, dreams, and goals. You want to stand out from the rest of the applicants, so you need to express what's important to you. You can show them how well you write and show passion, your smarts, and sense of humor as you write. You can do this because you are prepared and you are being true to yourself. Once you understand t...
Feel like you're too old to still wear a costume on Halloween? We hear you. If you're past the whole "dress up as a pumpkin" phase of Halloween but still want to look festive for the occasion, why not consider a face mask?
If you think thrifting just involves hitting up your local Salvation Army and picking up a few pieces of secondhand clothing plus a cute little old-looking vase for your dining room table then you've got some learning to do.
In this video, we learn how to perform a shot fake in basketball with Chase. There are three keys to a good shot fake. First, make sure you are on balance and nice and stable. Be in a good dent athletic position, but don't come out and up from your position. Then, you will need to make sure your eyes are to the rim. This will sell the shot and get the defender to buy it, making the defensive player lose focus and position. Last, you want to make sure you keep it tight when you are playing. Th...
Your tanks and your tees aren't fitting just right, don't throw them away or toss them in a storage box just yet. Grab some scissors and cut that sucker up, then mold it in a better fitting, unique and cute shirt. The easiest part is simply slicing up the back up the shirt, but then comes the strings. Watch and see for yourself. This is a great way to transform a normal T-shirt or tank top into something more creative.
In this video, we learn how to play guitar: Funk Grooves. First, learn how to slide your finger from the ninth chord using the third bar. As you do this, it will create a groove in your music that is unique and very "funky". Once you learn how to do this, you will be able to make funk groove music easily. Don't forget to mix things up with other chords to make up your own unique sounds as well. Remember to make sure you keep your right hand moving as you play, so you don't create any squeaky ...
Not that we have anything against painting on an aubergine nail polish for a night out on the town, but why not get a little inventive next time you do your nails by creating unique designs? Become a nail Picasso by checking out this nail tutorial for creating nautical-inspired nails featuring ocean waves, jumping fish, and pretty rhinestone air bubbles.
In this video, we learn how to apply a Chanel temporary tattoo. First, you will need to purchase the tattoos from a store that sells Chanel products. After this, you will need to cut out which tattoo you want from the collection. You can use just a small one or you can connect them together to make one large tattoo. After this, you will need to peel off the plastic from the top of the sheets and apply a wet cloth to the back of it. Next, push the tattoo onto where you want to apply it, then p...
You may not realize it, but many appiances that are sold today are equipped with a Sabbath Mode. This is a feature that many of the modern home appliances feature. It is intended to allow the appliances to be used by Shabbat observant Jews during Jewish holidays.
You may not realize it, but most of the laundry detergents that are being sold in supermarkets contain chemicals that can be bad for peopel, but more importantly bad for the water supply. People have begun to realize this and are starting to make their own household items from scratch using harmless items.
If you use Windex or any other window cleaning product, you may be exposing yourself, or others, to harmful chemicals. Many cleaning products that are sold in supermarkets, contain harmful chemicals that are not good and certainly not good for the environment.
If you're a fan of the original Hydro Thunder, that came out for the Playstation and Sega Dreamcast, you'll be happy to hear that it's back! Hydro Thunder Hurricane is a sequel/remake of the original game and is being sold as an Xbox Live Arcade game.
Cherry blossoms aren't just special because they're Bath and Body Works' best-selling scent of all time. No, in addition to their delicate floral smell, cherry blossoms are special because they are the first flower buds to open in spring. Spring officially stars when you see the cherry blossom trees bursting into color, and what a wonderful way to celebrate the new season!
Any successful blogger and business brand will tell you that social media is really the only PR you need these days. Whether you're tackling Facebook, MySpace, Twitter, or planning a takeover of YouTube, getting your product name out there - even if it's just your own name because you run a blog - is the number one absolute, most importan thing you can do to sell your brand.
A trip to the movies simply isn't complete without a nice big tub of buttery popcorn. Salty and crunchy, it's the perfect complement to the much more sugary treats offered at movie theater concession stands, and tastes great when washed down with a can of Coke.
In this video tutorial, viewers learn how to data clear and erase an LG CU720 Shine mobile phone. This task is very fast, easy and simple to do. Begin by clicking on the Menu button and select Settings. Then scroll down the list or press the # sign to select Reset Settings. Now select Master Clear and select Handset. If there is data in the memory card, clear it as well. Click on Yes to confirm the resetting and type in your security code. This video will benefit those viewers who have a LG S...
Need help drumming up new business as a Pilates instructor? This clip presents an overview of the five principle benefits derived from the practice of Pilates. Whether you're considering the possibility of starting your own Pilates studio or already have one and just need a little help tackling a particular pedagogical problem, you're sure to be well served by this free video lesson from the folks at Balanced Body Pilates. For more information, including a comprehensive overview, watch this v...
In this video tutorial, viewers learn how to develop an elevator speech. An elevator speech is a short prepared speech in which you "sell" yourself to others. The average elevator ride is no longer than 20 seconds, so your speech should be no longer than that. Your speech should describe who you are. Your name, if your meeting a new contact. It should explain what you have to offer, the skills that are relevant to the job you are seeking. What benefit will you provide. This video will benefit...
Most of the new refrigerators that are being sold nowadays have the ability to provide fresh drinking water with the push of a button. This comes in handy for those who want a nice and cold glass of water quickly. In order to provide drinking water, a water filter is installed in order to catch any harmful ingredients that may be inside of the water.
In this crochet tutorial, you'll be guided through how to crochet using one of the most unique and difficult yarns avilable on the market. Known as Pomp A Doodle yarns by Red Heart, these yarns are punctuated with little pom poms and are cute on their own, but great for fluffy projects.
This adorable bird pendant on a gold chain is a common sight at fashion forward indie stores like Urban outfitters, where similiar pendant necklaces sell for upwards of $30. While this necklace may look difficult to make, the materials are actually extremely easy to assemble (and no one expects you to cast and mold the bird yourself, so that saves a bit of time).
There are always two sides to every argument. Usually when it comes to furniture, one side is for throwing it out or selling it to buy a newer more enjoyable looking piece, while the other side may want to keep it. Is there a way to compromise? You bet there is! When it comes to old looking or antique furniture, you can easily refinish it to make it look brand new and fit the style of your room. This tutorial will show you how to easily refinish antique furniture in a snap! Enjoy!
Okay, so you've played through the whole game of Metro 2033 and feel like you've been missing out on something. Well, did you go after the achievements? If not, here's a tutorial on how to add some points to your gamerscore. The name of this achievement is called the Wheeler-Dealer. It's an easy to get achievement and requires you to buy and sell shotgun ammo over and over again until the achievement is unlocked. So good luck and enjoy!
Whether you are moving or just cleaning up your home, consider polishing your brass hardware. Just by giving a quick polish to things like doorknobs and window frames, you can improve the look of your home. If the little things are shiny, they are what everyone will notice, giving your home an especially clean look down to the tiniest detail. So, before you sell your home or invite company to stay, check out this tutorial and learn some polishing secrets from successful real estate profession...
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
Looking for something unique and beautiful to wear tonight? Check out this video on how to make a chunky crystal drop necklace that works for any occasion.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
It is very important to learn how to create a good book proposal. This video helps shed more light on things to think about when creating your book proposal. Essentially, a book proposal is your opportunity to sell yourself as a marketable asset to a publisher. Most publishers websites have down-loadable book proposal forms. They will request a lot of information such as what is your market, how do you intend to promote yourself, along with a few sample chapters. Publishers receive hundreds o...
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. "
"She never mentions the word addiction in certain company..." Have any idea who sings that wonderful song? Only the Black Crowes, one of the best rock bands to hang around since 1984 and sell 20 million albums. Learn how to play "She Talks to Angels" by the Black Crowes on acoustic guitar in this two-part guitar lesson video.
