Copy the top 70% of the shuffled dataset (based on your split ratio) into a new sheet or file for the training data.
Copy the bottom 30% of the shuffled dataset into a new sheet or file for the testing data.
Remember, while Excel can be used for simple datasets, for more complex tasks or larger datasets, you might want to consider using specialized data analys