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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
In this Electronics video tutorial you will learn how to build and use a tinyCylon kit. The kit contains a battery pack, a PCB, LEDs, resistor, a momentary switch and a screw. The long end of the LEDs will go into the square shaped contacts. Don’t push the LEDs right up to the board. Instead, use some poster putty to hold the LEDs standing upright so that they can be bent later on. Fix all the LEDs in this manner and solder them on the other side. Then solder the leads of the battery pack. ...
In this video, we learn how to fix and iPod touch LCD screen that is too dim/won't light up. First, open up the back case of the device and take out the battery. Make sure not to disconnect the battery that is attached to the battery. After this, take a tool, which you can purchase at ifix, and remove the LCD connection button, then snap it back on. This is located at the bottom left hand side and is black. Replace your battery and case your back light will now be back up, without having to p...
In this video tutorial, viewers learn how to reset a frozen iPod Touch after jailbreaking. iPod Touch is a portable media player, personal digital assistant, and Wi-Fi mobile platform. Begin by holding in the Sleep and Home button at the same time. Hold it until a black screen appears. After it appears, let go of the buttons immediately. Now connect you iPod Touch to your computer. Then open i-Tunes and Restore the iPod Touch. Now users are able to try to jailbreak their iPod Touch once again...
Is your digital SLR camera creating an unintentional "Jello effect"? Well, this is caused by a rolling shutter, which can be fixed in Adobe After Effects. This tutorial serves to help you eliminate your problems on your D-SLR caused by the CMOS's "rolling shutter".
This video shows you how to use an aspect of Photoshop so that you can fix snapshot pictures that may have gotten an exposure level you did not want. This quick and easy tutorial video shows you how easy it is to adjust the layers in the screen. With different adjustment tricks for the layers to use if you are unsatisfied with the results you are getting. Each video will take moments to do and once saved you can move on to edit any other photos that did not come out with exposures that you wa...
This how-to video is about how to color correct photos using Photoshop levels.
You're driving down the road and all of a sudden SNAP—your alternator belt just snapped. You're losing power fast and need a quick fix, but there's no mechanic in sight. If you have a woman in the car, you may have a simple quick belt replacement—pantyhose. That's right, some simple pantyhose can act as a makeshift alternator belt until you find a proper solution, i.e. a real alternator belt. Check out this video to see how it's done!
The first part is the trailer for a fixie feature from track bike legionnaires, MASH SF. The second is a video by Bre Pettis. This instructional DIY video shows you how to build a single speed fixed-gear or 'fixie' bicycle. Using old parts, build a bicycle effective for flat grounds. It looks like a lot of work, but if you have the tools, it should be relatively inexpensive. Learn aside Bre Pettis and Make Magazine.
Watch our video for step-by-step instructions showing you how to replace/install a broken power door lock in the front of a Chevy Trailblazer or GMC Envoy (2002-2006). We'll show you an easy way to fix this common problem with simple hand tools, which any do-it-yourself mechanic can perform. Save time and money by fixing the issue yourself.
Plumbing is best left to plumbers. The results of DIY plumbing are almost always disastrous. However, with the help of this video, you can do a little self-plumbing by diagnosing the cause of your noisy pipes. The video also explains, in general terms, how to fix each type of noisy pipe.
As a mechanic, you can't get paid until you fix it, and you can't fix it until you diagnose it, which means a quick diagnosis means a quick fix which means a quick payout. If life was always this easy! This automotive video will show you how to troubleshoot and diagnose a 1999 Mercury Village, 3.3L, with 150,000 miles on it. The chief complaint is the CEL (check engine light) comes on and it runs like it has a misfire. It feels like a steady consistent misfire, which is code P0304 (Cylinder #...
Need help figuring out how to fix a No-Disk Exception Processing error on a Windows PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over two minutes. For more information, including detailed, step-by-step instructions, take a look.
Looking for instructions on how to fix a missing or corrupt hal.dll error on a Windows PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over five minutes. For more information, including step-by-step instructions, take a look.
Need help figuring out how troubleshoot a hard disk not found boot-up error on a Windows PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over ten minutes. For more information, including step-by-step instructions, and to get started fixing your own desktop of laptop computer, take a look.
If you're a Final Fantasy VII fan, this video will excite you. Learn how to install a custom graphic driver to play Final Fantasy 7 PC. This is an improvement for the game that makes it playing more enjoyable on your display. It fixes some bugs and glitches and allows you to change the resolution of the game. It also lets you play in windowed mode.
Do you have stacks of scratched up DVDs that will no longer play? Have no fear. In this video, learn how to clean and fix a scratched DVD in minutes.
This works well for short hair. First of all you need to have artificial hair extensions of golden color or any other color of your choice. You also need a glue gun and hair clips to hold these extensions to your real hair. You can choose to fix these extensions on the left side of your head, just below the hair. Lift your hair at the left sides, add some glue using the glue gun and place the extension. Now add clips to fix it on your hair. Carefully conceal it below your real hair. Take care...
Is your Mac running slow? If yes, then the instructor in this video shows just how to diagnose and fix it. It is not an uncommon problem that a Mac begins to get slow with time. Though there are a million different things that can slow down a computer and it is never easy to pin point the problem, there are a few things that you can do to try and get it fixed. The first thing that you should do is check the free space in the hard disk drive. If it is less than 10 percent then you better start...
In this video, harrymedan offers a do-it-yourself remedy to fix an iPod that has the "sad face" warning screen on it. As you follow along, he explains all the tools and supplies you will need to get started on this project. He demonstrates how to force the iPod into disk mode, leading you through, step by step. Once you achieve this he tells you how to connect the iPod to your computer and "Restore" the iPod back to factory settings, which usually fixes the problem.
AHHHHH!!! The Red Ring of Death! Fortunately there's a solution. This straightforward and incredibly helpful how to video will breathe some life into your XBox 360.
Is a squeaky door in your house bringing you down, and making the house seem haunted? Well, it's a simple solution to fix. As Phillips Woodworking shows us, it's merely a matter of greasing the hinges. Once you get some WD-40 and apply it correctly, your door will make no more noises.
Say GoodBye To Those annoying tiny dots on your LCD TV, display, computer screen or laptop display. It is all possible, in a single click.
A great way to rack your brain is by trying to solve a puzzle, so grab your puzzle and get solving! If you need a little help, this video tutorial will show you how to fix the Square One puzzle. The Square-1 is one of the most baffling puzzles on the market today, so make sure your up to speed on solving it, and fixing it. Just beware and pop your Square-One at your own risk; it's not an easy task to put back together.
Getting the pesky error 80108351 on your Playstation portable? Take a look at this tutorial and learn how to fix this theme error on your PSP.
This is an easy, up close, demonstration of yet another way to unravel your knitting when you make a mistake. By Judy Graham, Knitter to the Stars, who's knits have appeared in movies, TV, and concerts for over 30 years and who has been hand knitting for over 50 years. Watch this video knitting tutorial and pick up another simple way to unravel yarn to fix a knitting mistake.
This tutorial shows you how to fix scaling issues you may get while trying to rig a character in Zbrush.
The shutdown button in Windows Vista doesn't actually shut down your computer. Watch this helpful computer tutorial video to learn how to fix your Vista power button so it does shut down your computer.
This how to video shows you how to perform some simple fixes to common problems that you might have with some of the cabinets around your house. This tutorial gives great solutions for those pesky cabinet doors.
Tired of adjusting your bi-fold door because it wont close or its unaligned? This how to video will show you a quick fix for those annoying bi-fold doors in your home.
A super quick and easy fix for reflections in Christmas ball ornaments using Photoshop.
Tim Carter of AsktheBuilder.com demonstrates a really simple way to fix a loose door knob handle.
Check out this video to learn how to fix a clogged shower or tub drain. This is an alternative to going to the store and buying chemicals.
This will show you how to fix any music or sound problems within Mugen - the custom PC game engine. Plugins to get:
Have your drawers dropped in your RV? If so it could be a simple problem to fix. Professor of RVing, Jim Twamley shows you how to fix a broken Face Frame Drawer Socket.
Watch this step-by-step essential guide to fixing creaky floorboards. Learn what equipment to use.
Fix up a dull sky by replacing it with a new one!! This Photoshop tutorial shows you how.
Your jog wheels don't move smoothly? Here's how to fix that with ease. Quick and simple! Then you're on your way to DJ-ing success.
Mechanic and Emmy Award winning car talk host Scotty Kilmer shows how you can fix your own flat tire.
Watch this video to learn how to fix a door latch.
