How To: Levitate a Paper Cup Using Magic
In this tutorial, learn how to trick your audience into thinking you can control things with your mind!
Mind Filing Search Results
How To: Remove and replace a drill press chuck
Like any machine, a drill press chuck is prone to wear and tear and with repetitive usage some parts can become unaligned. If you are going to remove a drill press chuck, keep in mind that also with any machine you work with, you'll want to clean off any gunk that accumulates so you have a properly working machine.
How To: Use content-aware scaling in Photoshop
Adobe Photoshop's got some great tools to make your photos look excellent. This video tutorial will show you how to use the content-aware scaling feature in Photoshop. This feature helps you resize content without changing the most important visual content. Once you see the beautiful, gorgeous results, your mind will be blown.
How To: Write an analytical proof of the quadratic formula
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to write a formal analytical proof of the quadratic formula.
How To: Round only the total column with SUM & ROUND 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, the 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
How To: Convert hours to days & days to hours with Excel's MOD
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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT functions.
How To: Calculate bonuses based on years worked in MS 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, the 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
How To: Allow only Monday dates in a cell in Microsoft 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, the 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
How To: Count with four criteria in Microsoft 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, the 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
How To: Count times exceeding 5 minutes in Microsoft 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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
How To: Retrieve the last value from a row in Microsoft 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 6th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to retrieve the last value in a row.
How To: Run a two-way lookup on a table array in MS 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 very first installment in their joint series of digital spreadsheet magic tricks, you'll learn how to do a two-way lookup on a table array.
How To: Count rows that meet three criteria in Microsoft 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, the 586th installment in their series of digital spreadsheet magic tricks, you'll learn how to enumerate rows that meet 3 using the SEARCH function.
How To: Increment column numbers for an Excel 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 335th installment in their series of digital spreadsheet magic tricks, you'll learn how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).
How To: Count between two numbers with Excel's DSUM & DCOUNT
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 use the DSUM and DCOUNT functions to sum or count between an upper and lower limit.
How To: Geometrically prove the Pythagorean theorem
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to perform a geometric proof of the Pythagorean theorem.
How To: Do bankers' and arithmetical rounding ways in MS 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, the 521st installment in their series of digital spreadsheet magic tricks, you'll learn how to round numbers two different ways.
How To: Use the * and ? wildcards in Microsoft 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, the 561st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the * and ? COUNTIF wildcards in Excel.
How To: Automatically insert symbols in Microsoft 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, the 391st installment in their series of digital spreadsheet magic tricks, you'll learn how to use custom number formatting to insert symbols automatically.
How To: Create a line chart mapping blood pressure in MS 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, the 361st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures.
How To: Create a mortgage calculator in Microsoft 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, the 355th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP to create a mortgage calculator that can handle four different types of loans: begin annuity, end annuity, interest only and "other."
How To: Highlight Excel values repeated a set number of times
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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the COUNTIF function to highlight values that are repeated a given number of times.
How To: Convert written math statements into Excel equations
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 352nd installment in their series of digital spreadsheet magic tricks, you'll learn how to convert written math statements into equations using Excel.
How To: Fix #DIV/0 errors with Excel 2007's IF & ISERROR tools
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 333th installment in their series of digital spreadsheet magic tricks, you'll learn how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF & ISERROR functions.
How To: Count words with the COUNTIF function 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, the 266th installment in their series of digital spreadsheet magic tricks, you'll learn see how COUNT and COUNTA have trouble counting only words or text and how to use a handy workaround.
How To: Randomly generate whole numbers in Microsoft 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, the 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.
How To: Add & count above a specified limit in Microsoft 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, the 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
How To: Extract characters without leading zeroes in MS 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, the 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.
How To: Make an Excel Gantt chart that highlights workdays
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 327th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color.
How To: Deal with a circular reference warning in MS 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, the 214th installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with a circular reference warning in a formula.
How To: Create a hyperlink from one Excel sheet to another
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 326th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a hyperlink from one sheet to another in the same workbook.
How To: Extract substrings with Microsoft Excel's MID 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 317th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data (specifically, a substring from string) using the MID Function.
How To: Use Excel's DSUM & DMAX functions with date 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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date criteria.
How To: Invert a range of values in Microsoft 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, the 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
How To: Sum only certain columns in Microsoft 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, the 297th installment in their series of digital spreadsheet magic tricks, you'll learn how to select varying columns for summing (adding).
How To: Fix date problems in Microsoft 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, the 301st installment in their series of digital spreadsheet magic tricks, you'll learn how to change Regional Settings to force Excel to accept 20th century (1900) dates.
How To: Do time calculations with Microsoft Excel's MOD
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 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM.
How To: Count codes from a column of text in Microsoft 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, the 290th installment in their series of digital spreadsheet magic tricks, you'll learn how to count codes from a column of text strings that have multiple codes.
How To: Reduce a column of numbers by a percentage 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, the 275th installment in their series of digital spreadsheet magic tricks, you'll learn how to reduce a column of numbers by a set percentage (in this case, 35%) quickly!
How To: Create sequential numbers in Excel formulas with ROWS
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS function.