While the iPhone 4G claims to have vastly improved battery life, some are still not impressed. If you are not convinced of your battery's longevity and wish to replace it, check out this clip. Apple won't do this for you and a repair shop will be pricey, but if you follow these instructions you can do it yourself. So, get ready to operate on your smartphone with this helpful tutorial.
Sometimes a single driver can vastly improve traffic. Drive like a trucker: keep a large space ahead of your car. This can erase the patterns of stop-and-go driving (wipe out the Traffic Waves.) It can also break up the clogged merge-zones at certain highway exit ramps.
Marvel Comics' Veno character is vastly popular. If you're one of Venom's many fans, chances are you've thought about sketching him onto your school notebook. In this video, learn how to draw the comic book character, Venom with help from fantasy artist, Wayne Tully.
This simple video tutorial from Hand-Washing.co.uk will show you how to wash your hands with a WHO (World Health Organization) approved technique. It demonstrates the individual stages of proper hand washing technique in a slow and easy-to-follow way. To avoid sickness and stay healthy, washing your hands is vastly important.
A journey to Africa requires a certain amount of open-mindedness and flexibility to interact with people of a culture vastly different from anything in the West. This video travel-tutorial offers advice for how to relate and get along with the local hosts during a trip to Africa, what to expect, and how to behave when encountering people from a different area of the world.
Did you know that you can actually start selecting gems before the computer has started the timer? This and other useful tips (including a source for you to download a free cheat bar browser add-on) can help you vastly improve your scores on Bejeweled Blitz!
In this tutorial, you will see how to apply a texture, in this case a subtle gradient, to the world background in Blender. Textures can vastly improve the presentation of your model. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-b...
This is an informative video tutorial on how to search graphics, tables and charts using MS Word 2010. The author informs that the earlier MS Word editions had fast and easy search options, but the same feature built into the 2010 edition is vastly improved. One simply has to click the ‘Find’ option at the top right-hand corner and a navigation pane opens on the left-hand side. In the search box, the keyword is typed in and all the instances of that word in the document are highlighted, while...
Your wedding day is vastly important and every bride would like the wedding pictures to reflect how beautiful they felt that day. In this tutorial presented by Smashbox Cosmetics, learn how to get the perfect camera-ready makeup look, perfect for your special occasion.
If you're a certified computer nerd along the lines of NASA scientist Howard from "The Big Bang Theory," then you know how frustrating it can be transferring large amounts of data between an external hard drive or other drive and your main computer, especially when you're in a rush to get experiment data in. Usually this requires mounting the drive into a system or external case first.
The deadlift is a great way to build muscles and strength in the lower half of your body. It is one of the oldest known weight lifting excersises and is vastly used around the fitness world. Even though it is pretty popular, some people still do it incorrectly. This video will show you exactly how to do deadlifts properly.
Android has released a new application called ezNetScan, which is a free app that scans the wireless network you're connected to and gives you a full log of all of the devices connected to that network. This isn't new for smartphone users, let alone Android users. Fing has been around for a while and does practically the same thing that exNetScan does. It gathers information such as the IP and MAC addresses, device vendors, and ISP location. But while Fing is a great program, it does lack a f...
Making a spaceship use its afterburner and escape from the Earth's gravitational pull is tough. Modeling and animating a 3D simulation of the same thing is also hard, although quite as much so. This video series will teach you how to create a 3D model of a flying rocket with an afterburner effect using 3D Studio MAX. At the end you will have a cool little video clip and vastly improved modeling skills.
This video is quite good, but to be fair, one needs more than 10 minutes to really be able to replicate the task. Mounting a taser is somewhat tricky. Watch this tutorial video and make this spud gun or otherwise known as the taser totter! You can use either a taser or a BBQ igniter. For those of you who want to shoot things with potatoes, this video is for you. Bre Pettis of Make Magazine, creates this potato cannon using a stun gun, PVC piping, and hairspray. Watch as he then launches it tw...
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...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.
The technology driving the automated vehicle revolution relies on the car's ability to see and understand the world around it.
See how to find the domain and range of a function implied by a word problem with this free video math lesson. 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 tutor...
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 and Mr. Excel, the 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX formulas.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
Sam Cassell teaches you how to master your mid range shooting by creating space from your dribble and posting up, and lastly how to shoot a clutch jumper. These are NBA Fundamentals from TNT. These skill drills and tips will help you win in the mid range game.
From all the demos we've seen, we know for sure that the marketing world is going to change drastically thanks to Apple's ARKit.
Most virtual and mixed reality headsets offer unnatural controls, making you use awkward movements or physical devices to control the holographic elements in your direct view. This doesn't make a lot of sense because using your hands is more natural, so Manus developed a set of gloves that solves that problem entirely.
If there was anything missing from the notorious YO app, it was Aaron Paul's character from Breaking Bad, Jesse Pinkman, calling me by his signature catch phrase—you know the one.
In this video tutorial, viewers learn how to return the base settings on a HPI 21BB engine. The engine has 3 needles carburetor: high speed, mid-range and low speed. Begin by turning the high speed needle clockwise until it is closed. Then turn it 3 1/2 turn counterclockwise. Then turn the mid-range needle clockwise until it is closed. Then turn it 3 1/4 turn counterclockwise. When adjusting the low range, make sure to hold the mid-rang with a screwdriver to prevent it from turning. Now turn ...
If you own or have access to an auto-ranging or manual-ranging multimeter you can measure several different aspects of circuits, resistors, and the like. For example, you can determine the resistance, voltage, continuity, and current with the multimeter to help you determine the precision of a resistor. This guide will help you learn how to use a multimeter to perform these tasks.
Watch this amazing USB Bluetooth adapter hack from Kipkay. It's easy and effective, plus it will work with other wireless devices, too. Bluetooth works on a 2.4GHz short wavelength radio frequency, but it's only effective over short distances. Well, Kipkay's going to show you how to increase the range by swapping out the antenna in the bluetooth adapter with a HyperGain 2.4GHz high performance antenna.
This tutorial shows you how to easily find an accurate range for your cannons when you're playing Minecraft. Calibrate your cannons just so, to make sure you score a hit every time you fire them. Works with short range and long range cannons both.
Using Excel, sorting large or small pools of data has never been easier. In this Excel tutorial, learn how to sort a range of data in Excel and what steps to do so, from start to finish. Sort totals, percentages, or decimals in a range in descending or acsending order with help from this video.
This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
Studying to be a nurse? Then here is a nursing how-to video that teaches you how to do passive range of motion a patient. Every nurse should know the basics of this technique, follow along and see how easy it is to to exercise a bed ridden patient with passive range of motion. These medical tips are sure to help you pass your nursing exam with flying colors.
Check out this instructional voice lesson that shows you how to sing high notes! This is a video for those who want to learn to sing in a higher range. This information has worked with the instructor since she started singing higher-ranged songs and hopes it does the same for you! Improve your vocal abilities by watching this voice tutorial and practice singing higher range notes!
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...
1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.
If you use After Effects you have become familiar with the Work Area, a range of time that allows you to focus on a specific range of time. You can work exclusively in this area, or work in the larger time of the composition, only to preview or render that area of time when you go out to final. In CINEMA 4D, users can achieve similar results using the Preview Range. This tutorial will show you how.
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
A remote control for a camera? Why not! You won't have to worry about racing the timer function any more! Build a remote control for your digital camera that will take the picture whenever you want. The range is as far as two miles!
This tutorial presents a lesson in generating high-dynamic range images (HDRI) within MAXON C4D. 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, including complete instructions, watch this 3D modeler's guide.
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.
