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

Download Excel Start Files: http://bit.ly/2FBEKxU
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.

View on 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
Download Excel Start Files: http://bit.ly/2VTHw6y
Download Excel Finished Files: http://bit.ly/2QOzNCY
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.

View on YouTube

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

Download Excel File: http://bit.ly/2TFoUp4
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

View on YouTube

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

Download Excel File: http://bit.ly/2TFoUp4
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)

View on YouTube

VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?

Download Excel File: http://bit.ly/2Rd7Cm7
In this video see how to use VLOOKUP to retrieve an entire record using two methods: 1) FILTER Function and 2) VLOOKUP, COLUMNS and Table Header Code.

1. (00:05) Introduction
2. (01:16) FILTER Function
3. (03:18) VLOOKUP, COLUMNS and Table Header Columns
4. (07:57) Summary
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

View on YouTube