Microsoft has a software package that is usually automatically installed on devices with the Windows operating system. Call it Excel, WordPowerPoint, Microsoft Teams, Word, OneDrive, OneNote and Project.
Software development makes it widely used, especially to facilitate the work of its users. Because Microsoft 365 has various functions.
With that in mind, this time Katadata.co.id will discuss about how to create a calendar in excel and Word. These two software are very commonly used.
Excel is software in the form of spreadsheet which makes it easier for users to process and calculate data. In a worksheet, there are many cells distributed by column and row.
While Word is a word processing software. You are free to type anything on a blank page.
For more details, see how to make a calendar in excel and word below which is summarized by the site Wikihow.
How to create a calendar in Excel with the default template
1. Open the latest Excel file by clicking ‘New’ on the card ‘Information’
2. Guy ‘Calendar’ in the search field
3. Select the desired calendar template by scrolling down the screen
4. Cancel the calendar template
5. Configure the calendar as needed
6. Change your calendar view
7. Enter important dates
How to convert Excel calendar to Outlook calendar
1. Open the latest blank Excel file
2. Create the following table titles:
a. Matter (Activities)
b. Start date (Program start)
c. Start time (Start Time)
d. End date (Program Completed)
And. Time out (Time out)
f. Description (Activity description/Description)
g. Position (Place of business)
You need to make sure that the date, month and year fields are created automatically. In accordance with the Excel format, namely BB/HH/TT. The goal is that the Outlook system can read it. Also, column Start date And End date it should also be done according to the format.
3. Complete each table according to the schedule
4. Click “Save As” to save the file
5. Before saving, make sure the file type (format) is CSV (comma separated values)
6. Save the file
7. Open “Outlook”
8. Click on options ‘Calendar’ which is located in the lower left corner
9. Click ‘File’ in the upper left corner
10. Click ‘To open & Export’
11. Select option’Import/Export‘
12. Select the option ‘Import from another program or file‘
13. Select the option ‘comma separated values‘
14. Select the Excel file you created earlier
15. Click ‘End.’
These are two ways that can be applied to create a calendar in Excel. Using Excel is relatively easier because the entered data will be read automatically. Also, the default templates are also different. You can choose it according to your needs. Not only that, you can also freely change the look.
However, it turns out that calendar templates don’t just exist in Excel. But there is also Word which can apply the same thing. For more details, here’s how to create a calendar in Word.
How to create a calendar in Word using a built-in template
1. Open a new Word file
2. Click on the “File” tab in the upper left corner
3. Click ‘New’
4. Guy ‘Calendar’ in the search field
5. Choose an integrated calendar template
6. Click ‘Create’
7. Once you’re done rewinding, edit the calendar as you wish.
How to create a calendar in the Word manual
1. Open a recent Word file
2. Select the option ‘Empty document‘
3. Type the name of the month (January, February, March, April, etc.)
4. Click on the “Insert” tab
5. Select the option ‘Table‘
6. Automatically creates a 7 x 6 table
7. Adjust the size of the table as desired
8. Type the names of the days in the top row of the table
9. Expand the calendar box
10. Manually enter the start date of numbers 1-31
11. Save the calendar by clicking on the option ‘Save as‘ or Ctrl+S
This is a complete explanation of how to create a calendar method in Excel and Word. Complete with alternatives. Excel lets you connect your calendars with Outlook, which is the integrated Microsoft 365 software that can manage your email and schedules in an integrated way.
As with Word, you can create a calendar manually. While it tends to be more complicated, you’ll be more flexible in determining what content you want to upload. For example an important date for an anniversary or the exam schedule.
Excel and Word Online features
Interestingly, you can use Excel and Word regularly on line. This means you can edit documents with other people at the same time from different devices.
Quoted from the site Microsoft supportyou must first have a OneDrive account that you are a part of Microsoft 365. After that, select the storage folder and open the Excel or Word file. Then, the file can be edited automatically on line. Interestingly, it is no longer necessary to save files again when something is changed because the system is automatic.
