Get a handle on controller disassembly with this free video tutorial. This brief how-to will guide you through the process of disassembling a Microsoft Xbox 360 console controller quickly and efficiently without damaging any of the components, the first necessary step of any successful repair (or custom paint job, for that matter). This tutorial will also be of use to those who wish to learn more about the guts of their Xbox controllers without actually disassembling their units.
Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.
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 254th installment in their series of digital spreadsheet magic tricks, you'll learn how to do contribution margin income statement analysis across various units using a one-variable data table.
One of the hardest things in figure drawing to master is proportion, but in this video Sheldon shows you how to the draw a figure proportionally. Using the head size as unit of measure, Sheldon will teach how many heads there are in a human figure drawing, a cartoon figure drawing and even in a super hero drawing. After watching this video you will have a firm grasp on the skills needed to draw a figure proportionally every time you put pencil to paper.
This video demonstrates a project taken from "Make" magazine. Viewers will learn how to modify an ordinary computer mouse with a vibration unit for use with PC games, similar to the rumble controllers sold for video-game consoles, to make gaming more fun.
In this instructional DJ video, take a look at the back of the Gemini CDM-3600 unit to learn how to use the inputs and outputs. This video is ideally for beginners who are just starting off as DJs and need some advice on the various outlets. Learn how to use the back of a Gemini CDM-3600 by watching this DJ tutorial video.
This metalsmithing video segment shows how to speed weave Byzantine chainmail.The Byzantine chain is a popular metal weave pattern for supple and flexible necklaces, bracelets, and other pieces of jewelry. This video assumes you know how to construct 2x2 chainmail units.
Want to take flash photos with your Diana+, but don't want to drop $100 on a DianaF+? Here's how you take flash photos with your standard Diana+. You can use a simple two battery flash unit and flash bracket to hold the flash to the camera. Note well: There's a trick to making this camera modification work, so pay attention to this instructional photography video.
Accidents will happen. This brief how-to will guide you through the process of removing the LCD on your 15" MacBook Pro's LCD from the bottom pan without damaging any of the components, the first necessary step of any successful repair. This tutorial will also be of use to those who wish to learn more about the guts of their MacBooks without actually disassembling their units.
Accidents will happen. This brief how-to will guide you through the process of removing your 15" MacBook Pro's CD/DVD SuperDrive both quickly and efficiently without damaging any of the components, the first necessary step of any successful repair. This tutorial will also be of use to those who wish to learn more about the guts of their MacBooks without actually disassembling their units.
Interested in installing a new hard drive (or, less happily, the victim of drive failure)? This brief how-to will guide you through the process of removing the hard drive from your 15" MacBook Pro without damaging your computer. This tutorial will also be of use to those who wish to learn more about the guts of their MacBooks without actually disassembling their units. Take a look.
If you have an older battery charger and it works apart from having worn out terminals or frayed wiring, don't throw it away. Overhaul it with new wires, a plug and clip leads. This costs about $15 at the most instead of the $50 for a new unit. So watch this automotive repair video and learn how to overhaul a car battery charger and keep your car running for less!
Charles Esseltine shows you how to fold a star out of paper. Diagrams can be found on this website: http://web.archive.org/web/20060330001742/www.anniefolds.com/TSUstepfolds.htm
This model is a modular origami 6 unit ball. Diagrams on Yurii and Katrin Shumakov's website: http://library.thinkquest.org/27152/towns/oriville/oriver/practice/05.htm
This 6 unit modular origami design should look like 3 intersecting diamonds. Fold each piece and then assemble as shown.
This modular origami ball requires thirty (30) units. After folding all the pieces, assemble them as shown to make a spiked ball.
With 12 of these units you can origami an octahedron or with 30 you can origami an icosahedron like this. This is modular origami.
This video provides instrucion on how to make an origami kusudama - or a modular origami ball. This model requires 30 units.
Learn how to make this Great Stellated Dodecahedron from "Tornillo" units. Speak Spanish? Then check out Paolo Bascetta's accompanying diagram:
Make a Japanese kusudama, or as it is more commonly known a 3D paper medicine ball. It resembles origami but much more fun. This modular origami model requires 20 units.
This video shows you how to make summer sausage, highlighting the stuffing and cooking operations. The mixing of the meat and vacuum packing is not included. In this version, I use a domestic (residential) oven rather than the wood fired masonry unit in the back yard.
Learn how to replace you computer's central processing unit (CPU). Includes tips on buying a new CPU and installing it.
These are step-by-step instructions on how to fold a Japanese paper ball (Kusudama). These are very cool origami decorations and can be hung all around the house, and these paper balls are also an excellent decorations or Christmas tree ornaments. This modular origami model requires 34 - 46 units.
This video is specifically for the C530 Slate cell phone from AT&T, though this procedure will probably work on similar models of phone. You can hack, or jailbreak, your phone to allow you to use third party apps or switch to a different service provider. You will need a non-AT&T sim card for this hack to work (T Mobile is shown in the video). Then turn it on, hit the unlock key and then enter in your unlock code. Make sure you get it right!
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.
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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
It's really tempting to put every app and widget you can think of on your Android cell phone's home screen, but eventually you'll have a hard time finding anything in the clutter. That's where folders come in. Creating a folder on your home screen makes life a little easier, and a little more organized. Think about dragging all your games into a one consolidated folder. CNET shows you how to make a folder, how to rename it, and how to manage it on your Android smartphone.
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 order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.
Want to give your new Android enable mobile device a personal touch? Well, your phone comes preloaded with wallpapers that you can use, and you just have to find the right one that fits your personality. Adding the wallpaper to your phone is easy. Go to gallery, flip through the stock wallpapers, and select the one you want by clicking "select" — Best Buy has answers. The Best Buy Mobile team explains how simple it is to set the wallpaper on an Android cell phone.
This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...
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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
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.
In this tutorial, we learn how to save a cell phone after dropping it into water. First, dry the phone off as soon as it gets wet then remove the battery and SIM card if you have one. Now, dry the crevices and all small areas of the phone with a towel. Once you have dried the phone out completely, let it set for over a day and it should work again. If it still doesn't work, charge the phone without the battery in it. If the phone works, you just need a new battery, not a new phone.
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
What is that smell? If you've got large gauge ear gauges, it's probably dead skin and buildup in your ear lobes.
