Demanding Function Search Results

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: Evaluate a random value against criteria 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 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...

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: Use a tripod to improve your photography

In this video tutorial, viewers learn how to use a tripod to improve photography. There are many different tripod manufacturers, but the operation of most tripods is similar. Look for a tripod that is easy to use. Make sure that the tripod can tilt forward, backward and side to side easily. It should be able to rotate at a 360 degree angle. This video also provides 4 different types of tripods in an image. Each tripod has different functions, size and movement. This video will benefit those v...

How To: Line and cast a fishing rod

In this brief video tutorial, the host Ian Leahy gives you step by step instructions about how to line and cast a fishing pole. For this video you'll need your baiting hook, some small line weights, bait, plyers, and some heavy-weight fishing line. First, he suggest you check your reel to insure that it functions properly, and to be sure to keep your bail down while you line your fishing rod. He also gives you some excellent tips on how to make lining your rod simpler. Keep watching while he ...

How To: Use email on a Blackberry Storm 9500

The Voda Phone Help Center's video provides you how to hints and tips to get your email onto your Blackberry Storm. This video will help you send and receive emails. To receive emails, click the main message button, which looks like an envelope, you will then see you inbox where all your messages are stored. Next if you wish to send a message, click the compose button in the lower left hand corner and select which type of message you want to send. Enter in the email address in the top box, wh...

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: Extract dates and times from a database field in 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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.

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 date labels with YEAR, DATE & TEXT in 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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.

How To: Set & insert a formula name into an Excel print area

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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.

How To: Add with case-sensitive criteria 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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).

How To: Create a grade book based on a total score in 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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.

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: Conditionally format dates & weekends in 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.

How To: Calculate excess over a hurdle 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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!

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: 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: 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: Crop and resize images in Adobe Photoshop CS2

When using Adobe Photoshop being able to crop and resize an image is essential. This live demonstration shows you step by step directions for these useful functions. To crop, select a certain area and hit enter, everything not selected will be deleted. If you mess up you can undo. This is a great way to take a large picture and only use the parts you want to concentrate on. Video also shows how to resize picture using width and height or mega pixels. Gives tips on how to keep your picture fro...

How To: Create an array for a stem-and-leaf chart in Excel

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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.

How To: Calculate vacation days with TODAY, YEAR & IF in 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.

How To: Extract the top five records from a table in Excel

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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.

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: Show vendor names associated with a low bid in Excel

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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.

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: Simplify expressions involving numeric radicals

In this video tutorial, viewers learn how to simplify expressions involving numeric radicals. This can be very frustrating to work with if you have not memorized the tables of square, cubes and fourths. If you are taking the square root of a number that is not a perfect square and you wish to simplify it, the key is to write it as the product of a perfect square or another number. This video is very descriptive and clearly explains the functions of the formula. This video will benefit those v...

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: Simplify expressions involving algebraic radicals

In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...