Change the default zoom level for new documents in Excel 2016 for Mac
There is a lot of confusion around how to do this, not just because it's changed from Excel 2011 to Excel 2016, but also because the process has even changed during Excel 2016's lifecycle.

I've also seen a number of different ways people have used to achieve a totally customised default workbook. 

In the interests of providing alternatives, I thought I'd share my preferred method as well:


On your Mac create a new folder called "xlstart". You can create this folder anywhere, but I prefer doing it within the Documents folder.
Launch Excel
Go to Preferences > General > At startup
For open all files in set the xlstart folder you created at Step 1 as the path
Exit preferences 
Open a new workbook and customise your Zoom setting to 150%.
While you're at it, you can also customise a whole heap of other attributes if you like 
Save the workbook as an Excel template, making sure you use the name "workbook", and make sure it's saved in the xlstart folder you created at Step 1. (Note: when saving the file, if Excel has placed the .xltx extension at the end of the file name, then manually remove the .xltx extension before saving)
Quit Excel
Launch Excel


You should now find the default workbook has all the customisations you made at Steps 6 &amp; 7.