### Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue

Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to create an Excel Spreadsheet Formula solution that calculates the Average Daily Revenue with the SUMIFS and DAY Function. This solution comes from Chris McNeil at YouTube.

### EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts

EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to create an Accounting Schedule of Accounts from a Text File using Power Query and a PivotTable with a Slicer. This solution will update when a new file becomes available next month.

### EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE

Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to create an Excel Spreadsheet Formula solution that calculates the Average Daily Revenue with the Average Function with SUMIFS inside. See a battle between the New Office 365 method using SEQUENCE Function or the old Excel way with the INDIRECT function.
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) https://www.youtube.com/watch?v=7jJMDGZpjSk

### Traditional Arrays or Office 365 Dynamic Arrays? Count Unique Dates Product Was Sold. EMT 1534

Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn two methods using Excel Spreadsheet Formulas to calculate a Unique Count of Dates Product Was Sold. Learn about the New Office 365 Dynamic Array Formulas and New Excel Calculation Engine or the Traditional Excel Array Formula Method. Learn about the new Office 365 FILTER Array Function, UNIQUE Array Function. See the standard Excel Functions: FREQUENCY, IF, SUM, ROWS and COUNT.

Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)