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.
