Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - preparing data for analysis

The video tutorial guides viewers through a series of data preparation tasks in Excel. It covers removing blank rows and duplicate records, applying correct number formatting, adding a new column for Region Code, and combining store and country codes. Finally, it demonstrates how to organize the cleaned data into an Excel table named Store_Sales.

What functions can be used to combine the store code and country fields?

How do you create a table from the cleaned data set?

What is the final name you should give to the table created from the data?