You can also read the blog post at https://www.ankitgupta.info/microsoft... in order to understand the tips and tricks in better way.
0:00 Copy Formatting - using Format Painter
0:23 Wrapping Text - using "Wrap Text" button
0:50 Selecting Entire Data - ^ + *
1:00 Splitting text to columns - Select data and click menu item Data Convert Text to Columns
1:29 Writing same data in multiple cells - select all cells - write data - command/ctrl + enter