Import sales data from multiple CSV text files using Power Query, or use the Excel 2016 data tab.
- [Instructor] Now what if you have many files…you want to import?…So for example, let's say your IT department gave…you these three files here to import.…Could you do it all at once?…Yes, and let's go one step further.…What if at the end of a sales cycle,…like at the end of the month, you get a new file.…Could you drop it in this folder and have Excel…automatically update and receive the data for that new file?…You sure could.…I'll show you how.…Let's switch on over to Excel,…and we'll go to Data, New Query, From File,…and then we'll choose From Folder.…
And I'm gonna click Browse, and I'm gonna navigate…to that chapter two folder and then the folder…called monthly sales files,…which is inside the chapter two folder.…I'll click ok,…and then ok again.…We get a preview here, and it's not like the other…previews we saw earlier.…It just shows the file names and the extensions,…the dates, etc.…But if we click this awesome button down here,…we can actually combine the data from all three files.…So I'm gonna click Combine & Load.…
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboards
Skill Level Intermediate
1. Getting Started with Templates
2. Importing Sales Data
3. Working with Tables
4. Analyzing Sales Data
5. Build Awesome Sales Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.