Some of the tips for you to become a Microsoft Excel pro include AutoFill, Ctrl+Shift to select, Text to Columns, Flash Fill, Paste Special to Transpose, Hide in Plain Sight, Pivot, Perform Quick Analysis and more.