Excel’s newer feature, the Power BI Suite, allows one to create a relational database within Excel. Topics include: Importing data with Power Query, Intro to relational databases, creating a data model, importing related database tables, creating a data model with a pivot table, creating and editing queries, importing data from the web, data analysis with Power Pivot, calculated columns and measures, and Data Analysis Expressions (DAX) language.
- Course creator: Kellie Benefiel
David Rose's favorite tips and tricks for Excel users.
- Course creator: Michael Reiter