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 1428

DESCRIPTION See how to create a formula that will calculate the Current value of an investment for each row of the table. The table has the yearly Growth Rate and Asset Name. See how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1427

DESCRIPTION See how to use GEOMEANX and other DAX Formulas to calculate the Average Counpounding Rate per Period and a Future Value Calculation. Topics: (00:13) Introduction (01:09) Data Model Setup (02:27) GEOMEANX DAX function to [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 1410

DESCRIPTION See how to Calculate Closing Balance for Each Month from Balance Transaction Table: (00:10) Introduction (01:20) SUMIFS and MAXIFS method (03:45) SUMIFS and AGGREGATE method (06:07) SUMIFS and VLOOKUP method (07:35) SUMIFS and MAX [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 1404

DESCRIPTION See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly: (00:10) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1402

DESCRIPTION See how to put a check mark in a cell when a number is greater than zero using the IF Function and the CHAR function: (00:11) Introduction (00:41) Insert a Symbol (01:28) Generate full [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 1395

DESCRIPTION See how to simulate the Standard PivotTable Show Values As calculations of % of Grand Total, % of Column Total and % of Parent Total. See the DAX Functions: CALCULATE, ALL, ALLSELECTED, VALUES, DIVIDE, [Read More >>>]