Online working moms can create their own monthly schedule with the help of an Excel spreadsheet. The template will require a bit of programming knowledge, but it’s not that hard to get started. In this article, we’ll give you a few tips to help you create your own, using Excel.
Start with a new spreadsheet, then make a list of the dates for the weeks in your calendar. Make sure you have all the right dates and you’ll be able to create your spreadsheet. You should leave two blank cells at the bottom of the spreadsheet to start.
On your spreadsheet, create a worksheet that is like a times table. Set the sheet to sort by Month, day, and start time. For instance, you could have the list like this:
For each column, add each day of the month in the column on the left, then the start time for that day, and finally the start date of the following day. If you want, you can use a different layout. Maybe you want the month number on the right instead of the list. This is OK, because you can still change the sheets layout.
To group the columns, you can add a unique column name to each column. To get the first row, the last row, and the groupings, put the unique column name of the column that has the date in that row, first. Then add the month and the start date, then the starting time for that day, and finally the end date. If you want, you can separate the left column, group by day, and put the month and start date in the first row, so that the rest is easy.
You might want to have a different template for every month. If you do, you need to put that on another worksheet. Just move the rows of the new sheet up one column, then the rows of the original sheet, and finally the column named column that was changed. Then just remove the cell you removed. Repeat the process for the other columns.
Now it’s time to add the worksheets. On the sheet you want to start with, you click on the column heading and make sure that the names don’t overlap. Select the row where you created the first column. Then, choose one of the two methods for a way to merge the columns. We’ll discuss that later.
When you have the steps all set up, it’s time to choose a way to merge the columns. At the top of the worksheet, choose the merge button. Here you can combine the left or right column, then choose the merges option to choose the direction of the merge. Then pick a merge type like “right to left”left to right”.
The final step is to create a new name for the columns. You can do this by clicking on the column header and choose “Name” from the menu. The process for doing this is the same as the ones you’ve done for merging columns.
When you’re done, turn the worksheet over. You’ll see that you have a template that looks like a table. You can add your information into the cells, like this:
It’s worth checking out if you’re new to spreadsheets. If you don’t have any idea about how to create these templates, you can always look at a tutorial online.