Excel Is Fun

Excel Magic Trick 1430

DESCRIPTION See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1429

DESCRIPTION See how to rank values in Power Query using an Index, the Group By feature and MIN Function. WORKBOOKS

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

Excel Magic Trick 1425

DESCRIPTION See how to use INDEX function & Number Increments to Convert 2-Way Table to Single Column Table: (00:11) Introduction (00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table (01:46) Number Increment [Read More >>>]

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 1423

DESCRIPTION Learn about the Power Query Function Number.ToText to use some Excel Custom Number Formatting and Power Query Custom Number Formatting to format numbers and convert then to text. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1422

DESCRIPTION Learn how to use the Power Query user interface and type M Code to quickly take all the items from an invoice and list them in a cell with a delimiter. The Data is [Read More >>>]