Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 365 and Power BI Intermediate to Advanced - Calculations and Data Analysis

ExcelIsFun via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master intermediate to advanced Microsoft Excel 365 and Power BI Desktop concepts through this comprehensive course taught by Microsoft Excel MVP Mike "excelisfun" Girvin from Highline College. Develop expertise in worksheet formula models, data analysis using PivotTables, Power Query, Data Model, and Power BI Desktop. Learn advanced date and time formulas, conditional calculations with SUMIFS and COUNTIFS, and logical formulas including comparative operators, IF, AND, OR, and IS functions. Explore lookup functions like XLOOKUP and FILTER, data validation techniques, and dynamic spilled array formulas. Discover the power of LET and LAMBDA functions for creating sophisticated formula solutions. Build professional reports and visualize data using conditional formatting, Excel charts, and Power BI visualizations. Create interactive dashboards and master Power Query for cleaning, transforming, and importing data from various sources. Dive deep into M Code programming and DAX (Data Analysis Expressions) for advanced data modeling. Practice with real-world examples including budget vs. actual variance analysis, mortgage loan schedules, financial modeling, and handling multiple fact tables. Gain hands-on experience with joins, group by operations, unpivoting cross-tabulated data, and solving complex business scenarios using Excel formulas, Power Query, or DAX depending on the optimal approach.

Syllabus

Introduction to Microsoft 365 Excel & Conventions for Class - 365 MECS 01
Excel Formulas & Functions, PivotTables, Slicers & Charts - 365 MECS 02
M 365 Excel Worksheet Formulas & Models – Everything You Ever Wanted To Know - 365 MECS 03
Excel & Power BI Data Analysis Complete Class in One Video - 4 Hours - Download Files - 365 MECS 04
Date & Time Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 05
Text Formulas & Functions in Excel Worksheet and Power Query - 365 MECS 06
Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query, & More- 365 MECS 07
All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08
Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09
Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10
Excel LAMBDA function – Every Single Things You Ever Wanted To Know - 2022 Version 365 MECS 10
Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11
Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12
Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13
Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14
7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15
Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16
Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17
Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18
Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19
What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20
Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21
Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22
Microsoft 365 Excel Complete Class: free from excelisfun at YouTube - 365 MECS 00
How To Access Excel F Keys on Laptop Computer – Huge List of Function Keys too - 365 MECS 01 Part 2

Taught by

ExcelIsFun

Reviews

Start your review of Excel 365 and Power BI Intermediate to Advanced - Calculations and Data Analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.