Do a Magic Pen Tricks

How To : Add fiscal year sales 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 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMI ...more

How To : Count unique items in a list 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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust ...more

How To : Return multiple items by array formula 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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

How To : Calculate hours worked in days 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 598th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Fix a DGET #NUM! error 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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve ...more

How To : Look up formulas in Excel with the CHOOSE function

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

How To : Delete only cell content or formatting 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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selecti ...more

How To : Fix the nine most common types of Excel errors

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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to underst ...more

How To : Use comparative operators with letters 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 386th installment in their series of digital spreadsheet magic tricks, you'll learn how to add con ...more

How To : Format field names 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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format ...more

How To : Create a dynamic area chart 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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Randomly generate letters in an Excel spreadsheet

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

How To : Use a data table for what-if analysis 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, the 253rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a d ...more

How To : Generate a dynamic list from a table 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from ...more

How To : Use the BINOMDIST & NORMSDIST functions 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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various pr ...more

How To : Use the COUNTIF function 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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words ...more

How To : Use the SUMIF function in Microsoft Excel 2007

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

How To : Make Fireproof Gloves

Learn how to make your own pair of fireproof gloves for magic tricks or movie special FX. Fireproof gloves let you cover your hands with flammable butane & play with fire like never before. They will not damage or incinerate your hands because they are constructed of several l ...more

How To : Perform a thumb fan card flourish

Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a thumb fan card flourish, which shows you how to fan a deck of playing cards with ...more

How To : Perform a blue moon fan card flourish

Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a blue moon fan card flourish, where you fan two decks of cards at the same time i ...more

How To : Perform a companion fan card flourish

Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a companion fan card flourish, where you fan two decks of cards at the same time i ...more

How To : Perform a riffle fan card flourish

Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a riffle fan card flourish, which you can use to either fan your cards out, or as ...more

How To : Perform a fan spin card flourish

Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a fan spin card flourish, which shows you how to fan a deck of playing cards and h ...more

How To : Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how ...more

How To : Use FREQUENCY array functions 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 627th installment in their joint series of digital spreadsheet magic tricks, you'll ...more

How To : Rank numbers ten different ways 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 337th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank nu ...more

How To : Shoot cards into the air

This kid has great instincts for teaching magic or card tricks as he instructs with multiple camera angles the best methods for shooting cards in the air. He also has different finger and grip techniques for multiple cards and different spins.

How to Do card tricks : "Mismag822" card trick revealed

This is a video tutorial in the Magic & Parlor Tricks category where you are going to learn how to do card tricks: "Mismag822" card trick revealed. This is really easy for beginners. Ask someone to tell you a number from one to ten and count up those many cards from the deck a ...more

How To : Do the "impossible" card trick

In this Magic & Parlor Tricks video you will see the ‘impossible’ card trick. This card trick is performed by Andy field. First he removes all the 4 aces from the pack and puts them face up on the table. Then he chooses a card from the rest of the pack shows it to the camera w ...more

How To : Perform the "dyslexic queens" card trick

In this Magic & Parlor Tricks video tutorial you will see the "dyslexic queens" card trick. The 4 queens are laid out on the table face down; three in one line and the 4th below the top line. To each queen 3 red cards are added. These cards are between 1 to 10; no jacks or kin ...more

How To : Perform the one-handed revolution cut card trick

What to be a magician, but only when it comes to card tricks? Just Flourish will help you improve your magic skills with that deck of cards. This video specifically covers how to perform the one-handed revolution cut card trick. This basic "magic revealed" tutorial into the la ...more

How To : Perform the anti gravity ring trick

How do you make an object suddenly appear to defy gravity? I'll show you! No camera tricks, this is an up-close parlor magic trick! The ring travels not because of gravity but because of friction. Check out the illusion for yourself.

How To : Do the "jacks who would be queens" card trick

In this video tutorial, viewers learn how to do the "Jacks would be Queens" card trick. This trick begins with a story of 4 jacks who all want to become women. The magician begins with 4 identical jack of diamonds. The first jack is the bravest. He goes under the knife and end ...more

  • Hot
  • Latest