Mind Complicates Search Results

How To: Recognize polynomials in algebra

Need help figuring out whether a given expression is a polynomial or not? Watch this free video algebra lesson. 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 free math tutorial, you'll learn how to distinguish polynomials from non-polynomials i...

How To: Measure right triangles with the Pythagorean theorem

Know the length of two sides of a triangle and want to know the third? With the Pythagorean theorem, a^2+b^2=c^2, it's easy! Learn how to use it with this free video geometry lesson. 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).

How To: Solve a system of equations algebraically

A system of linear equations usually has a solution that is an ordered pair (x,y). Sometimes that isn't the case, especially when the equations represent the graphs of parallel lines (inconsistent system) or the same line (dependent system). Learn how to solve a system of equations algebraically in this free video lesson. 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,...

How To: Find the mean of a set of numbers

Need to find the mean (that is, the regular average) of a set of numbers? It's easy! So easy, in fact, that this clip can present an overview in just under 45 seconds' time. Learn how with this free video lesson. 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 te...

How To: Use the upside-down birthday cake method to find a GCF

Need to find the greatest common factor for a set of numbers? Easy as cake. Learn how to find GCFs using the upside-down birthday cake method with this free video lesson. 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).

How To: Find the GCF for two terms using factor trees

Need to find the greatest common factor for a set of two numbers? Try a factor tree! Learn how with this free video lesson. 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).

How To: Find the LCM & GCF of a number set with a Venn diagram

Looking for an easy way to find the least common multiple and greatest common factors for a number set? Try a Venn diagram! Learn how with this free video lesson. 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).

How To: Find an LCM with the upside-down birthday cake method

Look for an easy way to find the least (or lowest) common multiple for a set of numbers? Like to think in pictures? Try the upside-down birthday cake method! Learn how with this free video lesson. 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).

How To: Find an LCM or GCF with the Indian method

Looking for an easy method for discovering the lowest common multiple (LCM) and/or greatest common factor for a set of numbers? Try the Indian method! Learn how with this free video lesson. 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).

How To: Graph a system of linear equations on a TI83 or TI84

Need to know how to solve a standard-form system of linear equations by graphing using a TI83 or TI84 series graphing calculator? Learn how with this free video lesson. 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).

How To: Use derivatives to find slope in calculus

Need help figuring out how to work with derivatives in calculus? 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 use derivatives to f...

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: Sort numbers with a formula 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 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.

How To: Count Mondays between 2 dates 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Create random dates within a set range 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 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.

How To: Display trend arrows in a Microsoft Excel spreadsheet

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 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

How To: Use the concatenate function & ampersand 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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

How To: Play the long greenside bunker shot

Golf is a difficult sport that takes time and patience to not only play, but to learn as well. In order to hit the perfect shot, a player needs composure, mental toughness, and the right set of mind to hit the ball where it needs to be. Since golf courses can vary from course to course, golfers must be prepared for the worst. In this tutorial you'll find out how to play the long greenside bunker shot while plying golf. To some this is easy, and for others it's a bit more difficult. So pay att...

How To: Use SUMIFS or SUMPRODUCT to get invoice info 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 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.

How To: Create an amortization table 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 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...

How To: Play the chords to "Jingle Bells" on the guitar

In this how-to video, you will learn how to play the song "Jingle Bells" on the guitar. You will need a guitar, acoustic or electric, and basic knowledge of chords in order to do this. The song consists of the chords C major, F major, G major, and back to the C. This makes the intro of the song. The next consists of C, F, C, D, and G. Repeat this for the chorus of the song. With these two chord progressions in mind, you will now be able to play the song "Jingle Bells" on the guitar. This vide...

How To: Enter VLOOKUPs in 4 different ways 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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP

How To: Count blanks in an dynamic range 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 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).

How To: Check to see if a string contains a value 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 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").

How To: Look up & retrieve a row of data from a table 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 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.

How To: Extract the nth word from a text string 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 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.

How To: Extract first, middle, & last names 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 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.

How To: Create a line chart with time as its x-axis 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 284th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a line chart from years and percentage change. See how Excel makes the chart wrong, but then see how to fix it.

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: Choose a snorkel

YouTube user Leisurpro is here to talk to you about the different kinds of snorkels. Snorkels are an essential tool to snorkeling and scuba diving. So which snorkel is good for you? Well, first we have the children's snorkel which we want to make sure that it's not to overwhelming for the individual using it you also want to make sure that the mouth piece is not to big for the child, keep in mind that some children will be big enough to use adult snorkels. A semi-dry snorkel will have a canop...

How To: Sing with clarity

This video illustrate us how to sing with clarity. Here are the following steps: step 1: First of all keep in mind to sing with full confidence and in the right pitch.

How To: Join & use Facebook effectively

In this tutorial, we learn how to join and use Facebook. First, go to www.Facebook.com and sign up with the website, you will have to enter some personal information as well as your e-mail address. Once you've confirmed your account, log into Facebook. Once in your account, you can click edit and change your personal settings. This includes birthday, hometown, sex, relationship status and more. You can also click on the photos button and upload photos of you and your friends. If you want to f...

How To: Make simple wire hoop earrings

The video describes to make wire hoop earrings. Take a steel metal of anything and take a eighteen gauge wire and wrap a few length of it around the taken piece of metal which is cylindrical in shape. Cut the wire at the desired part and remove from metal.The wire takes the shape of a standard spring. Again cut it into two or three pieces. Hold the wire again and straighten the edge and after that once again bend it down holding at the place where bent begins. Put some on it to design and the...

How To: Disable pop-ups in Google Chrome

In this video tutorial, viewers learn how to disable pop-ups in Google Chrome. This task is very fast, simple and easy to do. On your desktop, begin by right-clicking the Google Chrome icon and select Properties. Click on the Shortcut tab and in Target, add "-disable-popup-blocking" to the end of the code. Now click Apply and click OK. Then restart Google Chrome. This video will benefit those viewers who use the Google Chrome web browser and would like to learn how to disable the pop-up block...

How To: Return multiple items for a single Excel lookup value

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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.

How To: Rabbit proof a garden

Small creatures like rabbits can be a large problem for gardeners when they begin to feed on garden plants. John White shares some tips on how to keep rabbits from ruining your plants. Rabbits will feed on almost anything, especially when they’re starving, so it’s hard to rabbit-proof everything. However, you can still try to save the plants that are most prone to dying with rabbits and rodents in the area. For instance, if you just planted a young tree, you can put netting around it with...

How To: Calculate probabilities with Excel's NORMDIST 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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...

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.