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

Highline Excel 2016 Class 17

DESCRIPTION In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula): (00:22) Introduction (02:43) Power Query to Clean, Transform & Import Text Files (From Folder [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1383

DESCRIPTION See how to Conditionally Format each row in a Data Set that has a Job Title that contains any text item from within a list. Learn about “Contains Criteria” in an OR Logical Test: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1375

DESCRIPTION See how to: (00:01) How to Navigate to sections of this video (00:46) Introduction (01:32) What is an OR Logical Test using OR Criteria (02:30) Fundamental Problem with an OR Logical Test on Two [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 1345

DESCRIPTION See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: (00:11) Introduction to Using Logical Formulas to Apply Conditional [Read More >>>]

Excel Is Fun

Excel Magic Trick 1344

DESCRIPTION See how to use a formula to apply Conditional Formatting to apply formatting to an entire row based on a condition in an Excel Table. This video shows the Excel Table Feature which allows [Read More >>>]

Tricks & Tips

Highlight Duplicate Values

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds. Here we have a list of names in Column A which contains some [Read More >>>]