Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

Connect Excel to a folder of files

From the course: Excel Business Intelligence: Power Query

Unlock the full course today

Join today to access over 15,000 courses taught by industry experts or purchase this course individually.

Start my 1-month free trial
  • Course details

    Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. In this course—the first installment in the Excel Business Intelligence series—follow along with experienced Excel trainer Chris Dutton as he shows you the robust capabilities of Power Query. Chris kicks off the course by outlining the power Excel landscape and spelling out when to use business intelligence tools like Power Query, Power Pivot, and DAX. He then dives into Power Query, explaining how to leverage key query editing tools to connect and transform data. Learn about basic Power Query table transformations, text-specific query editing tools, how to merge and append queries, and more. Chris also shares best practices for working efficiently with Power Query.

    Instructor

    • Chris Dutton

      Chris Dutton

      Founder & COO, Maven Analytics
      View on LinkedIn

      Chris Dutton is a certified Microsoft Excel Expert and analytics consultant.Chris has nearly a decade of experience working with Fortune 500 companies across automotive, retail, insurance, and travel verticals. He has developed award-winning business intelligence and data visualization tools, which have been featured by Microsoft, the New York Times, and the Society of American Baseball Research (SABR). As founder of Excel Maven, Chris has helped thousands of students learn how to use Excel as a dynamic and powerful analytics tool, and has developed personalized training programs for individuals, private groups, and businesses across the country. He graduated summa cum laude and received the Charles Bluhdorn Prize in Economics at Tufts University.

      View all courses by Chris Dutton
  • Welcome

    - [Instructor] All right, time to revisit the Appending exercise that we went through in the last lecture. Now, if you recall, we had a 1997 file. We loaded up a 1998 file. And then appended the 1997 data to create this kind of stacked version called Transactions 1997-1998. And that worked just fine. The only catch was that it left this component table, this 1997 table, on its own, and since it's dependent on it, we can't delete that one. So, not a problem at all. You could move on and work with the data in its current form with no issue. But, if you want to know an interesting way to kind of get around this, I'm going to show you how to point to a folder containing these files instead. So, the first thing we're going to do is actually right-click and delete these two Transactions table. Don't worry, it's not goodbye for good. We'll be gettin' those back in an even more efficient way. So, got rid of both of the Transaction files. You should just have your Lookups left here. And now…

  • 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 the exercise files for this course. Get started with a free trial today.
  • 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.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents