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 the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP 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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
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 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degrees and radians in Excel with trigonometric functions and formulas. Rad!
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 SUMIF & SUMPRODUCT functions.
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 multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
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 WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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 create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Try out this old school street hustler card trick. See if you can find where the queen is hiding, then see if you can perform the trick. It's a truly amazing card trick that will impress anyone, or enrage anyone (if money is involved). This hustling trick is known as the "three-card monte".
This is an amazing magic trick that can only be done with a new deck of cards. Watch the video to learn.
This is a magic trick in which you turn one small coin into two larger coins. First you need to place the two larger coins horizontally between your index finger and your thumb. Then you need to place the smaller coin vertically against your index finger and thumb as to conceal the two larger coins. Then when you make a motion with your hand you can slide the smaller coin down and have two larger coins.
Perform a Criss Angel card magic trick in which you make two chosen cards instantly jump from the middle of a jumbled deck and into your hand.
Ice that sinks? This is a weird trick shown and explained. Blow your mind, and that of your friends. This trick needs rubbing alcohol.
Magic is a wonderful thing. But so is science. So, which category does this mystifying candle trick fall in? Perhaps both.
In this two part tutorial, learn a very cool magic trick that will have people stunned! In this video, magician Jason Younger will teach you how to rip a full sized phonebook in half! The secret behind this trick is actually a lot simpler than you would imagine, and no one will be able to guess how you are doing it.
In this video, viewers will be watching the performance of the "whispers" card trick. The magician begins by shuffling the deck and asks the spectator to select 3 cards. Then they are laid face down and the magician takes all 4 of the queens out of the deck. He uses the queens as a guide and is able to tell the spectator the 3 faced down cards. Then he waves a queen over the 3 cards and places it down. The cards in his hands become the selection and the face down cards become the 4 aces. This...
In this video tutorial, viewers learn how to perform the double undercut using a deck of cards. This shuffle controls the bottom card. The trick begins with the magician asking the spectator to choose a card. Return the card on top of the deck. Then it will be shuffle and end up at the bottom. To do this trick, create a break between the card and the deck. Now cut the deck in half. The right hand packet is placed under the left hand packet. The card is now transferred to the right hand. The l...
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 kings. Now the top 3 stacks are picked up one by one shuffled and when turned over, the queen has vanished. All the 4 queens are found in the 4th stack. Then the 4 stacks are put face down with 4 queens in the 4th stack. On...
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!
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 proceeds to reveal the reality of the illusions before a captivated television audience.
Levitating has always been one of the most difficult and expensive magic tricks, usually involving a harness and rig. Thanks to the Balducci technique, it’s now one of the easiest and cheapest.
The key to many coin based magic tricks is proper "palming". In this tutorial, learn the basics of how to palm a coin and open the door for many tricks to follow.
In this video tutorial, viewers learn how to do the "my favorite ace" trick. The trick begins with all 4 aces. Then the magician flips them over and goes through them. As he goes through them, each ace changes the color of the back. All the aces change to a red back except for the ace of spades. Users will need 3 aces with the red back, the ace of spades with a blue back and a double back card. This video will benefit those viewers who enjoy magic tricks and would like to learn how to perform...
In this challenge, you need to grab the dollar bill without making the top beer bottle fall down. By just grabbing and yanking on the banknote, the bottle will fall. You need to grab the top beer bottle and slapping the bill away. Another way is to use pure speed. Try this "fast on the draw" beer bottle / banknote bar trick out and win money… or more beers.
Improve your magician skills with this magic card trick video lesson. This magical tutorial will show you how to perform a joker card trick. Doing a joker card trick just takes a little sleight of hand and practice. See the reveal of this cool card trick.
Improve your magician skills with this magic card trick video lesson. This magical tutorial will show you how to perform the color changing kings card trick. Doing the color changing king card trick just takes a little sleight of hand and practice. See the reveal of this cool card trick.
Improve your magician skills with this magic card trick video lesson. This magical tutorial will show you how to perform the self revealing card trick. Doing the self revealing card trick just take a little sleight of hand and practice. See the reveal of this cool card trick - a card is taken, then put back in the deck, then it flips over all by itself!
Learn how to make a simple but impressive magic trick. You can impress anyone with this card trick without setting up anything. Amaze your friends with this easy trick. Like a David Copperfield card trick.
You can learn three magic tricks that use cards. In the first trick, you push the front card forward and the card behind it backwards. In the second trick, you spread the deck and flip one card, but then pull it away. Be aware that the video ends abruptly before you can learn how to do the third trick.
This bar trick that will be sure to win you some beers. Plucking at the table cloth will slowly, but surely, pull the penny out from under the glass. Try this "coin limbo" party trick out yourself by watching this reveal.
A bar trick is just the thing to win a few bucks… or a few beers. With this "icebreaker" matchbox trick, you can do just that, until you're too drunk to do it anymore, and start losing beer and money. Anyways, the challenge is to put the bottom matchbox on the top while keeping your middle finger on the table at all times.
A great and easy to do trick. You can cut out a small hole and by bending the paper just right you can fit a much larger coin through it. This "large coin, small hole" bar trick is a great way to win money, beer or even just to impress the best.
