Excel Is Fun

Excel Magic Trick 1238

October 13, 2016 0

DESCRIPTION Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples Learn how to check whether the content of multiple cells is the same for each cell: (00:11) Problem Introduction (00:40) […]

Excel Is Fun

Excel Magic Trick 1235

October 3, 2016 0

DESCRIPTION 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP Learn how to do a two way lookup to retrieve the conversion rate for currencies: (00:11) Two-Way Lookup for Currency Conversion Problem […]

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

Highline Excel 2016 Class 03-02 Filter

September 20, 2016 0

Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin WORKBOOKS Highline Excel 2016 Class 03 Start Workbook Highline Excel 2016 Class 03 Finished Workbook Highline Excel 2016 Class 03 2015 Data Highline Excel 2016 […]

Dueling Excel

Dueling Excel 100

September 7, 2016 0

Two Way Lookup Formula and Conditional Formatting! DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions 2. Excelisfun […]

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

Dueling Excel

Dueling Excel 86

July 13, 2016 0

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

Dueling Excel

Dueling Excel 81

June 8, 2016 0

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]

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 […]

Excel Is Fun

Excel Magic Trick 1198

March 28, 2016 0

Median for Each Quarter Using AGGREGATE Function DESCRIPTION See how to calculate Median for Each Quarter Using AGGREGATE Function (00:08) Problem Setup (00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl […]