Make Schedule in Excel  Step by Step Guide ▷ 2020

While it is true, in the office environment, Excel is the most widely used spreadsheet based on devices of different operating systems. Thanks to the fact that it is a truly complete program for manage data, perform calculations, use graphical tools, etc..

Thus, generally, this spreadsheet developed by Microsoft is used to solve formulas and make graphs. But, beyond that, it is an ideal tool to ensure the general organization of an information flow. Therefore, it can also be used to create calendars, generate agendas and even to make a schedule.

That is why, if you need to distribute your time effectively or read the schedule of each of your employees, for example, you can make use of this program. Next, we show you how can you create any schedule with excel.

Steps to make a school or work schedule in Microsoft Excel

Basically a schedule consists of a kind of calendar used as a tool to manage time. In view of the fact that it allows easy distribution of the hours in which a certain activity or work is carried out and even when a service is provided.

Consequently, it consists of a list of hours in which certain events or actions can take place and thus, it is a widely used mechanism. both at an academic level as well as at a work or professional level. But, despite the fact that there are tools dedicated exclusively to that, the truth is that, it is more advisable to use Microsoft Excel for this.

In this sense, in order for you to be able to prepare your schedule simply and for free, without having to resort to third-party and / or paid programs, we explain How can you make a schedule in an Excel spreadsheet, through two available mechanisms:

With templates

Today, the Internet provides endless options to simplify the processes of its users. For this reason, it is possible to get templates of different models of schedules, compatible with Excel to download and use them freely.

Here is the step by step to follow in these cases:

  • First of all, directly from the Internet, you have to find the template to use and download it to your computer.
  • Once the template in question is stored in any folder on your computer, proceed to open the Microsoft Excel program and click on “Open”, for now click on “Browse” and locate the model that you downloaded from the Internet.

With templates

  • After locating it, just double click on said file to open it in the spreadsheet or select it and press “Open”.

With templates

  • Then, after a few seconds of waiting, you will be able to see the template of the schedule that you have downloaded and manage it as you like, modifying each of the available fields.

With templates

  • Finally, you just have to save the changes made and ready.

Manually

Another of the mechanisms that exist to make a schedule of any nature in Excel is based on making an equitable distribution of each of the cells and entering the required information. This, without using any base pattern and making it manually.

Although, the above procedure reveals much more ease and productivity, in this case, users have greater freedom to allocate their time and customize the appearance of the schedule.

Here we show you how to do it:

  • Initially, what you have to do is open a worksheet in Microsoft Excel.
  • Followed by that, start writing on the cell A1 the following text “Work schedules” and hit the Enter key.
  • Now, in cell A2, enter “Week corresponding to:” and hit Enter again.
  • Then, leave blank space in cell A3 to mark a separation and better organize the text. Next, go to the cell A4 Y write “Monday” to press Enter.
  • Later, in cells A5, A6 and A7, chooses to write each shift of the day (first, second and third, correspondingly).

Manually

  • Once this is done, go to the cell A8 and enter the term “Tuesday”. Followed by that, add the three shifts corresponding to that day in the cells A9, A10 and A11.
  • Thus, it is time to repeat the same procedure in the following cells to add the information for Wednesday, Thursday, Friday, Saturday and Sunday with each of your three shifts.

Manually

  • When you have already included all the days of the week and the schedules, selects everything from cell A4 to cell A31 (where it ends), to proceed to click on the “Insert” tab from the ribbon and select the option “Table” within the Tables group.

Manually

  • After that, through the “Table Tools” and “Layout” tabs, proceed to choose a table style for your schedule, specifically in “Table styles”.

Manually

  • Finally, from the same tab indicated above, proceed to edit the table with the other available tools. To later enter all the appropriate information in the corresponding cells.

List of the best timetable templates you can use in Microsoft Excel

For ease, productivity or convenience, many people prefer to create their schedule from an Excel compatible template, rather than create it from scratch.

Therefore, to simplify your search when downloading these templates, Below, we list several free and interesting alternatives, with their respective download links:

Simple and practical schedule

It allows to distribute the time from Monday to Friday of each week and provides different time intervals for it. It is characterized by being very colorful and versatile.

Download Simple and Practical Excel Schedule

Homework schedule

It consists of a schedule that exhibits a very clean design and allows you to list your tasks along with study hours within a list of duties. To do this, you must select it by month, since it is a kind of calendar.

Download Excel Homework Schedule

Schedule by Dates – Starting Monday

It is a schedule that shows a more professional and offers three alternatives to choose from (weekly, up to 31 days and up to 5 weeks), according to your requirements.

Download Schedule by Dates – Starting on Monday Excel

Weekly schedule with breaks

It is an official Microsoft Office template that allows you to enter the data of assignments and classes on a separate sheet. Thus, it offers the possibility of list all weekly duties (with day and time).

Download Weekly Schedule with Recess Excel

Weekly university programming schedule

It is an elegant, attractive and very functional model. Which allows you to write the elements in the day and time spaces, as well as establish a priority for each task. It is recommended to use it at an academic and / or university level.

Download Simple and Practical Excel Schedule

School Hours (no weekend)

As its name implies, it refers to a calendar that does not contain the days of the weekend and, therefore, you can add the duties to fulfill from Monday to Friday. It includes four alternatives based on the schedules and their horizontal or vertical distribution.

Download School Schedule (without weekends) Excel

Daily Work Schedule

It is ideal for manage all daily and weekly tasks, as well as for programming events. Basically, it is characterized by being a very interactive template.

Download Excel Daily Work Schedule

Schedule for Students

It is used in academic and educational environments to keep an optimal follow-up of assignments and class scheduling, during the 12 months of the year. One of its greatest advantages is that delivery dates are automatically highlighted.

Download Schedule for Excel Students

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment