Excel Is Fun

Excel Magic Trick 1318

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create report and Chart for How Many Unique Visitors To Site Each Day with Two Methods: (00:13) Introduction (01:01) Excel 2016 Data Model [Read More >>>]

Dueling Excel

Dueling Excel 149

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 [Read More >>>]

Dueling Excel

Dueling Excel 142

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

Excel Is Fun

Excel Magic Trick 1284

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 [Read More >>>]

GETTING STARTED IN EXCEL

What’s New in Excel 2013

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1273

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1269

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 [Read More >>>]

Dueling Excel

Dueling Excel 128

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1268

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1267

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 [Read More >>>]