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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
Have a digital image that's a little bit too dark or otherwise lacking in depth? Your fix is just a few mouse clicks away. This free software tutorial will teach you how to use the new Brightness & Contrast tools within Adobe Photoshop CS5. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free 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 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and 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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special 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 598th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate hours worked given an in time, an out time and an in and out time for the lunch break. Learn about how time in Excel is the proportion of one 24 hour day.
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
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 11th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create a formula that will randomly select a name from a list of names without having the list of names sitting in cells.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM 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 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in VLOOKUP 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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP 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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data 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 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special 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 575th installment in their series of digital spreadsheet magic tricks, you'll learn how to selectively delete. Specifically, you'll se how to delete the cell contents only, formatting only, the entire cell, or formatting and content together.
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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with 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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
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 386th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting for letters less than the letter M. Yes! Comparative operators like less than (<) work on letters!
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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.
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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.
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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades 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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.
By default, iPhoto will open as soon as your Mac detects a digital camera or iPhone. In this tutorial, learn how to change your iPhoto settings so that it does not automatically open. The auto open is a good feature, but can be annoying, especially if you are just using your computer to charge your device and do not need to import any files. iPhoto's auto-open can disrupt other activities you may be involved in on your computer. In this video, Luke will take you step by step through the proce...
