Function Search Results

How To: Kill bugs in wall holes with Diatomaceous Earth

Diatomaceous Earth may be useful for killing bugs in walls. Light sockets and phone jacks provide a highway for bugs to travel from one infested room to another or one infested apartment or another. They also function as a hide-out for them during daytime hours, when they might be more visible.

How To: Match exponential graphs

This video tutorial belongs to the Education category which is going to show you how to match exponential graphs. The video shows two graph sheets with three graphs marked A to F on each sheet and six equations. It starts off with matching the basic function, y = 2 to the power x. If you plug in zero for x, you get '2 to the power 0' which is 1. Hence, the equation becomes; y = 1. So, the graph that passes through y = 1 is the matching one. In the video it is graph A. You can watch the video ...

How To: Cleanse toxins from your body

In order to cleanse your body of toxins, you first need to determine the types of toxins you've been exposed to. This can be done with blood screening or urinalysis or liver function tests. If the liver isn't functioning properly, then there will need to be some steps taken or the benefits of cleansing won't last very long.

How To: Convert PSone games to PSP

In this Video Games video tutorial you will learn how to convert PSone games to PSP. For this you will need a 5.03 firmware update. It is capable of running ChickHEN enabler. After you upgrade, run the firmware. You will need a utility called magic ISO for ripping the discs. Put in your PSone game in to your PC and use the extract game function. Then a program called Simple Popstation GUI comes up. Browse to where you saved your ISO, pick the output destination and click GO. Then you drag the...

How To: Use LightScribe with a Nimbie NB11 disc burner

In this video tutorial, viewers learn how to light-scribe with a Nimbie BB11 disc burner. This device is an auto disc loading system that allows the user to light-scribe multiple disc without manually inserting them one-by-one. Simply load the disc into the machine with the labels faced down. On your desktop, double-click on the Q-Q-Box icon to start the program. Start up the labeling function, select a desires image and quantity up to 100. Then click on Print. The machine will then product l...

How To: Access & use exposure compensation on a G1 or GH1

Learn how to find and set the exposure compensation function on 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 find . For more information, including detailed instructions, watch this digital came...

How To: Use the Shutter Priority mode on a Panasonic G1 or GH1

Learn how to set and use the Shutter Priority (S) function on a Panasonic G1 or GH1 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 use the Shutter Priority mode on a G1 or GH1 camera. For more information, including detailed i...

How To: Use Excel to sort data & present data in a line chart

This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...

How To: Sum and average statistical data within MS Excel

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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Find outliers using the Z-score method

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 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

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: Avoid a #NUM! error when changing NPER inputs in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up approximate values with VLOOKUP in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Use curve sketching to solve equations in calculus

PatrickJMT takes you through step by step on the basics of how to use curve sketching to solve calculus equations. Steps that are covered in this two part video include domain, intercepts, symmetry, horizontal and vertical asymtotes, intervals of increase/decrease, local maximums and minimums, concavity and points of inflection, and finally the sketch. A rational function is looked at as an example. The problem is to graph y equals (x - 1) divided by x to the power of 2. This video clip cover...

How To: Use numerical truth values in Microsoft Excel

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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.

How To: Root your T-Mobile G1

Rooting a cell phone can give you so many different perks and advantages that you wouldn't normally have. But at the same time it can also cause damage to the phone itself that it may even cease to function properly causing any money that you spent, to go down the drain. This tutorial shows you how to root your T-Mobile G1. Be careful and good luck!

How To: Sum the values from many cells to a single Excel cell

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.

How To: Create a column of unique values in an Excel LU table

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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.

How To: Speed up Windows Vista in three steps

This video will show you how you can increase the speed that your Microsoft Windows Vista runs by using several different methods. You can disable the transparency function and go to a basic mode. Clearing disc space will also make your computer run faster. You can just run a disk clean up. Finally you will want to do a disk defragment your computer. If your computer is running a little slower than you’d like then try doing these three things and you should gain a little speed.

How To: Use Excel for daily interest and monthly deposits

Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...

How To: Fix your broken Xbox 360 using the towel trick

In this video tutorial, viewers learn how to fix an Xbox360 with the towel trick. This technique is for an Xbox360 that has the 3 red flashing lights on the power button and does not function properly. Begin by unplugging all the cables from the Xbox360, except for the power cable. Then turn on the console and wrap it in 3 towels. Leave it to heat up for 25 minutes. Now unwrap the console and turn off the power. Let it cool off for 15-20 minutes. This video will benefit those viewers who have...

How To: Quickly find the area of a trapezoid

In this video, Mr. Maisonet provides a quick and easy method for calculating the area of a trapezoid. In the first step, The lengths of the two bases (the two sides of a trapezoid that are parallel to one another) are averaged. The lengths of the bases are first added together, and the sum is divided by two, yielding the average. The average is then multiplied by the height. The resulting product is the area of the trapezoid. This method for finding the area of a trapezoid is mathematically s...

How To: Use the zoom in Mac OSX

In this how-to video, you will learn how to use the zoom function in the Mac OSX. This will help if you are visually impaired. Next to the space bar, there are two keys. There is the command key and the option key. Hold them both of them down at the same and press the number eight key. Once this is done, the desktop will be zoomed in. To zoom in even further, press control, command and plus. Do the same except with the minus key to zoom out. Press option, command and the number 8 to reset the...

How To: Define an antiderivative in calculus

The relationship and the definition of derivatives and anti-derivatives is described in this video. First, consider a function F(x)=x^3-5x+2 and another with small 'f', f(x)=3x-5. f(x) here is the derivative of F(x). However, on the contrary, F(x) is said to be the anti-derivative of f(x). There is a catch though; even though F(x) has only one derivative in the form of f(x), f(x) here has more than one anti-derivative. This is because f(x)'s anti-derivatives are of the form F(x)=x^3-5x+c, whe...

How To: Dual boot Windows Mobile & Android

This will illustrate us how to dual boot Windows Mobile and Android. Here are the following steps:Step 1: First of all switch on your mobile and close all the running taskStep 2: Go on the start menu and press the center scroll key, the menu will open up.Step 3: Now go on setting and select itStep 4: various icons will appear, Now out of this choose the REboot function , the reboot will start.Strep 5 : enter reboot Windows And AndroidStep ^: after await of few minutes the reboot will be compl...

How To: Use definite integrals to find the area of curves

Brightstorm explains how to use definite integrals to find area. There are two basic area problems: one in which the area lies between the function and the x-axis, and one where the area lies between the two functions. In the first case, if the curve lies above the x-axis for x=a to x=b, the definite integral returns the area. If it lies below the x-axis for x=a to x=b, then the definite integral returns a negative area. In the second case, we assume that f(x) is the higher curve and g(x) is ...

How To: Browse the Internet on an Xbox 360 using MCE Browser

Madman McClinton demonstrates how to browse the internet on an Xbox 360 using the MCE browser. First, download the MCE browser by doing a Google search and clicking on the first link. Next, install the MCE browser on your system. Then, connect your Windows Media Center to your Xbox. Then, go to your Xbox and open up the Windows Media Center. Select the program library function from the online media option. Next, choose the MCE browser from the available choices. Enter your desired URL into th...

How To: Edit or delete tiles on your HP TouchSmart homepage

TouchSmart demonstrates how to edit or delete tiles on your HP TouchSmart homepage. Editing and deleting tiles is a useful way to keep your homepage up to date. To edit a tile, first tap the personalize button at the bottom of the screen. Then, tap the pencil icon next to the shortcut that you would like to change. Edit the information for the tile as desired. Tap the okay button when you are finished editing your tiles. To delete files, tape the pencil icon next to the tile that you would li...

How To: Use Excel databases for home improvement calculations

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 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.

How To: Use electronic image stabilization on a video camera

This is a video that is showing its audience how to use the electronic image stabilization or digital image stabilization on their digital cameras. Image stabilization is a good function to have on when movement is involved while taking a photo. The video goes over terms such as image stabilization, shutter speed, and contrast. It adequately defines image stabilization and digital stabilization and goes over the problems that consumers might have with the image stabilization mode on their cam...

How To: Use a TI89 calculator to graph linear equations

This video shows the user how to use a T189 calculator to plot linear equations. The video demonstration is done using an ‘on screen’ representation of the calculator – there are also verbal instructions. The equations are plotted on the same axis by selecting the ‘y=’ function. The corresponding values of y in terms of x are then inputted into the graphical calculator. Once this has been done for every equation you can get the calculator to display the graph. This then allows you to compare ...

How To: Write a logarithm as a sum or difference of logarithms

This video shows the method to write a logarithm as a sum or difference of logarithms. The square root of the term given is taken out as half according to the rule. Then the numerator and denominator is divided into product of factors. This is broken into the difference of numerator and denominator according to the rule. Finally, the product of factors is expressed as the sum of factors. Now we see the domain of the term. As the term is a square root of the term it should be greater than zero...

How To: Copy and paste on your Android

This video shows the viewer how to use the copy and paste function on an android smart phone. This feature is only demonstrated for text. The text is copied by highlighting it with a long press. A second press brings up a menu; copy is one of the options. Once the text has been copied it can be pasted into the desired location by moving the cursor to this point. Another long press will then bring up a menu with the option to paste the original text. Furthermore the video also explains how whe...

How To: Make a screen capture program in Visual basic

This video shows how to make a screen capture program in Visual basic. The first step to create a screen capture is to open a new project and open a new form window. The second step is to create to temples for either saving or capturing the picture you choose to select. The third step involves following the code structure given by the instructor to enable the correct function for the save or capture button options. The final step is to open the project as a finished work with the correct codi...

How To: Use a multimeter to check connectivity on a guitar

The first thing you need to get is a multimeter this will help you test it. There might be a function on the meter that will give you the amount of voltage in that particular area. Then you have to put foil tape on all of the inside of the guitar to test it. You need to get two wires from the meter and then put them both on the foil tape on the guitar. If you don't hear a beep then you add more tape in that area where there is no activity. You can also test this on the ground.

How To: Fill a cone

This is a very interesting instructional video on how to fill a cone. Pour oil into a cone of diameter 30 inches and depth 40 inches. Now find the volume of the oil as a function of its depth. Volume = 1 over 3 phi rsquare h. We don't know the height and depth of the oil poured into the cube. Draw similar right angled triangles. In one right angled triangle the height is 40 inches and in the other triangle it is h. Similarly the height is 40 inches and h respectively. Now rover h =15 over 40....

How To: Calculate equivalent earnings in Excel

In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...

How To: Make your computer more environmentally friendly

Eric Rochow of Real World Green gives us advice on making our computers more environmentally friendly. This video first explains that screensavers are not green. Screensavers require a computer to use its processor. Ideally, when you're not using your computer it should be in sleep mode and your monitor should be in sleep mode as well. This saves a lot of energy. Also, at the end of the day, turn off your computer and monitor. Don't let them run all night. An interesting fact from the Departm...

How To: Right click on a Mac using the Apple mouse

Jonathan demonstrates how to right click on a Mac using the Apple mouse. There is a short cut: holding down control while left clicking to make the right click menu come up. The Mighty Mouse has a right click function but you have to enable it. To enable this feature, go to system preferences and click on mouse and keyboard. The mouse and keyboard menu will now open up. Locate the right drop down menu. The default is set to "Primary Button" so you will need to change that to the "Secondary Bu...