Need help figuring out how to convert between the assorted metric units? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to convert betw...
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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...
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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.
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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selectively delete. Specifically, you'll se how to delete the cell contents only, formatting only, the entire cell, or formatting and content together.
If you haven't gotten the new Splinter Cell video game yet, you probably still have the demo version, so learn some tips and tricks, which can also be applied to the actual game on the Xbox 360. Watch this video walkthrough of the Splinter Cell: Conviction Demo. Join Sam Fisher as you make your way through and infiltrate the warehouse. This video is full of information about the new gameplay. The demo is super short, but it's a good place to start before playing the new Tom Clancy game. Pay a...
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!
What if you're in the middle of a call before you enter your car? Ford's new SYNC system has a solution. As long as your cell phone is paired with SYNC, you can continue the conversation uninterrupted. See how to use hands free calling with Ford SYNC.
See how to make a portable spy scope cell phone camera with KipKay and MAKE Magazine! Find out how to use a cellphone camera for espionage that captures long-distance secret activities! Kipkay loves his spy gadgets! This portable cell phone camera spy scope is the perfect way to spy on your neighbors!
Plunk! When your mobile device takes a swan dive, act fast with this Tech Triage first-aid guide to cell phone revival.
Dr. Kiki, from popSiren, solves the age old cellphone reception question. The Rad Scientist has moved into a cell reception twilight zone. Lucky for her, she's well-versed in antenna-making!
The first video introduces the basic electrical quantities of charge, current, voltage, and resistance. The concept of quantities and units is explained. The units of Coulombs, Volts, Amperes, and Ohms are described. The three basic formulas of Ohm's Law (E=IR, I=E/R and R=E/I) are also introduced.
This video provides instruction on how to make "buckyballs" (dodecahedron, truncated icosahedron) from "PHiZZ" units. It looks complicated but it is really easy to make.
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great features in this how-to video.
The Nintendo DS Lite is the best portable gaming system ever, and you want to make sure yours works forever. If you find that your unit won't charge or turn on and plugging it in makes the charge light flash, watch this video for a guide to taking the DS Lite apart and jumping the fuses with a conductive pen like a CircuitWriter so it will power on once again.
Looking for a primer on how to remove the superdrive and power supply from your Mac Pro? This brief how-to will guide you through the process, the first necessary step of any upgrade or repair to either of the aforementioned parts. This tutorial will also be of use to those who wish to learn more about the guts of their Mac Pros without actually disassembling their units.
Fixing to remove the logic board from your Mac Pro? This brief how-to will guide you through the process, the first necessary step of any upgrade or repair. This tutorial will also be of use to those who wish to learn more about the guts of their Mac Pros without actually disassembling their units.
Want to know how to remove the fans, heat sink and processor from your Mac Pro? This brief how-to will guide you through the process, the first necessary step of any upgrade or repair to either of the aforementioned parts. This tutorial will also be of use to those who wish to learn more about the guts of their Mac Pros without actually disassembling their units.
Interested to know how to remove the video card and RAM riser boards from your Apple Mac Pro? This brief how-to will guide you through the process, the first necessary step of any upgrade or repair to either of the aforementioned parts. This tutorial will also be of use to those who wish to learn more about the guts of their Mac Pros without actually disassembling their units.
If something has happened to your Nintendo DS Lite case and you want to replace it or if you want to put a custom case on your unit, this video will show you how to do it. You can order all sorts of custom cases off the internet or stock ones form Nintendo.
Accidents will happen. This brief how-to will guide you through the process of removing the speaker assembly from an Apple iPad 3G tablet computer 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 iPads without actually disassembling their units.
Accidents will happen. This brief how-to will guide you through the process of removing the logic board and micro SIM card from an Apple iPad 3G tablet computer 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 iPads without actually disassembling their units.
Accidents will happen. This brief how-to will guide you through the process of removing the I/O (or IO) cable from an Apple iPad 3G tablet computer 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 iPads without actually disassembling their units.
Accidents will happen. This brief how-to will guide you through the process of removing the LCD display and glass assembly from an Apple iPad 3g tablet computer 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 iPads without actually disassembling their units.
Accidents will happen. This brief how-to will guide you through the process of opening up an Apple iPad 3G tablet computer 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 iPads without actually disassembling their units.
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.
Malaria is a massive worldwide health problem. The Centers for Disease Control and Prevention estimate that 212 million cases of malaria occurred worldwide in 2015 and 429,000 of the infected people died.
People who have heart disease get shingles more often than others, and the reason has eluded scientists since they first discovered the link. A new study has found a connection, and it lies in a defective white cell with a sweet tooth.
Even before we are born, our immune system is hard at work. New research shows how the developing fetal immune system takes advantage of the time and opportunity of gestation — in the presence of mom's cells and tissues — to develop a sense of self.
In a move that confirms previous speculation, Apple has placed a large OLED display order from Samsung for its next iPhone. At 70 million display units, the order is a large one to be sure, but when stacked against previous iPhone sales, it's no wonder the rumors say there won't be enough 2017 iPhones to meet demand.
When the mosquito that carries the malaria parasite (Plasmodium falciparum) bites someone, the parasite must travel to the liver where it undergoes part of its lifecycle before infecting red blood cells and spreading to its next host. Until now, the first step of how the parasite gets to the liver hasn't been clear.
Access your favorite FM radio station with your Motorola Q! This tutorial also shows you how to load your favorite music onto your cell phone, and then choose segments to turn into ringtones, which you can personalize further by assigning them to individual callers.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...
This CNET tip gives you fast and easy access to those locations you frequent most on the map, like your home or workplace. Getting instant directions to those favorite places doesn't get any easier. Navigation on your Android cell phone makes life a little easier. This video will show you how to create these map shortcuts on the Motorola Droid, but it can be used on any Android phone with 2.0 firmware and GPS.
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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how toe AGGREGATE function cannot handle 3-D cell references.
In this tutorial, we learn how to use task types in MS Project 2007. First, open up the form view of all the different tasks you have. Now, look at the unit task type and see if it's effort driven or fixed units. Now, change what you want the task type to be and then click on the next button. Assign a second resource if you need to, then change the duration if you need to as well. Continue to change the task types depending on what durations you have then make sure to save this. Double check ...
In this tutorial, we learn how to find the area of a rectangle. First, you will need to know the formula, which is length times width. So, first find the length and width of the rectangle. After this, you will multiply the length and width together. Next, write down the units so you don't forget. When you are finished, you will know the area in just a few easy steps. This is a basic formula that is easy to understand and can be done quickly. When you are finished finding this, make sure you w...
This clip presents a detailed overview of how to create Cell Renders in C4D to analyze the structure of your models. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
