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

Excel Is Fun

Office 2016 16

DESCRIPTION Topics in this video: (00:01) Introduction (01:22) What Excel can do: 1) Calculations, Data Analysis (01:58 and 03:22) What is Data Analysis? (04:00) What is a Proper Data Set? (06:26) SUMIFS for Regional Sales [Read More >>>]

Excel Is Fun

Office 2016 15

DESCRIPTION Topics in this video: (00:01) Introduction (00:41) Different kinds of counting and adding (02:28) Function Drop-down and screen tips to learn which function to use (04:05) COUNT Function (05:04) COUNTA Function (06:16) SUM Function [Read More >>>]

Excel Is Fun

Excel Magic Trick 1438

DESCRIPTION See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column [Read More >>>]