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

Method 1 – Inserting Class Times

  • Go to cell C4 and type “PERIODS”.
  • Select all the cells from C4 to K4.
  • Navigate to the Home tab and click on Merge & Center.

merging title to make a class schedule on excel

  • The PERIODS title will extend to all the cells.
  • Apply some styling to this.

title to make a class schedule on excel

  • Select the cells from C5 to E5 and G5 to K5.
  • Format all these cells in Time format as we will insert time data here.

  • Insert all the necessary times in the desired time format.
  • Merge all the cells from F5 to F11 and insert the Break period.


Method 2 – Adding Weekdays

  • Merge cells B4 and B5.
  • Insert the Days title and also insert the weekdays in column B.

adding days to make a class schedule on excel


Method 3 – Entering Subject Classes

  • Enter all the subject classes at their due time.
  • We used some common subjects as an example.

subjects to make a class schedule on excel

  • Enter a subject multiple times using cell referencing without typing them out manually.
  • Click on the cell D9 and enter the formula below:
=D6

duplicating subject to make a class schedule on excel

  • Press Enter.
  • Make a copy of the subject class that you referenced.


How to Make Different Types of Schedule 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. You can insert a simple shape in the appropriate cell to assign a specific task to an employee.

how to make a work schedule on excel


2. Daily Schedule

A daily schedule of the tasks of a specific day is essential 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 ideas that you might have to improve this further.


3. Weekly Schedule

Weekly schedules are helpful for efficiently recording each week’s data. You can add Category rows that group your tasks into different major types. Also, a % Complete row can show the amount of work that was completed relative to the set goal.

how to make a weekly schedule on excel


4. Monthly Schedule

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


Download Practice Workbook

You can download the practice workbook from here.


Related Articles


<< Go Back to Excel for Business | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo