Excel Is Fun

Excel Magic Trick 1301

June 26, 2017 0

DESCRIPTION Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between […]

Excel Is Fun

Highline Excel 2016 Class 03

October 1, 2016 0

Data Analysis Fundamentals: PivotTables, Power Query & Data Model DESCRIPTION In this video learn about the fundamentals of Data Analysis and Business Intelligence in Excel 2016: Sort, Filter, PivotTables, Power Query, Power Pivot Data Model: […]

Excel Is Fun

Excel Magic Trick 1201

April 18, 2016 0

Conditional Format Product With No Sales (5 Examples) DESCRIPTION See how to: (00:08) Problem Setup (00:43) Format Product with NO Sales: COUNT & =0 (02:46) Format Product with NO Sales: COUNT & NOT (Any non-zero […]

Dueling Excel

Dueling Excel 70

March 23, 2016 0

Lookup & Return Last 5 Numbers in a List DESCRIPTION See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable […]