Excel Is Fun

Excel Magic Trick 1424

DESCRIPTION See how to calculate Average, Moving Average at Different Granularity in both DAX and Excel Formulas: (00:14) Introduction (00:27) What is Granularity? (02:15) Look at Data Model and Hide Columns from Client Tool (03:29) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1419

DESCRIPTION See how to use the RANKX Function in DAX. Learn : (00:15) Introduction. Look at Finished Data Model PivotTable. Look at Established Data Model. (02:24) Create Total Profit Formula, start PivotTable. (04:14) Discuss how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1418

DESCRIPTION See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer: (00:10) Introduction (01:31) PivotTable #1 for Total Profit per Product and Ranking [Read More >>>]

Excel Is Fun

Excel Magic Trick 1408

DESCRIPTION See how to create a DAX Measures for Moving 12 Month Average on Daily Sales: (00:15) Introduction and comparison to formulas created in Excel Magic Trick 1406. (01:07) Discussion of Filter Context and how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1407

DESCRIPTION See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using The Data Model, Two Fact Tables with a Relationships to Data Table, and Two DAX Measures. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1403

DESCRIPTION Learn about the difference between Explicit and Implicit DAX Measures: (00:10) Introduction to Explicit and Implicit DAX Measures (01:33) Create Implicit Measures and see these six problems: 1) Number Field will use SUM Function, [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 23

DESCRIPTION In this video learn about a free download called Power BI Desktop that is a single program that does all that Excel’s Power Query & Power Pivot can do, and more. Comprehensive example of [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 22

DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1398

DESCRIPTION See how to: (00:15) Introduction (02:45) Look at Data Model in Download file. This is the Data Model that we start with at beginning of video. (04:55) Add Upper & Lower Limit “Regular Increment” [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 20

DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [Read More >>>]