How to Make a Class Schedule on Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I am going to share with you step-by-step procedures to make a class schedule on excel. This can be very helpful if you are a teacher or maybe a student. Also, throughout this tutorial, you will learn some valuable tools and techniques that will be helpful in other excel related tasks. In the last section, we will provide some examples of other types of schedules that you can create to manage your tasks.

Download Practice Workbook

You can download the practice workbook from here.

Watch Video – Make a Class Schedule on Excel

Step-by-Step Procedures to Make a Class Schedule on Excel

We have tried to keep our excel dataset area concise to explain the steps clearly. As you can see, this dataset has about 8 rows and 10 columns. Although we may need to do some adjustments as we proceed through the steps to make a class schedule in excel. Note that, initially we have applied All Borders with black color on all the cells of the dataset.

how to make a class schedule on excel

Step 1: Inserting Class Times

  • First, go to cell C4 and type “PERIODS”.
  • Now, select all the cells from C4 to K4.
  • Then, navigate to the Home tab and click on Merge & Center.

merging title to make a class schedule on excel

  • As a result, the PERIODS title will extend to all the cells.
  • Here, you can apply some styling to this.

title to make a class schedule on excel

  • Next, select the cells from C5 to E5 and G5 to K5.
  • Then, format all these cells in Time format as we will insert time data here.

  • Now, insert all the necessary times in the desired time format.
  • Then, merge all the cells from F5 to F11 and insert the break period.

Step 2: Adding Weekdays

  • To begin this step, merge cells B4 and B5.
  • Then, insert the Days title and also insert the weekdays in column B.

adding days to make a class schedule on excel

Step 3: Entering Subject Classes

  • In this step, enter all the subject classes at their due time.
  • Note that, we have used some common subjects as an example.

subjects to make a class schedule on excel

  • Now, you can enter a subject multiple times by using cell referencing without typing them out manually.
  • Here, as an example, click on the cell D9 and enter the formula below:

duplicating subject to make a class schedule on excel

  • Next press Enter.
  • Consequently, this will make a copy of the subject class that you referenced.

How to Make Different Types of Schedule in Excel

Making a work schedule in excel can help you to keep all of your tasks in one place. In the following section, we will see some examples of different types of schedules that you can easily create in excel.

1. Work Schedule

Excel is very efficient in managing the task division of employees. You can create a work schedule like the one below and distribute it among your teams. After making the first copy of this schedule, you can use that same file for efficient updates. To assign a specific task to an employee, you can insert a simple shape in the appropriate cell.

how to make a work schedule on excel

2. Daily Schedule

A daily schedule of the task of a specific day is very important for both students and employees alike. You can make this schedule more visual by grouping your times into small sessions. Here, we have used typical Morning, Afternoon, and Evening sessions. You can also add any idea that you might have to improve this further.

3. Weekly Schedule

Weekly schedules are helpful in keeping a record of each week data in an efficient way. You can add Category rows that will group your tasks into different major types. Also, a % Complete row can show the amount of work that was completed with respect to the set goal.

how to make a weekly schedule on excel

4. Monthly Schedule

We have created below a monthly schedule that is in a Calendar format. This makes it easy to see the summary of a month in terms of various tasks. This type of monthly schedule can also be helpful in laying out all of the important dates you have coming up. For example, you can note things like team meetings, project deadlines, and other significant events.

Read More: How to Create a Recurring Monthly Schedule in Excel


I hope that you were able to apply the steps that I showed in this tutorial on how to make a class schedule in excel. Also, you learned some other types of schedules that you make with very little excel knowledge. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.

Related Articles

Nazmul Hossain Shovon
Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF