Accomplished Deal Search Results

How To: Create a LinkedList for Java programming

Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to work with linked lists when writing code. For more information, including detailed, step-by-step instructions, watch this programmer's guide.

How To: Create mouse events for Java programming

Want to write Java applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to create mouse events. For detailed instructions, watch this programmer's guide.

How To: Create a GUI with JRadioButtons when Java programming

Want to write Java applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to work with JRadioButtons when developing a graphical user interface (or GUI). For detailed instructions, watch this programmer's guide.

How To: Program a mouselook scroll for Java game development

Want to write Java applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to work with the MouseLook class for a free look effect in Java game development. For detailed instructions, watch this programmer's guide.

How To: Work with sprites in Java game development

Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to work with sprites when doing game development. For detailed instructions, watch this programmer's guide.

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: Extract part of a table from a larger table 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Cast a shadow within a photo in Photoshop

When editing your photos in Photoshop, there are many different things you can do to manipulate your original image. One of those things is to add shadows. Using Photoshop you can cast a shadow within any photo, on any object. In this tutorial, learn exactly how to accomplish this. You will also learn how to use the extraction tool and distort mode to cast a realistic shadow on just about anything.

How To: Make salmon sushi

Love sushi but have no idea on how to make it? Watch this quick instructional video and learn how to make mouth watering salmon sushi. Its simple to make and takes a few ingredients with salmon and white rice being the main ingredients you will quickly be able to create this sushi. Learn the right way of cutting the salmon for the perfect sushi and learn the techniques it takes to accomplish making a salmon sushi roll that will make you look like a pro.

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: Create a multicolor effect in Photoshop

This video is a how to guide on how someone can add multiple colored sections to a photograph. It goes step by step to guide viewers on how to accomplish the color effects. Although the video is only 5 minutes long it provides a great wealth of information. However the speaker is quite fast so using the pause button is highly encouraged for those not proficient with computers, or those not very quick with a mouse. A very informative video that taught me something I did not know how to do in P...

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: Pair your bluetooth phone to Ford SYNC

Sometimes pairing your mobile phone with your car is a difficult and unwritten chore to accomplish. But now with Ford's new SYNC system, you can easily pair your cell phone. It's as easy as pressing the Phone button. Let it search for already stored bluetooth devices, and if none are stored, simply press the Arrow buttons until you see the Add Bluetooth Device option. It's that easy!

How To: Solve the Rubik's Cube with Shepherd stickers

Learn how to master the Rubik's Cube puzzle... watch this two-part video tutorial to see how to solve the Shepherd Rubik's Cube. You don't have to be a genius to accomplish solving the 3x3 Classic Rubiks Cube, but you may have to be one to solve one with stickers invented by Alistair Shepherd. This is one hard cube design! These replacement stickers can be used for the 3x3, 4x4, and 5x5 Rubik's Cubes.

How To: Solve the Rubik's Cube faster with fingertricks

Learn how to master the Rubik's Cube puzzle... watch this two-part video tutorial to see how to solve the Rubik's Cube faster with fingertricks. You don't have to be a genius to accomplish solving the 3x3 Classic Rubiks Cube. You just need some limber fingers, and maybe some heavy duty silicone spray for lubrication. These finger tricks will get you on your way to solving the Cube in under one minute, or close to it anyway.

How to Do the M1R/M1L: Make One Right/Left knitting technique

Watch this instructional video to accomplish the knitting technique: M1R / M1L: Make One Right / Left. A make one, abbreviated M1 in knitting patterns, is an increase stitch. In some instances the slant of the increase does not matter, but, when it does, it's helpful to know how to make one left-slanting and how to make one right-slanting. A make one right slanting is abbreviated M1R:

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Perform a magic bar trick with a cloth napkin

This trick works great in pretty much any bar or restaurant. All you need is a cloth napkin to achieve this funky trick. Bet someone that they will not be able to tie a napkin in a knot without crossing their arms or lifting their fingers. Those suckers will tie themselves in a pretzel before they are able to accomplish this and you can laugh and laugh because you know the secret!

How To: Carve a roasted chicken for easier eating

Kat Malone shows how to carve a roasted chicken. Once you remove the twine, set the chicken on its side on the cutting board. To accomplish this, use a chefs fork and a sturdy knife. Stick the fork at the point where the thigh and drumstick meet. You'll then pull on the fork and cut around the leg. Twist your wrist and the leg should fall out of the socket. Cutting through the joint of the leg will seperate the drumstick and thigh. Repeat the same steps on the other side. turning the chicken ...

How To: Easily create a speed dial for contacts on the Android

One of the great things about cell phones is the fact that they can accomplish so much in just a small piece of hardware. If you need help figuring out how much to tip, where a certain person lives and their contact informaiton, and even how many miles you have been walking since you left your home. Yup some cell phones can do all of that and more. In this tutoral though, you'll find out more about a basic, easy to use system that has been around for some time. The speed dial.

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: 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: Design a wintery holiday centerpiece for your table

In this video the author describes how to design a centerpiece for your table with a holiday or winter type theme. The author uses different types of foliage including cedar, pine, sugar pine cones, roses, and twigs to accomplish this masterpiece. This is a step-by-step video and is easy to follow along with. The author starts with floral foam and explains the process from start to finish with enthusiasm and detail. The finished product would decorate a large table for a party or gathering an...

How To: Do a parkour rail balance

This is how you can learn how to easily accomplish a parkour rail balance. When you first start out, use a rail that is close to the ground; you will probably fall several times while practicing. As you get more used to it you can use rails that are higher. Start out by walking across the rail slowly; keep your feet forward or curved, whichever you prefer. Eventually you will get faster and be able to jump from rail to rail. Just keep practicing and you will get the hang of it quickly.