Excel Is Fun

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

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

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

Excel Is Fun

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

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