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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
-Fold paper where you want it cut -Take a wet piece of string and insert it in the fold, pressing it firmly
In this video, learn how to use the Classic Bumpit to create height to your hair, and how to style it with a ponytail for a classic glamour look. Watch as the videomaker demonstrates how to keep it from showing and coming out with help from a few bobby pins.
Learn how to make stuffed pizza pockets for your kids. A delicious snack or meal. A larger version of this Italian recipe is often called a calzone. Vary the fillings to your families liking and you will win raves at the table.
Maple glazed butternut squash is great during the holiday season, and the dark rum in this recipe makes it a worthy addition to any party table.
Potatoes au gratin are a favorite all season long. This creamy and cheesy casserole is a great side to any meal. It's a perfect side dish for your table!
Roasted winter vegetable medley will add a dramatic feel to your harvest table. By roasting root vegetables together, you bring out all the best flavors that this winter vegetable medley has to offer.
What's the best way to bribe a bouncer at a club? It takes tact and strategy. Fold a bill up with the denomination showing into a tiny square. You must need a good attitude to get past the bouncer or the best table at a new restaurant.
This tutorial will show you how to achieve romantic curls. All you need is a curling iron and some helpful advice from Michelle Phan. Create pretty curls for Valentine's Day in no time.
Nothing beats a Champagne tower for old-world elegance—so long as you construct it so it doesn’t fall down! Watch this video to learn how to build your own champagne tower. You will need:
Steampunk, a vintage Victorian mechanical style, is one of the hottest design trends to date since faux bois. Get in on the trend while creating many hours of fun for yourself and friends by making this awesome steampunk style chess set. This chess set is comprised of various pieces of hardware, a found table, and common household chemicals.
In this short automotive restoration how to video Chris explains how to repad your VW seats by going to your local fabric shop and save money. Once you find something you like, it's really easy to recover and restore seat padding in any classic Volkswagen bug or beetle.
Watch this instructional photography video with Jim Talkington and learn how to light a studio portrait using three lights. This is the classic three light portrait technique using a main light, fill card, hair light and background light in the photo studio. Adding additional lights should bring out texture, extra detail, and three dimensionality. Practice these tips and improve your photography skills.
In this episode of "The Cocktail Spirit," Robert Hess mixes up a classic champagne cocktail and relates some cocktail history. You will need champagne, bitters, and lemon for garnish. Learn how to mix a champagne cocktail by watching this video beverage-making tutorial.
In this DIY video, we show you how we built our camera crane. This was all done with a table saw, drill and hack saw.
This pool shooting tutorial demonstrates how to control the cue ball using reverse English, opposite to the one that seems obvious. This will help line the ball up where you want it, preventing it from going too far down the table and allowing you to win the match.
Mari demonstrates how to fold the leaves and stand for the Kawasaki Rose. These make really nice table decorations.
Learn how to make this classic vodka drink, the Cosmopolitan from acclaimed bartender Anthony Caporale, of The Art of the Drink. He shows how to put in the correct ounces of vodka, cranberry juice, triple sec & lime juice and he also shows very interesting techniques with the lemon garnish as you will see when you watch.
In order to use ThermaPure heat system to eradicate bedbugs, you will need a professional, with the appropriate equipment, including surface temperature readers.
This is a video that shows how to design an accent table centerpiece for a wedding. The video shows the simple and easier way to do it. First you have to fill the glass with water and fill that with whatever leaf and things that will suit according to you. Keep these things in a direction that bends to the outside of the glass, then add some flowers to it which will make it even better than you can see when doing it. Adding flowers gives it a beautiful look. Finally tie a white ribbon to the ...
In this Labrats video tutorial the instructors Andy Walker and Seab Carruthers show how to undelete the deleted files and recover them. When you save data to your computer, the computer stores the data in the binary format on the hard disk. To keep track of the files, the Operating System maintains a file table that shows the location of the data on the hard disk for a specific file. There are many file formats like FAT, NTFS etc. So when you are erasing the file only the entry in the file ta...
The martini is the most classic of all cocktails, but with great fame comes great controversy. What kind of gin do you use? What kind of gin to vermouth ratio? This video mixology tutorial series covers all those pressing martini questions and set you on the way to become a martini aficionado.
This classic lunchtime sandwich gets a twist in this recipe, made with garlic balsamic glaze. Get the recipe and all the steps to cooking this wonderful meal. Cook a classic open face New York steak sandwich.
In this how to video, you will learn how to make creamy asparagus pasta. First, you will need 200 grams of pasta, 3 cloves of garlic, 240 grams of asparagus, a half a cup of white wine, pepper, 2 table spoons of extra virgin oil, 3 sun dried tomatoes, a handful of fresh basil, salt, 2 table spoons of soy cream, and parmesan. First, wash the asparagus and cut the ends off. Now cut the asparagus into pieces. Cut and peel the garlic, tomatoes, and basil. Add the oil into a pan and place the aspa...
Fifty cent coins and quarters made before 1964 were made of 90% silver. This is considered jeweller's quality silver so can easily be made into a ring. Kennedy Half Dollars can be found at coin shops or on ebay for four or five dollars a piece. Begin with an anvil which can clamp onto a table. This will allow you to hammer without damaging the table. If you don't have a anvil, you can use any flat surface that is sturdy and made of metal. Next, take a small hammer, position the coin on its ed...
Andy Field shows us a trick that has little set up and carries a high reaction. This trick is called the wrong prediction trick. You will need a deck of playing cards a wallet and a black magic marker. Take out the queen of hearts and write "9 of clubs" on the back of it. Stick the card in the wallet face side up this will be called the "force card". Find the 9 of clubs in the deck and slightly bend it to give a slight concave effect. Do the same to the queen of hearts. Fan out the deck face ...
Andy Field shows you how to perform the “Whispers” card trick by John Mendoza. This is a more advanced trick that requires a detailed setup that Andy demonstrates.
Know thy enemy — wise words that can be applied to many different situations, including database hacking. It is essential to performing adequate reconnaissance on a system before even thinking about launching an attack — any type of attack — and this is no different for SQL injection.
If you are interested in cake decorating and sugar craft, check out this great video that will teach you how to make a swan out of sugar. The swan is a symbol of elegance and makes a great addition to any cake or table.
Adorn your table top with azaleas this spring that'll last through the season, and perhaps for many more springs to come. While most flowers die within a week, these origami azaleas will stay ever beautiful year round.
Does a bob haircut remind you of flappers from the 1920's? Originally, the hairstyle (as worn by flappers) was meant to be an androgynous cut, boyish in length and style.
This is a great bar trick - cut a small notch into two pennies and then stick them together. Make sure they are lined up ninety degrees to each other. And then, roll them across the table, bar or floor!
This is an easy exercise you can even do at home - all you need is a weight or dumbbell and a few chairs or similar low table to exercise on. This is a bit more challenging than a traditional exercise, but the results are worth it! Always keep your back straight.
There may only be one thing hotter than a disco inferno and that's learning how to play the bass line from 'Disco Inferno'. Throw down some heavy tones and watch them shake it on the dance floor. This disco classic will show you how to play the bridge section of this classic disco hit.
A tortilla warmer is a traditional way to keep your tortillas warm at the table. This tutorial shows you a quick and easy way to warm up your tortillas and the warmer in the microwave. Make sure not to microwave the lid!
This tutorial shows you how to sew your own set of black out or Roman blinds. You will need some heavy fabric in your chosen colors, a large work table, a steam iron and a heavy duty sewing machine or serger.
Got a vase? How about a candle and some fake snow? Then you've got yourself a frosty good centerpiece for your holiday table. Check out this holiday decor video to learn how to put together a wintry scene.
Wreaths traditionally go smack dab on your front door, but that doesn't mean you can't get a little creative with them. Turn a wreath into a table centerpiece by laying it down, sticking a candle in the center, and adorning the wreath with ornaments and ribbons.
The winter months may not seem like the best time to be growing much of anything, but the amaryllis thrives from October to April, which means its bright, cheery petals can adorn your table top during the holiday season.
So it's 6 AM on Monday morning and you're sitting at your dining room table dreading the hour-long drive to work. While taking a swig of Vodka - or at least a flouncy little martini - would probably make you feel better, invigorate the senses and ease your way into the workweek with this Monday Morning espresso cheesecake mocktail instead.
