### Excel Magic Trick 1275

March 2, 2017

DESCRIPTION Excel Online Office 365 MAXIFS function Learn how to find the biggest value based on a condition or criteria. New features released in these versions: 1. Office 365 Online Excel OR 2. Office 365 […]

### Highline Excel 2016 Class 03

October 1, 2016

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

### Highline Excel 2016 Class 03-02 Filter

September 20, 2016

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

### Excel Magic Trick 1190

February 1, 2016

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]

### Excel 2013 PowerPivot Basics 10

April 10, 2015

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example […]

### Dueling Excel 018

March 18, 2015

DESCRIPTION See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP. See Mr Excel and excel is fun create an IF function formula that use the functions […]

### Excel Magic Trick 1104

March 2, 2015

DESCRIPTION See how to add unit numbers with AND and OR Criteria where the criteria are given as years and months but date column contains serial number dates. See how to use SUMIFS function to […]

### Highline Excel 2013 Class Video 17

February 16, 2015

DESCRIPTION Topics in this video: (00:35) Bank Deposit Example: Multiply and then Add in Succession. (02:37) Grade Book Weighted Average Example: Multiply and then Add in Succession. (03:30) Accounting Budget Weighted Average Example: Multiply and […]

### Highline Excel 2013 Class Video 14

February 13, 2015

DESCRIPTION Topics in this video: Analyze customer credit worthiness with logical formulas: (00:23) Analyze customer credit worthiness. (01:42) AND functions. (03:45) IF function and AND function. (06:05) OR function. (07:47) Formula Evaluator (Evaluate Formula) = […]

### Highline Excel 2013 Class Video 13

February 12, 2015

DESCRIPTION Topics in this video: (00:37) Excel TABLE. (01:04) Total Row. (01:59) AND Criteria with Table Feature. (04:07) OR Criteria with Table Feature. (04:40) AND and OR Criteria with Table Feature. WORKBOOKS