In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...
In this video the instructor shows how to format tables in Microsoft Word 2007. To know how to format tables in Word, you will first have to know how to create them. This video assumes that you already know how to create tables. When you click inside a table in Word, a new tab label, Table Tools, appears above the Design tab in the tool bar. In the Design tab there are a lot of options available that can change the look of your table with just a click. To the extreme left there are three chec...
Do you remember "The Heist" from episode 21? Well, the sequel is even more unfair than the original! Check out this video if you want to stump people with a trick called "The Heist II." For this trick, you need only a few simple supplies: a match, a cup, and a nickel.
Multi-touch input has been spreading throughout a huge variety of devices, from phones to all-in-one PCs. However, most multitouch (table) displays that can function with your computer tend to be fairly expensive, so with this project we're going to make our own display, that can run on any operating system, and reuses some useless everyday materials.
This table magically folds over to create a secret compartment. This way you don't have to clean the table off, just fold it over and use the backside.
This video will show you how to build or assemble the IKEA FJELLSE twin kids bed with wooden head and foot board.
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.
You probably decorate your dining room table for Christmas, but what about Thanksgiving? We realize that the big turkey, mashed potatoes, and various other sides take up most of the room on the table, but that doesn't mean you can't add some non-edible flavor.
Looking for comprehensible instructions on how to assemble your IKEA Kvarnö garden table? You're in luck! This free video tutorial presents comprehensive, step-by-step guide on how to put together a Kvarnö table. For detailed instructions and to get started setting up your own Swedish garden table, watch this helpful how-to.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).
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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.
This style of table is often only seen at restaurants, but you can easily build a set for your own home - a square, high-set pub table with four matching stools. A stylish addition to any kitchen or dining room.
This video begins with examples of different finished welt techniques being shown. A piece of finished cloth is then folded over twice and then held in place before stitching. The first knit is started on the left side of the cloth and continued until reaching the opposite side of the fabric. A wooden needle is then used to weave from right to left until the wooden needle is pushed all the way across the fabric for support. This step is repeated three times until the welt is visible and stabl...
This video explains how to build a robot with the basic ability to scribble on paper. The narrator gives website addresses for more examples on completed robots and various information on the subject. The Robot is built using a plastic cups and wooden sticks for legs and support. A motor is then attached to a wooden stick which is then attached to the top of the plastic cup. One nine volt battery is needed to power the motor. Once the battery has been attached to the motor you must attach the...
It is a well known fact that due to the rotation of the Earth about its own axis has a bulging effect on the equator and a slight flattening effect at the poles. This experiment tries the reproduce the same effect using simple materials.
In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...
Chemistry can be very fun when you create different kinds of reactions between elements. Note that caution should be employed to not harm yourself while performing these reactions. Ammonium Tricynate reacts with barium hydroxide octahydrate in endothermic form. Endothermic reactions are those which absorb heat from the surroundings during the reactions as opposed to exothermic reactions which produce a lot of heat during the reaction. When endothermic reaction occurs, depending up on the inte...
This video helps the holiday table settings add a fun and colorful theme to each holiday. Using white plates and table cloths, along with clear glass settings, will help to bring out the colors and details of the decorative additions to the table. Having scented candles or other types of fragrances will highlight and compliment the holiday table theme you have set. The table decorations you will see don't need to match, they only need to flow in with the theme you have arranged. This video wi...
This video from Danny Lipford explains how to make a cover for raked leaves so that the wind won't blow them away. Get a tarp and cut it to the right size. Get two wooden dowel rods and put them along two ends of the tarp. Turn the tarp edge over the dowel rods and tape them down with duct tape. The cover can be used to cover leaves that are in a wheelbarrow or on the ground. You can also lay the tarp on the ground, rake the leaves into the tarp, drag them where you want them and pick up the ...
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
So whether you’re a beginning builder with a little know-how, or you happen to be an experienced craftsman itching to do another project, watch these basic carpentry videos and learn how to build table from scratch. Learn what tools and materials you need, how to take measurements properly, how to use shop tools to cut the wood, how to attach an apron to the table top, how to create leg braces, how to put it all together, and finally, how to sand the table.
Learn the massage techniques for performing dorsaflexion and table stretching. Part 1 of 3 - How to Perform table stretching.
Now you can create really sophisticated tables in InDesign CS2. Your tables can contain text or graphics and best of all they can be created dynamically by importing tables from Microsoft Word or Excel. In this video you’ll see how to create tables from scratch as well as how to create them in Excel.
Hi everyone, I have been working on some videos and tips about restoring antique furniture, in this tutorial, I will be showing you how to remove a scratch from a wooden table.
The Segway is one of the oddest inventions of the last decade, but they've captured the imaginations of many. If you don't have $5000 to spend on one, but have $4000 and some heavy robotics skills, watch this video. It will teach you how to build your own DIY self-balancing Segway-style scooter, in either steampunk wooden barstool form or a more modern bicycle-handled model.
This video is a demonstration of how to play a drinking game called flip cup. You'll need a stack of 16 oz. plastic beer cups, a long table, and beer. First pick two teams of four to ten players. Teams stand on opposite sides of the table and fill the cups with beer. The lead players drink, then set the cup down so that part of it is off the edge of the table. Then they flip the cups so that they land upside down on the table. The next player on each team has to wait until their teammate has ...
Enhance your garage with a custom-built workbench. If you can use a wooden workbench, you can build one. And this carpenter's guide, which presents a complete breakdown of the build process, will show you precisely how to do it. For more information, and to get started building your own custom worktable for your garage woodshop, watch this free video guide.
Log cabins are so beautiful they look straight out of a storybook. In this two part tutorial, starring Becky from Becky's Homestead, you will learn how to make your very own wooden home. It's easier than you think!
Check out this informative video tutorial from Apple on how to use tables, color, images and fonts in Numbers '09.
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09.
The hot dogs are all eaten and the fire is still crackling; it's the perfect time to make some delicious s'mores. You will need marshmallows, chocolate bars, graham crackers, a wooden stick or metal roasting fork, and a campfire. S'mores are a camping and outdoor food favorite, but can be made at home with a microwave. Watch this video cooking tutorial and learn how to make s'mores.
In this video tutorial, you'll learn how to make utensils in the wilderness. You'll see how to make a wooden fork, spoon, pot hanger and support when out in the woods. Also, learn how to clean your knife using moss. A nice piece of hazel wood is what you'll want for this survival bushcraft technique.
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 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...
In this video Ron Hazelton tells you how to build a craft table. By following each step carefully you will have a sturdy and proper table. Some of the things you will need are laminate, trim, nails, screws and stringers. Using these steps and creativity putting together a craft table is made easy.
Bert creates an 8-ball on a pool table from scratch with Adobe Photoshop. The pool table is made using the noise filter, pixelate>facet feature and the gradient tool. Learn to create your own virtual pool table in this Photoshop tutorial.
In this tutorial, we learn how to build a magnetic stirrer from computer parts. This is a simple thing to make, and is great if you are going to be mixing chemicals and don't want to get your hands dirty. First, you will need to create a wooden box with the top empty. Then, place a computer fan into the middle of the box and pin it down. Place a magnet from the hard drive in the middle of the fan, then place a stirring rod on the glass that will go on the top of the wooden box. Now you will b...
This video is a tutorial on how to set a table in a restaurant. The table should first be wiped thoroughly with a product called Thieves, a mixture of organic oils that contains no chemicals. Be sure it is dry before people are seated.
This video teaches us the way to properly set a table. You will require a couple of things for this purpose. These things include a table with a table cloth and napkins. These should be kept at one side of the table. Then take salad forks and dinner forks. Arrange these in the center. Take knives and spoons. Arrange these besides the forks on both the sides. Take bread and butter plates and arrange them above the salad and dinner forks. Put glasses above the spoons. Put bread and butter knive...
To carve a wooden propeller first join six pieces of wood together to form a block. Mark the outline of the propeller on the block in pencil. Use a hand chisel and hammer to form the rough shape of the propeller. Once the rough shape is complete use a motorized hand grinder and then a motorized hand held sander to make the propeller smooth. After the sanding is complete you will need to finish it off with a coat of polish. Finally, you will need to balance the motor before fitting it into pla...
