One of the best thing of Excel courses online which can enable everyone on social media. Excelโs utility extends beyond the realm of numbers and graphs to include the management of online and social media content. Creating an editorial schedule and keeping track of upcoming pieces might be facilitated with the help of Excel.ย
After learning Excel courses online, social media and website publication schedule in Excel is very easy but itโs technical. First, ready to learn Excel step by step. Sometimes the file is compatible while installing on your laptop or desktop with all versions of Excel, and if you don’t have it installed on your PC, you can use the free, web-based Excel Online version instead. This version doesn’t require any downloading or installation, and it’s ideal for collaborative projects like this one. The file is incompatible with Google Sheets, so please don’t try to open it there.
Summary Sheet And the Actual Calendar:
We can get a feel for the whole document by looking at its two main sections, the summary sheet and the actual calendar. You can sort the dates in chronological order using the filter, but the calendar is laid out in such a way that you don’t have to.
Proven Facts:
Multiple checks are made for accuracy in the file’s data. For instance, the date column requires an exact date, not just “September” or some other generic month name. There is only one pull-down menu in column B from which you can choose one of three options, such as “published” or “draft.” Column F lists the various social media platforms, and a drop-down menu shows the available platforms alongside their respective color codes. This pull-down menu can be edited freely at your discretion; if you need help, you can learn Excel from one of my online courses.
The keyboard shortcut Alt Gr + A can be used to input the date fast. If that doesn’t work, try entering the date manually and then pressing the F9 button or using the =TODAY() method. The Today function inserts the current date, but it is a dynamic function, so the value will change tomorrow; by pressing F9, we transform the result of a function into a “crystallized” value, so the value will also be fixed the next day. Due to data validation, the sheet won’t let me enter a publication date before the delivery date.
Structure:
The locking of the first row facilitates reference, making it possible to work with the file even when it contains numerous rows. I’ve added a code in column A that should help you keep track of all the different threads. You can select if the post is a video, photo, text, infographic, etc. in column G. A drop-down menu is available for your convenience. I have added category lvl 1, category lvl 2, and category lvl 3 to columns J, K, and L, respectively, for the website and blog. You can put the text, picture, or video file’s URL in column N. A window for inserting the link will appear when you right-click and select the link item.
Colors:
If you want an overview of the scenario, I’ve included various conditional formattings in this document. If you give a post a status of 2 (readiness to publish), the entire row will color red and the text will be yellow to indicate that the post will be published late. Instead, the status is not displayed in red if it is published (or “other see notes”).
Lines of text that are scheduled to be released today are shown in green. Filters allow you to see at a glance which content is red and so overdue, and all content that is green and therefore scheduled for publication today. If you take the time to type everything correctly, the Summary sheet will provide a comprehensive overview of your time spent with friends and family. The Summary sheet is split in half, with the first half devoted to the various social networks and their respective percentages of completion. Naturally, the percentage is zero and the donut chart is hidden when there is no post.
The delivery status can be quickly grasped thanks to the proportion of work done. The second table differs in that it provides a more comprehensive picture of upcoming and past due deliveries and publications, as well as social media networks, via a drop-down menu.
The posts for the next 28 days are included in the total for the last 28 days, therefore there are some that need to be published today as well. This editorial calendar Excel file is very intuitive to use, and its contents are totally dynamic and editable. The only catch is that it won’t function with Google Sheets. Excel Online is a secure option for sharing and collaborating on documents in the cloud.
