Current Search Results

How To: Use the CUMIPMT function for interest in MS Excel

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 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the CUMIPMT function to calculate the cumulative interest on a loan for a 1 year period.

How To: Do a complete loan analysis in MS Excel

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 18th installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the PMT and RATE functions for a complete debt/loan analysis.

How To: Build an Excel table of fraction & percent equivalents

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 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.

How To: Use Excel's built-in SUM, MOD, LCM & PRODUCT functions

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 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.

How To: Make present value calculations in Excel

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 58th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make simple value calculations for the present.

How To: Find a checking account's service charge MS Excel

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 35th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate the service charge for a checking account and see how to create a formula for the balance in a checkbook or checking register.

How To: Work with bank checks in Microsoft Excel

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 34th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with the various elements of bank checks in Microsoft Excel.

How To: Solve an interest loan problem for part/base in Excel

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 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.

How To: Solve trade discount word problems in Microsoft Excel

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 45th installment in his "Business Math" series of free video lessons, you'll learn when to solve a trade discount word problem with Excel.

How To: Find credit for a partial invoice payment in MS Excel

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 47th installment in his "Business Math" series of free video lessons, you'll learn how to determine credit given for partial payment of an invoice.

How To: Do colorful electrolysis

No, colorful electrolysis has got nothing to do with zapping the hair off of a punk rocker's head. Electrolysis of water, according to Wikipedia, is "the decomposition of water (H2O) into oxygen (O2) and hydrogen gas (H2) due to an electric current being passed through the water." In this video, you'll watch in amazement as a young scientist colorful electrolysis to transform ordinary water into a psychedelic display.

How To: Install an OWC Mercury Extreme processor on a G4 Mac

The OWC Mercury Extreme G4 is a fantastic high speed single processor replacement to your current processor. The Mercury Extreme, unlike other processor upgrades, does not use or require 'enabling' utilities to operate. It's the easiest upgrade for your G4 Quicksilver Macintosh to boost its speed. This video tutorial will take you, step by step, through the installation process. For more, take a look!

How To: Build a faraday motor

Build a faraday motor with tips from this how-to video. In the early 1800s, physicist Michael Faraday invented the first device to convert electrical energy into mechanical motion. This is an easily built version of his motor. The magnet sets up a magnetic field, and the electrical current through the screw sets up a separate electromagnetic field around the screw. The two fields react and the result is rotation.

How To: Cook Kentucky fish fry

Many major fast food restaurants currently advertising on television have added hooks to their current run of commercials. The lure is their fish sandwiches. "Kentucky Afield" is getting in on the act. The only difference is that host Tim Farmer hopes you'll catch your own and prepare it with the show's special sweet batter recipe. The flavor is guaranteed to sway even the most skeptical skipper.

How To: Create and use maps on a Nokia C5-03 mobile phone

Learn how to use Ovi Maps on your device. See your current location, find a place, plan a route, and more. The C5 is the first offering in Nokia's new "C" series of mobile phones. It runs on Nokia's Symbian OS and features a 2.2-inch screen and 3.2-megapixel camera. Want more? Search WonderHowTo's sizable collection of C5 video tutorials.

How To: Use probability to predict weather

In this video, we learn how to use probability to predict weather. Probability is the chance of something happening. If you want to know what the weather is going to be like, you can look at the weather report and see what each day is going to do throughout the week. Ask yourself what the probability is that the weather will be cloudy, judging from what the current work week weather is. First, figure out how many days there are total and then find out how many are cloudy versus how many are s...

How To: Prep your walls for wallpaper

In this tutorial, we are shown how to prep your walls for wallpaper, which is very easy! Preparing your walls only takes a few minutes and makes applying the wallpaper easier and look a lot better. You will need: rags, soapy water, wallpaper stripping knife, and sandpaper to do this. First, you need to apply the soapy water to the current wallpaper and then take it off with the stripping knife. Once it's all removed, you need to repair any holes in the wall. Next, sand down the surface of the...

How To: Calculate how much you'll need for retirement in Microsoft Excel

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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.

How To: Make sodium bromate & potassium meta-periodate

This video tutorial is in the Education category which will show you how to make sodium bromate and potassium meta-periodate. This experiment uses toxic chemicals and releases harmful gases. First you have to make a saturated sodium bromide. To this solution then add a small amount of potassium dichromate. The solution now becomes concentrated. Then make the circuit as shown in the video. You need a 3 - 5 ohm resistor in order to reduce the current. Then let the cell run for around 6 hours. S...

How To: Choose the right shot in World Golf Tour

In this tutorial, we learn how to choose the right shot in World Golf Tour. The game will automatically choose the shot for you. You can find the different shots by clicking on the current swing selection on the bottom left hand corner. A full swing is the most common type of shot that delivers the most power. A punch shot is a flatter and shorter swing that causes the ball to fly lower during high wind. A pitch shot is a controlled swing that is used around the greens. A chip shot is compact...

How To: Tell if a girl is interested

In this video, we learn how to tell if a girl is interested. If you just met a girl and have gone out with her a couple of times, there are ways to tell if she really likes you. Sometimes girls can forget to call you or hang out, but don't take it to heart. The best way to know if a girl likes you is to compare her to a girl that you know was interested in you in your past. If your current girl acts like the girl that liked you in the past, you will know she really likes you and can think abo...

How To: Install a bath fan

In this tutorial, we learn how to install a bath fan. When you take a shower and don't have a bath fan, you are more likely to have mold or mildew in your bathroom. First, you need to determine the correct CFM for your bathroom, then you need to find a fan that is as loud or quiet as you want it to be. Choose if you want a quiet or loud one. After this, you will need to find out where to put the bath fan or check your current one to see if a new fan will fit inside!

How To: Renew a US passport

In this tutorial, Laurie Lee-Partner teaches us how to renew a US passport. First, you can only renew your passport if you have the current one and it expired less than five days ago. You will first need government form ds-82 and remember to sign it in black or blue ink, then send it in. Next, you will have to send in your passport that has already expired or is going to expire. Next, you will need two identical passport photos that have been taken in the last six months. They must be in colo...

How To: Install a car alarm on a Viper 5900

In this tutorial, we learn how to install a car alarm on a Viper 5900. First, read your manual and figure out which wires go where, then label them so you don't confuse them. Next, grab all the tools you will need and have them prepared and ready. After this, find the electrical box on the car and remove all the wires that are inside of it. Now, you will take out the wires that go onto the current alarm system. Replace with the new alarm system and apply the wires where they belong. You may n...

How To: Adjust ISO on a Panasonic G1 or GH1 digital camera

Learn how to adjust ISO exposure settings when using a Panasonic G1 or GH1 digital camera. Learn how to set the auto mode on a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to change your camera's current ISO value setting. For more information, including detailed instruc...

How To: Calculate simple and compound interest in MS Excel

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 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Format whole & decimal numbers in Microsoft Excel

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 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.

How To: Solve markup & markdown math problems in MS Excel

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 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.