Accomplished Search Results

How To: Stealth patch XBox 360 ISO's with AGBX 360

If you have a hacked XBox 360, you've only accomplished part of the process required to allow you to played burned copies of games on your console. You also have to burn the games correctly, and part of doing that is stealth patching you ISO files to make sure that they are up-to-date and won't get you noticed by Microsoft. This video will show you how to use AGBX360 to stealth patch you files and make them ready to play.

How To: Upgrade a flashed BenQ XBox 360 drive to IXtreme 1.61

If you've already flashed your XBox 360's disc drive, then congratulations, you've accomplished the most challenging step involved in hacking you XBox. You aren't done though. As Microsoft keeps updating it's firmware to try and fend off hackers, you must keep updating your custom firmware to thwart their efforts. This video will show you how to upgrade your flashed BenQ XBox 360 disc drive's firmware to IXtreme 1.61 using Jungle Flasher 1.61. NOw you can play your burned games with a greater...

How To: Do the Ed Marlo's atfus sleight move

Not only does "Andy Field Magic" go about showing the effect in a professional manner, he does so in a personable and thorough demonstration. Agreed, the effect is not magic in essence, but does show off quite the slight of hand. I appreciated that lack of jargon in the demo; the performer visually made sure that you understood what he was doing step by step. It makes for an easier learning environment when you know exactly how the effect is achieved through a slower paced demo. He seems to b...

How To: Shoot pool

Hello all of you fellow pool shooters. This video tutorial is designed to help you look like a real pool shooter. There are no pool tricks here, but great and informative basic information on playing pool. This will help you become the accomplished billiards man you've always wanted.

How To: Stencil paint your walls with help from the Home Depot

This is a step by step tutorial on stencil painting your walls, brought to you by The Home Depot. Beginning with a brief description of the art of stenciling, you are then shown the materials you will need to proceed. Next, you are shown how to prepare your room and surfaces. The goal will be to use a single stencil in multiple positions. The stipple method of application is stressed to achieve a multi-dimensional application. Two colors are used to give the added dimension of shadow to the i...

How To: Extract only numbers from a text string array forumla

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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.

How To: Generate a dynamic list from a table in MS Excel

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. In this Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Use the BINOMDIST & NORMSDIST functions in Excel

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. In this Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...

How To: Change dark hair to blond hair in Photoshop

In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...

How To: Fold a beautiful origami cicada

Ana Maria, an art student and origami expert, delicately explains and exhibits how to fold an origami cicada. The only material required is a perfectly square piece of paper, which is also known as origami paper. There are only seven easy steps or folds to create the paper-crafted bug; all of which are shown in plain detail by the artist. Every fold has another fold or edge to use as a guideline, so this simple creation should result in being very neatly accomplished.

How To: Draw martial artist Bruce Lee (face, body and shading)

When you think of martial arts, only one name comes to mind, and no… we're not talking about Steven Seagal or Chuck Norris. We're talking about Bruce Lee, the epitome of martial arts. Not only was he the best martial artist known to man, he was also an accomplished actor, instructor, director, producer, screenwriter, and philosopher. But there was one thing he wasn't. An artist. Okay, he was a "martial artist", but he wasn't a visual artist, master of the pencil, kind of the drawing world… bu...

How To: Do a slant gainer/cheat gainer

In this video tutorial the performer demonstrates the slant gainer, also known as the cheat gainer. Basically, it involves hurling yourself away from the ground, spinning in the air for a while and then trying to land without busting your ankles and/or head. If accomplished successfully, it looks extremely cool. If it ends in failure, at least you might get a hit YouTube clip out of it.

How To: Make an Infrared Mask to Hide Your Face from Cameras

This how-to video shows how you can hack a standard baseball cap into a cool invisible IR mask to hide your face from cameras anywhere, and look perfectly normal to the human eye! You have to admire a technically accomplished hacker. Now don't go out a rob a bank or anything. Watch this video tutorial and learn how to camera-proof your face with a creepy infrared mask.

How To: Dynamically count unique words in a column in MS Excel

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. In this Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Extract the three largest values from a list in Excel

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. In this Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

How To: Repair the remote start system in the ACME RC car

This video is a Hobby Estore Video Tutorial that will show you how to repair or replace the ACME remote start system in your radio control cars. You will know you need to take this step when your RC car doesn't start or when you push the start button and all you hear is a clicking noise. The first step is to remove the remote start system and this can be accomplished by taking the top cover off of the car and then unhooking the exhaust hose from the remote start system. Then take the cover of...

How To: Develop a child's beginner scissor skills

Shelley Lovett has some tips for helping a young child learn how to use scissors. The first thing you need to do is make sure you have paper and child size scissors available for the child to use. A full sheet cut in half is usually more manageable for a young child to work with. Have the child take the paper and just make cuts into the paper however they feel comfortable. Using colored paper can make it more interesting for them. After that very beginning practice stage has been accomplished...

How To: Find the percentage of total from a DB set 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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.

How To: Make date & time calculations (sans weekends) 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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.

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: Create an Excel Gantt Chart by conditional formatting

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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT 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...

How To: Do the Bachata reverse basic steps

The Bachata is a style of dance from the Dominican Republic. Accomplished with a Cuban hip motion to a four-step beat, it's a dance sure to get you sweating and grooving. In this dance tutorial, learn how to do the reverse step with a little help from a professional.

How To: Set and adjust tab stops and indents in MS Word 2007

This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...

How To: Stuff balloons inside of balloons for party decor

An interesting party decor idea is to place balloons inside other balloons. This can be accomplished easily by first inflating a large balloon. Using a small stick, push a second, smaller balloon inside the larger one and then inflate the smaller balloon while it is inside the larger one. You can then tie up the second balloon, leaving the smaller one inside the large balloon. This can be repeated with multiple small balloons, so your balloons will have a unique and interesting look. This tut...

How To: Bake low-fat lemon shortbread cookies or bars

Take the saturated fat out of a shortbread cookie?! What would be left? Cooking Light has accomplished what seems impossible! A low(er) in fat recipe for shortbread cookies. This Cooking Light recipe reduces the fat and calories without sacrificing the taste of these mouth-watering lemon shortbread cookies, perfect for an after-dinner dessert with coffee.

How To: Draw realistic looking people

To draw people, proportion is important to maintain a realistic appearance, as well as anatomical details. Draw the basic human form with tips from a professional illustrator in this free instructional video on drawing. Figure or anatomy drawing is an important first step in becoming accomplished at drawing.

How To: Dumpster dive with freegans

What is a freegan? It's an anti-consumer movement, and a way of getting free food by dumpster diving. Get a crash course in dumpster diving with an accomplished Biology professor who demonstrates the lifestyle of a freegan. Watch this video ecology tutorial and learn how to dumpster dive.

Prev Page