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 1418

DESCRIPTION See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer: (00:10) Introduction (01:31) PivotTable #1 for Total Profit per Product and Ranking [Read More >>>]

Excel Is Fun

Excel Magic Trick 1413

DESCRIPTION See how to set the Default Layout Settings For a PivotTable with this new feature in the Options area, Data Tab, Set Default Layout. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1412

DESCRIPTION See how to use Power Query to Merge Two Tables into a Single Table, Load as a Connection Only and then build a PivotTable based on the New Merged Table saved as a connection [Read More >>>]

Excel Is Fun

Excel Magic Trick 1409

DESCRIPTION In Excel 2016, see how to create a relationship between two tables so that the PivotTable dialog box will list two tables that we can drag and drop fields from both tables to create [Read More >>>]

Excel Is Fun

Excel Magic Trick 1407

DESCRIPTION See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using The Data Model, Two Fact Tables with a Relationships to Data Table, and Two DAX Measures. [Read More >>>]

Excel Is Fun

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

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 1397

DESCRIPTION See how to create formulas and a chart for Category Totals, Running Totals, and % Running Totals: (00:15) Introduction. Why you might use formula rather than a PivotTable. (02:00) Create formulas for Lower and [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 20

DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [Read More >>>]