Category : Spreadsheet.
Topic : Navigation in a spreadsheet model can be facilitated by. Author : .
Posted : Tue, Mar 15th 2022 06:20 AM.
Format : jpg/jpeg.
Now that we have some test dummy data on our spreadsheet we can go ahead and reformat the column widths. You can add more data if you would like or even use an already existing spreadsheet. The choice is completely up to you; however the steps to reformat the column widths are all the same as you will soon see. The next step is to highlight the columns that you want to reformat. To reformat the columns we are using in our example, using the month names, you need to click on the column header labeled ”A”. Now hold down the ”shift” key and click the column header labeled ”L”. In other words you are clicking the first column and the last column. If you chose to use your own spreadsheet, your columns that you use may be different. You could also click on column header ”A” and holding down the left mouse button, drag the cursor over top of the final column, in this case ”L”, and let go of the mouse button. Either way is fine.
I understand how you may feel reluctant to allow an external advisor to delve into the detail of your business. I have had other clients who felt the same way. But all of my other clients found the investment they made was repaid many times over both in their business and their own work life balance. To help you we have produced a free spreadsheet which will allow you to reflect on what you would like to achieve with your business and where you are at present. If you use the spreadsheet it will help you to identify if it would be beneficial to get an external advisor or if you are proceeding in the direction you want. Once you have completed the spreadsheet we will review the results with you if you want at no cost to you.