In this video tutorial, we learn how to use the music player application on a Verizon LG Octane VN530 cell phone. Whether you own a LG Octane phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to use the DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM and REPLACE to extract dates from a cell containing both dates and words.
In this video, we learn how to find the surface area of a cube. Finding the surface area of a cube is something everyone will have to do in math. The easy formula to figure out this is: surface area= side x side x 6. Your first step to figuring out the problem is to find the length of a side. Once you have found this, you will substitute and evaluate the numbers in the equation. After this, write the units in for the problem. You will then come up with the answer of the equation with the unit...
The hydrogen fuel cell has great potential to replace carbon-based fuels in our vehicle fleets and stave off global warming. It's a difficult concept intellectually, so why not make this fun little science experiment to try it out for yourself? Yes, by following these simple instructions you can make a small hydrogen fuel cell at home that will even power some devices!
Jailbreaking isn't just for Apple devices anymore! You can jailbreak your G1 phone as well, which will give you access to third party apps outside the regular market store. After you've connected your phone to your computer, download the software, and you'll have a freshly jailbroken G1 phone! Make sure you have everything backed up before doing the jailbreak.
This clip presents an overview of the general technique required for pairing a mobile phone with a headset via the Bluetooth wireless protocol. For detailed instructions, and to get started pairing your own cell phone with Bluetooth-enabled devices, take a look.
Need a quick primer on how to get started using a Verizon Wireless ZTE Salute cell phone? Whether you're a proud owner of the Verizon ZTE Salute or are merely considering picking one up, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, take a look.
Whether you're a proud owner of the Verizon ZTE Salute cell phone or are merely considering picking one up, you're sure to benefit from this video tutorial, which presents a reasonably thorough overview of the device's various features and functions. For more information, including detailed, step-by-step instructions on how to perform a number of basic tasks, take a look.
Could you use a hand tackling metric conversions? You're in luck. 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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to convert between metric units in basic mathematics.
Need a quick primer on how to get started using a Samsung Intensity II cell phone? Whether you're a proud owner of the Samsung Fascinate Google Android smartphone or are merely considering picking one up, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, take a look.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to effectively use the Terran sniper units Ghosts to effectively dev...
Android cell phones are highly customizable. You can put just about anything on any one of your home screens, but the widgets are an entirely different animal. They can make your home screens more than useful. CNET shows you how to create widgets, use them, and move them about your home screens. You can even put home photos on your Android smartphone's home screens.
Although the Motorola Droid isn't the newest Android cell phone from Verizon Wireless (e.g. Droid X, Droid Incredible), a lot of mobile phone users are reluctant to switch because of its reliability and QWERTY keyboard. If you're one of those users, but haven't quite fully realized the potential of your Motorola Droid, this video straight from Verizon Wireless will give the lowdown on all the features and uses.
In this video tutorial, viewers learn how to reset a garbage disposal. Begin by making sure that the garbage disposal is turned off. Then look for a red button underneath the garbage disposal. This red button is the reset button. If the button is pushed out, push it back in to reset the unit. If it still will not start, look down the sink hole for any obvious obstructions. Another solution is to insert the included wrench into the center of the unit. Then turn it 1/4 - 1/2 turn. This video wi...
In this episode of the Crafty Gemini Show you'll learn some quilting basics and make a small project out of what you learn. You'll be run through some quilting terminology, including what a pieced quilt is, what quilt blocks are, and how to make half-square triangle block units using a super easy method where you can make two blocks at once.
Just like at home, your A/C unit needs its filter to be replaced on a consistent basis. Not doing so will result in a poor performing unit and bad air quality for you and others. The same goes for car A/Cs as well. Not changing it can affect how your A/C will perform. So in this tutorial, you'll be finding out how to replace a BMW E46 A/C cabin filter easily. So check it out and enjoy!
One of the great features in cars nowadays, is the ability ti connect it with your cell phone. With states accepting laws about driving and cell phone use, this feature can be a much needed addition to your vehicle. In this quick and easy tutorial, you'll find out how to setup your bluetooth phone with a 2010 Ford Fusion. Enjoy!
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th installment in said basics series, you'll learn how to use both relative and absolute cell references in MS 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 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.
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 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF function.
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
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 384th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an easy go-to/enter keyboard shortcut trip that will allow you to highlight 1000 (100x100) cells.
True's Owner Maintenance Video Series shows us how to set the defrost time clock on a True freezer, and also how to cut the shipping band on the compressors of all larger freezers. The time clock is behind the grill at the base of the unit, behind a gray box. There are instructions in the inside of the lid for setting the time clock and for setting the defrost settings, and the video goes through the entire process, as well. Next, the man shows how to remove the shipping band protecting the c...
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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.
In this video tutorial, we learn how to navigate and use the basic functions and features of a Verizon LG Touch cell phone. Whether you own a LG Octane Touch phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
How to turn off or restart an Apple iPhone or iPod Touch
New to 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 Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
In this video tutorial, viewers learn how to set up text alerts in Edmodo. Begin by opening your browser and go to the Edmodo website. Select Settings, which is on the top fight side of the page. Now click on the Notifications drop-down menu and select Text Message. Type in your cell phone number one the next blank space. Then select your cell phone provider. Then check the boxes that you wish to be alerted to. Finish by clicking Save Notifications. This video will benefit those viewers who u...
Nine inch storage shelves are spaced and constructed in a practical way. It shows the right screws. This requires a drill some wood. The viewer is shown how to make a good back brace for the shelves. It shows how to make the shelving unit level. You learn the screw head must be flat. You are also shown how to put in a good support for underneath the shelves. It shows the center support being constructed. He shows how to set the shelves up so there is support from all sides and to make the she...
This video describes the ways people hold onto fat. There are three main types of bodies. There are naturally skinny, round with an easy time gaining weight and overly round with a hard time losing weight. Each person is different but in certain body groups there is an easier time to maintain a lean appearance. Fat cells in your body also play a part in you getting fat and staying thin. It is said that all of your fat cells have been fully grown in your puberty years. There are some new studi...
This video teaches us how to perform a magic trick with a deck of cards and a cell phone. The presenter starts by talking about a man named Eddie Carrol, who apparently hates the presenter for revealing these card tricks on YouTube. The presenter leaves his cell phone and a deck of cards and leaves the room. A spectator is chosen to pick one card out of the deck. When the card has been picked the magician's assistant calls the magician and says that the card has been picked. The trick is how ...
This video will demonstrate exactly how to shift a graph on a x,y axis. When shifting a graph on the x axis you will need to replace x with x-h; where h is the variable to shift the graph. No matter how far you need to shift a graph, h is always the number of units you are shifting; shifting up or right is represented as a positive and down or left is negative. Just plug in your units into your equation and you will have your shifted graph.
This is an easy guide on how to load a CD in a 2010 Toyota Prius. On units with standard audio system, insert CD into the slot to load. Press eject button on the left to eject. On units with JBL audio systems, press the load button in the right hand side and wait for the light. Next to the CD port to turn amber until solid green. Now you can insert a CD (if you'd like to load all 6 CDs), press and hold the load button and wait until light turns solid green. Now you can insert the next CD and ...
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
In this tutorial the instructor shows how to convert lengths between different units. He show a two step approach where in the first step he setups a relation between centimeters and meters showing that 100 cm equals 1 meter. Now he writes it down in a fraction form and equates it to another similar centimeter upon meter fraction where the value in meters in unknown. Now he cross multiplies and solves the fractions giving the result of the unknown meters. This video clearly explains how to co...
Call internationally from a cell phone
