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.
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 733rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate expected returns for a portfolio 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 734th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to convert decimal grades to integer grades in Excel.
One of the most famous miracles of Jesus is turning water into wine. This process is not easy for the mortal to perform, but it is possible using modern chemistry. Watch this video to learn how to perform a water into wine magic trick with powerful acids which you MUST be careful handling.
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 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to add a column of numbers ignoring #N/A 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 723rd installment in their series of digital spreadsheet magic tricks, you'll learn how to avoid errors with the COUNTIF function when using workbook references by using the SUMPRODUCT 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 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked while subtracting time spent at lunch.
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 721st installment in their series of digital spreadsheet magic tricks, you'll learn how to to go from a time of 0655 to 06:55 AM with the TEXT 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 703rd installment in their series of digital spreadsheet magic tricks, you'll learn how to filter with 6 criteria then extract records to a new location.
How can duct tape be magical? When it you turn it into a magical duct tape wallet. The "magical" part of the wallet is that it can be flipped around to reveal a secret compartment.
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 693rd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate how long it will take to double your money using the NPER function and the rule of 72.
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.
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...
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...
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.
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 ...
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...
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
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...
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 ...
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...
You'll put Mr. Lance Burton out of business once you acquire how to make these easy but impressive magic cubes. Made out of many thin sheets of paper, these cubes are attached to one another without glue or tape and move a full 360 degrees.
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 89.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use absolute and relative macros in concert with one another.
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.
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.
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.
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.
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.
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 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.
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 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.
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 8th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to deal with common filtering problems.
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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.
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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic, two-way IF function lookup formula for pulling data from a 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 MS Excel tutorial from ExcelIsFun, the 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 501st installment in their series of digital spreadsheet magic tricks, you'll learn how to work with time in Excel, making calculations and formatting temporal 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
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 517th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions to show vendor name associated with lowest bid.
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 524th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records with partial text NOT criteria via filter, advanced filter & array formula.
