Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53 January 2019 – Bonbon's Guide To Data & Tech
Practical Solutions for Excel, Power BI, SQL, Access, Python, Data Science, Automation & Other Tech
Month: January 2019
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
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.
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
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.
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
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
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
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)
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
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