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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
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 124th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a box plot or box-&-whisker chart using a stacked bar chart and a open-high-low-close stock chart. You'll also learn how to use the QUARTILE function.
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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
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 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
Drawing is an excellent exercise for the brain that also lets your mind wander. This video tutorial demonstrates how to draw a serene mountain landscape using charcoal techniques. Begin with a simple sky and mountain range, then add trees and a beach. Pencilling in water will help to bring the trees to the foreground. Finally, add shadows and a waterfall to provide a sense of depth to the entire rendering.
Shatter glass with your mind!… Um, no… with speakers! This little video shows you how to shatter wine glasses with your own speakers. Yep, those normal, everyday home speakers that you have can break a wine glass just like a jackhammer.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
They don't call them salad days for nothing; you probably can't afford to eat anything else. But there are ways to trim your food budget—and they're even good for you. Learn how to eat cheaply on a budget.
Take a look at this instructional video and learn how to hack into your iPod's firmware on a Mac. In order to hack into the 5.5g iPod's firmware, you need to download the Alterpod, a firmware editing software. With this program, you'll be able to download themes onto your iPod. Keep in mind that this hack is for the 5.5 generation iPod and does not work for the 6th generation or the older ones before 5.5. When downloading themes, make sure to download the correct version.
Ever wondered about the reproductive tract of a female pig? Well, these video tutorials will tell you all you need to know about the anatomy of a sow's reproductive tract.
The Golden Egg is perhaps more of a state of mind than a posture in yoga. The Golden Egg involves sustaining and concentrating your core strength, creating what Sadie Nardini calls an "abdominal balloon."
In this video we learn how to increase & decrease the size of web page content. First, click and hold down the control key and move the mouse wheel up and down. After you do this, you will start to see your web page content get larger and smaller right before your eyes. You can also use the plus and minus keys on the keyboard to get the same effect. Keep in mind you will need to do this for each of the different pages as you access them. For a more permanent fix, you will need to go to the to...
Is it possible to look put together without actually, you know, having to put in the work to look put together? We're glad to tell you that there is.
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
If your little girl loves jewelry making but you're scared she's going to poke her eye out with a wire when you're not looking, sleep soundly at night by teaching her how to craft shrink plastic jewelry. Perhaps the safest and easiest forms of jewelry making, it involves only shrink plastic and a mini oven (which you would help out with).
In this video, we learn how to tailor your resume for foreign countries. When you are writing the resume, you need to keep in mind the: length, content, demands, passport, and hobbies. You should make sure the content is descriptive and you focus on your accomplishments. Don't focus on the family and references, these are not required on the resume. The recruiter wants to know more about your professional life, and if you have a passport to travel. Depending on the country you are traveling t...
In this video, we learn how to improve your yoga with the hara breath. Start by sitting down on your yoga mat and become centered in your body. You will start to breathe in different poses by placing your hands underneath your navel. Close your eyes and envision the center of energy that's in your body. Close your eyes and deep breathe, inhaling and screening energy into your body. Feel your body fueling up with energy and block out all the negative thoughts from your mind. As you do this, fe...
Seated dips are one of those exercises that looks easy but is a real pain to actually do. While you can do seated dips on the floor, doing them on a bench with your feet flexed adds an extra dimension of height that will increase muscle intensity and heart rate.
If you excel at drawing faces directly facing the front but can't seem to wrap your mind - and finger - around turning that face to the side and performing a profile sketch, then you're not alone. Adjusting a face to the side adds another dimension of facial contouring and structure.
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 four-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find the optimal angle at which to launch a projectile.
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 calculate unknowns in proportions in algebra.
In this tutorial, we learn how to cram for a test if you need to. It's always best to study adequately, but cramming is always needed at times. If you cram in all the information right before you go to bed, it will soak into your mind after that while you are sleeping. Your subconscious will think about everything you just read, then you will be able to do better on your test. Make sure to do this one hour before you go to bed for the best results. When you take your test, make sure you eat a...
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 requiring you to rewrite and simplify an expression with th...
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 write a multiplication problem as an exponent problem.
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 requiring use of multiple mathematical operators at once.
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 requiring you to round whole numbers.
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 requiring you to multiply whole numbers.
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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
No, this isn't an elaborate paper helicopter design that will take you weeks to master. Just because it can fly doesn't mean it's difficult to make. In fact, this is one of the simplest paper helicopters you could make. And it's a great instructional tool for a science classroom to learn about the principles of flight and the heat of the sun. It flies like it has a mind of it's own! Sometimes it will even hover in one spot for an extended period of time. Check it out, both videos, then make y...
The core principle of origami is folding something from a single sheet of paper. The idea is to challenge your mind to create something fabulous out of very limited material. And while this is quite the poetic journey, as you'll see with modular origami and this origami tutorial, sometimes more than one sheet is necessary to get the job done.
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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.
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 calculate the probability of two dependent events in statistics.
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 that require you to apply deductive reasoning.
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 involving events and outcomes.
