 |
See how to use the excelisfun YouTube channel: 1) Search ... Posted by: ExcelIsFun
Video duration: 274 seconds Global video hits: 27480 See how to use the excelisfun YouTube channel: 1) Search For Videos 2) Download Workbooks 3) Find Playlists With The Videos You Want! Excel How To Videos Excel Videos Learn How To Use Excel Videos Excel Tutorial Videos Excel Formula Videos Excel Functions Videos Excel Pivot Tables PivotTables Videos Excel VLOOKUP Videos Videos About Excel Related: excel, 2007, 2003, 2010, excelisfun, is, fun, learn, how, to, mike, gel, girvin, highline, community, college, formulas, functions, search, for, videos, download, workbooks, find, playlists, tutorial, advanced, basic, beginning, intermediate, formula, function, calculations, data, analysis Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 16: Scroll Bar For Percentage Posted by: ExcelIsFun
Video duration: 394 seconds Global video hits: 2234 See Mr Excel and excel is fun create scroll bars that will control a percentage in a cell. Mr Excel will do an ActiveX Control and excelisfun will do a Form Control. Related: excel, activex, control, form, scroll, bar, for, percentage, in, cell, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, duel, dueling Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? Posted by: ExcelIsFun
Video duration: 807 seconds Global video hits: 3059 See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) and excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions. INDEX and MATCH magic Related: excel, reverse, lookup, vba, macro, index, match, function, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, duel, dueling Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures Posted by: ExcelIsFun
Video duration: 554 seconds Global video hits: 696 See how to lookup a chart using Defined Names, Data Validation List, and a formula using the INDIRECT function inside a picture of a chart. Select from the drop down list and your chart appears. Related video: Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA? Related: excel, 2007, 2010, excelisfun, mike, gel, girvin, highline, community, college, lookup, chart, defined, names, indirect, function, and, formulas, in, pictures, picture Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columns Posted by: ExcelIsFun
Video duration: 310 seconds Global video hits: 332 See how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns. See the LOOKUP and SMALL functions. Related video: Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table Related: excel, 2007, 2010, excelisfun, mike, gel, girvin, highline, community, college, approximate, match, lookup, with, unsorted, column, across, multiple, columns, and, small, functions, table Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula Posted by: ExcelIsFun
Video duration: 490 seconds Global video hits: 484 See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula. Link for file: flightline.highline. edu Related: excel, 2010, aggregate, function, small, array, formula, mike, gel, excelisfun, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 638: Two Horizontal Axes for A Chart. Posted by: ExcelIsFun
Video duration: 312 seconds Global video hits: 503 See how to add two horizontal axes for a chart. Related: excel, 2007, 2010, excelisfun, mike, gel, girvin, highline, community, college, see, how, to, add, two, horizontal, axes, for, chart Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 648: Interesting Formula To Create A Data Set ROWS, COLUMNS and CAR functions. Posted by: ExcelIsFun
Video duration: 255 seconds Global video hits: 603 See the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set. Related: excel, 2007, 2010, functions, rows, columns, and, char, in, formula, that, will, create, data, set, excelisfun, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 649: Formula to increment number pattern 1,1,1,2,2,2,3,3,3... Posted by: ExcelIsFun
Video duration: 353 seconds Global video hits: 382 From Aladin and Hot Pepper at the Mr Excel Message Board see two great formulas to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3. Amazing formulas. Related: excel, 2007, 2010, aladin, hot, pepper, mr, message, board, great, formulas, to, increment, number, pattern, using, the, int, row, rows, functions, and, act, of, dividing, by, amazing, excelisfun, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set Posted by: ExcelIsFun
Video duration: 286 seconds Global video hits: 317 See how to create a formula to add a column of categories using the functions VLOOKUP, RIGHT, LEN, SEARCH: 1. Extract partial text from style description using RIGHT, LEN, SEARCH functions 2. Use VLOOKUP to look up category and fill column in data set. Related: excel, 2007, 2010, excelisfun, mike, gel, girvin, highline, community, college, extract, partial, text, from, style, description, using, right, len, search, functions, use, vlookup, to, look, up, category, and, fill, column, in, apparel, data, set Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick #4: Comparative Charts Posted by: ExcelIsFun
Video duration: 509 seconds Global video hits: 2667 See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values MrExcel's Learn Excel #985 - Dueling: Chart Types Excel Basics Chart Basics Highline Excel Class 05: Charts, Page Setup, Data Analysis Related: excel, bar, stacked, column, trendline, charts, to, compare, data, values, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, duel, dueling Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in? Posted by: ExcelIsFun
Video duration: 320 seconds Global video hits: 1871 See Mr Excel and excelisfun take math formulas stored as text and evaluate then using three methods: VBA, Excel 4 Macro Function or the MoreFunc add-in. See how to create a global universal relative Cell Reference in a Defined Name Formula. Related: excel, evalualte, text, math, formulas, vba, morefunc, add-in, macro, function, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, global, universal, relative, cell, reference, in, defined, name, formula Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 14: Trending Up Down Arrows Posted by: ExcelIsFun
Video duration: 449 seconds Global video hits: 2691 See Mr Excel and excelisfun create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers. See functions like: SIGN, IF, and CHAR. Related videos: Dueling: Up/Down Symbols - 1035 - Learn Excel from MrExcel Related: excel, sign, if, char, function, conditional, format, stock, value, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, duel, dueling Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 45: + or with Formula or Custom Number Formatting Math Plus or Minus Posted by: ExcelIsFun
Video duration: 277 seconds Global video hits: 1047 See Mr Excel and excelisfun: 1) create a formula to extract a number from a text string that can be used for calculations and 2) Use Custom Number formatting to make a number appear to have a leading + and -.See the functions LEFT, LEN, MID Related: excel, plus, or, minus, left, len, mid, functions, function, custom, number, formatting, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria Posted by: ExcelIsFun
Video duration: 269 seconds Global video hits: 1115 See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses the MIN and IF functions, Advanced Filter and the best solution amongst them all the DMIN function.! Find Earliest Date From List Of Dates Given 2 Criteria Filter or Formula Related: excel, filter, sort, min, if, functions, advanced, dmin, function, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, find, earliest, date, from, list, of, dates, given, criteria, or, formula Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP) Posted by: ExcelIsFun
Video duration: 473 seconds Global video hits: 2856 See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how to use INDEX & MATCH to solve this problem. Excelisfun will use the LOOKUP function to solve this problem. Related: excel, vlookup, to, left, index, match, lookup, functions, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, col Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 44: Count Mondays Between 2 Dates WEEKDAY or TEXT? Posted by: ExcelIsFun
Video duration: 244 seconds Global video hits: 617 See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function. Mr Excel uses SUM and Ctrl + Shift + Enter and excelisfun uses SUMPRODUCT and Enter. Related: excel, count, mondays, between, two, dates, weekday, or, text, row, indirect, sum, sumproduct, function, functions, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick #5: Horizontal Subtotals Posted by: ExcelIsFun
Video duration: 618 seconds Global video hits: 2154 See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting for non-contguous cell ranges using a TRUE FALSE logical formula with the NOT symbols. Related: excel, horizontal, subtotals, sumif, function, formula, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, duel, dueling Display Video Comments | Hide Video Comments | Add Comment |
 |
Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table Posted by: ExcelIsFun
Video duration: 486 seconds Global video hits: 1285 See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his lookup with the MIN, IF, MATCH and INDEX functions. See excelisfun use the SMALL, ROWS and LOOKUP functions to sort the table inside the formula and to an approximate match. PodCast 1144 Learn Mr Excel Amazing Excel Trick. Related: excel, vlookup, approximate, match, unsorted, table, excelisfun, bill, mr, jelen, mike, gel, girvin, highline, community, college, small, rows, lookup, min, if, index, function Display Video Comments | Hide Video Comments | Add Comment |
 |
excelisfun Search for Excel Videos, Playlists & Download Workbooks Posted by: ExcelIsFun
Video duration: 237 seconds Global video hits: 146423 See how to find the Excel video that you want to see. See how to search for Excel videos, Excel Playlists and download the Excel workbooks with examples and notes at the excelisfun channel. Related: excel, 2003, 2007, 2010, how, to, download, workbooks, serach, for, videos, find, playlists, mike, gel, girvin, highline, community, college, formulas, functions, vlookup, pivot, tables, array Display Video Comments | Hide Video Comments | Add Comment |
| Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
Latest comments made on this video: