Celebration Table Search Results

How To: Play the Carom pool billiard game

Pool is an amazingly challenging game that one can spend a lifetime mastering. If you're bored with it, however, and want to try a new game on your pool table that uses the same skills, this video will show you one. It explains the rules to a game called Carom Pool, which is a hybrid between pocket pool and more traditionally carom billiard games. Even if you don't' enjoy the game, the spread-out nature of the table makes it great for working on your long shots and banks, so rack 'em up!

How To: Create a drawing space

In this video tutorial, viewers learn how to create a drawing space. A good drawing table has an incline and plenty of space for drawing on. But if you can't afford or don't have enough room for a drawing table, buy a piece of Masonite from the hardware store. Then simply lean the board on a desk or table. To hold the paper onto the board, use some tape and stick it onto the board. This video will benefit those viewers who are interested in art and drawing, and would like to learn how to crea...

How To: Use pivot tables for data analysis in Microsoft Excel

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 20th installment in said basics series, you'll learn how to use pivot tables (PivotTables) to analyze and summarize data.

How To: Build an Excel table of fraction & percent equivalents

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.

How To: Create a quantitative freq. distribution in MS Excel

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 24th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data frequency distributions with pivot tables. See how to create the correct unambiguous labels ...

How To: Look up data from different Excel tables with INDIRECT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Fix poorly set up data in Microsoft Excel

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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.

How To: Make a stuffed cabbage

Expand your dinner table selection, with help from ths wonderful and easy recipe for stuffed cabbage. Include this as a side dish to a main meat dish, and nobody will leave your dining table unsatisified. For this recipe you will need: cabbage, white wine, chicken broth, carrots, tomato sauce, onions, tomato, cooked rice, celery, garlic, and ground beef.

How To: Match two lists in Microsoft Excel

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 382nd installment in their series of digital spreadsheet magic tricks, you'll learn how to match values in lists and, where there are matches, take the second column from each table and put it in new table.

How To: Make easy kid placemats and set the table

Now when it comes to setting the table you just need three things: fork, plate, and a napkin. But for some, things are more complicated than that. Sometimes they feature the soup spoon , salad fork, and so on and so forth. Although this video doesn't cover every single utensil, it does cover some of the basics. Find out how to make placemats for kids as well as teach them how to set the table. Enjoy!

How To: Create formulas with table nomenclature on Excel 2007

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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.

How To: Analyze a CM statement with a data table in MS Excel

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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.

How To: Make a Christmas table centerpiece from an antler

Danielle Proud shows you how to make a beautiful Christmas table centerpiece for your Christmas dinner! Your guests will be amazed at how incredible your table looks. This amazing display catches light and looks simply magical. All you need is an old pair of deer or elk antlers, some sticky-backed crystals, and a little time and creativity! First, take your antlers and sand them until they are smooth and the color you like. Then, take different sized crystals, even different colors if you pre...

How To: Build a table out of LEGOs

In this tutorial from brickboy518, viewers are shown how to construct a table out of fourteen LEGO bricks. The following bricks are required: 4 1x1 spokes, two 4x1 strips, a 4x6 thin, a 2x4 thin, two 4x1 thins from the LEGO Racing Legacy sets, and 4 1x1 spokes. First, the builder must apply the 2x4 thin to the center of the of the 4x6 then. Next, they must attach one of the spokes on each corner of the 4x6. Then, the car strips must be applied face-inwards to the sides of the 4x6. Thus, this ...

How To: Do a jumping gemini with a three card monte throw

This video shows the viewer how to do a ‘Jumping Gemini’ card trick. In this trick three different cards of your choice appear to continuously find their way back to the top of the pack. This seems impossible as the cards are both placed on the table as well as being placed at the back of the pack. The trick uses a series of breaks and lifts to work. Essentially it involves continuously appearing to place the chose card at the back of the pack or on the table whilst actually keeping the card ...

How To: Build a LEGO table

Out of all the toys that have existed in the world, LEGOs are some of the most interesting, fun, and creative pieces of building blocks. Not only can they easily be taken apart, but there is no limit to what you can build using these magnificent blocks. This video tutorial will show you how to take some LEGOs to make a nice little table. Enjoy!

How To: Perform the "oil and water" card trick

In this short, fun and informative tutorial, Andy Field demonstrates the Oil and Water trick using four black cards and four red cards. Four cards are placed on one side of the table and the four red cards are placed on the opposite side of the table. He then mixes the cards, pulling one card from each side to make a new pile of cards with alternating colors. One red, one black, one red and so on and so forth with each of the eight cards. After letting the cards sit for just a few seconds he ...

How to Play pool: The Double Drifter

Use this tutorial for a simple and shot accuracy improving technique in pool! The steps for this tutorial are simple, yet effective in improving shot accuracy in pool. Align pool balls in a triangular formation at the far side of the table. Note that this is not the standard triangular formation for pool. Two lines are to be made diagonally from the center back of the table outward. Similar to this formation: \/ where the point would be directed to the back of the table. Leave space in betwee...

How To: Calculate the percentage of a number

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other files, even those with related data. If you wish to make your job easier, you should use relational databases. With databases, the tables communicate between one another. Once you store an entry in a table, you can use it i...

How To: Do a reverse two way look up in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...

How To: Reverse two way lookup for date & time in Excel

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...

How To: Graph a line using an x-y table

In this video the instructor shows how to graph a line using X-Y table values. He specifies a four step approach. In the first step he picks numbers for the value of x. In the next step he substitutes the values of x in the equation of the line to obtain the corresponding y values, in the third step he plots these ordered pairs on a graph sheet. Finally in the fourth step he joins them resulting in a straight line for the given equation. This video clearly shows how to graph a line using an X...

How To: Use PivotTable to group data in Excel

Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.

How To: Use flat files vs. relational databases with FileMaker

This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big disadvantage: it cannot communicate with other files even those have related data. So, instead of using those, if you want to ease your job, you should use relational databases. With databases, the tables communicate betwee...

How To: Stabilize your table saw

Shopsmith Academy shows you stabilize your table saw. Some projects may require precision down to a few thousandths of an inch. This video shows you how to accomplish very exact measurements. Apply this lesson to your next woodworking project. Search Shopsmith Academy on WonderHowTo for more woodworking videos.