Copy the Visual Basic for Applications code below into the module sheet. You should be able to execute this show at least twice per month. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar. These also get plugged into your calendar first. One-time shows: These shows are special quarterly or yearly shows that attack a major customer pain point or topic. The wikiHow Tech Team also followed the article's instructions and verified that they work. Download Your 2021 Content Calendar Template + Bonus Resources. He writes on search and social media for the Manifesto blog. Now, bring this to your editorial meetings and make sure to keep tabs on how content is performing, so you can adjust your publishing flow and content ideation, as necessary. The actual calendaring part is pretty quick, once you get your shows established. See below for a formula that will dynamically return the first day of the current month. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. While there are a ton of amazing, wonderful content calendaring platforms and tools, we’ve opted for an Excel spreadsheet. Now that we have all of that out of the way, let’s get to the good stuff: calendaring all of our amazing content. On the File menu, click “Close and Return to Microsoft Excel.” Click the Sheet1 tab. Note: By default, a template file download goes into the Downloads folder on your computer. Similar to a content calendar, an editorial calendar looks like an actual calendar. Easy to customize, this template can be used by most content teams with a little tweaking. The calendar helped me consistently post unique content every single day of the year, which is why I continue to create a social media content calendar every year. Step 2: Identify and Create Your Content Shows. For example: Repurposing content assets takes away some of the strain of having to come up with a million new content ideas. For example, if you want an academic calendar, you can search "academic calendar" instead. 2. Creating a calendar from a template will allow you to create a blank calendar that you can fill in with events. It also helps you efficiently fill gaps in your content schedule. Instead, start by taking note of all of your existing content or resources to see what can be repurposed and remixed. There are a variety of calendar templates available that you can customize to your liking, which will be a lot quicker than trying to format a calendar yourself. Enter your events. Content marketers need to start to think like television networks and create content shows. And the content calendar defines and publishes the specific content. Invite your team to review, and use their feedback to improve 8. CoSchedule. Audit your social networks and content 2. It will not convert any of … Step 3: Plan, Schedule, Publish, Promote, Track and Tweak Your Content. 3. In this post, we provide a guide to building a content calendar, plus a free template for the year. 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 … On the Insert menu, click Module. Killer content is hard. One-time show example: Who doesn’t love CMI’s annual Benchmarks, Budgets and Trends report?! 5. Note: This example assumes the start date will be provided as the first of the month. In this article, you'll discover how to plan a year's worth of social media posts and content. This nifty eBook shows you the difference, based on our real-world work with dozens of brands. To add your content to the calendar and get the most out of your content: That’s it! Click CalendarMaker, and then click Run to create the calendar. 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. If you’re already familiar or just want the highlights, content marketers need to start to think like television networks and create content shows. If you’re not familiar with Jay Baer’s concept of creating content shows, you can read his in-depth post about content shows. Start crafting your posts 7. This template also tracks the status of each piece of content, the category it falls under, marketing goals, and more. 3. Select all your dates (from B6 to AF6) Open the Format Cells dialog box (Ctrl+1 or Home>Cell format>More Number format) Select the Custom category Enter ddd dd in the Type field. For example, an infographic can support a blog post that analyzes the integrity of the data on which it was based. Open your calendars to everyone: While not everyone should have the ability to edit a master content calendar, everyone should at least know where the content calendar is located and have viewing access. Yes, amazing new ideas and brilliant sparks of creativity help, but we can’t rely on them alone. Regularly scheduled program example: Convince & Convert’s own blog is our version of regularly scheduled programming. Highlight the bullseye looking icon and drag it … If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. You can set up the social media content calendar template for whatever channels you use, like Twitter, Facebook, and Instagram. By signing up you are agreeing to receive emails according to our privacy policy. Excel will search through thousands of templates online and show you a selection of daily , weekly , monthly and yearly calendar templates grouped into categories, like shown in the screenshot below: 6. ; To change the background color of the weekday header or of an event entry, highlight the cell, click the paint bucket icon, and select the fill color. For this, just click File > New , and type "calendar" in the search box. % of people told us that this article helped them. You can do this with Excel or Google Sheets. These free marketing calendar templates are in Excel and PDF formats. Make a content library for your assets 5. That is precisely where content calendars come into play. This yearly report is chock-full of goodness. So, go ahead and insert Sunday, for example, into the B3 cell. Create a new workbook. There’s a lot of focus on creating new content when we should really be focusing on creating more with less. Using a social media calendar will help you plan your content around smart social media goals and coordinate with campaigns and blog content to achieve them. Jamie is the inbound marketing strategist at London based digital agency Manifesto. Please do as follows to create a dynamic monthly calendar in Excel. If you don’t have any shows in your existing content assets, or you need more shows to round out your calendar, then you’ll want to focus on creating new content shows. It premiers live every Thursday at 4:00 pm PT and includes a live chat with the hosts. Search for a calendar template. On the Developer ribbon, Click Visual Basic. Social Media Calendar Template for Small Business A content calendar helps you deliver the right message to your audience at the right time. On the Tools menu, point to Macro, and then click Macros. Using apps such as Hootsuite , Buffer and PostPlanner make the process easier. Social Media Marketing, Social Media Research. Even just opening a blank Excel spreadsheet can feel overwhelming. Excel Calendar Template. {"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":"