Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Is the battery life on your Ipod diminishing? Watch this video as the folks at Repairs Universe show you how to replace the battery on your 1st generation Ipod. First you need some tools to pry open your Ipod. Flathead screwdrivers and razors work well. Take the razor and slowly inch your way around the opening to pry it open. Then take off the back cover. The battery is black and has a serial number and the Apple symbol on it. Don't confuse this with your hard drive. Watch the video for the ...
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...
This how-to video is about how to remove a hickey with a battery. This is useful if you want to hide it from your boss, your mom, or even your girlfriend (shame on you, really).
Hack Restaurant City (06/02/09): Waiters serve faster
What happens when you need to build a fire, but you forgot your matches and lighter? What if you don't know the fire-plow method, the bow and drill method, or even the flint and steel method (not that you would have flint, because you forgot your lighter)?
Using only vinegar and a few simple materials, it is possible to construct a working battery. This science video tutorial explains how to construct and use a battery like this to power a calculator. A good science project as part of an introductory electricity course. This project can be used as a science fair project or merely for fun. If you've ever wanted to make your own battery, know is the time, this science experiment will show you how.
Is the battery in your Apple iPod Nano just not up to par? Well, maybe it's time you replaced it with a high capacity battery. These detailed instructions will get you through the difficult, but easy process of doing so. Make sure you observe static safe precautions. Ground yourself before opening your iPod and don't walk around while performing this upgrade. This video tutorial will guide you on how to install a high cap battery in an iPod Nano.
Is the battery in your Apple iPod just not up to par? Well, maybe it's time you replaced it with a high capacity battery. These detailed instructions will get you through the difficult, but easy process of doing so. Make sure you observe static safe precautions. Ground yourself before opening your iPod and don't walk around while performing this upgrade. This video tutorial will guide you on how to install a high cap battery in a 4th Generation iPod Photo.
Is the battery in your Apple iPod Mini just not up to par? Well, maybe it's time you replaced it with a high capacity battery. These detailed instructions will get you through the difficult, but easy process of doing so. Make sure you observe static safe precautions. Ground yourself before opening your iPod and don't walk around while performing this upgrade. This video tutorial will guide you on how to install a high cap battery in an iPod Mini.
Is the battery in your Apple iPod just not up to par? Well, maybe it's time you replaced it with a high capacity battery. These detailed instructions will get you through the difficult, but easy process of doing so. Make sure you observe static safe precautions. Ground yourself before opening your iPod and don't walk around while performing this upgrade. This video tutorial will guide you on how to install a high cap battery in a 1st Generation iPod.
Well, Apple may not want you to do it but you just can't help yourself, you want to get inside that beautiful iPhone 4 and see what's inside. This clear, detailed guide shows how to remove the back panel, safely get inside your iPhone and remove your battery as well.
When you think of robots, you probably think of things that have more than three parts. Not this robot! If you want a robotics project to try that doesn't require an MIT degree, watch this video for instructions on how to build a 'Dizzy Robot' out of only some thin tin, a pager motor, a button cell battery, and this template.
The new Unibody MacBook Pro's are a little different in design than the older MacBooks, so it may be a little confusing on how to see the innards of the laptop. Watch this to see how to remove the hard drive and battery of the MacBook Pro 17" Unibody.
Know someone that's terrified of rats? This twitching dead rat prank is perfect for you then. Great for Halloween or April Fool's Day. You just need a stuffed rat, a rattrap, vibration motor, AAA battery holder with batteries, and a piece of straw. Oh, and fake blood, too!
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
Take your old electronics and make them scream with glitchy goodness. This an extremely easy project and makes a great project for first-time solderers. Circuit bending involves taking electronic devices that make multiple sounds and wiring in switches to set off glitches or loops. Using an out-of-tune toy, the first part of this video series demonstrates how to apply a basic pitch bend using a potentiometer. In the second part, you'll learn how to bend the same toy by applying body contact. ...
Save tons of money by building your own LED pen that works with a multitouch smart board / whiteboard. You'll also need a WiiMote (Wii Remote) to use in conjunction with your homemade LED pens that you'll be making in this video. To get started with this awesome project, you'll need a 1.5 volt tolerant infrared LED, momentary push button switch, AA-battery case holder, one AA battery, containment unit (Sharpie marker or highlighter body), pliers, superglue, thin copper wire and a soldering iron.
This video will show you how to make a lemon battery. You use a copper penny and a zinc coated nail to create a circuit.
Interested in getting 1.5-volt button cell batteries for pennies on the dollar? Kip Kay, of Make Magazine, is here to show you how. The trick is to buy Energizer A23s, each of which contains 8 1.5-volt button cells. For detailed instructions on this straightforward money-saving hack, take a look!
In this video tutorial you will see how to Pandora a PSP slim battery. You will need a knife for this. When the normal battery is in the PSP, when you switch it on, it will log on just normal. Now remove the battery, put the knife in the joint of the battery case and move it up and down and slit open the case. Then pry it open and remove one half of the case. Then flip open the flap on the battery and cut off one connection on the battery as demonstrated in the video. Now put the battery back...
For most automotive applications a battery needs to supply a lot of current for a short period of time to turn over the engine and get the car started. With the engine running, the car's alternator produces all the power the car needs. Thin plates inside a starting battery increase the surface area and produce this relative burst of energy. Thicker plates in a deep cycle battery provide a steady amount of current over a long period of time. Deep cycle batteries excel in reserve capacity (RC),...
Harley Davidson is one of the most recognizable motorcycles in the world. Learn how to change a battery in a Harley Davidson from a motorcycle specialist in this free motorcycle video series.
With iOS 12, Apple is making up for mistakes from the past, with iPhone batteries being no exception. The new update builds upon both battery health and performance throttling tools introduced in iOS 11.3 by offering users more information about your iPhone's battery usage than ever before.
One odd change found in the Android Pie update is that the "Battery" menu no longer lets you see apps that are draining your battery, nor gives access to usage details. However, one quick menu tweak will bring the Battery menu back in line with Android Oreo's, only there's a hidden setting you have to unlock first.
It seems Apple has followed through on their promise. After the disastrous battery slowdown scandal in December, the iPhone maker has finally pushed new battery health information and controls to iOS 11.3. Now, if you have an affected battery, you can disable performance throttling to keep your iPhone running as fast as possible.
Apple's MacBook line of laptops is quite famous for their extensive battery life, thanks to various technologies that Apple has utilized. However, all things must pass, and over time your MacBook's battery will degrade. Certain use scenarios can accelerate the degradation of the battery—from excessive usage to high temperatures to overloading the system—and this can all lead to the untimely obliteration of your battery.
Sony Corp. is working on new battery technology that the company says would have a 40% longer life than a lithium-ion battery of the same size. Sony is planning to have the higher-capacity batteries on the market around 2020.
Not all batteries are created equal, but one thing's for sure—they all lose capacity over time. Thankfully, the advanced lithium-ion batteries in your MacBook and iPhone are meant to last for several years before they begin to lose their overall charge capacity.
The trick in the video is that the magnets are made of a conducting material and they connect the battery terminals to the copper wire, so the battery, magnets and copper wire make a circuit that generates a magnet field just in the vicinity of the battery. The geometry means the two magnets are automatically at the ends of the generated magnetic field, where the field is divergent, so a force is exerted on the magnets.
The new iPhone 6 and 6 Plus are supposed to last a lot longer in your pocket with improved battery life, but that doesn't mean that iOS 8 will be that friendly on your older iPhone model. All of those awesome new features could be killing your battery, but with some simple tweaking, your battery life concerns will be a mere afterthought.
When it comes to squeezing as much battery life as possible out of our smartphones, most people aim for software solutions, or ones that can otherwise be easily managed right from the touchscreen.
There are a lot of things your Samsung Galaxy Note 2 can do straight out of the box, but there's also a ton of things it can't, or simply could be better at. That's why most of us end up rooting—to enhance the mobile experience.
"What is dead may never die." That's easily one of the best lines (and episode title) from HBO's Game of Thrones series. While the saying may ring true for the Ironborn, it's not quite as catchy when it comes to batteries.
For most people, the battery life on a DSLR is more than sufficient, but if you want to do a really long exposure or time-lapse, one charge might not last long enough to get the shot you want. You can always connect it to an extension cord to charge while you shoot, but that can be really annoying to work around.
Android devices are known for their USB and Wi-Fi tethering abilities—rooted or unrooted—which comes in handy for those that travel and need internet on their laptops in areas that don't have any Wi-Fi networks available, but have a strong cellular signal.
Tired of worrying about where you can get your next charge? Watch this video to learn how to save your Android phone's battery life. Don't let your phone charger become a ball and chain, use the techniques shown here to conserve your Android device's battery life.
Learn about the history and technology of batteries in this informative video, and learn how to make your own voltaic cells at home, along with other scientific experiments. Jeri Ellsworth demonstrates how and provides several informative facts about the history and technology about the battery.
If you've ever left the lights on in your car for a long time or just have a bad alternator, then you know all too well the pain of a dead battery. This video will teach you how to push start a dead battery car, which can often restore it for long enough to get you to the shop.
In this video, we learn how to build a portable personal heater. This is a great weekend project that is easy to make and will keep you warm during a freezing winter. You will need: two double a batteries, charger, twin double a battery charger, winding wire, and balsa wood. First, cut the wood the size of the battery holder and cut it out. Now, reel off 30 ft of winding wire and hold down with duct tape. Wind the wire around the piece of wood and tape down the other end of the wire. Scrape o...
