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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND 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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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."
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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!
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.
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 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).
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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks 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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
