Celebration Table Search Results

How To: Turn Google's 'Files' App into a Full-Fledged File Manager

With the files on our devices getting more important as the years go by, the need to keep things organized continues to rise. The longer you have a device, the messier the internal storage might become. Having a file manager would be extremely useful in this situation. You could also reorganize the folder structure as well, just like you could on a desktop computer.

How To: Survive Your First Night

This "How-to" is how to survive your first night on Minecraft. This is for new Minecraftians to Minecraft. The first thing you want to do is find wood. This is very essential to survive your first night. Then, you want to make wooden planks. To craft anything, press E or I. After that, there should be a 2x2 box at the top. Put two wooden planks on top of each other. If you did this right, there should b four sticks to the right. After that, you want to make a Crafting Table. To make a Craftin...

How To: Paste an Excel table into a PowerPoint for Mac 2011 presentation

Need to know how to paste an Excel table into a Microsoft PowerPoint for Mac 2011 presentation? This video will show you how it's done. Whether you're new to Microsoft's popular word digital slideshow application, new to MS PowerPoint 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For detailed, step-by-step instructions, watch the video.

How To: Make a miniature table

In this tutorial, we learn how to make a miniature table. Materials you will need are: a wood slat, 4 popsicle sticks cut in half, paint, paintbrush, and glue. Heat up your hot glue gun and then grab your popsicle sticks. Glue one stick to the side of every corner of the slat. After this, you should have two on each side of all four corners of the wooden slat. After you're finished placing them on, let the glue cool and then harden. To finish, you can paint this and decorate it and use it ins...

How To: Use a table saw with Skil & Lowe's

In this video we learn how to use a table saw with Skil & Lowe's. The rip cut and the cross cut are two cuts that are most useful. A rip cut goes with the grain of the board to cut it to width. The cross cut goes against the grain and cuts it to length. First, position the board next to the blade and then raise the blade. The blade should be just above where the board is at. Slide the rip ends over to the dimensions you want and then lock it down. Put your safety glasses on, then turn on the ...

How To: Play blackjack using basic tutorial

In this tutorial, we learn how to play blackjack using basic tutorial. To start, the dealer needs to deal cards to the players at the table. Then, the dealer will lay out cards on the table. If you think that you have the right cards to make 21, then you can tell the dealer to lay out another card or you can hold if you don't want to go over 21. Whichever player comes closest or exactly to this number will be the winner overall. This is one of the most easy casino games to learn how to play a...

How To: Create a data validation drop-down list from a table with duplicates 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Set up the L drill in pool

In this tutorial, we learn how to set up the L drill in pool. To do this, you will place all of your balls in an "l" shape on the pool table starting from the middle of one side of the table. Place the balls about two inches apart, then star to make the horizontal line for the balls. Place these two inches apart as well. After this, you can place your shooting ball next to the balls and hit each of them into the same corner pocket as the last one. This is a great way to practice hitting balls...

How To: Recycle old windows into new decorations

In this video, we learn how to recycle old windows into new decorations. First, you can make a coffee table by using the old window and adding legs onto the bottom of it. You can also place a box around the bottom and hinge the window to make a display case. This is simple to make and doesn't cost much, you only need to pay for the legs of the table! You can also use the window to make a pot rack, but make sure you have strong hooks in the ceiling to hold the rack tightly and it will be able ...

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