In this tutorial, we learn how to use a jigsaw. First, measure and mark the size of the circle you need to cut. You can use a compass or trace around a round object. Now, place your wood off of a table and clamp it into a place. Now, drill a starter hold inside the circle and put on your protective glasses. Now, place the saw in the starter hole and saw half way up, or to where you feel comfortable. After this, reposition yourself, then continue on. Make sure you don't force the saw, just let...
In this tutorial, we learn how to design a fall centerpiece in a watering can for a home. Start off by cutting branches off of a willow and placing it into a watering can. Next, arrange Japanese lanterns around. After this, cut alstromeria and seeded eucalyptus and place them around the can where you feel they fit best. The best part of this arrangement is that you can arrange it however you want! You can add different types of fall flowers and add more or less of flowers you prefer. When fin...
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
In this tutorial, we learn how to increase accuracy while playing pool. First, place the Q-ball on the head spot of the table, then you freeze an object on the opposite and shoot the Q-ball into the object ball and make the ball come back in the same path. You will want to ball to shoot directly back at you. This drill will help you develop accuracy and a better stroke. If you don't have a perfect shot it won't come back in the right path. Keep practicing this and in no time you will have inc...
Saving energy is as easy as 1,2,3! There are various places in your home where you can spend money on that will not only save you energy, but money as well. One of the most common and easiest places is the light fixtures. From sconces, to lamps, to the lights above your dining room table, these lights can be replaced with more energy efficient lights easily. They cost a bit more, but in the long haul will save you money and help leave a smaller footprint on this planet.
In this tutorial, learn how to make an ordinary coin completely vanish by placing a clear wine glass over it!
Warhammer 40,000 and other collectible-miniature-based table-top games have created a generation of people who love painting and playing with tiny figures. If you are into the game or any of it's ilk you've probably had an idea for a piece that you would like to create from scratch. This video from Storm the Castle shows in great detail how to make your own miniature figures out of rubber that should stand up to anything you've bought from Games Workshop. Model on!
A brick oven makes baking cakes so much easier. Now you don't have to prepare the cake fully before your guests arrive, now you can bake it while they're there, tempting them with a cake "straight out of the oven!" This chocolate soufflé cake is delicious warm, too! Watch the full video recipe for baking chocolate soufflé cake with Chef Hubert Keller.
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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
To do the Faro shuffle card trick, first divide the deck in half. With practice you should be able to accurately make an even division. Hold your left hand underneath the deck and your right hand on top of the deck. Use the two halves to square up the deck. Go in on an angle, intertwining the cards. Make them meet on the bottom and apply a little bit of pressure to them. They will naturally intertwine. Spread out the cards on a table in two columns to check your shuffling technique. You can a...
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the consolidation feature in Excel. Summarize data from a number of different tables quickly using consolidation.
If I had kids, this is something I would totally use to not only entertain them but give them something fun to look at during dinner. This fun tutorial shows you how to take some simple foam and use glitter, markers, and other items to make cool placemats. Enjoy!
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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.
In this Family video tutorial you will learn how to do leaf rubbings for a children's activity. For this you will need a flat surface. If the table top in slightly uneven, put a sheet of construction paper on it. The materials you will need are sheets of paper, crayons and leaves. You can also use fabric leaves if your area doesn’t have any leaves. Take a leaf; put it upside down on a flat surface so that the veins are on top. Put a sheet of paper over the leaf and hold it down with one hand....
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. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).
Here's a healthy recipe for a sumptuous sweet potato salad and a refreshing beverage to complete your dessert table. For the potato salad: 1. Place the diced sweet potato in a large bowl. 2. Add the diced chicken, some chopped onions, some scotch bonnet pepper, some sweet pepper (green, yellow and red), the mixed vegetable, mayonnaise and raisins. 3. Toss and mix the ingredients well. 4. Place the potato salad on a bed of lettuce leaves and garnish as desired. For the mango-cherry lime splash...
This video explains how to properly fold fitted sheets. The first step is hold the sheet with the pattern, outer side closest to you and put your left hand into the first pocket and your right hand to the second pocket. Put your right hand over your left hand and flip the sheet on top of itself. Keep your hand on the top sheet and follow the edge all the way down to the third pocket. Place your hand on the underside (non-patterned part) and match it to the first two pockets, and then flip it ...
The self-proclaimed "Flower God" was shopping the other day when he came across a vase that he could not resist purchasing. He shows us how to create a beautiful flower arrangement. He works with two different heights: a high plain and a low plain. He wires up some flowers so that they hold their shape better, clustering them down at the bottom. He then accents the low section with some Japanese Lanterns which project outward from the lower section. Next come the flowers for the height, tall ...
Go to the Menu and click the Start button. Now select Control Panel. In the Control Panel, you can see the Option Programs. Now you can see Uninstall Programs in small letters below the Programs option. Click on Uninstall Programs. Here you can see the list of programs installed, when they were installed, what is the size of the program, and which version of program is installed. To uninstall a program, simply click on the program you wish to uninstall. Some options get displayed above the ta...
This is an instructional video on how to decorate a cake with icing in a basket-weave pattern. You start out by measuring out the cake and placing evenly spaced marks along the side so you know where to put each line in the weave pattern. You then use a flat, rigged tip and drag the icing horizontally from one of your lines to the next line. They suggest using a turn table so you can easily access the entire cake. Then they teach you how to put a "shell border" on your cake by using a differe...
This video demonstrates the making of mango pickle without using oil. Take a few raw mangoes and peel them, cut them into small pieces and remove the seeds. Do not throw away the peels as these can be used crushed in mint chutney. In a bowl, mix table salt, red chili powder (made fresh by grinding some dried chilies from which the seeds are removed), add a few pieces of asafoetida (hing). Put the mix in a pestle and grind them as fine as possible. Fresh grinding will give the aroma of the spi...
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
This video teaches the secret of making a cool perpetual spinner with a few little things and science. You will need: white paper, scissors, pen, pencil with eraser on its back, bell pin and a suitable cap. Draw a spiral shape on a plain sheet of white paper using a pen. Now cut out the drawn spiral with a scissor carefully. Punch the bell pin on the tail of a pencil. Stick a small cap (which suits the center of the spiral) to the center of the spiral as shown. Now stick the pencil on a table...
This video explains the method making heart shaped cupcakes or Valentine Day's cupcakes. At first take the mix here the moist deluxe cake mix is used. Using that mix make the cupcake mix, for a particular pack of mix 3 table spoon of oil is added then add egg white to the mix. Then to the mix pour some water of about half or quarter of a glass. The water poured mix is mixed with a mixer. Then pour the mix in the cup cake plate placing a cup cake paper in it. Then shape it in the form of heart...
He starts off performing the task that he then describes. It's one technique that is called a mirrored double click flare. This is done by moving the record forward a double click and then back a double click then forward a single click. The whole process is then done in reverse, starting with moving the record back a double click. On his DJ table he moves a cross fader to mirror his movement of the record. First start the technique slow without a beat to get the movement memorizes. Add a bea...
Quick and simple technique to soap a deck of cards. Use any deck of cards. Use a bar of cashmere bouquet soap. Make an x mark on the back of EACH card using the soap. Shuffle several times in different directions and spring the cards to spread the soap better. Lay all the cards in the table to check smoothness. Try this easy approach to soap a deck of cards and see how smooth you can use the cards. Find other tips at Gary Ouellet's book, "Close Up Illusions".
We all love muffins and this is a recipe for really spongy, fluffy and moist raspberry muffins that will make the perfect addition at the breakfast table. This video will make baking delicious muffins easy for anyone and any occasion.
This Lowe's video shows you how add warmth and beauty to your home by installing hardwood floors step by step. First you must prepare the sub-floor. You will need engineered hardwood planks, transitions, and moldings. You will also need flooring adhesive, trowel, hardwood floor cleaner, circular saw and table saw, hammer, nylon tapping block, pry bar and pull bar, wood glue, pencil and tape measure, nails, knee pads, dust mask and safety glasses. You should read the instructions. It should ta...
Ingredients required: 1)3 eggs
This video shows Joanne McKenzie working at her table talking about making her oversized/giant photo corners for her paper cutting projects. Using an assortment of different sized and colored punches, she explains how to use the punches, saying the smaller one is the better one to start with. She talks about using the next size up and then centering the paper to be cut from corner to corner and layering the different cut out corners for decoration. Very clear and professional.
This is video is a tutorial on how to sharpen a pocket knife. It is filmed as a man sits at a dining room table discussing points and demonstrating how to properly sharpen the knife. He makes several points about different ways on how to sharpen knives. He is careful to explain why you sharpen the knife during each step in the process. This video would be great for people who have never sharpened a knife before because he discusses a lot of information. However, if you're just looking for a n...
This video describes how to improve one's skill when performing home based projects with wood which is a useful skill if one wants to build a table, chair or even a box. In this video one will learn how to sink a nail, cover the hole and leave a sanded finish. For example it is important to drive all nails 1/8 an inch into the surface of the wood so the filler can cover the hole properly and avoid leaving sharp edges or uneven surfaces. Overall this video is simple, easy to follow and useful ...
This bar trick that will be sure to win you some beers. Plucking at the table cloth will slowly, but surely, pull the penny out from under the glass. Try this "coin limbo" party trick out yourself by watching this reveal.
A bar trick is just the thing to win a few bucks… or a few beers. With this "icebreaker" matchbox trick, you can do just that, until you're too drunk to do it anymore, and start losing beer and money. Anyways, the challenge is to put the bottom matchbox on the top while keeping your middle finger on the table at all times.
If you don't have Stampin' Up's Big Shot yet, you will definitely want one after watching this video! In this video you will learn to make a rosette using this machine. You can make them out of paper, fabric or any of a number of mediums. These rosettes are great embellishments for many things such as scrapbooks or gift cards. If you are really adventurous you can even use fabric to make rosettes to adorn your table or maybe make hair decorations for a special little girl.
