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.
Bobby Flay is a leading figure in the television-grilling world. In this episode of his show Grill It! with Bobby Flay, he veers away from his usual pile of meat to make a delicious side dish, grilled corn sheets with a homemade vinaigrette. Corn is not generally served in sheets, and this original presentation adds some flair to what is thought of as a rather boring staple of the American diet. All you need is some skill with cutting vegetable, a functioning grill, and a blender to make this...
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 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
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 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
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...
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...
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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
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 count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.
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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.
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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
Skype is a very cool, useful communications tool that you can download online. This program is free and includes video chats, instant messaging, search functions and various other features.
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...
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...
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...
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.
If your outdoor faucet is dripping, that is not a good sign. It is important to keep your faucet functioning properly both to protect your lawn, and save on water.
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...
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 ...
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...
This video tutorial from Michael Espinosa shows how to install and use File Zilla Ftp client on Windows XP operating system.
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!
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.
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.
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.
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.
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).
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.
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.
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.
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!
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.
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...
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...
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...