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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.
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 192nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the middle name in quotes from a cell that has last, middle and first name using Excel's in-built text-to-column tool.
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
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 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average 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 MS Excel tutorial from ExcelIsFun, the 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY 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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF 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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW 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 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.
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
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 formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
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.
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.
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!
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!
Show off your card trick skills with a little XCM (extreme card manipulation). This video tutorial will show you how to perform the Lang-Pentagon Display card flourish. There's no magic involved here, just some card manipulation for a great show. The card flourish is a technique for card handling that magicians use, perfect for making card tricks more impressive. See how to do the Pentagon Display.
Show off your card trick skills with a little XCM (extreme card manipulation). This video tutorial will show you how to perform the Lang-False Cut Combo card flourish. There's no magic involved here, just some card manipulation for a great show. The card flourish is a technique for card handling that magicians use, perfect for making card tricks more impressive. See how to do the False Cut Combo.
Show off your card trick skills with a little XCM (extreme card manipulation). This video tutorial will show you how to perform the Lang-Surprise Display card flourish. There's no magic involved here, just some card manipulation for a great show. The card flourish is a technique for card handling that magicians use, perfect for making card tricks more impressive. See how to do the Surprise Display.
Tired of card tricks? Learn some coin tricks! Up your magic expertise with this video tutorial on how to magically turn one dime into two quarters. You can even turn that dime into more than two quarters if you'd like. You just need a little practice and a little sleight of hand.
Lovely easy MAGIC with solution! Try it!! All you need is a match and some saliva. Be discreet about applying the saliva & impress your friends by balancing it on its head. Fun & easy bar trick.
Been practicing a few pen spinning tricks? Check out this pen spinning magic trick to learn how to get at least two spins with a continuous backaround. This move looks nice in a combo move. Learn the multiple backaround movement and you can start performing 3-6 backarounds in a row like a pen spinning pro!
Want to gross out your friends with a magic trick that makes it look like you pierced your chin with a drinking straw? Well, here goes. This is a really simple prop trick. You need a pre cut straw.
More trick shuffles for magic or poker. Keep the cards you want, where you want them allowing you to deal yourself a certain poker hand, or keep a spectators card where you know you can find it again.
This is a great video tutorial showing how to do the Four Aces magic trick. Spell out each suit and watch as the Aces magically appear.
An easy self working magic trick that requires no sleight of hand.
An explanation of the Mind Merge card magic trick.
This video reveals how the vanishing water trick works. It is not magic but chemistry. Music: Kevin MacLeod
This shows you how to turn an ordinary cigarette into cash. Stump your friends with this simple magic trick.
Learn a card magic trick in which you quickly and sloppily break a deck into to piles. Then find chosen cards from each half after an audience member shuffles them back together.
Learn a magic trick in which you appear to drive your finger straight through a bottle cap.
Here is an inventive way to retrieve an egg once it has been magically placed into a bottle. Dazzle the audience with two magic tricks in one as you make an egg appear in a bottle and then magically make it appear outside of the bottle. This is a great two for one trick that takes only minutes.
A tutorial for a beginner's magic trick - the basic card teleport, in which you appear to make a card placed in the middle of a deck magically reappear at the top.
