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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.
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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.
Have you ever tried to erase the background on an image so you can use the object image to layer with another document? You can do it in Adobe Photoshop, but if you don't know what you're doing, it could take hours… days to extract that image you want. But with Photoshop Elements, there's a handy tool called Magic Extractor that helps you get some of the dirty work out of the way, so you can concentrate on the finer details. Watch this video to see how it's done.
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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.
In this video tutorial, viewers learn how to three easy tricks. The first trick is the coin in the hand. The magician drops a penny into the spectator's hand 3 times. on the third time, the coin ends up being a nickel instead of a penny. The second trick is vanishing coin. The magician simply takes a coin, blows on it and it appears under his elbow. The third trick is the throw away card. The magician holds a card, throws it away and magically makes the card appear back in his/her hand. This ...
In this video tutorial, viewers learn how to do a finger palm coin vanishing magic trick. The user begins placing a coin in their hand on the middle and fore finger. It should be placed where the fingers meet the palm of the hand. Flip the coin over a couple of times, and make sure that it stays. Then the user tells the audience that they will place the coin into the other hand. As the user pretends to toss the coin into the other hand, they should give the illusion that it is in the other ha...
In this video tutorial, viewers learn how to force cards. Card forcing is when it looks like the users has a free selection of cards, but in reality the magician has predetermined a card to be selected. The force taught in this video is the cross cut force. Take the desired card on top of the deck and place it face down on top. When you shuffle the deck, make sure that the desired card always remains on the top of the deck. This video will benefit those viewers who are interested in magic, an...
In this video tutorial, viewers learn how to do the drop coin vanish magic trick. The magician begin by holding onto a coin and shows the audience that the other hands is empty. Then the magician takes the coin with the other hand and starts to rub it. When he opens his hand, the coin has been vanished. To do this trick, hold onto the coin in between your thumb, index and middle fingers. The coin should be down about half way. They key is to create an illusion that you're taking the coin, whe...
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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...
In this video, learn how to convert iTunes m4a files into mp3's so that you can share and listen to them anywhere. This tutorial will also show you how to bypass the restrictions on the program and convert as many files as you like for absolutely free.
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.
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 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and 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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
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 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...
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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS 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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID 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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF 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 284th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a line chart from years and percentage change. See how Excel makes the chart wrong, but then see how to fix it.
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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing 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 MS Excel tutorial from ExcelIsFun, the 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.
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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.
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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table 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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time 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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.
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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.
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 add a mean value as a scatter diagram data series to a box plot or box & whisker that is set up as a bar chart.
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.
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.
