Magic Wand Search Results

News: Magic Leap's Latest Job Posting Shows They're Getting Ready for Mass Production

Few companies have maintained such intense secrecy, in the face of such extreme hype, as Magic Leap, but the closer their mysterious Mixed Reality product comes to mass production, the harder it becomes to hide the details. Hopefully we'll find out way more details soon, as a Magic Leap job posting for a supply chain manager hint that they're readying for release in the next couple years.

How To: Unbrick a fully bricked PSP

The video explains how to unbrick a fully bricked PSP using a hard modded pandora battery and magic memory stick. This method does NOT need a 2nd custom PSP. Your PSP is fully bricked if it is not powering on/no recovery. You won't need anything else other then a PC (OS must be XP for the MMS creator to work, VISTA doesn't work) a bricked PSP and a 1gb memory stick. In order to create the Magic Memory Stick, you'll want to go here and follow the instructions.

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Generate random numbers not divisible by 3 in 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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.

How To: Do the Ed Marlo's atfus sleight move

Not only does "Andy Field Magic" go about showing the effect in a professional manner, he does so in a personable and thorough demonstration. Agreed, the effect is not magic in essence, but does show off quite the slight of hand. I appreciated that lack of jargon in the demo; the performer visually made sure that you understood what he was doing step by step. It makes for an easier learning environment when you know exactly how the effect is achieved through a slower paced demo. He seems to b...

How To: Perform an amazing mind reading trick

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...

How To: Perform the erase the face card trick

Impress all of your friends with some card magic, or as others like to say, card manipulation or card trick. You don't need to be a magician to learn the illusion of magic with a deck of playing cards. See for yourself how easy it is to learn... watch this video tutorial to see how to perform the erase the face card trick, where one card erases the faces of four or five playing cards, magically. You will need a special deck for this erase the face trick.

How To: Perform the what's up card trick

Impress all of your friends with some card magic, or as others like to say, card manipulation or card trick. You don't need to be a magician to learn the illusion of magic with a deck of playing cards. See for yourself how easy it is to learn... watch this video tutorial to see how to perform the what's up card trick, where a little of scotch tape comes in handy for when you throw the deck up in the air onto the ceiling, revealing the spectator's card, taped to the ceiling. What's up!

How To: Perform the four aces card trick

Impress all of your friends with some card magic, or as others like to say, card manipulation or card trick. You don't need to be a magician to learn the illusion of magic with a deck of playing cards. See for yourself how easy it is to learn... watch this video tutorial to see how to perform the four aces card trick, where you pick cards randomly out of the deck, put them into four piles and reveal four aces on the top of each pile.