### Excel Magic Trick 1478

DESCRIPTION In this video learn how to use Conditional Formatting to format the row in a data set and how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver [Read More >>>]

### Excel Magic Trick 1474

DESCRIPTION Learn about how to create a Twinkling Christmas Tree with a Star on Top in Excel using the RAND and CHAR functions, the Conditional Formatting Scales and Conditional Formatting Icons. WORKBOOKS

### Excel Magic Trick 1465

DESCRIPTION Learn about how to apply Conditional Formatting with a Logical Formula so that dates in a list that are holiday lists show up with the word “Holiday” and with red fill and white font. [Read More >>>]

### Office 2016 29

DESCRIPTION Topics in this video: (00:01) Introduction (00:32) Example 1: Accounting Style Formatting (4 Examples) (08:47) Example 2: Accounting Borders (09:25) Example 3: Column widths!! (10:16) Example 4: Wrap Text in Cell: Multiple Lines in [Read More >>>]

### Excel Magic Trick 1448

DESCRIPTION See how to create Conditional Formatting for Truck Arrival Dates that shows Blue when truck in unloaded, green when it less than 2 days since arrival, yellow when it is 2 days since arrival [Read More >>>]

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

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

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