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

DESCRIPTION In this video learn how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals [Read More >>>]

### Excel Magic Trick 1467

DESCRIPTION Learn about how to Count Open Projects by Day and Project Code, Including Empty Cells with the following Complex Criteria: 1) Start Date Less Than or Equal To Date AND 2) Start Date NOT [Read More >>>]

### Office 2016 40

DESCRIPTION Topics in this Video: (00:01) Introduction (01:20) What is a Query? (02:10) Query 01 Description and Sell Price (06:50) Query 02 Product Records From SC (08:40) Query 03 On Hand = 10 (09:57) Query [Read More >>>]

### Office 2016 31

DESCRIPTION Topics in this video: (00:01) Introduction (01:30) Review of SUMIFS and COUNTIFS examples we hjave already done in this class. (03:38) What is an AND Logical Test (06:40) Example 1. Goal: Count How Many [Read More >>>]

### Excel Magic Trick 1454

DESCRIPTION Count Customer Totals Between Upper & Lower Limits For Each Month using a DAX Measure in either Power Pivot or Power BI Desktop. See the DAX Functions: COUNTROWS, FILTER, MAX and MIN and an [Read More >>>]

### Excel Magic Trick 1451

DESCRIPTION Topics in This Video: (00:04) How to Download Files. (00:14) Introduction to building Data Model with Relationships and DAX Formulas without buying Power Pivot in Excel 2016. (02:47) Import Tables and Build Relationships using [Read More >>>]

### Office 2016 27

DESCRIPTION Topics in this video: (00:01) Introduction (01:15) Example 1: Excel Table feature for VLOOKUP & Data Validation List (07:10) Example 2: Excel Table feature for Chart (09:45) Example 3: Excel Table feature for PivotTable [Read More >>>]

### Excel Magic Trick 1444 Part 1

DESCRIPTION See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight [Read More >>>]

### Office 2016 05

DESCRIPTION Topics in this video: (00:01) Introduction (03:21) Formatting Keyboards: (07:40) Insert Clip Art or Pictures (11:05) Highlighting and Fill to add background colour (14:39) Highlight to end of document = Ctrl + Shift + [Read More >>>]