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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create 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 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 solve a complex radical equation in algebra.
Need help figuring out how to tackle complicated mathematical expressions? 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 the or...
Thinking of an unknown exponent as a cat stuck in a tree, you will see how to bring down the exponent by using the the log function. In other words, you will be utilizing the Power Law to bring the exponent down in front of the log function. In this slightly more complicated example, a little work has to be done to first be able to take the log (i.e., get the base by itself). Then once you take the log, the unknown still isn't entirely by itself, so you divide off everything it's being multip...
Reading people's minds is something that most inquisitive and sensitive people have wished that they could do at some point. Well, what if you could? This video will show you a great multipurpose bar trick that will allow you to appear to read the mind or body of people in a variety of situations. It's really remarkable how easy this is and how well it works.
Do you like music? How about the acoustic guitar? How about Brenda Lee? How about a Willie Nelson, Elvis Presley, or the Pet Shop Boys? Well, this video tutorial will show you how to play "Always on My Mind," most notably by Elvis Presley. This instructional guitar lesson will teach you a few tips and tricks for playing an arrangement of the famous song.
You don’t have to be a psychic to read someone’s mind – or, at least, to make them think you’re reading their mind, as shown in this how-to video. You will need one card with an "X" on back, an envelope with "you will choose (blank card)," a duplicate of the third card, and a flat surface. Watch this video magic tutorial and create the illusion of reading someone's mind while performing a card trick.
Most long-haired men and women in America have a hair tie on them most of the time, sometimes more. All you need are two different-colored ones to do this awesome mind game / bar trick on someone! It involves tying the two ties together surreptitiously, and you'll learn how to do it in this video.
Your mom probably told you not to play with matches, but now that you're a little older it's time to start breaking that rule. Watch this video to learn how to play a fun trick on / mind game with people at a bar or other social occasion using matches.
Understand quantum physics and mind matter interface with an explanation from Dean Radin, Ph.D on "The Stupidity Hypothesis." Watch this video on learning how to understand science to improve your life.
Breathing oxygen is an extremely important component of staying alive, right? Well, the same goes for running. If you're not breathing properly, you're running is going to suffer.
Impress all of your friends with some magic, or as others like to say, illusions. You don't need to be a magician to learn the illusion of magic. See for yourself how easy it is to learn... watch this video tutorial to see how to perform an amazing mind reading trick, where you ask someone to think of number between 50 and 100, where both numbers have to be even numbers, and neither number can be the same. This mind reading trick leaves only six numbers left, essentially turning it into picki...
Microsoft's HoloLens has two gestures: bloom and air tap. While the two might not seem like much to learn, some people struggle with the air tap because the headset can be a bit particular. The easiest way to learn the proper form is to look through someone else's eyes while they do it, so we've captured that for you.
This simple meditation is a very effective way to create inner stillness, bringing the mind into peace and quiet. It's a great tool for practicing the art of concentration, and for stopping the endless chatter of the mind. There is wonderful feedback from everyone who has tried it. Hope you enjoy the deep relaxation that comes as a result of concentrating the mind. Try this infinity meditation from Brahma Kumaris Meditation.
There are good magic tricks, and there are bad magic tricks. The host of this video tutorial might not be the most skilled magician around, but he's a pretty good judge of card tricks. Check out how to perform a mind control card trick. With just a little mind control and a little magic, your spectators will be astonished. See the reveal and explanation.
Impress your friends by learning how to perform an easy and amazing mind reading card trick. this video tutorial will how you how to do this mind reading magic card trick, so pay close attention. Is it sleight of hand or is it magic? See it revealed.
One of the unique aspects to the game Mindjack is the ability to take control of someone else's mind - or mindjacking. This video is a great tutorial on how this mechanic works, and the best ways to make it work for you.
The foundation of most fine arts educations begins with the drawing of the human figure. These human figure drawing tutorials are brought to you by Cy Porter of solomation.com. Search WonderHowTo for more figure drawing tutorials by Cy.
Do you ever feel as if your mind is running away from you? What if you could map out all of those thoughts into a coherent map that helps you make sense of your reality? Well, now you can.
Solving long and extensively complicated equations in grade school was tough to do by hand. Keeping track of which part of the equation to solve first took time, training, and lots of bad grades.
Love roses and complicated craft projects? Make a beautiful decorative paper rose using origami, the traditional Japanese folk art of paper folding. This 26-minute free origami video lesson presents complete instructions on how to make your own roses from folded paper. For more information, and to get started making paper flowers yourself, take a look!
Dina Prioste wants you to clear your mind by using simple mantra meditation, and show us how to in this video tutorial. This is a great exercise to use if you have creative block and need help relaxing and clearing your mind. First, begin sitting comfortably on a pillow or folded blankets. Bring your left hand inside your right hand with your palms facing up and your thumbs gently touching. Now close your eyes and sit up tall while breathing through the nose. Begin to observe the sound of you...
If tension is bothering you, take some time to relax and let the stress melt away by practicing the Reversed Corpse pose, or Adavasana. This simple exercise can help you relax your body and mind, by focusing on your breathing you will find relief from stress and tension.
Want to know how to bend a spoon and a fork and a steel bar with just your mind? Check this out. Of course, there are many ways to bend a spoon, and for some strange reason they all require touching the spoon at some point, so that's one clue to how psychics do the trick.
Even basic electronics are pretty damn complicated. This video is near the end of Scotty's amazing series of electronics tutorials, and will teach you about adding a diode and a capacitor to a circuit, choosing a power supply, voltage states, and polarity.
If you own a wolf t-shirt as so many kids do these days, or just like wolves, you've found your Call of Duty Black Ops emblem. This video will teach you how to make an awesome playercard with a wolf howling at the moon that is complicated and sure to impress your fellow players.
So, you've got a copy of Reason 4 now huh? Congratulations, you own one of the most powerful music-making tools on Earth. It is infinitely complicated though, and getting started can be tough. Watch this video to learn how to load a .wav sample into Reason 4 using ReDrum, something you're going to be doing a lot of as you produce your tracks.
Replacing the rear wheel bearings on a car is a great place to start for at-home mechanics, as you don't need to fully lift the car or work with any really complicated parts. This video will teach you everything you need to know to change out the rear wheel bearings on any Toyota car.
Most people think of gears as big pieces of metal, but for a long time gears were mostly wooden affairs. In this video you'll learn how to make small wooden gears that you can use in all sorts of complicated machinery oriented woodworking projects.
If you're looking to tie something that is elegant and beautiful, then this next tutorial has something for you. This video is going to show you step-by-step on how to tie a Japanese bow knot.
The rear wheel of a bicycle is the more complicated to work with of the two because of it's position in the frame. If you have quick releases, it's still pretty easy to remove and reinstall. This video will show you how to do it step-by-step, and should have you back on the trail again in no time.
Scripting languages, like coding languages, are among the most complicated and daunting aspects of computer use to master. If you can do it, however, they allow you to do nearly anything you want with a computer. This video will introduce you to the popular scripting language Actionscript 3. This language is crucial to using Flash successfully to create games, movies, and websites, so get this stuff down and then go watch our other Actionscript tutorials!
Whoever said that pretty has to be complicated hasn't taken a glimpse at these adorable cards decorated with glued-on yarn motifs. A simple craft for kids and adults, yarn art creates homespun cards that evoke a whimsical, old world charm.
In this video, Justin Kredible will teach you how to perform a ton of cool magic tricks using items you already have around the house. Justin is a master illusionist and in this clip he shows you some of his easiest (yet still fascinating) magic tricks. Like Justin says, he doesn't reveal secrets..he teaches magic. Have fun!
Paper is good for more than just scribbling your crush's name in hearts during a boring history class lecture. Watch this video to revitalize your understanding of paper power and to make a spring craft that will scream hugs and kisses to anyone whom you give it to.
The trinity stitch looks very complicated, but this easy tutorial makes it simple to create a crochet pattern that has three columns of eyelets which punctuate your stitch.
This video basically covers some of the simplest Salsa dance moves that are basically universal -- that everyone who does Salsa knows how to perform. It is interesting to note that some of the more complicated Salsa dancing moves actually end up being variations of these combos.
This is a US Army training video that shows you how to stitch a wound. It is a simple laceration, not a complicated gash.
Flashback Max ties the Basic Alaskan Flesh Fly. It could be very simple, yet very, very complicated, articulated, flesh flies. So pay close attention, not that anybody's calling you an idiot or anything. I'm sure you could do it just fine.
Summer Mind is the bonus level to Chapter 1 of the popular Xbox arcade game, Ilomilo. This tutorial does not focus on gathering any items, but it does show you how you can solve the puzzle in this level quickly and easily.