Although working in a single worksheet makes the process simpler, the same worksheet may make your sheet look complex and cumbersome. Not to mention errors those are made when too much data is handled in a single sheet and gets inadvertently ignored by users. Large and complex data will only waste your time and degrade the quality of your overall excel worksheet.
For example, if you are making a financial model, you will be faced with tons of data. Comparing or crosschecking in the same sheet will mess up the values. This will make the model look bad. In case you are maintaining an Accenture model, predicting annual statement and making proper calculations simultaneously will only make the model look even more messed up. Also, errors will only impact the integrity of your spreadsheet whilst making it more difficult for you to identify the issues.
Here is one sure short way out. To make your spreadsheet look simple, organized and effective, then dividing your data in different workbooks is an apt solution. Minimize time-consuming mouse-method by using the excel shortcut for new excel worksheet. This will keep your model clean and organized.
The Shortcut for Mac is:
⌘ + N to open a New excel workbook in Mac
Avoid reaching for the mouse and start using the keyboard commands to minimize your work problems and manage your time effectively. So now that you know how to create new excel workbook, know the shortcut to insert a new sheet in your document.
You have learned the shortcut to open new workbook, now know the Shortcut To Insert New Sheet