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

Excel Magic Trick 1387

DESCRIPTION See how to Create a Data Model with DAX Formula to build PivotTable Frequency Distribution with Conditional Formatting. Also learn how the Data Model and DAX Formulas work on Big Data: (00:13) Introduction (03:42) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1373

DESCRIPTION See how to Conditionally Format Every 5th Value and Extract Every 5th Value: 1. Introduction 2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions. 3. Formula 1 for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1367

DESCRIPTION How to make Calendar Table in Power BI Desktop? See how to create three types of Calendar Tables in Power BI Desktop using the CALENDAR Function and various other functions: (00:02) Files to Download [Read More >>>]

Excel Is Fun

Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1325

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]