Excel Is Fun

Excel Magic Trick 1485

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1476

DESCRIPTION In this video learn how to use the SUMIFS function to add Expenses for a specified Date Range. This is an example of using SUMIFS to add with three conditions or criteria. See how [Read More >>>]

Excel Is Fun

Excel Magic Trick 1471

DESCRIPTION In this video learn how to use Array Formulas to automate the reporting process for Rain Totals where the staring time for a day period changes. Topics: (00:01) Introduction and description of reporting requirements [Read More >>>]

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

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

Excel Is Fun

Excel Magic Trick 1452

DESCRIPTION See two methods: 1) PivotTable Method, 2) Array Formula Method. The PivotTable Method is the easy way to accomplish this. The Array Formula method is a difficult Array Formula, but it can make all [Read More >>>]