Excel Is Fun

Excel Magic Trick 1470

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period by subtracting [Read More >>>]

Excel Is Fun

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

Excel Is Fun

Excel Magic Trick 1464

DESCRIPTION Learn about how to check whether or not an item in is a list using the MATCH Function. Learn three different formula that may work for your situation: (00:11) Introduction (00:53) Excel New Windows [Read More >>>]

Excel Is Fun

Office 2016 37

DESCRIPTION Topics in this Video: (00:01) Introduction to Power Query and the examples in this video (02:50) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016 (04:32) Example #1: [Read More >>>]

Excel Is Fun

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

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

Excel Is Fun

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

Excel Is Fun

Excel Magic Trick 1442

DESCRIPTION In this video see how to use the EXCEPT DAX Function & Excel Existing Connections Edit DAX feature to Extract Items in List 1 that are NOT in List 2. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1441

DESCRIPTION In this video see how to use an Left Anti Join in Power Query to Extract Items in List 1 that are NOT in List 2. WORKBOOKS

Excel Is Fun

Office 2016 25

DESCRIPTION Topics in this video: (00:01) Detailed Introduction to the IF Function & Comparative Operators and Logical Tests (08:53) IF Example #01: Your Bonus: =IF(C6 Greater Than =C11,C10,0) (13:39) IF Example #02: In Balance?: =IF(B22=C22,”In [Read More >>>]