Excel Is Fun

Excel Magic Trick 1401

DESCRIPTION See how to use the Excel 4.0 Macro Function GET.CELL & a Defined Name to create a Conditional Formatting Logical Formula to Format Row when the Date is Bold. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1400

DESCRIPTION See how to Conditionally Format the row in an Enrollment Table when the following conditions are met: 1. Enrollment less than or equal to 15, then format row 2. Name Column can NOT contain: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1399

DESCRIPTION See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula. WORKBOOKS

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

Excel Magic Trick 1396

DESCRIPTION See how to: (00:13) Introduction. What is a Running Total or Cumulative Frequency. What is a % Running Total (03:10) Example 1: Grouping Integer Values for # of Transactions with a Quantity between an [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 >>>]

Excel Is Fun

Excel Magic Trick 1394

DESCRIPTION See how to use formulas to calculate “PivotTable Show Values As: Calculations: (00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations (01:29) Total Revenue Formula for either Product or Manufacturer in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1393

DESCRIPTION See how to use the Show Values As Calculation in a PivotTable: (00:14) Introduction (00:46) Build Pivot Table for Total Revenue for Manufacturer and Product (02:13) Explain Parent Child Relationship (03:22) % Column Total [Read More >>>]

Excel Is Fun

Excel Magic Trick 1392

DESCRIPTION See how to perform Case Sensitive Unique Count with Power Query: (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count. (01:34) Case [Read More >>>]