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

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

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

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

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

Excel Is Fun

Office 2016 01

DESCRIPTION Topics in this video: (00:01) Introduction (00:28) Programs/Apps (application software) (02:32) Task Bar (02:56) Operating Systems (03:11) Start Button (05:23) USB Flash Drive (05:58) Introduction to Windows Explorer (09:34) Deleting a File or Folder [Read More >>>]

Excel Is Fun

Excel Magic Trick 1408

DESCRIPTION See how to create a DAX Measures for Moving 12 Month Average on Daily Sales: (00:15) Introduction and comparison to formulas created in Excel Magic Trick 1406. (01:07) Discussion of Filter Context and how [Read More >>>]