In this tutorial, Simon Leach teaches us how to make lidded boxes. First, grab your pot and dip the top of it into water to get it wet and soft. Now, grab a small amount of clay and set it on your spinning table. After this, get your hands wet and start to craft a lid out of the clay. Make an inner base as you are spinning the clay by carefully placing your finger on the side of the top. When finished spinning, place the top down and see if it's the correct size for the pot, then glaze and fi...
Halo Reach is the final entry in the Halo series (at least according to Bungie), and if you're looking to chomp up some achievements with little to no effort, you're covered! In this video, IGN shows you how to cheat the multiplayer settings of the game to allow you to get as many of the game's multiplayer cheats with little to no effort. Just be sure you can handle Legendary mode!
Have you been yearning to join a crime syndicate? Wishing you could you mob-like skills to proper use? Want to bust heads with a thick accent? Well, you don't need to live in a crime-filled city to become a gangster in the mafia, because Mafia II lets you do it right from home, from your Xbox 360.
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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
In this video, we learn how to update your living room. First, you can paint your living room with premium colors to give it a richer look. Crown molding will also change the look of the room after you paint. Window treatments will also give your home a nicer look, adding in dimension. Invest in table lamps, which will encourage your guests to sit down and relax. Also, changing the door to your dining room will add a classy touch as well! If you can afford it, upgrading the carpet will add a ...
We've all played with LEGOs at some point in our childhood, but when video games took over the world, we all converted to PlayStations and Xboxes in lieu of building blocks. But soon enough, the satisfaction of childhood construction was integrated into video game format, so we could once again love LEGOs. With LEGO video games like LEGO Harry Potter, LEGO Indiana Jones, LEGO Star Wars, what could go wrong? Nothing. But before those games, there was another, based not off of popular movies, b...
If you liked Daniel Craig as the new James Bond, then you'll love this video game for the Bond franchise. It's called 007: Quantum of Solace, but isn't just based off the movie "Quantum of Solace," it also mixes in the previous film, "Casino Royale." It's a first-person shooter that's full of action packed scenarios.
In this tutorial, we learn how to create links between tasks in MS Project 2007. First, select the task you want to link, then click on the link task button on the toolbar. You will now see a finished task link between these tasks. In the entry table, you will see the predecessor, which is task two. You can also type the numbers in the predecessor column and enter the information in. You may want to create a link that is different, so you don't confuse two things that will start at the same t...
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!
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....
In this video tutorial, viewers learn how to control which games can be played with Net Nanny. Begin by opening the program and select Manage Games under Games. Users will have 3 options on how to block or allowing the games. Users can block by the ratings, games or descriptions. For the ratings, simply drag the slider to which ESRB you want to be allowed. For the games, simply go through the list and click on the game that you want to block. For the description, by checking the content that ...
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're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...
