Buffet Table Search Results

How To: Divide bigger numbers

In this video, we learn how to divide bigger numbers. As an example, let's say you were dividing 843 by 13. To make this easier, write down the times tables for 13 down and keep adding up. After you do this, see how many times 13 goes into 84. Your table will tell you how many times it goes into the larger number. Thirteen will go into 84 six times, so write six on the top line above the four, then subtract 78 from 84 and write a 6 next to the 4. Now, work out the remainder and when finished,...

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: 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: 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.

How To: Make a floral Birthday "cake" table centerpiece

This video describes how to make a "no calorie" birthday cake centerpiece with carnations in soft and sweet hues of pink, yellow, white and cantaloupe. first a flower foam was taken. Then the toothpicks were used to join the flower foam together. Then trace out a circle from the foam using a kitchen knife. Add some water to the base of the cake. With equal size flowers decorate the base of the cake. Then the cake is beautifully covered with different types of flowers. decorate with as many fl...

How To: Fold a geometric origami salt cellar

Want a super awesome way to serve your salt and pepper that's not in your run-of-the-mill salt and pepper shakers? Then try popping your table seasonings into this awesome geometric salt cellar. It has four different compartments for you to place whatever you like tossing on your food.

How To: Carve a turkey easily for Thanksgiving

Once your Thanksgiving dinner table is set with beautiful gourds, autumnal leaves, and candles and your turkey, green bean casserole, and pies are out of the oven, it's time to mess everything up. While a beautiful dinner presentation is great and all, unless you plan on having your guests rip off drumsticks from the turkey caveman-style you'll probably want to carve the bird.