Dueling Excel

Dueling Excel 142

May 17, 2017 0

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

Highline Excel 2013 Class Video 35

May 12, 2017 0

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 Is Fun

Excel Magic Trick 1284

April 3, 2017 0

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

GETTING STARTED IN EXCEL

What’s New in Excel 2013

March 19, 2017 0

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 Is Fun

Excel Magic Trick 1273

February 23, 2017 0

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 Is Fun

Excel Magic Trick 1269

February 9, 2017 0

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

Dueling Excel 128

February 8, 2017 0

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 Is Fun

Excel Magic Trick 1268

February 6, 2017 0

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 Is Fun

Excel Magic Trick 1267

February 2, 2017 0

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

Excel Is Fun

Excel Magic Trick 1256

December 15, 2016 0

DESCRIPTION Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!! Learn how to build a PivotTable with Grouped Month and Year Dates and add a Slicer for a Marine Species Data Set, and then […]