Excel 365 & Power BI Intermediate to Advanced Free Course - 365 MECS - Calculations & Data Analysis.
25 videos • 374,961 views • by excelisfun This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike “excelisfun” Girvin. Mike is an Microsoft Excel MVP and a professor at Highline College. You can expect a couple videos each week from June 20, 2022 to August 20, 2022. 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