Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - use split and trim functions

The video tutorial covers importing data using Get and Transform, combining files, and transforming data in Power Query. It includes a practical demonstration of data import, cleaning, and formatting, followed by loading the data into Excel. Key steps include combining files, removing unnecessary columns, setting data types, splitting columns, and trimming data.

What is the first step you need to take to import the Invoice Data folder?

Describe the process of combining all the invoice files in Power Query.

What should you do after combining the files to prepare for analysis?

How do you ensure that each column in your data has the correct data type?

Explain how to split the Client column into two separate columns.

What is the purpose of trimming the data in the new Location column?

What final step do you need to take to load the transformed data into Excel?