This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike \u201cexcelisfun\u201d Girvin. Link to class: https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW<\/a> You can expect a couple videos each week from June 20, 2022 to August 20, 2022.<\/p>\n Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https:\/\/creativecommons.org\/licenses\/by\/4.0\/<\/a> . Artist: http:\/\/audionautix.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike \u201cexcelisfun\u201d Girvin. Link to class: https:\/\/www.youtube.com\/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW Mike is an Microsoft Excel MVP and a professor at Highline College. This class will cover topics such as: 1. Introduction 2. Worksheet Formula Models 3. Data Analysis with PivotTable, Power […]<\/p>\n","protected":false},"author":3,"featured_media":4108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2022\/06\/JgctsDIVVhw.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-14d","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4105"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=4105"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4105\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/4108"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=4105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=4105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=4105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nMike is an Microsoft Excel MVP and a professor at Highline College. This class will cover topics such as:
\n1. Introduction
\n2. Worksheet Formula Models
\n3. Data Analysis with PivotTable, Power Query, Data Model, Power BI\u2026
\n4. Date and Time formulas
\n5. SUMIFS, COUNTIFS & Conditional Calculations
\n6. Logical Formulas: Comparative Operators, IF, AND, OR and IS functions
\n7. Lookup functions: XLOOKUP and FILTER, Data Validation
\n8. Array Formulas
\n9. LET and LAMBDA functions
\n10. Formulas to Build Reports
\n11. Visualizing Data with Conditional Formatting, Excel Charts and Power BI
\n12. Dashboards
\n13. Power Query, to clean, transform and import data
\n14. M Code
\n15. DAX
\n16. Much more<\/p>\n