From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
Join today to access over 24,600 courses taught by industry experts.
What you should know
From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
What you should know
- Throughout this course, you'll be working with data sets and course files that you'll be able to download to your machine. You're going to connect these data sets to Excel without having to copy and paste them, and without having to create external links. They're going to be connected straight through Power Query. When you download the course files, please take note, the location of the files will be on your machine, not mine, and not with LinkedIn Learning. Therefore, some of your Excel files will not be as dynamic and automated as you might like. You are going to need to edit the pathways where Power Query points and make the connections to where the data sits on your drive. But don't worry, I'll coach you through exactly how to do this.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.