Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:
If you're looking for a new way to show your feelings without buying a sappy Hallmark greeting card, then your solution: Make your own card.
There are so many different kinds of vegetables out there that each one contains its own unique look, tast, and benefits. Carrots are full of beta-carotene, broccoli is chocked full of healthy vitamins and minerals, and celery is a great veggie that has no calories and contains a good source of calcium. So taking a bunch of veggies and making soup stock out of it is a great way to not only add delicious flavor to any soup, but a good way of getting some healthy vitamins and minerals. Check ou...
In this how-to video, you will learn how to change the password to your hotmail e-mail account. This will be useful if someone knows your password or it is not unique enough to be safe. First, go to your web browser and log in to your hotmail account. Once you are in, go to the options bar and click more options. Next, go to view and edit your personal information. Click on change next to your password. Enter your old password and then enter your new password twice. Click save to change the p...
Racheal Ray shows us how to oven roast broccolini and green beans to feed six people. Any vegetable will have a unique and nutty flavor when you roast it in a high heat oven.
Linux is a fully functioning free operating system that you can download online. Just because you are using Linux Ubuntu doesn't mean your projects have to suffer or look less professional that those made on traditional operating systems like Windows or Mac OS X. In this tutorial, learn how to download and add fonts to the GIMP photo program on a Linux Ubuntu system.
"Blah, I vant to suck your blood!" One of the most common and overused vampire lines out there! But who could blame them? Vampires are pretty interesting and cool creatures that have been around for centuries. What makes them so unique and different is that instead of preying on victims during the day, they use the night to hunt and attack its prey, feeding off their fear of the dark. Well at least in movies. In real life vampires don't exist. But it doesn't mean you can't dress or look like ...
Looking to add some unique greens to your diet? Why not try some kale? Kale is a delicious, leafy veggie that can add some much needed fiber and nutrients to your meal. Kale tastes great prepared in many different ways and in this video, you will learn how to roast it for a yummy cooked flavor.
This video shows how to make an inside-out French braid across the front of the head. First divide the hair into three pieces like a normal braid at the very front off to one side. Instead of braiding the normal way, make the middle piece go over the top alternately on the left and right. Keep picking up more hair and adding it in, like you would do for a normal French braid. Continue braiding across the top front of the hair. The braids can be done tightly or loosely however you like, and th...
According to Shelley Lovett Pop Beads are a wonderful addition to any early learning environment. In this video Lovett starts by showing all of the different shapes, sizes and colors the Pop Beads come in. She also explains to the viewer where the beads can be purchased. Lovett then demonstrates how the unique construction of the beads makes it somewhat difficult to snap them together. Yet is it the required pinching and grasping that makes playing with Pop Beads so beneficial to developing a...
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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
Adorn any headband, broach, pair of earrings, or pendant with these adorable handmade paper flowers! Learn how to make these precious accessories step by step using this two-part video tutorial as a guide. Step out in style & unique to your friends by dressing up regular store-bought accessories with your own hand crafted creations!
Looking for a unique and inexpensive place to store your small possessions? In this two part tutorial, learn how to fold an origami jewelry box. All you need is paper and your fingers. This is a very cool origami project that is fun and easy to learn.
The Amazing Origami channel takes you through step by step instructions of how to build a triangle origami box in this video. Six pieces of origami paper, three different colors, are all the supplies you will need to make your very own box! First, separate the origami paper into two groups of three, all three colors should be in both groups. These groups will make the top and bottom of your box. The three pieces of paper used for the bottom will all use the same folding technique, this is als...
In this video tutorial, viewers learn how to gift wrap two bottles using the chopstick tenugui wrap technique. Tenugui is a thin Japanese hand towel made of cotton. The materials needed for this gift wrap are: a tenugui, chopsticks and two small bottles. Begin by laying the bottles horizontally as the bottom bases touch on the tenugui. Roll the tenugui and fold it up. Tie the ends with a double cross and add the chopsticks in the knot. This video will benefit those viewers who are planning to...
In this video, JD, from Tying It All Together, demonstrates how to tie a knot known as a "Ringbolt Hitch". This is also known as "coxcombing". This type of knot was once a common tie used by sailors to dress-up items and parts of their ships. When tying a wheel, a "Turk's Head" knot was used to cover the part of the wheel where the two ends of the ring bolt met, which would firm up the hitch, and help to keep the tied ends from unraveling. It is a nautical tradition to use this type of knot t...
In this video the instructor shows how to use the Auto play feature in Windows 7. Auto play is an old feature which was also available in Windows XP and Windows Vista. When you insert any removable media into your computer like a CD, DVD or a USB thumb drive, Windows automatically pops up a Auto Play window where it gives you various options that can be performed on the recently inserted media. This feature is very helpful and helps you open your media very conveniently. The Auto play window ...
Microsoft recommends a unique user ID and password for every user. In order to switch user ID or log off one need to click to the 'Start' menu as shown in the video. Press the move button at the shut down menu as shown. In the sub menu you can see the Change user and Log off. The window will typically shut down and restart on change of user ID or Log Off. In case you need to leave your PC unattended you can press 'Lock' from the same menu which will refrain anyone from changing your desktop s...
Don't trash your unfashionable old skirt, but turn it into something new, something unique, something fashionable. See how to create a designer tote from a skirt in this video from GiannyL.
Let's get creative! In this video learn how to transform that boring old paintbrush in Illustrator into a totally new shape and size. You can turn your art brush into an arrow to a paint stroke to charcoal or even a fire truck or another fun shape! This tutorial will show you how to change your brush, step by step, and get the most out of Illustrator's drawing capabilities. Follow along with the video and soon you will be making unique designs with ease.
Have you ever tried to write in calligraphy copperplate?Let's start with the basics-punctuation marks. First we nee a book and a pen to write in calligraphy. The letter '&' looks similar but has a long tail. The question mark,exclamation mark and brackets look similar like in a normal font except all have the similar properties of calligraphy i.e., the variation in thickness. This will add a unique style in hand written documents as well as to add some charm in your letters.
Butterflies are some of natures most beautiful creatures. How would you like to make one of your very own? Check out this tutorial and learn how to origami your very own paper butterfly and impress your friends. Grab a piece of paper - and some pens or markers if you wish to decorate your unique butterfly - and start folding! Making an origami butterfly is not as difficult as you would think, but you would never know that from the great results. Have fun!
How should you write in copperplate? Hamid will show us how write E and e in copperplate. First we need a book and a pen specially to write in copperplate. This type of font has letters with narrow edges and it gets broader in the middle. For capital 'E', it will be in curved form with the font's unique style of thickness. The small 'e' more looks like a 'c' with a closed loop. It will help in improving your handwriting style and add some grace.
This video shows us how to play "Creep" from Radiohead on an acoustic guitar with beginner alternative chords. The usual way to play this is by using the chords G, B, C and C minor but here it is taught in a rather simple way for making it easier for the beginners. For the beginners the easier way to play is to put the cap on the string where you will hold for the chords, for holding it a bit firmly. Firstly you need to hold is the chord C, following that will be E, then F97 and lastly it is ...
If you grew up eating beef mami or if you are looking to try something different here is a flavorful Filipino beef dish called beef mami. Filipino cuisine is inspired by Polynesian, Spanish, Chinese and American cooking and has transformed into it’s own unique style and flavors. This video will walk you through the process of creating this delicious dish. In preparation you will need to cook egg noodles, hard-boil eggs, have beef brisket, Chinese cabbage, star annis, mince garlic, mince onion...
Aspiring makeup artist demonstrates how to apply nonpareil sprinkles to achieve a candy-inspired look Purchase rainbow-colored nonpareils (tiny round sprinkles). These can be found in the baking aisle at your local grocery store. Apply sprinkles using a clear sticky lip-gloss. Create unique patterns, such as this swirl from the corner of the eye to the collar bone. Pair with candy-inspired jewelry and a chunky bun positioned high on the head to finish the look. Follow these suggestions to tur...
Enchant that special birthday boy or girl with a unique origami birthday pop-up card by following this well produced instructional video. 1. All you need is a two sided square piece of colorful wrapping paper to create your origami birthday pop-up card. As long as your paper is square, the finished card can be any size you wish. 2. Make a series of simple sharp folds on both sides, carefully following the video instructions. Pay particular attention to the final intricate folds which create t...
Mixologist Miguel Aranda wants to share his very simple recipe for Rose Water Champagne Cocktail in this video. He goes through each stage of the recipe including adding real rose petals to add more flavor and color to the Champagne Cocktail. You can use sparkling wine in place of the champagne if that is your preference and all of the ingredients are listed at the end of the video. By following these easy instructions you will have a great Rose Water Champagne Cocktail any time you need to a...
Learn how to personalize birthday cards with this informative video! This tutorial will show you how in just a few steps, you can make a race car birthday card with the help of a simple pattern. Why go out and buy a card from the drugstore that looks like everyone else's when you can create something unique for your birthday boy? All you will need to make this fun card is some colorful card stock, the Cricut racer paper doll pattern, glue, and a little time. This video also shows you how you ...
This video from TyingItAllTogether, brings us yet another tutorial explaining how to create a unique type of knot, called the "guitar bar". This knot is so named for it's similarities to the neck and fret board of a guitar. To make this knot, you'll need several feet of rope. For every inch in length of the guitar bar, you will need an extra foot of rope. So 12 inches = 12 extra feet of rope to spare, to make this creation.
One of the coolest features on a Blackberry is BBM or Blackberry Messenger. BBM allows you to talk to anyone with a Blackberry, anywhere in the world, absolutely free! You can send messages back and forth and you phone will even keep a record of the conversation in case you need to reference something later.
This video tutorial explains how to use Adobe Photoshop in order to create a unique metallic black and white effect. This simple technique (accessible to both newbies and experts) allows one to easily make photographs appear metallic. This technique requires minimal prior knowledge, walking viewers through the steps, from the application of filters (such as high pass) to the introduction of a black & white gradient. Finally, a subtle sepia tone completes the effect. This technique is useful f...
Two hunky guys demonstrate how to improve your abdominal muscle tone. Work your abdominals in a unique motion and boost your anabolic hormones to gain muscle and lose fat. In addition to this workout, add healthy eating and positive thinking and you will accomplish your goal. You can get your heart rate up to over 160 using these tips. The movements are simple, they are basic boxing hits. You must work the right muscles and move the right way, as with any exercise, and it works.
An interesting party decor idea is to place balloons inside other balloons. This can be accomplished easily by first inflating a large balloon. Using a small stick, push a second, smaller balloon inside the larger one and then inflate the smaller balloon while it is inside the larger one. You can then tie up the second balloon, leaving the smaller one inside the large balloon. This can be repeated with multiple small balloons, so your balloons will have a unique and interesting look. This tut...
Learn how you can make a Winnie-the-Pooh diapper cake with this video! Roll your diaper and arranged it in a unique shape one by one. It is covered with a baby towel then tied it with a ribbon. With in the side of the ribbon we can put toys, baby powder, dolls etc. After the decoration the diaper cake will look like a real cake. It is very useful to babies and this is very attractive.
For nails that always look unique, stylish, and are simple to make, you should take some advice from this video. After cleaning and shaping your nails, you should apply two coats of a white or slightly off-white nail polish. After allowing these layers to dry, get some black nail polish and make the zebra print by carefully swiping the brush over your nail. Alternate sides from which you start the lines and you should soon have a very stylish and interesting nail pattern.
A "hair bow" is a very interesting and unique up do which can be made fairly easily. After making your hair manageable with conditioner and other hair products, take a portion of your hair from the front and separate it from the rest. Make a tight, high ponytail with the rest of your hair and use a hair styler to carefully pull your hair through, making a tight knot. Separating your pony tail in half, tuck first one side and then the other into the pony tail, making two loops. You should then...
Creating a unique zebra print eye makeup design. Using a few different products such as a white base, liquid black liner, and hot pink eyeshadow you can create this effect. Video is complete with step by step pictures as well as finished photos. The color of the eyeshadow can be changed to match an outfit and create versatility. Watching this video allows you to create a very different style and look with the versatility to customize it to any particular outfit you are wearing.
This video shows you exactly how to great a collage using Photoshop. Step by step, from duplicating the layer, dragging, and every tool you'll need to learn to achieve the best collage possible. You can use this to make a cool, unique, and interesting collage, to share with your friends and family. This tutorial is easy to follow, so if your looking to master your Photoshop skills or are just learning how to use the program. This video shows you an alternative to the typical photo albums, and...
Want to create a realistic or customized wood stain for your home? Learn how to get the exact color stain you need to match existing wood finishes or to create unique effects.
