Celebration Table Search Results

How To: Punch down a 24 port patch panel

Jim teaches us how to punch down a 24 port patch panel in this tutorial. You will need: cable scissors, a punch down tool, and 24 port patch panel. Now, strip the cable by cutting it and stripping down the wires. Now, attach the wires to the port punch panel by following the pattern of where the different colors are at. When you have these connected, use the punching tool to punch the wires down, then it will cut off the excess wire from the panel. When this is all done, you will want to tie ...

How To: Use the TextEdit text editing application in Mac OS X

Before you buy a professional word processor consider using TextEdit, a program that comes with your Mac and can handle most non-professional word processing needs. You can format and style text, add images, lists and tables, and even open Word docs. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about five minutes. For more information, including detailed, step-by-step instructions, watch this Apple lover's guide.

How To: Use templates in Dreamweaver

In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...

How To: Pack glass for storage or moving

In this video, we learn how to properly pack glass for moving. Make sure you have a table or work area that has a furniture pad on it. Now, place packing paper onto the bottom of a box carton for glasses and china. Glass should be on the top of the box while plates should be placed at the bottom. Put the glasses into a rolled piece of paper until secured, then place upside down into the box. When finished, add crushed paper to the top of the first layer to avoid any glass from breaking. Make ...

How To: Do Pilates Reformer exercises to strengthen your hips

This clip offers advice on how to use a Pilates Reformer table to strengthen your hip muscles. With Pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body Pilates. For complete instructions, give this free exerci...

How To: Reverse yoga poses to open up shoulders

In this tutorial, we learn how to do reverse yoga poses to open up the shoulders with Dina Prioste. You will want to start off in a reverse table top position, which will give your shoulders a nice deep stretch. To come into this position, sit with your knees bent and take your hands behind you, so your fingers point towards your feet. Now, inhale and lift your hips up and keep pressing your feet into the floor. Keep your chin touching to your chest. A regular tabletop position just includes ...

How To: Fix a wobbly platter problem on a turntable

Learn how to open up your turntable platter in order to fix a wobble on your table, getting those records to play smooth. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions, take a look.

How To: Replace old shoe molding in your home

It may not seem like a big deal, but it can be for some homeowners. Shoe molding around your cabinets and island tables, can asily be damaged or become worn out over a long period of time. Replacing it, may seem like a pain, but it's really simple and can be done in no time. Check out the tutorial above on how to replace old shoe molding in your home today. Good luck and enjoy!

How To: View a hidden friends list on MySpace

MySpace gives users the ability to hide their friends list. This video walks you step by step through being able to view this list. First, go to the desired profile. You'll see the hidden friends list. Now, click on "Edit with notepad" and code will pop up on your notepad. Because the list is on the page, editing the source code will make the list appear on the page. Next, type the command >table border=0 cellspacing=0 align="center">. Now you'll be instructed on how to delete the source code...

How To: Find APR, EAR & amortization for payday loans in 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Install and use a dado blade on your table saw

If you plan on making any kind of cabinetry or beds or anything else like that, having a dado blade is a useful and handy tool. What this does is make a u-shaped cut into your piece of wood that is perfect for combing two pieces together to form a sturdy, solid joint. So if you want to find out more about dado blades and how to install and use one check this tutorial out. Enjoy!

How To: Sort data with sorting functions in Microsoft Excel

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 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Sharpen a fillet knife

Believe it or not, you are more likely to hurt yourself or others with a dull knife. Not only are sharp knives better to cut with, they are much safer to use. When you are fishing, the fillet knife is one of your most important instruments. In this tutorial, you will learn how to sharpen your knife on the go and keep your instrument in tip top shape. In order to sharpen a fillet knife, place the blade of the knife in the "V" of an Accusharp tool before following the blade off the table. In th...

How To: Create a partition & format an external hard drive

This video teaches us to partition a hard drive. Open 'Disk Utility' and go to 'Seagate FreeAgent Media'. Go to 'Partitions' and select '2 partitions' in the 'Volume Scheme'. Click on 'Untitled 1' and put the name of the partition, its format as Mac OS Extended (journaled) and Partition Table from 'Options'. Name the second partition and choose 'MS DOS (FAT)' in format. Choose 'Master Boot Record' in 'Options'. Click 'Apply' and 'Partition'. This creates the two partitions of the hard drive a...

How To: Create a simple rollover menu in Dreamweaver

This video shows how to create a menu with rollover images in Dreamweaver. Open a new document and create a table with one row and one column. To add your rollover images, go to the "Image" tab and select “Rollover Image”. In the “Insert Rollover Image” box, give the image a name, then click “Browse” under “Original Image” to find your images. You can select your rollover images in the same window. Then enter your alternate text and click OK.

How To: Make a puffed up tissue flower

This video shows you how to make a puff flower ball using tissue paper.Spread out a tissue paper,of any colour,on a table.Keep one of the short ends of the paper,facing you and away from you.Then fold it back and forth,from one short to the other side until the whole of the tissue paper is used up.Fold this into half and release.Take a piece of ribbon and tie it on the center.Give the edges a pointed, partyish look by cutting them using a pair of scissors.Now take a single piece of tissue pap...

How To: Find percent by mass & percent composition

In chemistry you come across problems which ask you to find the percent by mass and percent composition of each element in a chemical compound. To do this the first step is to compute the molar mass. Use the periodic table to look up the mass of individual atoms and multiply it by the number of atoms to find the mass of that element. Now add up all the masses to arrive at the molar mass of the compound. Now to find the percent composition of an element divide the total mass of each element by...

How To: Sort data in single columns & whole tables in Excel

To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...

How To: Solve word problems involving exponential growth/decay

The first problem that is show is exponential decay. First you will need to create a table with hours and substance left. The next step is to find the trend by noting that we are left with a certain percentage of the substance. One you have the trend you will use this to calculate the amount of substance left in said hours, in this case 6 hours. The following example shows you how to solve exponential growth. It is essentially the same except for the fact that you will be increasing, so inste...

How To: Do a t drill in pool

In this how to video, you will learn how to do a T drill in Pool. This is called a T drill because the balls are arranged in a T shape on the table. The point is to take the cue ball and try to run the balls in numerical order without allowing the balls to touch another. You also must be able to make the shots with each ball. Try moving the cue ball so that it lands far away from the balls. The hardest part is shooting 3, 4, 5, and 6 into the pockets. Try shooting 3 and 4 in the same corner. ...

How To: Do the black and red cared trick

In this Magic & Parlor Tricks video tutorial you will see how to do the black and red cared trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. It displays a deck of cards, which the presenter says is a normal deck of playing cards containing 52 cards. He then shows the other side of the deck where the cards all mixed up. He shuffles the deck a few times and shows that the black and the red cards are all mixed. Then he shuffles one more time, puts the dec...

How To: Change Windows XP start menu text

Certain aspects of Windows User Interface are not customizable like the text of the start button in Windows XP. However you can use certain tools and follow a procedure to change the default text of the start button. To do this you have to use a tool called Resource Hacker. Note that this is a very simple method, but be careful or you may end up causing damage to the Operating System as you are modifying system files. To do this run the program. Now browse to the Windows folder and locate win...

How To: Use an OFFSET as a dynamic range in an Excel VLOOKUP

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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.

How To: Make lamb burgers

In order to create lamb burgers, you need lamb meats, spices, sauces, a bowl of lime and lemon, sweet chili and honey. Mix the onion granules and honey altogether and marinate the lamb meat. Add a table sauce of hot chili sauce, a pinch of salt, add lemon and place your hand inside the mixing bowl to thoroughly mix the lamb meat. Create little buns as the consistency starts to thicken. Make patties that are flat and round. Place it in the microwave to hasten the process. Once the patties are ...

How To: Use a pugmill in pottery throwing

This video shows the method to use a puggmill in pottery throwing. Take the two packets of clay and take the clay out on the table. Take a thread and cut the two pieces of clay in the middle to form four bricks. Put the bricks in the puggmill one by one and wait for it to come out. The pugged clay comes out from the bottom in a cylindrical shape. Take out the four cylinders from the four bricks of clay. After this, put the cylinders in the pugmill again so that they are pugged thoroughly. Put...

How To: Throw a terracotta long tom flower pot

You start out with putting a rater big lump of clay on the potter's wheel (the turn table if you want) and make sure you got water close by. By using your hands and your fingers you then start to shape the clay lump into the size you want it. Keeping both the clay and the hands wet all the time. Once the pot starts to get the size you want it to be, you start to give it a more detailed shape. In this case it is a bit wider in the top than in the bottom. Once your satisfied with the shape, you...

How To: Clean and cut a whole pineapple

Chef Dan Bobo explains the proper way to clean and cut a whole pineapple, putting safety and cleanliness first. The first step is to wash the pineapple. Then, you can start cutting it: First, try to find the flattest side of it by rolling it over the table. Then, hold it firmly, make sure you keep your hand clear the knife and just cut the top of it. Discard the cut piece and repeat the same to cut the bottom of the pineapple. Now, you can use the new, flat surfaces of the pineapple to cut th...

How To: Extract the top five records from a table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.

How To: Spray paint Ikea furniture for a girl's bedroom

The video demonstrates the way of converting a plain IKEA cabinet for a girl's bedroom using spray paint. The person presenting us the video uses a pink all-purpose spray paint from Rust-Oleum Painter's Touch. The cabinet to be painted is dismantled and placed on a table. The person recommends to shake the paint spray bottle well before using it. First she paints the cabinet body and then the two cabinet doors using the pink spray paint. Once the spraying is complete, she lets it dry well and...

How To: Simplify expressions involving numeric radicals

In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square and you wish to simplify it, the key is to write it as the product of a perfect square or another number. This video is very descriptive and clearly explains the functions of the formula. This video will benefit those v...

How To: Make easy grilled pork with marinated pork chops

This is a video showing how to make grilled marinated pork chops. It is marinated in oyster sauce, garlic and ginger. She then minces garlic, ginger and cilantro. She also adds sugar, oyster sauce and another seasoning sauce. She also adds water, salt and pepper and mixes. She then submerges the pork in the sauce. She places oil in the hot pan and then places the pork chops in the pain. The pork chops are allowed to cook on high heat and are then removed and sliced into strips on a cutting bo...

How To: Use the antique distressed paint technique

Using an antique distressing paint finish technique on furniture is a good way to revive a piece of furniture that other wise might just be discarded. This video is part of a series of videos taking viewers through the process of distressing furniture and focuses on accent technique. You’ll want to accent the select parts of the furniture you want to accentuate that distressed look. Our expert recommends painting the edges of this table. You’ll want to pick a complimentary color and when you ...

How To: Bend acrylics (like Plexiglas) with a hot air gun

Have you ever wanted to bend a small piece of acrylic? Well now you can with the help of a traditional hot air gun and this informative video. Make sure to wear safety glasses and gloves before trying this project. Clamp the acrylic to a work table, and proceed to turn the gun on and heat up the piece of acrylic, using a steady back-and-forth sweeping motion. As it heats up, you can use your fingers to gently bend the acrylic upward. Leave it at 90 degrees to cool down for a couple minutes, a...

How To: Use a Neti pot easily

Neti pots can be used to clean out your nose of dust, dirt and allergens and can help reduce swelling of the nasal passages. Stir half a teaspoon of salt in to a cup of warm water. Salt should be kosher salt or sea salt (DO NOT use ordinary table salt). Pour saline solution in the neti pot, then leaning over a bowl or sink place the spout of the neti pot in one nostril. Tilt your head so that your nose is slightly higher than the mouth, then rotate your head so your ear is facing the bowl or ...

How To: Wrap a Wiccan cinnamon stick bundle for protection

This Spirituality video clip will show you how to wrap a Wiccan cinnamon stick bundle for protection. You need some cinnamon sticks, scissors and ribbon. Cut a very long piece of ribbon, lay it down on a table, place the cinnamon sticks on the ribbon, tie a basic knot flip it over and tie another knot. With one end of the ribbon, go over and in between the sticks and with the other end, go under and in between the sticks. Now put one more knot in between the sticks. One more time go under or ...

How To: Transform a hoodie into a strap bag

This video visually explains how to convert your hoodie into a strapped bag. First lay the hoodie face-up onto a table or other flat surface. Then you take a normal belt and, holding it in one hand, feed it in from one sleeve all the way through to the opposite side. Once the belt is peeking out through both sleeves, buckle it together. You can then place the items of your choosing inside the hood, tying it shut, while using the belt as a strap that you can hang around your shoulder like any ...