Dueling Excel 149

July 5, 2017

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

Dueling Excel 142

May 17, 2017

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

Highline Excel 2013 Class Video 35

May 12, 2017

DESCRIPTION Topics in this video: 1. 3 Reports with Formulas. 2. What is a PivotTable do? a. Summarise data b. “Calculation with criteria” c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set. […]

Excel Magic Trick 1284

April 3, 2017

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

What’s New in Excel 2013

March 19, 2017

Welcome Screen The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that […]

Excel Magic Trick 1273

February 23, 2017

DESCRIPTION Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins Learn how to use the Get External Data Feature, Web Query to get Super Bowl data. Then make two PivotTables to […]

Excel Magic Trick 1269

February 9, 2017

DESCRIPTION Without Power Pivot: DAX Measures, Relationships & Data Model Using Excel 2016, learn how to access the Data Model, build Relationships between tables and create DAX Measures (Formulas in Pivot Tables) without having PowerPivot […]

Dueling Excel 128

February 8, 2017

DESCRIPTION Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF See Mr Excel and excelisfun use two methods to count the occurrences of items in a list: 1. PivotTable 2. Advanced Filter Extract Unique […]

Excel Magic Trick 1268

February 6, 2017

DESCRIPTION Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables […]

Excel Magic Trick 1267

February 2, 2017

DESCRIPTION PivotTable Automatic Date Grouping: New in Excel 2016 See that in Excel 2016, a Date Field from a Table that is dropped into the Row Area of the PivotTable automatically groups into Years, Quarters […]