Entering Crowded Search Results

How To: Customize sneakers in Photoshop before you paint them

Basketball shoes are expensive, so if you want to use something like Dunks (a big, beautiful white leather canvas) for a custom painted sneaker project you better know what you want to do before you start. Enter Photoshop. This video will teach you how to use Photoshop to plan your kick design out before you paint, helping ensure that you kicks come out the way you want.

How To: Understand aperture values in photography

If you're just getting started in photography or if you're looking to learn a little bit more about your camera, then you may have run into the term "Aperture" or "Aperture Values", or those weird number numbers. Aperture is in the lens of your camera and determines how much light enters into the lens itself and helps to determine your focal length. In this video you will get a small lesson on what Aperture is, and how to calculate focal length and aperture values.

How To: Average times entered as text 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Make a delicious meat lovers wrap

Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like rich person and make these delicious meat lover wraps to enjoy any night of week. Don't be afraid to enter the kitchen after watching this video you'll be eager to have dinner guest.

How To: Find your IP address with the Command prompt

In this video we learn how to find your IP address with the Command prompt. First, go to the start menu on your desktop. Then, find the run box and type in "cmd". After this, hit "enter" and then a black command prompt will show up on your screen. Next, type in "ip config" and then hit the enter button again. Now, a list of information will appear on the black screen. Look down the list to find the IP address listed on the page. Once you have this, you should write down your IP address and th...

How To: Reformat your computer step by step

This video tutorial belongs to the Computers & Programming category which is going to show you how to reformat your computer step by step. Go to BIOS by restarting your computer. Go to BOOT menu, select CD/DVD ROM and press f10 to save and exit. Now insert your operating system CD, don't let it run, restart your computer again and keep tapping f8. When the set up page is displayed, press 'enter' to set up Windows XP. Select your partition and press D to delete. Then press L to continue deleti...

How To: Authorize or de-authorize a computer on iTunes

In this video from wadeputtii we learn how to authorize or de-authorize a computer on iTunes. Go to iTunes, sign into your account. Now click on Share and you will see Authorize Computer or Deauthorize Computer. If you want to authorize, click on that and enter your apple user email address and password. Then click authorize. If you have a new computer or you want to prevent someone else from using your account on your computer and you want to deauthorize your old computer, go to Share and De...

How To: Change your NAT type to open on your PS3

FROMAN1115 teaches you how to change your NAT type to Open on your PlayStation 3. On the PlayStation 3, go to Settings-Network Settings-Settings and Connection Status List and write down your IP. Go to your PC and start your internet browser. Type in 192.168.1.1. This will bring up the router settings page. Go to Applications and games and then DMZ. Check the first box that says Enabled. Enter your IP address below and click ok. Your settings have been saved and you can enter a new internet m...

How To: Open your NAT for use with online games on Xbox Live

Open your internet browser, type in the address bar 192.168.1.1 and enter your user name and password to access. Look in the right and search for Port Forwarding / Port Triggering. Click on Add Custom Service. Type a name to the service, like XBox Live, now access HushedCasket and scroll down to see the ports you need to open. Go back to the setting and select UDP in Service Type. Put 88 in Starting Port and Ending Port. Go to your XBox and enter in System Settings, go down to Network Setting...

How To: Delete an old Yahoo account

Learn how to delete your old Yahoo account from this video in simple steps. First open your web browser on your computer and go to the Yahoo home page. Now sign into your account using your username and password. Now copy and paste this link "http://edit.yahoo.com/config/ delete_user" in your address bar. Enter your password to confirm the deletion of your account. Finally enter the code to confirm and delete your account.

How to Train Your Python: Part 4, Basic User Input

In the last iteration of how to train your python, we covered basic string manipulation and how we can use it to better evaluate user input. So, today we'll be covering how to take user input. User input is very important to scripting. How can we do what the user says if we can't tell what the user wants? There are multiple ways to take input, we can give the user a prompt and take input from them directly, or we could use flags/switches, and take their input before the script is even execute...

How To: Show Someone a Photo on Your iPhone Without Them Swiping Through All of Your Pics

You hand your iPhone to a friend to show them a picture. What happens? They swipe. Left, right, it doesn't matter. You don't remember what lies in either direction of the photo in question, and you don't want anything compromising exposed to the unassuming viewer. Luckily, Apple includes a safety net in iOS to prevent this scenario from ever happening, so long as you set it up ahead of time.