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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.
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.
Looking for a way to stop the clock and game your Bejeweled Blitz score? Check out this video tutorial to learn how to hack Bejeweled Blitz (04/11/10) with a Mozilla Firefox extension, which will teach you to do just that.
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!
In this video tutorial, viewers learn how to do a switch kick-flip on a skateboard. It is the same as a regular kick-flip, except you switch your stance. Users should be able to perform a regular kick-flip before attempting this trick. Start with the front foot near angled near the bolts and back foot on the tail of the board. Pop the tail hard and flick the front foot outwards. Make sure that your weight is centered and do not lean to far back or forward. This video will benefit those viewer...
In this video tutorial, viewers learn how to fix an Xbox360 with the towel trick. This technique is for an Xbox360 that has the 3 red flashing lights on the power button and does not function properly. Begin by unplugging all the cables from the Xbox360, except for the power cable. Then turn on the console and wrap it in 3 towels. Leave it to heat up for 25 minutes. Now unwrap the console and turn off the power. Let it cool off for 15-20 minutes. This video will benefit those viewers who have...
This is a demonstration of performing the green triangle yo-yo trick. You can start with a trapeze, lift your non throw hand middle finger and swing the yo-yo off the trapeze. Take care that you do not drop the yo-yo, you can use the middle finger to hold the string. Swing just like doing the trapeze so that the string lands at your wrist. Slide your throw hand out of the loop and you will form the green triangle. To dismount pop the yo-yo out of the green triangle and land on the string near...
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.
The commentator tells viewers they will learn how to make smoke from their fingertips. First you must tear the strip off of a matchbox. Then place the strip in an ashtray, facing upside down. Light the strip on fire and let it burn for a little while. Push the burned strip to one side of the ashtray and there will be a brown-yellow residue left in the bottom of the ashtray. Wipe the residue off with one of your fingers and then proceed to rub your fingers together. Smoke will then come from y...
In this video from Dom Bower Photography, he demonstrates how to make it look like a person is levitating in a photo. He sets the timer on the camera and takes the picture of himself. It takes a few tries to get a picture where he is airborne when the picture is taken. The trick is to try to pose while jumping so that it doesn't look like you're jumping. It might take a few tries, but if you use some of the tricks shown in this video, you'll be able to take a picture that makes it look like a...
Ever worry about your breath after eating an onion? Well, follow along as food editor Ian Knauer gives us a trick on how to get rid of the dreaded onion breath.
In this video tutorial, viewers learn how to perform a kick flip on a skateboard. is a skateboarding trick where the skateboarder drags his front foot at an angle up the nose of the skateboard in order to make it flip 360 degrees along the board's axis. Begin with back foot in an ollie position, while front foot is angled. Start by sliding the foot onto the toe kick outwards behind you. After sliding, you will need to jump and keep feet away from the board's spin. As you see the grip tape com...
Want a card trick to amaze and wow your friends? With just a normal deck of cards, you can fool and fascinate your friends by just following this video. First of all, go through your deck and grab 12 diamonds, 6 clubs, 3 hearts and 2 spades. Now hand these cards to your friend and have them shuffle and mix them up. With probability, the chance of a diamond showing up is over 50 percent. So all you have to do is predict that the card on the top of the deck is a diamond. More than half the time...
Mismag822 shows you how to perform the "best little self working" card trick. Get your mini deck of cards and count out 16 cards. Shuffle the cards out and lay them out in a grid. Select 4 cards over the deck. Then the other person selects a row and fold it over like a book. Keep folding till you have one deck. Spread out the cards 4 should be face down. The four cards that are left should be all aces.
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.
Just follow a few steps to simplify algebra with the minus one trick. First step is to take two algebraic equations with having numerator and denominator algebraic equations. Second step is to divide the denominator with numerator. For example, it have like -c/c, it gives like answer as -1, but we have another type like (c-a)/(a-c) - to solve these types of steps, like multiply numerator with minus(-), it gives the common the minus and -(a-c)/(a-c), then it gives -1 as a answer.
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
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.
Tired of not being able to quit smoking? Have you tried everything but nothing works? Watch this life changing short video and learn the trick of quitting smoking by simply using a pen cap. Watch this video and listen to MAtt Jarbo's story on how he fought off smoking for ever. All you need is a BIG pen cap and you will be able to fight off the cravings of smoking. No other thing needed just follow his tricks and you will soon not smoke anymore.
In this Excel magic trick video the tutor shows how to print labels on each page of a large spreadsheet in Microsoft Excel. He shows how to download the sample work book so that you can try the tutorial hands-on. He shows a spread sheet which he intends to print and wants the label of columns to be printed in the top and left of a page. For that he shows the page setup preview where you can check the print preview of the pages about to be printed. He shows that the columns appear on only the ...
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
In this tutorial the author explains of how to compute percentages of a given number. He explains that x percent of some number y is x multiplied by y and divided by 100. He says that of means multiply and percentage means for hundred. He goes on and explains this concept with numerous examples. He suggests a small trick to move the decimal point of a number two digits to the left to get it divided by hundred. The author demonstrates many more similar tricks and short cuts using which one can...
By following this tutorial, you can learn how to easily make a train whistle sound using only your hands. You can replicate the sound of a train whistle by simply folding your hands and adjusting for the airflow as you blow on your thumb knuckles. This is a very easy trick to learn, so with just a little practice, you can use the train whistle to play with your kids, call them to dinner, etc. It's a great trick for somebody who has difficulty with conventional whistling.
