This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike “excelisfun” 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 Query, Data Model, Power BI…
4. Date and Time formulas
5. SUMIFS, COUNTIFS & Conditional Calculations
6. Logical Formulas: Comparative Operators, IF, AND, OR and IS functions
7. Lookup functions: XLOOKUP and FILTER, Data Validation
8. Array Formulas
9. LET and LAMBDA functions
10. Formulas to Build Reports
11. Visualizing Data with Conditional Formatting, Excel Charts and Power BI
12. Dashboards
13. Power Query, to clean, transform and import data
14. M Code
15. DAX
16. Much more

You can expect a couple videos each week from June 20, 2022 to August 20, 2022.

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/ . Artist: http://audionautix.com/