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 in importing data using Get and Transform?

• Download the Invoice Data folder

• Open the Excel application

• Navigate to the Data tab

• Select the Home tab

Which option should you select to import data from a folder?

• From Folder

• From Database

• From Web

• From Table

What should you do after combining the files in Power Query?

• Export to PDF

• Close Power Query

• Save the file

• Remove unnecessary columns

How should the Client column be split?

• By space

• By delimiter

• By tab

• By semicolon

Which data type should be set for the Amounts column?

• Text

• Date

• Percentage

• Currency

What is the purpose of trimming the Location column?

• To remove leading spaces

• To convert text to numbers

• To change text to uppercase

• To remove duplicate entries

What is the final step after transforming the data in Power Query?

• Print the data

• Save the query

• Close and load the data into Excel

• Export to CSV