Coffee Table Search Results

How To: Find mean, median, & mode (averages)

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 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Create an amortization table 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 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...

How To: Look up & retrieve a row of data from a table 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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

How To: Set a table easily

To set the table for a formal dinner, place a plate a little bit to the left of the center of the meal sheet. Place two forks to the left of the plate, The smaller fork is for the salad, and should be placed on the outer side. The inner fork is for the dinner. Place two knives to the immediate right side of the plate. The outer knife is for the salad, and the inner knife is for the dinner. Place two forks to the right side of the knives, the outermost spoon is for the soup, and the inner spoo...

How To: Set up your table for watercolor painting

In this how-to video, you will learn how use set up a studio table for watercolor. First, make a water blotter out of toilet paper and tissue folded in half. Fold the towel into the paper. The gator board and paper should be in front of you, with the sketch at the left side. If you are right handed, everything should be on the right side. This allows for ease of painting. The kleenex and trash can should be on the right as well. If you are left handed, everything should be on the left. This p...

How To: Use the MCONCAT function 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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.

How To: Create a column of unique values in an Excel LU table

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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.

How To: Clean a microwave with citrus and water

In this video, we learn how to clean a microwave using water and citrus. You will need 1 lemon, 4 cups of water and microwave safe bowl. On a cutting board, slice the lemon in half. Next, place the lemon halves in the microwave safe bowl and fill it with water. When you are done with this, place the bowl into the microwave and set to 5 minutes. Turn on the microwave and when it's done take the bowl and turn table out. Wipe the inside of the microwave out with a cotton towel. If you have stubb...

How To: Draw atoms of different elements

An atom is a basic unit of matter consisting of a dense, central nucleus surrounded by a cloud of negatively charged ions. The nucleus itself is a mixture of positively charged protons amd electrically neutral neutrons. Different groups of elements have respective atomic numbers. You can use the periodic table as a tool to draw atoms of elements. The periodic table is organized into periods, groups and families. This video is a tutorial that reviews the subatomic particles found in an atom. I...

How To: Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...

How To: Make Thai iced tea

This is a video demonstrating how to make Thai Iced tea. The presenter explains that Thai tea mix can be bought at a local Asian market. She explains that it costs about 5 dollars. She says that one package can last a long time. Sugar and boiling water, ice and half and half is also necessary. A large pot is then filled with water and boiled. The tea leaves are then placed in the boiling water and are then mixed with a large spoon. The heat is on high and the tea is allowed to boil for 15 min...

How To: Get rich quick with feng shui at home

Feng shui helps to create positive energy at your home. It drives away the negative energy from your home. Eventually the people living in that home will get good thoughts. Thoughts make a person good or bad. Thoughts can make you rich or poor. You can change your life by making some simple changes at your home. This space lift can do wonders for you. In the energy map, wealth area is at the far left hand corner of the house. dry flowers bring negative energy and losses to your home. Therefor...

How To: Design a head table flower centerpiece for a wedding

This is a short, very fast paced (6x normal speed) demonstration of how to arrange a floral and green head table piece. The 54 seconds shows the designer how to complete an arrangement from beginning to end. It is difficult to see what the shape of the base is, but it is fresh flowers going into the design. The designer places long greens into the center of the base, adding some long white stemmed flowers. Red carnation heads are then placed around the base along with some additional greenery...

How To: Make homemade playdough for kids

To make homemade play dough you first need to mix all of you ingredients together in a pan staring with two cups of flour and two cups of warm water. Next you add about one cup of salt, two table spoons of vegetable oil, and one table spoon of cream of tartar. After that you stir it until it looks like pancake mix. Now you need to continue to stir it while you cook it over low heat. It should start to stick together and form play dough like masses. You will know the play dough is done when it...

How To: Design a candle centerpiece for your table at home

In this video, The Flowergod demonstrates designing a candle centerpiece for a table at home. The video includes a time-lapse (6 times speed) demonstration of Flowergod actually creating a centerpiece, and lighting the candle afterwards. In this way, you can see how quickly (The video is less than a minute long at 6x speed, so just over 5 minutes) he arranges this centerpiece, as well as how it looks when it is finished. At the end of a video, a website is displayed where you can go to see fu...

How To: Clean cut using a table saw, mitre saw or power saw

This short video tutorial Bob Schmidt will show you how to make clean cuts in wood. The blade rotation of any pretty much dictates the best way to run your material through. To get the cleanest cut possible remember these tips: Whenever you run wood through a Table saw, always make sure that your finished side is up. Do the exact opposite when you are using your Power saw. The finished side of your wood must be at the bottom. When you use a Mitre saw, make sure the finished side of the wood i...

How To: Cook a quick dish of spinach fettuccine

A quick and easy way to whip up gourmet spinach fettuccine. Follow along and learn how to make this vegetable and pasta dish. This cooking how-to video is part of Quick Fix Meals with Robin Miller show hosted by Robin Miller. Busy people everywhere face the same dilemma, how to get healthy weeknight dinners on the table when you've only got minutes to spare. Cookbook author, nutritionist and food journalist Robin Miller guides you through the landmines of getting food on the table nightly wit...

How To: Make easy and quick zucchini boats with orzo pasta

Make easy zucchini boats for a delicious weeknight meal. This cooking how-to video is part of Quick Fix Meals with Robin Miller show hosted by Robin Miller. Busy people everywhere face the same dilemma, how to get healthy weeknight dinners on the table when you've only got minutes to spare. Cookbook author, nutritionist and food journalist Robin Miller guides you through the landmines of getting food on the table nightly with her stress-free meal planning strategies. Her easy, day by day plan...

How To: Solve dog counter surfing with a clicker

It's a timeless doggie no-no, and one that has been paradied in numerous dog scenes in movies: A plate of delicious fried, steaming food is left by the owner on the table. The owner then leaves for a brief moment. His dog, smelling the delicious goodness, seizes the moment and quickly jumps up, snatches a piece of chicken, and devours it under the table.

How To: Make spiced tapioca sago

This video describes how to prepare the tapioca sago. First take 2 cups of tapioca and wash, drain and soak in ¬O cup of water. Soak it for two hours minimum. Then the tapioca will become softer and become larger in size. Next take a pan and take 2 table spoons of oil and one table spoon of oil in that heat it for a while. Next ¬O teaspoons of cumin seeds then add green chilies and then add 2 table spoons of peanuts. Once the peanuts are fried, add the slices of potato. Next add the ¬º spoons...

How To: Make a Jeopardy board using Powerpoint 2007

Microsoft PowerPoint is a powerful software to make presentations. It can also be used to make a Jeopardy board. To do this open a new PowerPoint presentation. Start with a title layout. Now add a gradient to its background. To do it right click on it and select the fill option from the menu. Select the color of you choice and fill the background. Now add the title in the layout with suitable fonts. Now add a new slide and insert a 5 X 6 table to it. Format the table with colors of your choic...

How To: Plan a kid safe, very green baby shower

Julie Auclair introduces authors of a book called "Celebrate Green." This book shows you how to throw a baby shower the "green" way. Guests do not realize that some of the gifts they give can be harmful, toxic, or not recyclable. You start with the three "R's", reduce, reuse and recycle. You use these to determine if a gift falls into one of these categories. They have added the three "G's", which are "good for people," "good for the planet," and "good for the community." They begin with the ...

How To: Clever Chemistry-Based Cures to Common Kitchen Conundrums

You probably already know that cooking involves a ton of chemistry. Bread rises because of the reaction between the flour and leavener, and the delicious crust on your steak is formed by the Maillard reaction. Understanding the chemistry going on behind the scenes is one of the best ways to improve the quality of your food—it's much easier to fix a problem when you know what's causing it.

How To: Build a light table for silkscreening and photography

Josh Copp and Madeline Donahue show us how to build a light table from pine wood and plywood utilizing two fluorescent light fixtures as the light source inside the box. The frame of the box is fashioned out of two 1X8 planks cut into four pieces so that two sides are 30 inches and two sides are 22 3/8 inches. The base of the box is made of plywood or OSB and is 30X22 3/8. Once the pieces are cut and assembled using a pocket hole jig and wood screws, the inside of the box is painted with whit...

How To: Make hydrogen gas & an explosion

First you need to make hydrogen gas which require a few material. Such as a glass bottle, a Full table spoon of aluminum (beer or soda can will work), a half a cup of cold water, a table spoon or two of caustic soda, a funnel, a medium size container of water, a way of cutting the aluminum, one or two balloon's, and some safety glasses just incase something goes wrong.