Excel Is Fun

Excel Magic Trick 1459

DESCRIPTION Learn how to create use SUMIFS and SUMPRODUCT functions to add the costs for each dog based on whether the expense is for Food or it is an Accessory. This video shows how to [Read More >>>]

Excel Is Fun

Excel Magic Trick 1458

DESCRIPTION Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1457 Part 2

DESCRIPTION In the English United States Regional Settings, SUMIFS seems to be recognizing Text and Number Dates as equivalent Criteria. But when we change the Reginal Settings, SUMIFS correctly interprets Text Dates and Number Dates [Read More >>>]

Excel Is Fun

Excel Magic Trick 1457 Part 1

DESCRIPTION Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1456

DESCRIPTION In this video see how to create an 8 Year Span Monthly Revenue Report for a selected Product. WORKBOOKS

Excel Is Fun

Office 2016 32

DESCRIPTION Topics in this video: (00:01) Introduction (01:51) Review of PivotTables we have already completed in this class. (03:15) What is Data Analysis in one sentence (03:34) What’s is Proper Data Set in Excel? (03:50) [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 1455

DESCRIPTION In this video see how to create an 8 Year Span Monthly Revenue Report for a selected Product. Learn how to take Text Month Criteria like “Jan” 2010 and convert it to the proper [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 1453

DESCRIPTION Count Customer Totals Between Upper & Lower Limits For Each Month using an Excel Array Formula and the functions SUMPRODUCT and SUMIFS. Create a Cross Tabulated Frequency Distribution that shows a count of Customer [Read More >>>]