View Detailed Profile
Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets

Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets

See

Mr Excel & excelisfun Trick 164: Sometimes VBA Is The Only Way To Go: Formula Too Long

Mr Excel & excelisfun Trick 164: Sometimes VBA Is The Only Way To Go: Formula Too Long

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick164.xlsm Download workbook: ...

YTLE#63: Array Formula: Vendor Max Rating Min Cost

YTLE#63: Array Formula: Vendor Max Rating Min Cost

Download

Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!

Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick27.xls See

Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula

Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula

Download Files: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick63Start.xlsx Finish File: ...

Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUND

Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUND

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelIsFunTrick92.xlsx Download workbook: ...

Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting?

Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting?

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick69-72.xlsx See

Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas

Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/

Mr Excel & excelisfun Trick 30: Count Bills for Money Transaction

Mr Excel & excelisfun Trick 30: Count Bills for Money Transaction

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick30.xls See

Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCH

Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCH

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick46.xls See

Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT

Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick39.xls See

Mr Excel & excelisfun Trick 99: Recorded Macro: Double-Click Fill Handle Trouble

Mr Excel & excelisfun Trick 99: Recorded Macro: Double-Click Fill Handle Trouble

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick99.xlsm Download workbook: ...

Mr Excel & excelisfun Trick 12: Sort Numbers With Formula

Mr Excel & excelisfun Trick 12: Sort Numbers With Formula

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcel&ExcelisfunTrick12.xls See