how to create content calendar in excel

Step 3: Plan, Schedule, Publish, Promote, Track and Tweak Your Content. What holiday is it on the 21st march 2028? 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). Click on the cell with the text you’d like to modify, and in the Home tab, you can change the font type, font size, font color, or make the text bold, italicized, or underlined. Social Media Calendar Template for Small Business Audit your social networks and content 2. It premiers live every Thursday at 4:00 pm PT and includes a live chat with the hosts. On the Developer ribbon, click Macros. A content calendar helps you deliver the right message to your audience at the right time. You need to create a Form Controls Combo Box in advance. This is because you can schedule the content and they’ll post automatically on your behalf. While Excel shines easily when you want to log this data, it has no quick way to visualize this information. On the File menu, click "Close and Return to Microsoft Excel." Browse through the calendar templates, choose an Excel calendar template that is best for you. This yearly report is chock-full of goodness. Use this customizable content marketing calendar template to develop your content strategy. 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 … 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. Step 2: Identify and Create Your Content Shows. #1: Create a Spreadsheet The first step in creating a content calendar is to set everything up in a spreadsheet. 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. Next, click on the cell and look for the blue rectangle at the bottom right corner. Decide what your calendar needs to track 4. Step 1: Start with Existing Content Assets. Now you can edit and update it, as needed. So, go ahead and insert Sunday, for example, into the B3 cell. In fact, these shows are something that they actually look forward to. It’s important to note that you most likely already have content shows in your existing content assets, so check your inventory first. 1. Think of them as what a local nightly news show is to any major television network. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar. The template divides the whole month into separate weeks and individual days with proper allotment of interesting topics and mention of publishing time and gateways. A single content asset can also often give rise to several pieces of content, which we refer to as content atomization. Before we jump into calendaring our content, let’s talk about what a content calendar actually is and a few baseline requirements for success. As far as I have found out, the only holiday in March in 2028 is Memorial Day, BUT it's on the 29th. You should be able to execute this show at least twice per month. Think white papers, research papers, contests, user-generated content campaigns, etc. It’s also usually not necessary to produce all your content from scratch since we often leave heaps of valuable content just lying around. Step 1 Create a new Excel workbook, click the "File" menu and choose "Options." Include your email address to get a message when this question is answered. Killer content is hard. We use cookies to make wikiHow great. wikiHow's. 49 Tactics to Atomize Your Content Marketing, read his in-depth post about content shows. 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. It has to be done on a regular, ongoing basis. Highlight the bullseye looking icon and drag it … Start publishing/scheduling Pro Tip: If this is your first time making a calendar for social, you might want to crack open our guide to creating a social media marketing strateg… Create … Creating a calendar from a template will allow you to create a blank calendar that you can fill in with events. Identify the keyword to be used in the content/persona targeted /industry targeted/ Article title / Media. However, the contact form does not seem to work for individuals who are not affiliated with any firm. There are 8 steps to creating an effective social media calendar: 1. One-time show example: Who doesn’t love CMI’s annual Benchmarks, Budgets and Trends report?! This social media calendar 2016 is in an Excel format. 5. Then draw a Combo Box in cell A1. 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. wikiHow is where trusted research and expert knowledge come together. 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. Establish a workflow 6. Similar to a content calendar, an editorial calendar looks like an actual calendar. Perfect for individuals or teams, when you’re starting a new blog, or simply want to “scale up” your existing blogging efforts. 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. Changing Fonts and Colors. Select a template. Last Updated: January 12, 2020 Invite your team to review, and use their feedback to improve 8. By using our site, you agree to our. Instead, everyone needs to be on the same page with what content is being created, plus where and when it’s being published. Seriously, check it out. Copy each month, then adjust the dates. This template also tracks the status of each piece of content, the category it falls under, marketing goals, and more. However, the fastest and easiest way create a calendar in Excel is to pick a free Excel calendar template. The wikiHow Tech Team also followed the article's instructions and verified that they work. % of people told us that this article helped them. These are often podcasts, video series, webinar series, white papers, reports, etc. 4 Higher Education Content Marketing Examples that Any School Can Implement, The 4 Best Practices of Healthcare Social Media Marketing for 2020. We define a content calendar as a shareable resource that teams can use to plan all content activity. This post was originally written by Jamie Griffiths in 2014, and extensively updated by Anna Hrach, Digital Strategist here at Convince & Convert, in 2019. One-time shows: These shows are special quarterly or yearly shows that attack a major customer pain point or topic. You can create a social media calendar in an Excel spreadsheet. If you want to convert a list of Excel data into an Outlook calendar, see the next section. This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. In this article, you'll discover how to plan a year's worth of social media posts and content. On the File menu, click “Close and Return to Microsoft Excel.” Click the Sheet1 tab. 1. The process will be a little different depending on the template you are using. Download Your 2021 Content Calendar Template + Bonus Resources. Tested. Regularly scheduled programming: These shows are ongoing content initiatives that round out your calendar, and they don’t have to necessarily connect completely or be 100 percent consistent in theme. The content editorial calendar template is detailed and insightful and is provided in an excel format. 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. Analytics (both web and social) and revenue data can also be used to make tweaks to already published content (e.g. Create a dynamic monthly calendar in Excel. That is precisely where content calendars come into play. Blog editorial calendar templates (excel, Google calendar, and Google sheets) Social media calendar templates (excel) Editorial content calendar templates (excel) Hubspot Editorial Calendar Templates. It’s the process of taking one big piece of content and spinning it out into eight smaller pieces of content. Content marketers need to start to think like television networks and create content shows. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. Microsoft Excel 2007 or later. On the second row type the days of the week (one day per cell). Excel Calendar Template. Social Media Marketing, Social Media Research. Note: By default, a template file download goes into the Downloads folder on your computer. Please do as follows: 1. On the Insert menu, click Module. You can find Date Picker on the Developer tab, which is hidden by default. Easy to customize, this template can be used by most content teams with a little tweaking. Click Developer > Insert > Combo Box (Form Control). And the content calendar defines and publishes the specific content. The further ahead you plan, the better positioned you will be to produce a consistent flow of content. One could not ask for more because you got it all covered. We’ve provided a basic content calendar for you to use. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. CoSchedule. If you’re not familiar with Jay Baer’s concept of creating content shows, you can read his in-depth post about content shows. to create Calendar in Excel you should follow the below steps, Step 1: Leave the first row in your spreadsheet blank. They’re too inconsistent and unreliable. Okay content is easy. Like in the case of blog posts, they may have a different author, topic or format, depending on the content, but they always connect back to the content strategy and have at least one clear audience in mind. You can get more specific with your search depending on your needs. Change the calendar view with clicking View > Change View > List. 2. While not known as a calendar program, you can use Excel to create and manage your calendar. {"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":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/65\/Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/65\/Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/e1\/Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/5\/58\/Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/e3\/Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/84\/Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, Importing an Excel List into Outlook Calendar, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c7\/Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c7\/Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/14\/Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg","bigUrl":"\/images\/thumb\/1\/14\/Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/81\/Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/62\/Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg","bigUrl":"\/images\/thumb\/9\/95\/Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/30\/Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg","bigUrl":"\/images\/thumb\/3\/30\/Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f2\/Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg","bigUrl":"\/images\/thumb\/f\/f2\/Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg","bigUrl":"\/images\/thumb\/8\/84\/Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c1\/Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg","bigUrl":"\/images\/thumb\/c\/c1\/Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/17\/Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg\/v4-460px-Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg","bigUrl":"\/images\/thumb\/1\/17\/Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg\/aid2105197-v4-728px-Create-a-Calendar-in-Microsoft-Excel-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"