Magic School 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: Clean your American Girl doll's skin with a magic eraser

In this video, we learn how to clean your American Girl doll's skin w/ a magic eraser. First, soak your Mister Clean Magic Eraser and then squeeze the water out. From here, undress your doll and put its hair up. Then, take the eraser and rub it onto the doll's skin to clean it. Rub it gently and scrub any parts that are especially dirty. If this isn't working, add on some baking soda and scrub it further until all residue is gone. Continue to do this throughout the entire doll and then when f...

How To: Perform brusspup's "Amazing Shampoo Trick"

In this video tutorial from YouTube's brusspup, we learn how to perform the "Amazing Shampoo" magic trick. For more information about the trick and its execution, including detailed, step-by-step instructions, and to get started incorporating this trick into your own routines, watch this free video magic lesson.

How To: Perform the "Amazing Stick Trick"

In this video tutorial, we learn how to perform the "Amazing Stick" magic trick. For more information about the trick and its execution, including detailed, step-by-step instructions, and to get started incorporating this trick into your own routines, watch this free video magic lesson.

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: Make a magic paper ninja star

This video tutorial is in the Arts & Crafts category where you will learn how to make a magic paper ninja star. For this you will need 8 sheets of square paper, all of the same size. Fold one sheet in half, open it up and fold both corners of one edge inwards along the centerline. Now fold the whole sheet in half inwards. Then fold the lower part in a triangular pattern, make a crease and open up the sheet. Fold the lower part inwards from the center and collapse the sheet over the fold. Do t...

Become a judge for Magic: The Gathering

In this video tutorial, viewers learn how to become a judge for the card game, Magic: The Gathering. The best way to join is to contact a level 2 judge. Judges must put rules in context. If confused or unsure, use online forums for a guide. Interact with the judge community. You don't have to be a certified judge to run a local event. The tournament policies and procedures can be found in the Universal Tournament Rules, Floor Rules or PCI Penalty guidelines. This video will benefit those view...

How To: Use VLOOKUP to add a column of categories 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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.

How To: Do the key card magic trick

In this video tutorial, viewers learn how to do the key card magic trick. The magician begins by shuffling the deck and ask the spectator to select a card. The spectator will remember the card and the magician will place the card on top of the deck. Then the magician lets the spectator cut the deck numerous times. Now the magician starts to deal the cards face up one at a time. The magician asks the spectator to look for the card, but not to tell him/her. Then the magician turns over the key ...

How To: Clean an Apple keyboard with Mr. Clean Magic Eraser

Keyboards get really dirty from your hands, food, spilled drinks, pens, pencils and everything else that winds up on your desk. This video will show you a great way to clean you white Apple keyboard (wireless or wired) so that it shines like you just bought it. All you need is a handy cleaning product called Mr. Clean Magic Eraser. This will get all of the dirt off of your white keys that come with Mac computers. Make sure to clean the keys and the inside between all of these keys as well. Ma...

How To: Do the auto reversal magic card trick

In this video, viewers observe the auto reversal magic trick. The magician begins by telling the spectator to select the card. Once selected, the magician places the card back into the middle of the deck. The magician then reveals that he/she has no card markings. Now the magician tells the spectator that he will find the card behind his own back. The magician starts shuffling the cards behind his back. The first card that shows up is not the selected card, so the magician goes through the de...

How To: Do the Chinese sticks magic trick

In this video tutorial, viewers learn how to do the Chinese sticks magic trick. The magician begins by showing the audience the two Chinese sticks together. When he pull the string down on one side, the other one goes up. Do this a few times to make the audience believe there is a string between the sticks. Then separate the two sticks to show the audience that there is no string between the sticks. But the magician is still able to pull the string down on one side and the other side will go ...

How To: Do the card on a rope magic trick

In this video tutorial, viewers learn how to do the card on a rope magic trick. The materials required for the trick are: deck of playing cards, rope, magnets and a bag. The magician begins by allowing the spectator to randomly select a card from the deck. Then the spectator places the card back in the deck and shuffles it. The deck is then placed into the bag. The magician takes a rope, places it into the bag and fishes out the select card. This video goes over the preparation and techniques...

How To: Perform a "black hole" magic trick with cards

Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform a "black hole" card trick using simple sleight of hand. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.

How To: Count with more than 1 criteria 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 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.

How To: Decrease 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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.

How To: Extract items not having a given text value 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 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.

How To: Control percentages with a scroll bar 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 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.