Do a Magic Pen Tricks

How To : Create a daily Gantt Chart in Microsoft Excel

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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart usi ...more

How To : Use an array formula to filter data 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering ...more

How To : Extract the top five records from a table 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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e ...more

How To : Format a cell with reference to another 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 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional f ...more

How To : Use the SUMIF & SUMPRODUCT functions in MS Excel

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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the ...more

How To : Replace a long IF with a MIN/MAX formula in Excel

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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF ...more

How To : Use VLOOKUP with multiple lookup values in Excel

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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with m ...more

How To : Format dates with the WEEKDAY function in Excel

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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEE ...more

How To : Create dynamic sub tables in Microsoft Excel

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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub ...more

How To : Create a dynamic weekly chart in Microsoft Excel

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 262nd installment in their series of Excel magic tricks, you'll see how to create a Weekly Chart that can sh ...more

How To : Create a dynamic data validation list in Excel

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 549th installment in their series of Excel magic tricks, you'll learn how to create a dynamic data validatio ...more

How To : Create a data validation list in Microsoft Excel

If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation t ...more

How To : Make your own Masked Magician mask

Make a Magician's Mask Have you ever heard of the Masked Magician? With the television series Magic's Biggest Secrets Finally Revealed, the so-called Masked Magician (Val Valentino) revealed secret after secret of the magicians repertoire. Valentino creates “the magic” then p ...more

How To : Perform the Double Lift card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Practice MagicBen's false cut magic card flourish

Practice this false cut. This tutorial on card magic and card trick flourishes is by MagicBen. This is the false cut, which is a staple move in learning and expanding your card trick repertoire. This is important for both card tricks for magic and trick plays in poker or black ...more

How To : Do the Hamman count card trick

See how to do the Hamman count card trick. Anyone wanting to be a magician should have the Haman count down. It's a necessity for completing more advanced magic card tricks. Just watch this video tutorial to see the reveal. This might also be a sleight for the call of the wil ...more

How To : Do the Elmsley count card trick

See how to do the Elmsley count card trick. Anyone wanting to be a magician should have the Elmsley count down. It's a necessity for completing more advanced magic card tricks. Just watch this video tutorial to see the reveal.

Friday Fresh : Get Started on Starcraft 2 and More

Every day of the week, WonderHowTo curators are hard at work, scouring the web for the greatest and most inspiring how-to videos. Every Friday, we'll highlight our favorite finds.Make a fireball you can hold in your hands. Bone up on Starcraft 2 The Starcraft 2 Beta may have ...more

How To : Perform the Spelling Bee card trick

Check out this episode of Brian Brushwood's Scam School from Revision3 to find out how to pull the best cons, bar scams and magic tricks. It's rare to find a trick that you can actually fool yourself with...and that's exactly what you get with this episode! In fact, grab a de ...more

How To : Calculate the vest date for a contract in MS 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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the EDATE functi ...more

How To : Use precision number rounding in Microsoft 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 237th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MROUND, CEIL ...more

How To : Perform the Pass for card tricks

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Fan a deck of cards for card tricks

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Toss Up Vanish card trick

Every magician needs to know how to do a little manipulation with playing cards! So grab a deck and get ready to learn The Toss Up Vanish! You need a single playing card to perform the Toss Up Vanish. Sometimes we use materials that require adult supervision... like scissors s ...more

How To : Perform the All Sorted card trick

Want to learn a great card trick that will really fool your friends? All you need is a deck of cards to perform this cool trick! You will need one deck of cards. Sometimes we use materials that require adult supervision... like scissors so make sure you have friends and family ...more

How To : Perform the Cutting The Deck card trick

Do you want to be a magician? Well then join Ryan Oakes and his assistant Damian as they show you a great card trick called Cutting the Deck! You will need one deck of cards, a pencil and a piece of paper. Sometimes we use materials that require adult supervision... like sciss ...more

How To : Perform the Out of This World card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Jack in the Hole card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the 21 card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the two card monte card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Ace Assembly card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform Criss Angel's Deck Change card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Sneak-A-Peak card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Hot Shot card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Joker's Wild card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Biddle Trick card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Temperature card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

How To : Perform the Card-Toon card trick

How to Disturb Reality is here to teach you some magic card tricks that you can learn directly at home. This video will hopefully inspire you to become a great magician, so if you're here to just learn card tricks and not perform them, you're here for the wrong reason! With t ...more

  • Hot
  • Latest