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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools 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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
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 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
Polymer clay has become a very popular modeling material. This narrator uses magic gloss UV resin and a needle tool for this video. A silicone pad is useful for the mixing process. Once a small amount of resin has been squeezed out, you can sprinkle glitter onto it, spread it out and allow it to cure a little. Once this has happened, a pressed flower can be stuck onto the surface and sandwiched between another layer of Magic Gloss. Once hardened, the flower is encased in the clear layers. Thi...
This video shows you how to perform the magic card trick "The Kicker". In poker when you have four of a kind, the fifth card in your hand is called the Kicker card. It's usually meaningless unless you have a tie where it is used to determine the winner. In this trick you learn how to use the kicker card, in this case a 10 of hearts, to find the four aces inside a deck of cards as if by magic. This trick is based on math rather than sleight of hand, once you arrange the deck as you learn in th...
In this video, the host, Mr. G teaches you an array of seemingly impossible magic tricks. Not only is it entertaining, but a viewer can learn how to scam money out of their friends. My only suggestion is that the steps for completing the tricks were explained in detail. The viewer see's the tricks but is not capable of recreating after the video. Overall, it is a good video, which offers a strong general idea on how to complete these magic tricks.
Check out this not-so-magic trick. Moving only three toothpicks, you can invert a toothpick pyramid. It's an easy and fun bar trick you can show anyone. It's great for parties and entertaining. For more magic tricks, search for magic tricks on WonderHowTo.
This magic trick is for the kids! It's a simple magic trick (or illusion) that will have your kids wondering if you really do have magical powers! Watch to see how to make one coin turn into two coins with just a pen. You'll need a razor blade to hack into the pen, to hide the coin, but it's worth it.
Lots of people love magic, and most of those people like card tricks, so why not learn a few? Whether you're a magician or not, you can still impress your friends with a few card tricks up your sleeve.
Lots of people love magic, and most of those people like card tricks, so why not learn a few? Whether you're a magician or not, you can still impress your friends with a few card tricks up your sleeve.
Improve your magician skills with this magic prop trick video lesson. This magical tutorial will show you how to perform the rubber band magic trick. Doing the melting rubber band trick just takes a little practice and a little bit of illusion. See the reveal of this cool trick.
Improve your magician skills with this magic prop trick video lesson. This magical tutorial will show you how to perform the broken and restored pencil magic trick. Doing the broken and restored trick just takes a little practice and a little bit of illusion. See the reveal of this cool trick.
Learn how to do the "melt through" coin and pen magic trick. This magic trick will make a pen slide right through a coin of your choice without any gimmicks. It's a pretty simple trick for anyone, if you're a fast enough magician. The melt thru is perfect for beginners.
See how you can impress your friends and family with magic! Watch this video tutorial to learn how to perform the invisible ace magic card trick. With a little sleight of hand, card tricks are easy. You just have to practice, like all good magicians do. See the reveal of the invisible ace card trick!
Magic is easy, especially when you learn online, with a video tutorial like this. See how to perform the "Biddle trick" magic card trick. You'll first see the performance, and then you'll see the instructions on how to perform this Biddle card trick yourself. There's no gimmicks and it's impromptu.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "ace thru four rearrange" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "this 'n' that" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "card switch" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "greatest card trick in the world" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform a magic mathematical card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "snap change" card trick.
Do you want to be the next David Blaine, Chris Angel or David Copperfield? These magicians know how to do magic right, and they know how to do card tricks right, but why can't you? Just watch this video tutorial to see how to perform the magic "card jump" card trick.
The goal of this video tutorial is to teach you how to perform the "coin through sugar packet" magic trick. This instructional is to help anyone wanting to be a magician, helping you understand technique and presentation of simple but effective illusions. These tricks are pretty easy, but with time, practice and patience you will be able to amaze your friends and your family. Learn the coin through a sugar packet magic prop trick.
Need a hobby? The yo-yo is the perfect to for anyone in need of a hobby to keep them busy. Did you know that it's also one of the oldest toys around, and that modern yoyo's have been born and perfected in Santa Barbara, California? Did you know there's millions of tricks out there for your disposal, for your fun, for your arsenal? In this video tutorial, learn how to do the "magic knot" yo-yo trick. The magic knot thing is a great advanced trick.
What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "year game" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this year game card trick, a little mathematics goes a long way, so don't fall asleep in math class.
What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "impossible card location" magic trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this impossible card location card trick, a little mathematics goes a long way, so don't fall asleep in math class.
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 two-handed swing cut card trick. This basic "magic revealed" tutorial into the land of card tricks will show you just how to do the swing cut.
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 pivot cut card trick. This basic "magic revealed" tutorial into the land of card tricks will show you just how to do the pivot cut.
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 Charlier cut card trick. This basic "magic revealed" tutorial into the land of card tricks will show you just how to do the Charlier cut.
It's magical! The Magic Light Brush knows what color you are using and magically reveals the color of clear Color Wonder paint. This is a great mess free product to use for your child's next art project. This tutorial teaches you and your child how to use the Crayola Color Wonder Magic Light Brush the next time you want to paint.
