### Office 2016 13

DESCRIPTION Topics in this video: (00:01) Introduction (01:30) Excel file = “Workbook”, not “Document” (02:22) Columns (Represented by Letters) and Rows (Represented by Numbers) (02:29) Cells = Intersection of Column and Row = Name or [Read More >>>]

### Excel Magic Trick 1440

DESCRIPTION See how to perform an OR Logical Test on Two Columns using the DAX IN Operator and the DAX OR Function. The goal is to create a Data Model PivotTable with Row Area Criteria [Read More >>>]

### Excel Magic Trick 1439

DESCRIPTION Using Excel 2016, see how to use a DAX Formula with CALCULATE Function, the SUM Function and the IN Operator to create two formulas for adding sales based on Product Groups. This example will [Read More >>>]

### Excel Magic Trick 1433

DESCRIPTION Because we don’t have an F9 key to evaluate formula elements like we do in Excel, learning how to materialize or evaluate or “see” DAX Formula elements is important. In this video see three [Read More >>>]

### Excel Magic Trick 1426

DESCRIPTION See how to: (00:11) Introduction (00:51) Count Columns with COLUMNS Function (01:08) Count Rows with ROWS function (01:30) Count Unique Numbers using FREQUENCY and SUM Functions (04:41) Create Data Validation Drop Down List of [Read More >>>]

### 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 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 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 >>>]

### 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 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 >>>]