We prefer a calendar-based format, as opposed to just creating a long list of content to be published, because it comes with several benefits: Consistency is insanely critical to content success. It also helps you efficiently fill gaps in your content schedule. For example, if you want an academic calendar, you can search "academic calendar" instead. Blog editorial calendar templates (excel, Google calendar, and Google sheets) Social media calendar templates (excel) Editorial content calendar templates (excel) Hubspot Editorial Calendar Templates. titles, introductions, outbound links, etc.) Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. The further ahead you plan, the better positioned you will be to produce a consistent flow of content. There are 3 types of shows you need to identify within your content: Binge-worthy shows: These shows are big, steady ongoing content initiatives that have the same theme and format. Aside from being super fun to watch, this show is also a fantastic case study for what a true binge-worthy show looks like and for how to build and engage with an audience. A single content asset can also often give rise to several pieces of content, which we refer to as content atomization. You can find Date Picker on the Developer tab, which is hidden by default. It premiers live every Thursday at 4:00 pm PT and includes a live chat with the hosts. Plan your business’ posts and tweets with this social media calendar template in Excel. And the content calendar defines and publishes the specific content. However, the contact form does not seem to work for individuals who are not affiliated with any firm. Select a template. This template also tracks the status of each piece of content, the category it falls under, marketing goals, and more. Whether you plan content on a weekly, monthly or quarterly basis, depending on how quickly your industry or organization moves, there are several universal keys to content calendar success: 1. This meeting can be used to schedule the publishing content from your repository with realistic time frames and to support social media activity, email newsletter inclusions, etc. Whether you plan content on a weekly, monthly or quarterly basis, depending on how quickly your industry or organization moves, there are several universal keys to content calendar success: Fantastic! Instead, everyone needs to be on the same page with what content is being created, plus where and when it’s being published. If you want to convert a list of Excel data into an Outlook calendar, see the next section. Binge-worthy show example: I’m a massive fan of Retro Replay, a relatively new weekly YouTube show that pits two of today’s most well-known video game voice actors against some of the most difficult and/or nostalgic video games of the past. Search for a calendar template. All tip submissions are carefully reviewed before being published, This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. We work to double your digital and we've done that for some of the best companies in the world. You can also take a list of calendar events from a spreadsheet and import them into your Outlook calendar. The actual calendaring part is pretty quick, once you get your shows established. You can usually set the day the week starts as well by selecting it and choosing a new one. Now that we have all of that out of the way, let’s get to the good stuff: calendaring all of our amazing content. There’s a lot of focus on creating new content when we should really be focusing on creating more with less. Convince & Convert, LLC Global HQ 885 S. College Mall Road, #376 Bloomington, IN 47401, Content Marketing Consulting and Social Media Strategy, How to Build a Content Calendar (Plus a Free Template). You could also include a video which explains the wider ramifications of its findings – so on and so forth. On the File menu, click "Close and Return to Microsoft Excel." Before we jump into calendaring our content, let’s talk about what a content calendar actually is and a few baseline requirements for success. CoSchedule. Creating a calendar from a template will allow you to create a blank calendar that you can fill in with events. It may just be a matter of spinning assets a bit differently, giving them an official show title or connecting them in more consistent ways. Make a content library for your assets 5. This yearly report is chock-full of goodness. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. Analytics (both web and social) and revenue data can also be used to make tweaks to already published content (e.g. Excel has a wide variety of useful tools, but one of the criticism is it doesn’t have any built-in calendar tool. Highlight the bullseye looking icon and drag it … to optimize visits and engagement. Start crafting your posts 7. This is because you can schedule the content and they’ll post automatically on your behalf. For certain versions of Excel, such as Excel 2011 for Mac, you'll need to select "New from Template" from the File menu instead of "New." On the Insert menu, click Module. On the Tools menu, point to Macro, and then click Macros. Skills: Content Writing, Data Entry, Excel, Copywriting, Content Strategy Invite your team to review, and use their feedback to improve 8. Go to Developer Tab > Click on Insert button in the Group called Controls > Select more controls from the selection for ActiveX controls > Select Microsoft Date and Time Picker control 6.0 (SP6) > Click OK > Click on the location where you want to place the calendar and drag to define its size > Click on Design mode in the Excel Ribbon > Right-click on the date picker > Select Properties > In the … Instead, because of Google Sheets formulas, you end up saving a ton of time creating your calendar. Tested. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/e1\/Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"