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

Excel Is Fun

Excel Magic Trick 1130

April 30, 2015 0

DESCRIPTION See how to create an Ageing Accounts Receivable Reports Using Advanced Filter: (00:27) Helper Column. The correct formula for Days Late is: =TODAY()-D8 (00:49) Sort to bring largest to top (01:10) Criteria Area (01:40) […]

Excel Is Fun

Excel Magic Trick 1128

April 28, 2015 0

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]

Excel Is Fun

Excel Magic Trick 1126

April 26, 2015 0

DESCRIPTION See how to complete a monthly employee calendar with the text “Training” based on a start and end date, and holiday and weekend dates. See the functions: IFERROR, WORKDAY.INTL, IF, AND, and NETWORKDAYS.INTL. WORKBOOKS