This video shows how to use StatPro to quickly transform variables in Excel.
While I perform a logarithmic transformation in the video, you can use the same process to do a sqaure, square root, or inverse transformation as well.
You can find StatPro here: https://host.kelley.iu.edu/albrightbooks/Free_downloads.htm
(Note: I use the PC version of StatPro in this video. While there is a version of StatPro for the Mac, I've never tried it out)