Excel Is Fun

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

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

Excel Magic Trick 1438

DESCRIPTION See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column [Read More >>>]

Excel Is Fun

Excel Magic Trick 1437

DESCRIPTION See how to build a DAX Query OR Logical Test using the IN Operator to Pull Sales Team Data to an Excel Sheet from the Power Pivot Data Model. See the DAX Functions: CALCULATETABLE [Read More >>>]

Excel Is Fun

Excel Magic Trick 1436

DESCRIPTION See how to use Excel 2016 to take a 900,000 row table and a 1,000,000 roe table and combine them into one in order to make a PivotTable Report. See how to use the [Read More >>>]

Excel Is Fun

Excel Magic Trick 1435

DESCRIPTION See how to query the Data Model with DAX Code to Export Data to an Excel Sheet: (00:14) Introduction, including looking at Data Model that downloadable file contains (02:13) Use Existing Connections in Data [Read More >>>]

Excel Is Fun

Excel Magic Trick 1434

DESCRIPTION See how to use the DAX SAMPLE Function in Excel 2016 to extract a sample of size n from a Data Set. WORKBOOKS

Excel Is Fun

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

Excel Magic Trick 1432

DESCRIPTION See how to create nine DAX Formulas that build a Confidence Interval: (00:13) Introduction to the Confidence Interval example, reference video about Statistics, and introduction to Data Model used in this video (03:34) Formula [Read More >>>]

Excel Is Fun

Excel Magic Trick 1431

DESCRIPTION See how to: (00:10) Introduction (00:52) XNPV, OFFSET and VLOOKUP formula to calculate the Net Present Value for each Project (10:45) XIRR, OFFSET and VLOOKUP formula to calculate the Net Present Value for each [Read More >>>]