Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
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 172nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create running total with a formula or a pivot table.
Take your dinner table to Vietnam (without the airfare prices) and make a traditional Vietnamese beef noodle pho soup! This is a delicious soup, perfect for a start to any Vietnamese meal. To make this recipe you will need the following ingredients:
This is a great bar trick from EasyBarTricks. This is the table smash technique. This will create enough space between the bottle and the dollar. Make this a bet and win a free beer. This is a great complement to the rolling bill technique of getting a bill from out of a bottle without touching the beer bottle.
Fashioning a napkin into a tidy envelope shape is one of the easiest ways to make each table setting look first class. Learn the art of napkin folding, perfect for entertaining guests!
The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch this video to learn how to open a bottle of champagne.
Learn this fun holiday craft that's great for kids! This pinecone placards make a great Thanksgiving decoration for the table. Follow along to learn how to make Martha Stewart's cute Thanksgiving turkey pine cone placards. All you need are pinecones, corn husks, and stems of gourds.
CSS div layers permit you to abandon the traditional MySpace layout by covering it up with a blank slate. Then you can create virtually anything you want to. You can add images, tables, Flash documents—most anything you can think of. For more information, and to get started using CSS div layers on your own MySpace profile, watch this helpful video guide.
This web development software tutorial shows you how to slice a site design in Photoshop, and then export the resulting images and HTML to Dreamweaver. This is an ideal method for creating newsletters, as the resulting HTML is tables-based, and better suited to email clients. Learn how to create HTML pages with this Photoshop and Dreamweaver tutorial.
We've all seen the popcorn cell phone video. Now, we have the exclusive inside into how those videos were created. A microwave magnetron is strapped covertly to the bottom of the table. Then the prank is ready. Gather the phones and wait for the exciting reactions.
Three different prank in order to scare your roommate. The only one that will cause harm to your friend will be the first one. So be careful and be safe. Use this as inspiration for one of your April Fools Day pranks!
Charles Sedlak shows you to properly tune your guitar in order to play Flamenco. You're just minutes away from playing this Spanish style music, and you can have your girlfriend dance on the table while you pluck those strings.
The key to this lamp is creating the luminescent shapes which represent electronic circuits or magic spells on the lamp surface. You could also do this on coffee tables or other objects you can make out of plexiglass - get creative!
Don't know much about the dinner table? You know the basics: you eat from a plate, you use silverware to shovel it in and you drink from glassware. But what about if you're at a fancy dinner? Would you be able to distinguish a juice cup from a champagne glass? A white wine glass from a martini glass? If not, these two videos will show you which ones are which.
Word 2008 for Mac is jam-packed with tons of cool and useful features and tools that you can use to make a great looking document. Starting with the pre-made templates is the best way to go, and from there, customize it the best you can, anyway you can. The Microsoft Office for Mac team shows you all the great features in this how-to video.
In order to make your own resin tabletop, you will need the following: a clean piece of wood (e.g. 2' x 2' piece of plywood, resin, gloves, objects to imbed in the table, and ultra seal.
Take your dessert from bland and boring to something special for your next dinner party with help from this video! In this cooking tutorial, learn from Sue McMahon, cookery editor at Woman's Weekly, how to temper chocolate. To complete this recipe you will need the following:
In this how to video, you will learn how to calculate the polygon area in ArcMap. First, open the program ArcMap. Next, go to the left column and right click it. Select attribute table. From here, go to options and click add field. Type in Area and click double. Next, right click area at the top and select calculate geometry. Next, select area disabled. Exit the windows. Next, click the red icon at the top and select data management tools. From here, select project. At the top drop down menu,...
Kevin demonstrates multiple methods to clean dirty coins.In the first method he takes some coke in a glass and hangs a dirty coin in it with the help of a string. This coke technique takes a few hours.In another faster technique which takes only 20 to 30 minutes he takes table salt and food vinegar. He takes the table salt and dissolves it in vinegar in a bowl. When most of it is dissolved he drops a dirty coin in it and waits about 20 minutes.Another method is to rub toothpaste on the coin f...
This is for an ankle that has been rolled to the outside of the body. Start by cutting a piece of rock tape that is about the length of the distance from the mid arch to right below the kneecap. To tape the ankle sit on a table put your heel on the edge of the table with your toes pointed down. With an ankle sprain this will be very painful so go really slow. Pull an inch of backing off the tape and anchor it about mid arch and then pull the backing off of the rest of the tape. Then with your...
This is a good dish to make it doesn't take that much time, and is something that you will like if you like shrimp.
Hosting your first holiday dinner? These tips & tricks will help you pull together a fabulous party without losing your holiday spirit or mind!
Whether you work at a clothing store or simply want to get your mom off your back, fold those tees in a flash.
Eagle Lake Woodworking, hosted by John Nixon, offers great do-it-yourself guides for building your own furniture, especially in the American Arts and Crafts style, and turning your garage into an amateur woodshop. Search Eagle Lake on WonderHowTo for more carpentry tutorial videos. From Eagle Lake Woodworking on this specific lesson:
Tired of losing your shirt playing poker? How about a fun game for couples instead? You Will Need
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to build a mini multi-touch table and photo stitch.
The art of floral arrangement is a fun and valuable skill. Dana Plazyk of Flowers by Design lends useful tips and tricks on making simple flower arrangements.
Learn how to sink a pool ball into a pocket. What do pool sharks know that you don’t about sinking a ball? Lots.
You'll never be able to hustle people at pool if you don't actually know how to play. Watch this video for a beginner's tutorial on playing pool.
A CNC router machine is probably the most useful tool a hobbyist can own, but the price for a CNC machine on the market is way more than the average hobbyist is willing to spend. You can build your own CNC with very basic tools, little knowledge of machinery, mechanics, or electronics, but be warned, these machines are inherently dangerous, so wear the proper protection and use common sense. At the very least, read the instructions and precautions on every tool you use.
You don't have to be a monkey to go bananas over these bananas. After all, these bananas look real and can be used as a fun dining room table centerpiece - just make sure to tell your friends not to try and eat them!
Live evergreen and flower arrangements are so beautiful for the holidays. But they can also be extremely costly, especially if you're getting boquets or arrangements in bunches so you have several for each table and countertop.
The holidays are upon us, guys and gals, which means it's time to start thinking about how you'll set your table to look inviting and beautiful for the festive season. While you can always go out and purchase a wilting pre-made floral centerpiece at your nearest supermarket, you yourself can often make a much better looking centerpiece at home.
Boomerangs can be dangerous. Oatmeal containers aren't. That's what makes this kids toy the perfect build for school or play. After constructing this "comeback can" toy, you'll have a can or container that you'll roll on the ground or table, and it will always come back to you. You'll need an oatmeal container (or similar can), rubber band, nut, a couple paper clips and a pen.
In order to use ThermaPure heat system to eradicate bedbugs, you will need a professional, with the appropriate equipment, including surface temperature readers.
If you enjoy dice games like Yahtzee that involve rolling dice in a cup, you have to learn this trick. It's called dice stacking, if you're not familiar with it, and it involves picking the dice up off the table with the cup and rolling them in such a way that they come out stacked. It makes you look like a pro.
80-ball is one of the many great games that you can play of your pocket-pool table, and involves all the layers of strategy of it's more mainstream pool game brethren. This video for 8-ball beginners will give you tips for evaluating and recognizing problems in different kinds of racks, equipping you to make the shots and decisions that will win you games.
In this tutorial from Dede, learn how to make this fantastic dip. This garlic sauce is nice and thick and goes great with pita bread, sandwiches, and many other dishes. Follow along with this recipe and add a little something extra to your next dinner table. You can even put it on fish! Yummm!
In this video, learn how to decorate beautiful cupcakes that are perfect for spring or summer parties. These little cakes look exactly like flower pots and in this tutorial, you will get a step by step walkthrough of the decorating process. These unique and delicious cakes will make a great addition to any table.
