Mind Everybody's Search Results

How To: Use Microsoft Excel's undocumented DATEDIF 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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.

How To: Extract records from a table to a column 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 extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.

How To: Create a list of hyperlinks 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Remove the last two words from a column in MS 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 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.

How To: Use IS functions in Microsoft 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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).

How To: Use the EXACT function in Microsoft 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 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.

How To: Convert currency with data from a web query 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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.

How To: Convert from gallons to quarts, pints and cups in basic math

Need to know how to express gallons in quarts, pints and cups? 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 gallons, quarts, pints and cups.

How To: Calculate price per unit with basic arithmetic

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 unpack and solve word problems that require you to find price per unit.

How To: Solve word problems that involve rounding to estimate differences

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 (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve problems that require you to estimate differences by rounding.

How To: Solve math problems involving the identity property of one

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 (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems requiring use of the identity property of 1.

How To: Calculate salary based on work experience 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 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.

How To: Interpret inequalities in basic algebra

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 (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to interpret simple inequality problems in basic algebra.

How To: Solve an inequality word problem in algebra

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 (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and find the answer to a basic inequality word problem.