Single Table Search Results

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: Make a time lapse video using Adobe Premiere Pro

Time lapse videos can be used to distort a sense of time around your subject, which makes them very useful special effects in documentaries. By using time lapse, you can show the transition from sunrise to sunset in just a few seconds, or slow down a drop of water hitting a table. The tools in Adobe Premiere can be used to create this effect, and the following tutorial shows you how to take your raw footage and turn it into a time lapse shot.

How To: Make simple pot stands

In this tutorial, we learn how to make simple pot stands. Start with your clay on the table and use water and your hands to start to shape it. Press down on the ball until it forms into a low bowl shape. Then, start to add more clay and water to the sides of the pot so that it's thicker on the edges. After this, place the pot stand onto a ceramic drying area, then you will be able to glaze it and fire it. Clean off your spinning table after you are finished, then enjoy your pot and pot stand!

How To: Beat the Tactical Command Challenge with flawless gold ranking in StarCraft 2

Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...

How To: Use bank shots to get off the wall in foosball

Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how to use bank shots to score more foosball goals and make you opponent look silly.

How To: Use brush passing to control the game in foosball

Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how you can use brush passing to confuse your opponent and win more games.

How To: Score goals with a snake or rollover shot in foosball

Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how to use a snake or rollover shot to get more points and defeat your foosponent.

How To: Score foosball goals with the pull shot

Foosball, the tiny table-based version of soccer, is one of the most popular games in fraternity houses and bars across America. It's great for bringing four people together, and is easy to learn but difficult to master. If you're looking to improve you game, watch this video. It will show you how a foosball pull shot works, and how you can use several different variations on the pull to score more goals.

How To: Master the basics of the billiard game 3 Cushion

Most US bargoers think of Pool as the only billiard game of any note. There are zounds of these games though, and many of them are just as fun. This video will teach you the basics of playing one such game called 3 Cushion. It looks really fun, and if you've got your own billiards table why not try it out? You do need a billiards table, no holes in this game.

How To: Perform a trapeze table Pilates exercise routine

This clip presents an overview of how to perform a basic trapeze table Pilates routine, one particularly well suited for gymnasts and martial artists. With Pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body P...

How To: Make a perfectly thin & crispy pizza pie

In this clip, learn how to make a perfectly thin, crispy Italian style pizza with Food Mob. You will also learn how to top those beautiful bases with the best ingredients so absolutely everyone at the table will be happy. Don't bother with delivery or one of those store bought pizzas - make your own! It's worth it.

How To: Summarize survey data with a pivot table in MS 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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.

How To: Clean up a bad data set for a pivot table 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 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Hand knead dough

This video shows you how to hand knead dough in the traditional French way. Your goal is to introduce air into the dough to add strength to it. Have a little flour on the table surface. Lift up the dough and slap it down on the table, trying to capture air into it as you let it fall. Do this for twenty minutes. Make sure that you make a quarter turn of the dough each time you lift it. It needs to be thrown about 600 times and when it is ready the surface will be smooth, with no bits hanging f...

How To: Calculate probability in an Excel pivot 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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.

How To: Use an advanced filter to extract table data 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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Build a garage workbench

Want a work table for your garage workshop? If you can use a wooden workbench, you can build one. And this carpenter's guide, which presents a complete breakdown of the build process, will show you precisely how to do it. For more information, and to get started building your own custom worktable for your garage woodshop, watch this free video guide.

How To: Use a Ouija board by yourself

OuijaFreak shows viewers how to use a Ouija Board alone! First, you need to gently set the pointer on the board. Next, place your hands very lightly on the pointer. You'll want to be barely touching the pointer. Hold your wrists up and keep your hand off the table. Your hands cannot be heavy on the table - you need to keep everything light. First, you should ask if 'anyone is here' when using the board. A response can take even 20 minutes or even longer. You have to be patient. If you are not...

How To: Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...

How To: Use data validation with a list in Excel

This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...

How To: Use the range property in Excel macros

Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...

How To: Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Extract records that meet certain criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...