WinCalendar Logo

Excel Calendar Template

Blank Calendar Templates in Excel format are available to download for free. Ideal to use as a spreadsheet calendar planner, school calendar, and much more. All Excel Calendar templates come blank, ready to print, and are compatible with OpenOffice. All Calendar Templates on WinCalendar are available to download for free!

Excel Calendar

Monthly Calendar Excel download files

Click to Download. 🔍preview

Full Year Calendar Excel download files

Monthly and Weekly calendar layouts

2023 Calendars

  • 2023 Weekly Calendar with week Num. 🔍preview
  • 2023 Weekly Calendar - starts with Monday 🔍preview
  • 2023 Calendar 🔍preview
  • 2023 Calendars with US Holidays…
  • 2023 Calendars …
  • More 2023 Calendars …

2024 Calendars

  • 2024 Weekly Calendar with week Num. 🔍preview
  • 2024 Weekly Calendar - starts with Monday 🔍preview
  • 2024 Calendar 🔍preview
  • 2024 Calendars with US Holidays…
  • 2024 Calendars …
  • More 2024 Calendars …

All calendars are expertly designed for easy editing and printing. For additional layouts see links on the left.

All calendars were created using WinCalendar.  For more layouts, colors, options and for religious holidays download WinCalendar from WinCalendar.com:

  • You can even convert Microsoft Outlook , Google , Yahoo and ical Calendar to Word and Excel format using WinCalendar.
  • Forecast Ovulation & Fertility on calendars and schedules.
  • WinCalendar integrates with Microsoft Office and comes with a free pop-up calendar & date picker .

How to Make an Interactive Calendar in Excel? (FREE Template)

If you like to plan ahead and make a weekly or monthly schedule, having a calendar in Excel could be quite useful.

In this tutorial, I’m going to show you how to create a calendar in Excel that automatically updates when you change the month or the year value.

I will show you the exact process to create the interactive monthly and yearly calendar, and I also have these as downloadable Excel files, so that you can use them offline.

You can print these calendar templates and manually create the schedule on paper.

Before I get into the nitty-gritty of making the calendar in Excel, let me show you what the final output would look like.

Click here to download the monthly calendar Excel template

Click here to download the yearly calendar Excel template

This Tutorial Covers:

Demo of the Interactive Calendar in Excel

Below is an example of the interactive monthly calendar in Excel where you can change the month and year value and the calendar would automatically update (you can also highlight holidays or specific dates in a different color).

It also highlights the weekend dates in a different color.

And on similar lines, below I have the yearly calendar template, where when you change the year value the calendar automatically updates to give you the calendar for that year.

The weekend dates are highlighted in a different color and if you have a list of holidays (or important dates such as project deadlines or birthdays/anniversaries), then those holidays are also highlighted in the calendar.

Now let me quickly explain how I have created this calendar in Excel.

Some Pre-requisite Before Creating the Interactive Calnedar in Excel

While most of the heavy lifting in this calendar is done by some simple formulas. you need to have a few things in place before you make this calendar.

Have the Holiday List and Month Names in Separate Sheets

Before starting to make the calendar, you need to have the following two additional sheets:

  • A sheet where you have a list of all the holidays and the dates on which these holidays occur. You can also use this to add important dates that you want to get highlighted in the calendar (such as birthdays, anniversaries, or project deadlines)
  • A list of all the month names . This is for the monthly calendar template only, and is used to create a drop-down that shows the month names.

If you download the calendar template for this tutorial, you will see these two additional sheets.

For the sake of simplicity, I have kept these two sheets separate. If you want, you can also combine and have the holiday dates and the month names on the same sheet.

For this calendar, I have used the holidays in the US. You can change these to your region’s holidays, and even add important days such as birthdays or anniversaries so that they can be highlighted in the calendar.

The data from this holiday sheet would be used to highlight the holiday dates in the calendar.

Create Drop Down Lists To Show Month Names and Year Values

Since I want this calendar to be interactive and allow the user to select the date and the year value, I will:

  • Have a cell where the user can input the Year value
  • Create a drop-down list that will show the month names from where the user can select the month

Note that the month drop-down list is needed only for the monthly calendar template, as in the yearly calendar template all the months are shown anyway.

Below are the steps to do this:

  • Enter Year in cell A1 and Month in cell A2
  • In cell B1, enter the year value manually (I will use 2022 in this example)
  • Select cell B2
  • Click the Data tab
  • In the Data Tools group, click on the Data Validation icon
  • In the Data Validation dialog box that opens, in the Settings tab, in the Allow options, make sure List in selected
  • In the Source field, enter =’Month Names’!$A$1:$A$12 (or select the field and then go the Month Names tab and select the month names in column A)

The above steps would give you a drop-down list in cell B2, where you can select the month name.

Now that we have a place to enter the year value and select the month name, the aim here is to create a calendar that would automatically update as soon as we change the month/year values.

So it’s time to go ahead and build that awesome calendar in Excel.

Creating the Monthly Calendar in Excel (that Auto-updates)

You can download this monthly calendar template by clicking here

The first thing I need to build this monthly calendar is to have the weekday names in a row (as shown below).

After entering the day name , I’ve also given it a background color and increased the column width a little.

Now it’s time for the formulas.

While I can create one single formula that will give me the values in the calendar grid that I have created, it would become quite big.

So for the purpose of this tutorial, let me break it down and show you how it works.

For the formula to work, I will need two values:

  • The month number for the selected month (1 for Jan, 2 for Feb, and so on)
  • Getting the Weekday value for the first day of the selected month (1 if the month starts on Monday, 2 if it starts on Tuesday, and so on)

Formula to get the month number of the selected month:

Formula to get the weekday value of the first day of the month

I have the output of these formulas in cells M4 and M5 as shown below.

Now that I have these values, I will be using these in the main formula that I will be using in the calendar grid.

Below is the formula that will give me the dates in the calendar:

This is an array formula, so you just need to enter it in cell D5, and the result would spill automatically to all the other cells in the calendar.

Note: This formula would only work in Excel for Microsoft 365, Excel 2021, and Excel for the web. This is because it uses the SEQUENCE function, which is a new formula and is not available in the older version of Excel.

In case you’re not using Excel for Microsoft 365 or Excel 2021, you can use the below formula instead:

Enter this formula in cell D5, and then copy and paste it for all the other cells in the calendar grid.

The result of the formula is the date serial number, so you may either see a serial number (such as 44562) or a date.

While this is good enough, I only want to show the day number.

Below are the steps to change the format of the cells to only show the day number from the date value:

  • Select all the cells in the calendar
  • Hold the Control key and press the 1 key (or Command + 1 if using Mac). This will open the Format Cells dialog box
  • Select the Numbers tab in the Format Cells dialog box (if not selected already)
  • In the Category options. select Custom
  • In the Type field, enter d

The above steps would only display the day number in the calendar.

As I mentioned, I broke down the formula to make it easier for you to understand how it works. In the templates you download, I have used one single formula only to generate the entire calendar.

Adding a Dynamic Title for the Calendar

The next step in making this dynamic calendar would be to add a dynamic title – that would tell us for what month and year does the calendar shows.

While I can see these values in cells P1 and P2, it would be easier if I create a title that shows me the month and year value right above the calendar.

To do this, I have used the below formula in cell D3:

This is a simple concatenation formula that combines the value in cell B2 and cell B1 (separated by a space character)

If you make any changes in the month and year selection, this value would automatically update along with the calendar.

I’ve also done the below cosmetic changes to make it look like a header and align it to the center of the calendar:

  • Select cell D3 and change the color and size of the text and make it bold
  • Select cell D3:J3
  • Right click and then click on Format Cells
  • In the Fomat Cells dialog box, click on the Alignment tab
  • Select Center Across Selection option in the Horizontal drop down

Highlight the Weekend Days

This one is simple.

Just select all the days in the calendar which represent the weekend and give it a different color.

In this example, since Saturday and Sunday are weekend days for me, I have highlighted these inner light yellow color

Highlighting Holidays in the Calendar

And the final thing that I want to do in this calendar is to highlight all the days that are holidays in a different color.

As one of the previous steps, we already created a separate holiday worksheet where I listed all the holidays for the current year.

Something as shown below:

Below are the steps to highlight all these holiday dates in the calendar:

  • Select all the cells in the calendar (excluding the day name)
  • Click the Home tab
  • In the Styles group, click on Conditional Formatting
  • In the Conditional Formatting options, click on New Rule
  • In the New Formatting Rule dialog box, select the option – ‘Use a formula to determine which cells to format’
  • In the field that shows up, enter the following formula:
  • Select the format in which you want to highlight the cell with holiday date (click the Format button to choose the color)

The above steps apply a conditional formatting rule in the selected cells, where each date in the calendar is checked against the holiday list that we provided.

In case the formula finds a date in the holiday list, it’s highlighted in the specified color, else nothing happens

That’s it!

If you follow the above steps, you will have an interactive dynamic monthly calendar that would automatically update when you make the year and month selection. It would also automatically highlight those dates that are holidays.

Creating the Yearly Calendar in Excel (that Auto-updates)

You can download this yearly calendar template by clicking here

Just like the monthly calendar, you can also create a yearly calendar that automatically updates when you change the year value.

The first step in creating the yearly calendar is to create an outline as shown below.

Here I have the year value in the first row, and then I have created the monthly grids where I’ll populate the dates for the 12 months. I have also highlighted the weekend dates (for Saturday and Sunday) in yellow.

For the yearly calendar, we don’t need the Month Names sheet, but we would still be using the holiday list in the Holidays sheet to highlight those dates that are a holiday.

Now let’s start building this yearly calendar.

Have Month Names Above Each Month Calendar

For this yearly calendar to work, I will somehow need to refer to the month value in the formulas for that month (i.e. 1 for Jan, 2 for Feb, and so on)

Let me show you a cool trick that will allow me to use the month number but at the same time instead of showing the number show the month name instead

Follow the below steps to do this:

  • In cell B3, which is the left-most cell above the first month calendar grid, enter 1
  • With cell B3 selected, hold the Control key and press the 1 key (or Command + 1 for Mac). This will open the Format Cells dialog box
  • In the Format Cells dialog box, make sure the Number tab is selected
  • Click on the ‘Custom’ option in the left pane
  • In the ‘Type’ field on the right, enter the text “January”

The above steps format cell B3 to show the full month name. And the good thing about this is that the value in the cell still remains 1, and I can use these values in the formulas.

So while the value in cell B3 is 1, it is displayed as a January.

Pretty Cool… right!

When you do the above, you may see the ## signs instead of the month name. This happens when the cell width is not enough to accommodate the entire text. Nothing to worry about – this will be sorted we align the text in the center (covered next)

You need to repeat the same process for all the months – where you enter the month number in the top-left cell in the above row off the calendar month grid (I,e, 2 in J3 and 3 in R3, and 4 in M12 as so on).

And for all these numbers, you need to open the format cells dialog box and specify the month name for each number.

This is just a one-time setup, and you won’t be required to do this again.

Also, you can reposition the name of the month so that it appears in the center above the monthly calendar grid.

You can do this using the Center Across Selection technique.

To do this:

  • Select cell B3:H3 (for January Month)

After doing this, the month names will be shown right above the monthly calendar and aligned to the middle.

You can also format the month name if you want. In the calendar I have made, I made the month name bold and changed the color to blue.

Once you have done this for all the months, you will have the structure in place, and we can go ahead and enter the formulas.

Formulas to Make the Dynamic Yearly Calendar

Similar to the monthly calendar, you can use the below formula for January:

As soon as you enter the formula in cell B5 for January, it will spill and fill the entire grid for the month.

And again, since we are using the SEQUENCE formula, you can only use this in Excel for Microsoft 365, Excel 2021, and Excel for the web.

You can use the same formula for other months as well, with one minor change (replace $B$3 with $J$3 for February, $B$3 with $R$3 for March, and so on).

This is because we have the month number for each month in a different cell, and we need to refer to the month value for each month in the formula.

And the final step of creating this dynamic yearly calendar is to highlight those dates that are holidays (these dates are specified in the holiday worksheet).

  • Select all the cells for the month of January month (B5:H10)
  • Click on Conditional Formatting
  • Click on New Rule from the options in the drop-down
  • In the field that shows up, enter the following formula: =ISNUMBER(VLOOKUP(B5,Holidays!$B:$B,1,0))
  • Click the Format button to specify the format for the cells (I chose yellow color with red border)

The above steps would check all the dates in January and highlight those that are marked as a holiday in the holiday worksheet.

You will have to repeat this process for all the months with one minor change.

In the following formula that we use in conditional formatting, you need to replace cell B5 with the top-left cell reference of that month.

For example, if you are doing it for February, then instead of B5, use J5, and for March, use R5.

Once done, all the holidays will be highlighted in the yearly calendar as shown below.

In the downloadable templates that I have provided, I have made sure that the entire calendar would fit one single sheet when printed.

So this is how you can create an interactive calendar in Excel that automatically updates when you change the month value and the year value.

I hope you found this tutorial useful.

Other Excel tutorials you may also like :

  • Excel Holiday Calendar Template 2021 and Beyond (FREE Download)
  • Calendar Integrated with a To Do List Template in Excel
  • How to Get Month Name from Date in Excel (4 Easy Ways)
  • Calculate the Number of Months Between Two Dates in Excel
  • FREE Monthly & Yearly Excel Calendar Template
  • Excel To Do List Template – 4 Examples (FREE Download)

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Leave a comment cancel reply.

BEST EXCEL TUTORIALS

Best Excel Shortcuts

Conditional Formatting

Excel Skills

Creating a Pivot Table

Excel Tables

INDEX- MATCH Combo

Creating a Drop Down List

Recording a Macro

© TrumpExcel.com – Free Online Excel Training

Privacy Policy  | Sitemap

Twitter | Facebook | YouTube | Pinterest | Linkedin

Excel Dashboards

Excel Tutorial: How To Create A Monthly Calendar In Excel

Introduction.

Creating a monthly calendar in Excel can be a game-changer for those who want to stay organized and efficient. In this tutorial, we will cover step-by-step instructions on how to create a customizable and user-friendly monthly calendar using Excel. Whether you need it for personal use, work, or school, mastering this skill will help you stay on top of your schedule with ease.

Key Takeaways

  • Creating a monthly calendar in Excel can greatly improve organization and efficiency.
  • Setting up the spreadsheet with proper formatting and labels is crucial for a user-friendly calendar.
  • Using conditional formatting can help highlight important dates and events on the calendar.
  • Making the calendar interactive with dropdown lists and formulas allows for easy customization and navigation.
  • Excel offers practical uses and benefits for calendar creation, making it a valuable tool for personal, work, or school use.

Setting up the spreadsheet

Creating a monthly calendar in Excel can be a useful tool for organizing your schedule and staying on top of important dates. Follow these steps to set up the spreadsheet for your monthly calendar.

A. Open a new Excel spreadsheet

To start creating your monthly calendar, open a new Excel spreadsheet on your computer. This will serve as the foundation for building your calendar layout.

B. Adjust the column widths and row heights for the calendar layout

Click and drag to adjust the column widths and row heights to create a grid layout for your calendar. Ensure that each cell is evenly sized to accommodate the dates and weekdays.

C. Add titles and labels for the days of the week and dates

At the top of the spreadsheet, add titles for each day of the week (e.g., Monday, Tuesday, Wednesday, etc.) This will help you organize the dates within the calendar. Below the days of the week, add the numerical dates for each day of the month.

Formatting the calendar

When creating a monthly calendar in Excel, it's important to ensure that the layout is clear and easy to read. This can be achieved through proper formatting techniques. Here are a few tips to help you format your calendar effectively:

Apply cell borders to separate the days and dates

  • Open your Excel spreadsheet and select the cells that contain the days of the week and the dates for the entire month.
  • Go to the "Home" tab and click on the "Borders" dropdown menu in the "Font" section.
  • Select the option to add borders to the cells. You can choose to add borders to the top, bottom, left, and right of each cell to clearly separate the days and dates.

Use conditional formatting to highlight the current date

  • To make it easy to identify the current date at a glance, you can use conditional formatting in Excel.
  • Select the cell or range of cells that contain the dates, and then go to the "Home" tab.
  • Click on "Conditional Formatting" in the "Styles" section and choose the option to highlight cells rules. From there, select "A Date Occurring" and then choose "Today" from the dropdown menu. You can then choose a formatting style to apply to the current date, such as a different font color or background color.

Choose a color scheme for the calendar

  • Adding a color scheme to your calendar can make it more visually appealing and easier to read.
  • Consider using a different color for the header row, weekends, and special dates such as holidays or important events.
  • You can also use color to differentiate between different types of activities or appointments on the calendar, such as work-related tasks and personal events.

Adding the dates

Creating a monthly calendar in Excel requires adding the dates for the specific month. Here are the steps to do so:

A. Enter the dates for the specific month

Begin by typing the first date of the month into the first cell of a column in Excel. For example, if the month is January, type "1/1/2023" into cell A2.

B. Use the fill handle to quickly populate the dates for the entire month

Once the first date is entered, you can use the fill handle to quickly populate the dates for the entire month. To do this, click and hold the fill handle (a small square in the bottom-right corner of the cell), drag it down to cover all the days in the month, and release the mouse button.

Note: You can also use the fill handle to populate the dates horizontally by dragging it to the right.

C. Adjust any dates that fall outside of the month

After populating the dates, you may need to adjust any dates that fall outside of the specific month. For instance, if the month starts on a Wednesday, the dates for the previous days will be included in the previous month. Ensure to adjust these dates accordingly.

Including events or appointments

When creating a monthly calendar in Excel, it's important to include events or appointments to effectively manage your time and schedule. Here are some tips on how to incorporate events into your monthly calendar:

A. Use conditional formatting to highlight specific dates with events

Conditional formatting can be a useful tool to visually distinguish dates with upcoming events or appointments. By setting up conditional formatting rules, you can make the cells for these dates stand out with a different color or font style, making it easier to identify important dates at a glance.

B. Add a key or legend for different types of events

It's helpful to have a key or legend that denotes the different types of events or appointments on your calendar. This could include color-coding for different categories of events (e.g., work-related, personal, holidays), or specific symbols to indicate recurring events, deadlines, or meetings. Adding a key or legend can provide a quick reference guide for understanding the various events on your calendar.

C. Input the details of each event or appointment in the corresponding date cell

For each event or appointment on your calendar, be sure to input the relevant details into the corresponding date cell. This could include the event name, time, location, and any additional notes or reminders. By inputting this information directly into the calendar, you can keep all the necessary details in one central location for easy access.

Making the calendar interactive

Creating an interactive monthly calendar in Excel can be a useful tool for keeping track of important dates, deadlines, and appointments. By making the calendar interactive, you can easily navigate between different months and years, and customize it to fit your specific needs. Here are some tips on how to make a monthly calendar in Excel more interactive:

A. Create dropdown lists for selecting the month and year

One way to make the calendar interactive is to add dropdown lists for selecting the month and year. This allows users to easily change the month and year displayed on the calendar without having to manually update the cells.

B. Use formulas to adjust the calendar based on the selected month and year

Once the dropdown lists for the month and year are in place, you can use formulas to dynamically adjust the calendar based on the selected month and year. For example, you can use the =DATE() function to calculate the dates for each day of the month based on the selected month and year.

C. Add buttons for navigating to the previous or next month

To further enhance the interactivity of the calendar, consider adding buttons for navigating to the previous or next month. This allows users to easily move between different months without having to manually change the month and year in the dropdown lists.

Creating a monthly calendar in Excel is a simple and effective way to stay organized and on top of your schedule. By following the steps outlined in this tutorial, you can easily customize a calendar to fit your specific needs. The practical uses of using Excel for calendar creation are numerous, from tracking appointments and meetings to managing project deadlines. Additionally, the benefits of using Excel include its flexibility, ease of customization, and the ability to easily share and collaborate on calendars with others. I encourage you to practice creating a calendar in Excel and explore further customization options to tailor it to your unique requirements.

Excel Dashboard

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

Excel Tutorial: What Does #### Mean In Excel

Excel Tutorial: What Does #### Mean In Excel

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Making Write 15 Minutes On A Timesheet

Making Write 15 Minutes On A Timesheet

Making Identify Sheet Sizes

Making Identify Sheet Sizes

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

  • Choosing a selection results in a full page refresh.

Get started

  • Project management
  • CRM and Sales
  • Work management
  • Product development life cycle
  • Comparisons
  • Construction management
  • monday.com updates

Access a monthly schedule template for Excel

monthly activity calendar excel

One of the most important parts of operating a business is managing its schedule. A monthly schedule template for Excel can help accomplish this by laying out all the important dates you have coming up. This can inform you of team meetings, project deadlines, and other significant events.

In this article, you’ll see how creating a simple monthly schedule using an Excel calendar template can clear the fog ahead and set you and your company up for ongoing success. In order to create a monthly schedule template, having a clear definition of what a schedule template is is a must.

Get the template

What is a monthly schedule template for Excel?

A blank printable monthly schedule template is a simple, yet effective tool for laying out upcoming events, important dates, and project deadlines in a single place. The monthly schedule template allows you to plan for the weeks and months ahead so that you and your team members can stay on top of your workloads.

A typical Microsoft Excel or Google Sheets monthly schedule template will include an outline for each month of the year, either as a single worksheet or 12 individual worksheets. Each month is broken down into the days of the week, beginning with Sunday or Monday. There is also a space for writing notes in a side column, a built-in to-do list, and budget and task trackers.

Tracking events and schedules is a crucial part of running a successful team, but it also has specific benefits when it comes to project management.

Download Excel template

Why use a monthly schedule template?

The role of the monthly schedule is self-explanatory: it provides you with a lay of the land, mapping out which important events and dates are approaching. However, it can also help you streamline project management, build harmonious team dynamics, and stay on top of client deadlines when used effectively.

69% of project planners claim that senior management values project management. Since time scheduling is a cornerstone of task management, the monthly schedule can be critical for hitting professional goals and efficient workflows.

The monthly schedule template for Excel divides months into weeks and weeks into days. Like a school calendar, it shows you all significant upcoming dates at a glance, but you can also zoom in and see what individual tasks you have on your plate each day.

With a monthly schedule template in place, you’re less likely to be blindsided by deadlines or meetings that could otherwise pass you by. You can set up a system of checking your schedule regularly, so you can have an eye on the big picture and ensure you’re on track to complete your long-term goals. It also helps you avoid getting bogged down in the minutiae of your day-to-day roles and responsibilities.

Monthly schedule timeline view example

When you have a monthly schedule, you can share it with your team, so you’re all on the same page. Syncing up your calendars with the schedule, you can lower the risk of missing project deadlines as the responsibility is shared. 20% of work time is taken up by team collaboration, so it’s important that teams are equipped with tools to sync up their workflows.

Monthly scheduling templates likely look different from company to company, but it’s sometimes helpful to know what you need once you’ve seen some examples.

What are some examples of monthly schedule templates?

From marketing campaign scheduling calendars to templates for project deadlines, there are several ways you can go about creating your monthly schedule template. Let’s take a look at a few templates for inspiration.

1. Marketing monthly schedule template

example of a monthly marketing schedule

( Image Source )

Use the marketing monthly employee schedule to outline your strategy for each marketing channel you use. If you’re planning on pouring resources into social media marketing, for example, this template can help you allocate the necessary human and financial capital. It can also provide you with a means of tracking the timeline to completion on a month-to-month basis.

2. Meeting monthly schedule template

screenshot of monthly meeting plan

Using it in tandem with automatic reminders is a powerful and effective way to stay on top of your work responsibilities. If you’re liable to forget a particular event, having it written down on a schedule like this and set up as a reminder is a surefire way to keep it in your mind.

3. Monthly schedule template for project deadlines

example of a monthly schedule deadline template

Deadlines can creep up on you if your focus lies elsewhere. It’s easy to develop tunnel vision while working on a single project. To ensure you never miss a deadline again, set up a monthly deadline tracking system like this one, and you’ll have a visual reminder of important upcoming due dates.

The above examples will certainly help you plan your monthly activities, but as far as customization goes or the ability to seamlessly include it in your workflow, you may feel limited. To edit events in real-time, tag coworkers, receive status updates on task progress, and keep all of your work in one place, you can turn to a monday.com template.

monday.com’s monthly schedule template

The monday.com monthly schedule template for Excel is simple to use and can streamline your efforts to organize your workload. With a template like this one, you’ll be able to stay on top of several projects consecutively, meeting deadlines and attending meetings punctually.

The template does all the heavy lifting for you, so all that’s left to do is enter information about your activities for each day of the week. That way, the upcoming month’s work won’t feel quite as overwhelming.

monthly schedule main table view example

monday.com’s monthly schedule template is customizable to suit your needs. You can also use the monthly template from monday.com in tandem with the remote work and weekly schedule templates. Syncing up your schedule with those of your colleagues can make it easy to coordinate and collaborate on projects. The template is fully online so your team can add information in real-time.

monday work management grants you access to effective project management solutions , which you can rely on for mapping out project milestones in a single interface for everyone to see. With the Work OS, teams can attach or link any work on the template to their workflows and tag peers to keep them in the loop.

monday.com has dozens of pre-built, customizable templates so teams can get started on workflows immediately. From content calendars to daily work schedules, let’s take a look at some other scheduling templates.

Related templates

monday.com has a handful of related templates that can be used in conjunction with the monthly schedule template.

Content calendar

The content calendar template from monday.com provides a framework for all things content. With it, you can map out your content marketing strategy, including publishing dates, key deadlines, and relevant workflows.

When used with the monthly schedule template, the content calendar schedule can sync up your content-producing responsibilities with everything else you have on your plate. For example, calendar templates like this one can be shared with the sales and marketing departments to ensure a cohesive approach to content production.

Remote work schedule

The monday.com remote work schedule template allows you to manage a remote team or collaborate with coworkers even while you’re out of the office. The template lets you create tasks, delegate them, and then execute them all according to your criteria and timelines.

Daily work schedule

The daily work schedule template is the micro-level organization system to match the macro-level monthly schedule. If you have too much on your plate to cover in a monthly schedule, the daily work schedule can help you free up headspace as you list out everything on your to-do list for each upcoming workday.

Have some additional questions about schedule templates? We answer a few of the most popular questions below.

FAQs about monthly schedule templates

How do i make a monthly schedule.

To make a monthly schedule, download the monday.com Excel template, and add all the relevant information in the corresponding fields. If you have a meeting that takes place every Monday at 9 a.m., add that into the template to ensure it never slips your mind.

You can customize the monthly schedule to suit your needs and preferences, too. For instance, you could color-code every important due date to make it easy to identify looming deadlines.

How do you use a monthly planner?

You can use a monthly planner to organize information related to upcoming work-related tasks, meetings, and deadlines. To use it, gather all the necessary information about your work activities and duties for the upcoming month, and add it all to the spreadsheet. Once you’ve done that, you can tailor the monthly schedule to your needs. Make changes such as color-coding certain events or setting up recurring reminders to personalize the schedule.

If you’d like more customization options, monday.com’s monthly schedule template could be a good choice, as it allows you to easily adjust the layout of your schedule to your needs. Unlike a spreadsheet, you don’t have to worry about setting it up yourself — just enter your schedule information and you’re good to go.

Is there a monthly calendar template in Excel?

Yes, Microsoft Excel has a variety of pre-made monthly calendar templates you can use with different themes and styles. Alternatively, you can use monday.com’s customizable monthly schedule template if you don’t want to feel limited by your formatting options.

How do I create a rotating schedule in Excel?

To create a rotating schedule in your Excel monthly calendar, type in the names of your employees or coworkers in the first column. Next, using a code such as ‘M’ for morning and ‘E’ for the evening, map out employee schedules for upcoming shifts. You can make more sheets and copy the monthly schedule template for Excel if it stays the same for consecutive months.

Send this article to someone who’d like it.

Login User

  • Get Started

#1 source for any calendar needs

» Calendar Templates » Excel Calendar » 2024 Excel Templates

2024 EXCEL CALENDAR TEMPLATES

Download and personalize these FREE editable Excel calendar templates featuring US holidays. You may easily edit these planners using the calendar modification tool or Office application. You can print multiple copies of the 2024 calendar templates and be sure the copyright statement stays intact at the bottom.

  • 2023 Templates
  • 2024 Templates
  • 2025 Templates

2024 Monthly Excel Calendar Templates

Compatible with -

Monthly 2024 Excel Calendar Planner

Download this horizontal Excel 2024 monthly calendar for printing purposes. For daily or monthly planning, the organizer template has huge boxes with the previous and following months listed at the top. Our online calendar maker allows you to modify it. Customize Download

Download this printable monthly 2020 excel calendar in a landscape layout spreadsheet template. The 2020 planner template features large boxes for each day and prior and next months at the top for easy planning. Customize it using our online calendar maker tool. --> Customize Download

2024 Excel Monthly Calendar With Notes

A customizable 2024 monthly calendar template is offered with room for comments at the bottom and US public holidays. Both the Xls and Xlsx file formats operate nicely with it. Customize Download

2024 Excel Calendar Spreadsheet Template

Print this popular 2024 excel calendar template, which includes large boxes each day as well as US holidays. With our calendar maker tool, you can add your appointments and activities to this calendar. Customize Download

2024 Excel 4 Month Calendar Template

The four-month 2024 planner is customizable and has a horizontal arrangement with US holidays. There are three sheets with this yearly calendar accessible. Utilize an online calendar builder to customize the template. Customize Download

2024 Excel Calendar With Holidays

A landscape-oriented, colorfully designed, three-month editable Excel calendar for 2024 includes a spreadsheet file with US public holidays. Each month represents on a single page. Customize Download

2024 Excel Calendar For Vacation Tracking

Print and personalize this beautiful customizable Excel Organizer for 2024, which features US holidays and makes the template planner ideal for scheduling appointments or monitoring meetings. Customize Download

2024 Excel Quarterly Calendar Template

This Excel spreadsheet template for a 2024 quarterly calendar in horizontal orientation is available for free download and customization. The page-sized three-month Xls calendar can be used as a quarterly organizer. Customize Download

2024 Monthly Excel Template Calendar

Download the portrait version of this 2024 Excel month calendar with a half-page remarks section. With our free online excel calendar creator, you may personalize the calendar template in Xls/Xlsx format. Customize Download

2024 Excel Monthly Calendar Template

A spreadsheet in portrait format with a 2024 calendar that is customizable in xls and xlsx format and includes the US holidays. With our Excel calendar designer, you can personalize the monthly excel sheet. Customize Download

Free 2024 Quarterly Calendar Spreadsheet

A printable Excel 2024 quarterly calendar in portrait mode that is 8.5 x 11 in size with US federal holidays and a comments space on the right side of the sheet. Easily customizable xls/xlsx spreadsheet calendar template that you can add your activities and events. Customize Download

Free 2024 Excel Calendar With US Holidays

A customizable 2024 monthly excel calendar with prior and next month calendars and US holidays in a huge box landscape style. Customize Download

Editable 2024 Monthly Calendar Excel Template

Download this free xls or xlsx spreadsheet with a 2024 planner template that includes US federal holidays. You can effortlessly record your daily thoughts as each day's cell has four lines. Customize Download

Editable 2024 Excel Three Month Calendar

Download this 8.5 x 11-inch portrait and editable 2024 Excel Spreadsheet calendar template. On the A3 sheet, the three-month calendar is easily customizable and printable. Customize Download

2024 Diary Planner Template

Download this 2024 monthly diary organizer design, which includes the US public holidays and an Excel template for the current and upcoming months. A4-size plain paper can be printed or divided into two A5-size sheets for each month. Customize Download

2024 Two Page Monthly Calendar A3

The two-page monthly calendar diary template for 2024 may be downloaded as an xlsx file. To create a DIY diary calendar, each month can be printed on two A4 sheets or one A3 sheet. Customize Download

2024 Two Page Monthly Spreadsheet Calendar

Download in XLSX format the 2024 two-page monthly calendar diary design template with holidays. Each month of the large-scale calendar can be printed on A3 paper or two A4 sheets and bonded together to make a DIY diary calendar. Customize Download

Popular 2024 Templates Pages

  •   2024 Calendar Templates
  •   2024 Appointment Calendar
  •   2024 Kids Calendar
  •   2024 Wall Calendar
  •   2024 Desk Calendar
  •   2024 Large Calendar
  •   2024 Mini Calendar
  •   2024 Pocket Calendar
  •   2024 Coloring Calendar
  •   2024 Pattern Calendar

Popular 2024 Calendar Template Pages

  •   2024 Templates
  •   2024 Blank Calendar
  •   2024 PDF Calendar
  •   2024 Word Calendar
  •   2024 Photo Calendar
  •   2024 Excel Calendar
  •   2024 Julian Calendar
  •   2024 Family Calendar
  •   2024 Moon Calendar
  •   2024 Accounting Calendar
  •   2024 Business Calendar
  •   2024 Fiscal Calendar
  •   2024 Monthly Calendar
  •   2024 Quarterly Calendar
  •   2024 Yearly Calendar
  •   2024 PowerPoint Calendar
  •   2024 OneNote Calendar
  •   2024 Google Docs Calendar
  •   2024 Mac Pages Calendar
  •   2024 Apple Numbers Calendar
  •   2024 Student Calendar
  •   2024 Monthly Planner
  •   2024 Printable Calendar
  •   2024 School Calendar
  •   2024 Calendar
  •   January 2024 Calendar
  •   February 2024 Calendar
  •   March 2024 Calendar
  •   April 2024 Calendar
  •   May 2024 Calendar
  •   June 2024 Calendar
  •   July 2024 Calendar
  •   August 2024 Calendar
  •   September 2024 Calendar
  •   October 2024 Calendar
  •   November 2024 Calendar
  •   December 2024 Calendar
  •   2024 Buddhist Calendar
  •   2024 Christian Calendar
  •   2024 Hindu Calendar
  •   2024 Islamic Calendar
  •   2024 Jewish Calendar
  •   2024 Sikh Calendar

2024 Yearly Excel Calendar Templates

2024 Excel Yearly Calendar

This one-page landscape-formatted annual 2024 Excel calendar template with US holidays is available for download and printing. With the help of the Excel calendar generator tool, the design can easily be customized. Customize Download

Download and print the most popular 2020 excel yearly calendar with the US holidays in a one-page spreadsheet template. Each quarter of the year arranged horizontally in this calendar template. The template is customizable using our online Excel calendar creator. --> Customize Download

2024 Yearly Calendar Template Excel

Download this one-page xls or xlsx spreadsheet template for the 2024 annual calendar with a horizontal format standard design that includes US holidays. Use our online excel calendar builder to customize it on your own. Customize Download

2024 Excel Calendar Project Timeline

A year-at-a-glance calendar template with months arranged horizontally and national holidays listed at the bottom of the calendar. The single-page 2024 yearly calendar template is best suited for project timetable tracking. Customize Download

Editable 2024 Yearly Excel Scheduling Calendar

Download the free printable landscape-oriented Excel annual calendar for 2024 in vertical form. The year-at-a-glance template has an area for planning and activities and organizes the months in a vertical pattern. Customize Download

Editable 2024 Yearly Spreadsheet Calendar

An Excel template with a one-page portrait-style 2024 annual spreadsheet calendar is free for users. After making the necessary adjustments, you can utilize the 12-month calendar with US holidays in both xls and xlsx files and print it on an A3 sheet. Customize Download

Free 2024 Excel Calendar For Project Planning

Download the one-page customizable annual project planning spreadsheet in vertical format. The running months in the one-page 2024 year calendar make project scheduling easy. Customize Download

Free 2024 Excel Calendar For Project Management

Downloadable and Printable 8.5 x 11 half-page Excel calendar with a portrait design for a 2024 one-page project timeline scheduler. The calendar was made with running months and plenty of grid area for noting plans. After adjusting the print parameters, the organizer can be printed on an A3 sheet. Customize Download

Free 2024 Excel Calendar Template Service

No matter your job profile or planning needs, CalendarLabs has an editable template for everyone, including employees/staff, entrepreneurs, teachers, college, school-goers, homemakers, and more.

The templates are available in many designs and layouts for various uses, such as training, academic, financial, and project planning. The spreadsheet templates in Excel format will allow you to do automatic date calculations, use formulas, and much more. The templates also include space to add notes, reminders, and a US holiday list.

You can access the Excel calendar charts in weekly, monthly, yearly, two-month, three-month (90-day), and four-month timeline formats. How about creating a DIY diary organizer using the two-month-per-page diary calendar templates?

If you want to change the templates further, use our Excel calendar generator tool and give your templates the makeover you like. Easily customize the templates by adding events, holidays, deadlines, and appointments and even color-coding them to highlight major dates.

You can adjust the week’s starting day, for instance, to Monday instead of Sunday , or have your calendar run from June to May. Once you have made the desired changes, print them free using A4 (8.3x11.7 inches), A3 (11.7x16.5 inches), Letter (8.8x11 inches), and Legal (8.5x14 inches) size papers. And if you like to use our basic calendar templates, you can certainly do so! Go to our ‘Online Calendar’ page and print a calendar in the format you want.

We have scheduler and planner templates for business , financial reporting, travel or holiday tracking, daily meeting or appointment scheduling , birthday organization, and other planning purposes. Browse our website to select from a wide range of ready-to-use, free printable template samples. All the planner templates are adaptable to different Office software and are available in XLS/XLSX formats.

Own Events

  • Save Your Own Events
  • Add Events to Calendar
  • Registration  is free

Creating your template, this process may take some time. Prefer an email?

Thank you...!

Your download will start automatically, if it doesn't restart the download .

OOPS! Sharing was not successful.

Thanks for trying though. Your download will start in a moment. If it doesn't, restart the download .

Your privacy matters. We never sell or share your email

Easiest Way to Make a Calendar in Excel

By Diana Ramos | January 17, 2024

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Link copied

In this article, you’ll find instructions for creating a weekly, monthly, or annual calendar in Microsoft Excel for Windows or Mac and Microsoft 365 on the web . Also find instructions for creating a calendar in Excel versions 2003, 2007, and 2010 .

How to Create a Calendar in Microsoft Excel for Windows

Follow these instructions to create a calendar using a pre-built template in the Windows Microsoft desktop app. This tutorial uses the latest version of Excel in Microsoft Office 16 for Windows.  

  • Open Microsoft Excel on your PC.
  • Click on the  New icon in the left nav menu.

Click  Calendar under the search bar to see included Microsoft calendar templates.  

Make Excel Calendar PC

Click on the calendar you want to use, and click the  Create button. For this example, we will pick the  Any Year One-Month Calendar template.  

Make Excel Calendar template choices PC

Note : Once you click on a calendar and look at the preview, click on the right and left arrows to navigate through all the calendar template options.

Rename and save the template. Click  File and  Save As . Enter the new name, navigate to the folder where you want to save it, and click the  Save button.   

Make Excel Calendar scroll template choices PC

To change the calendar’s look, click  Page Layout in the upper ribbon. Click the drop-down arrow next to  Themes in the ribbon. Click a new theme, and the color and font changes will be applied to the calendar.    

Make Excel Calendar themes PC

If you’re looking for calendar templates with more functionality than those available in the Microsoft Excel app for Windows, check out this  selection of yearly, weekly, and monthly calendar templates . Some of the Excel calendar templates include the following:   

A  bi-weekly work calendar template for planning your morning, afternoon, and evening activities.   

2024 Bi-weekly Work Calendar Template

The  quarterly calendar template offers space to list one main event for each day, an ideal view for planning three-month projects.   

2024 Quarterly Calendar Template

Easily track important dates at a glance with this  yearly calendar template with months as rows and that lists the 2024 U.S. holiday dates.  

2024 Yearly Calendar Template with Months in Rows

How to Create Calendar in Microsoft Excel for Mac

Follow these steps to create a calendar using one of Microsoft’s pre-built templates in the app. This tutorial uses version 16.80 of Microsoft Excel for Mac.   

  • Open Microsoft Excel on a Mac. 

Click the  New button on the left nav. In the search bar, type  Calendar and press the  Return key on your keyboard.  

Make Excel Calendar search Template Mac

Double-click on the calendar you want to use. For this example, we will pick the  12-Month Calendar template.  

Make Excel Calendar 12 month Template Mac

  • Rename and save the template. Click  File and  Save As . Enter the new name, navigate to the folder where you want to save it, and click the  Save button. 

To change the look of the calendar, click  Page Layout in the upper ribbon. Click the drop-down arrow next to  Themes in the ribbon. Click a new theme, and the color and font changes will be applied to the calendar.   

Make Excel Calendar Change Theme Mac

The Microsoft Excel app templates are for various scenarios, ranging from student and school calendars to those for tracking family events to a basic social media calendar. Find more business and work-centric calendars in this  collection of Excel calendar templates . Highlights include the following:   

Managers will appreciate this  shift work calendar template for 2024 and its color-coded feature that displays the rotation pattern at a glance.  

2024 Monthly Shift Work Calendar

Use the  employee calendar template to schedule and track hourly staff work hours and pay rates.   

2024 Employee Calendar Template

This  weekly calendar with U.S. holidays for 2024 marks all the major holidays and includes space for adding notes.  

2024 Weekly Calendar with U.S. Holidays

How to Create a Calendar in Microsoft Excel on the Web Using 365

A Microsoft 365 subscription includes a web version of all the included apps. These apps add commenting and sharing functionality. However, they tend to lack some of the more robust features found in the desktop app. 

Follow these steps to create a calendar using one of Microsoft’s pre-built templates on the web:   

  • Sign in to your Microsoft 365 account by visiting  www.office.com , clicking the  Sign in  button, and entering your username and password. Tip:  You can also go directly to  create.microsoft.com/en-us/templates/calendars , but you still need to sign in. You can also download and use the template in your Microsoft 365 desktop app.

Enter the phrase  calendar templates in the search bar, and press the  Return key on your keyboard.   

Make Excel Calendar Microsoft 365 web

  • Click  More template results .
  • Double-click on the calendar you want to use or click the  Create button. For this example, we will pick the  Social Media Content Calendar  template.

Double-click on the phrase  Book 1 in the top-left corner to rename, and save it to  One Drive .  

Make Excel Calendar Microsoft 365 web rename

You’ll need to make any customizations, such as font and color changes to the calendar manually, as the web version lacks pre-designed themes. However, you can share the calendar and add comments to it. 

If you’re looking for an Excel template with more functionality, check out this  collection of marketing calendar templates and  Excel project calendar templates . Some of the more advanced calendars you’ll find include the following:   

A  marketing plan calendar with budget tracker to quickly learn how much you’re spending on each tactic.   

monthly activity calendar excel

A  weekly marketing calendar template to easily manage which activities you need to accomplish daily. 

Weekly Marketing Calendar Template

An  annual marketing calendar template you can use for planning and getting a snapshot of monthly efforts.  

monthly activity calendar excel

How to Create a Calendar in Excel 2003, 2007, and 2010

Here are some step-by-step instructions for making a monthly or yearly calendar in Excel. Start by opening a blank document in Excel.   

1. Add Weekday Headers

First, you’ll need to add the days of the week as headers, as well as the month title. 

  • Leave the first row in your spreadsheet blank. On the second row, type in the days of the week (one day per cell). 

To format the weekday headers and ensure proper spacing, highlight the weekdays you just typed, and on the Home tab, in the Cells group, click Format. Select Column Width and set the width for around 15-20, depending on how wide you want the calendar.   

monthly activity calendar excel

2. Add Calendar Title 

In the first blank row, add the current month as the title of the calendar using a formula. Click any cell in the first row, and in the fx field above the blank row, enter =TODAY(). This tells Excel you want today’s date in that field.   

monthly activity calendar excel

  • You’ll see the format of the date is incorrect. To fix this, click the cell with the date. In the Home tab, in the Number group, click the Date drop-down. Select More Number Formats and choose the format you would like for the month title.

To center the title, highlight all the cells in your title row (including the one with the month displayed) and click on the Merge and Center button in the Home tab.  

Merge and Center in Excel

3. Create the Days in the Calendar 

Here is where you will build the body of your calendar. We will use borders to create the date boxes.   

  • First, highlight your whole spreadsheet. 

Click the paint bucket icon in the Home tab and select white. Your spreadsheet should now have a white background.  

monthly activity calendar excel

Then, highlight five or six cells under the first weekday header, Sunday.  

Highlight cells

  • While the cells are still highlighted, click the borders icon in the  Home tab and select the outside borders option. This will outline the first date box in the row.
  • Highlight the box you just made, and copy and paste it under the other weekday headers. This duplicates your box for the other days in the week. 

Do this for five total rows in your sheet. The calendar should look like this:  

Five rows calendar view

To add borders around the weekday headers, highlight the row with the weekdays, click the borders icon, and choose  All Borders .  

4. Add Dates

We’ve created the framework for the calendar, now it’s time to add the dates. You can either manually enter the dates in each box, or use Excel’s auto-fill feature. Here’s how:  

  • For each row in the calendar, enter the first two dates of that week in the first cells in each box. For example, if the 1st of the month is Wednesday, enter 1 into the first Wednesday box and 2 in the Thursday box. 
  • Then, hold down Shift and highlight both cells with the numbers.
  • Drag the bottom-right corner of the highlighted cells to auto-fill the rest of the week.

Repeat for the whole month.   

Five rows calendar view with dates

Note : You must manually enter the first two dates for each row before you can drag and auto-fill the rest of the week. To make a yearly calendar, repeat these steps for each of the 12 months.

How to Make a Calendar in Minutes with Smartsheet's Calendar Template

Try Smartsheet for Free

Smartsheet’s pre-formatted templates allow you to instantly create a calendar. Months, days of the week, and dates are pre-formatted, and you have room to add descriptions, comments, and duration in hours of each activity.  Here’s how to use a calendar template in Smartsheet:  1. Open a Smartsheet Calendar Template 

  • Log in to your account (or  start a free 30-day trial ).
  • Open the  Annual Calendar by Day template and click the  Use Template  button.

Click  Annual Calendar by Day and the calendar template will open.  

Make Annual Calendar Smartsheet Template

2. List Your Calendar Information 

A pre-made template will open, complete with the months and dates already formatted for the entire year. There will also be sample content filled in for reference.   

  • Add your calendar events under the  Activity column. You can also add more detail in the  Description, Hours, and  Comments columns. 
  • To add multiple events for the same date, you must create a new row. Right-click on a row and select  Insert Row Above or  Insert Row Below . Then, in this new row, add the month, day of the week, date, and activity.

If you need to delete a row, right-click on the cell in the row you’d like to delete and select  Delete Row .   

Annual Calendar by day

On the left side of each row, you can attach files directly to a task or start a comment around a certain event, adding more context to your calendar. 

3. Switch to Calendar View

All your calendar information lives in this table. Then, with the click of a button, you can see all the information auto-populated into a calendar.   

  • On the toolbar, switch to  Calendar View .   

You will now see all your information in a calendar (today’s date will be outlined in blue). You can edit or add an event directly from this calendar view, or change the color of an event, by double-clicking on a blue bubble.   

Annual Calendar by day updated table

Anything you change in this calendar view will be automatically updated in your table.

Email, Share, or Print Your Calendar

Share your calendar with colleagues, friends, or family. You can choose from printing, exporting, or emailing your calendar from Smartsheet. 

To email your calendar: 

  • Above the toolbar, click  File .
  • Select  Send as Attachment .
  • In the To field, add the recipient(s). Choose from your contact list or type email addresses.
  • The  Subject and  Message fields are auto-populated for you, but you can choose to delete the text and add your own. 

Choose whether to attach the calendar as a PDF or Excel sheet, and whether you want to send the calendar right away or on a recurring basis.   

share your calendar as attachment

To share your calendar with a link:

  • On the toolbar, click on the calendar icon.
  • Select the publishing option you would like by clicking the slider.

A pop-up box will appear with a publish link. You can copy and paste the link for anyone to view the calendar or use the embed code to embed the calendar into any web page.   

Calendar publish options

To print your calendar:

  • On the toolbar, click the printer icon. 
  • Choose the calendar date range, paper size, orientation, and more. Then, click  OK . 
  • A PDF version of your calendar will begin downloading. You can then print this PDF.

Learn more about  working in Smartsheet's dynamic calendar view and get started today.

Use the Calendar Feature in Smartsheet to Improve Planning Efforts

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time.  Try Smartsheet for free, today.

Discover why over 90% of Fortune 100 companies trust Smartsheet to get work done.

Filter by Keywords

How to Make a Calendar in Excel? (2024 Guide With Templates)

Evan Gerdisch

Content Strategist

December 18, 2023

It’s Sunday, and you’re trying to relax. 

However, the thought of Monday’s deliverable haunts you. 😨

Relatable? 

Well, it doesn’t always have to be like that. 

If you use a calendar, you can plan your week or even month ahead, and stop stressing out for no reason!

Want to learn how to make a calendar in Excel?

In this article, we’ll take you through the steps you need to take to make a calendar in Excel and even highlight some handy templates. We’ll also highlight Excel calendars’ limitations and suggest an alternative that lets you make better calendars.

What Is a Calendar in Excel?

4 steps to create a calendar in excel, 3 excel calendar templates, 3 limitations of excel calendars, create effortless calendars with clickup.

  • See How ClickUp Can Help your Team ‘Excel’

Let’s begin!

ClickUp Calendar View Blog CTA

An Excel calendar is like any other calendar 📆, just on Microsoft Excel. 

You can use it as a daily planner , weekly planner, task planner, and even create a printable calendar. In project management, teams often use Excel to create project calendars (like a quarterly calendar for finances) and timelines to track tasks and resources.

After all, if there’s data that needs organizing, there’s Excel.

And whatever be your need for an Excel calendar, there’s more than one way to create it. 

Just Google ‘create calendar in excel,’ and you’ll see what we’re talking about.

Here are some ways you can create a calendar in Excel:

  • Using Microsoft’s code : use Microsoft’s ‘Visual Basic for Applications’ code to create a calendar
  • Using Power Query for Excel : Power Query is an Excel add-in that uses pre-built functions to merge, remove, pivot, filter rows, and columns
  • Using Pivot Tables : a Pivot table summarizes the data of another large table 
  • Using Excel calendar templates : pre-made calendar layouts that can adapt to your needs
  • Create one manually from scratch : formatting Excel data in rows and columns to create a calendar

Note : you can even create calendars in Google Sheets , Google Docs , Microsoft Word or PowerPoint if you like, or use these other calendar apps .

In this article, we’ll give you a step-by-step guide on how to create a calendar in Excel from scratch, using the manual approach.

Here we go!

Follow these simple steps to create a calendar in Excel from scratch. 

The steps work for Excel Online, the Excel 2010 version, and up.

Step 1: Add the days of the week

Open a new Excel file and name it the year you want. 

For this example, we’ll name ours ‘ Calendar 2021 ’.

Then, type in the days of a week in the second row of the Excel sheet.

spreadsheet listing the days of the week

Step 2: Format cells to create days in a month

Now, insert the days of a month under the row that contains the weekdays.

The days will be a calendar table or grid of seven columns (seven days a week) and six rows (to accommodate 31 days), as highlighted in the image below.

spreadsheet listing days of the week with several columns selected

To format the cells, let’s start with the column width.

Select the seven columns ( A-G ), and adjust the first column’s width to the size of your liking. All seven columns will automatically take the same size when you do so.

That was easy, right?  

Now let’s adjust the row height with a very similar process. 

Select six rows ( 3-8 ) under the ‘ days of the week ’ row and adjust the first row’s height to your desired size. All six rows will again automatically take the same height.

It’s taking shape and already looks like a calendar! 📅

In the next step, add the digits for the days and align them to each cell’s upper-right corner representing a day.

To do so, highlight the grid of seven columns and six rows under the weekday header row and then right-click on any selected cell.

Select Format Cells > Alignment .

Set the horizontal text alignment to Right (Indent) and the vertical text alignment to Top . Click on OK, and the cells will get aligned.

Excel's Format Cells Window

Now, insert the numbers in the cells. 

Refer your laptop or mobile’s calendar or just Google Calendar 2021, and that should help.

This will help you find out which day of the week your calendar should start on. In 2021, Jan 1st was a Friday, so you start numbering January from F3 .

Insert the numbers sequentially till you reach the last day of the month.

spreadsheet formatted like a calendar

Since this is the January calendar, name it so. 

Highlight the cells in the first row from A1 to G1, and then click on Merge & Center .

In the merged cell, type in January , and voila, your first month is ready!

Change the font size and font color to your preference.

spreadsheet formatted as a January calendar

Step 3: Create the next month

Since a year has 12 months, you have to create 11 more tabs, each representing a month in your Excel workbook.

Copy the January worksheet to create the February sheet. 

To do so, right-click on the January tab and select Move or Copy .

When the Move or Copy dialogue box appears, select (move to end) > check off Create a copy > click OK .

Excel will create a new calendar sheet as ‘ January (2) .’ 

Rename the sheet as ‘February’ and then edit the days’ numberings on the sheet accordingly.

Don’t forget to change the month name to February in the first row of the Excel worksheet.

Quick Tip : if you want to find today’s date, just click on a cell outside the calendar grid, and click on the formula bar. Type =TODAY() and hit enter , the current date will appear.

spreadsheet displaying multiple dates

You can always change the date format to your preference.

Step 4: Repeat the process for other months

Repeat the above step for the rest of the ten months. 

Make ten more copies of the ‘January’ tab and edit the dates and month titles accordingly.

How long have you been at it?

But it’s the last one, we promise.

You’ve now learned how to create an entire calendar in an Excel spreadsheet from scratch!

We know what you’re thinking: isn’t there an easier way to go about creating a calendar ?

Well, you could always use an Excel calendar template …

There are several Excel free calendar templates available on the web, and the options can leave you feeling overwhelmed.

Don’t worry. 

Here are three free Excel calendar templates so that you can skip the research:

1. Weekly calendar template for 2021

This is a great weekly calendar to note down your to-dos for each day.

spreadsheet with January to-do list

Download this weekly calendar 2021 for Excel .

2. Weekly schedule planner

Here’s another weekly calendar you can use to plan your week ahead of time to stay organized.

This weekly schedule planner is actually a built-in Excel template. 

To find it, just go to Excel’s Home tab , then click on More Templates > Calendars .

Scroll down to find this template and many more, including monthly calendar and yearly calendar templates.

spreadsheet formatted as a weekly planner

3. Project calendar template

Here is a calendar template designed for basic excel project management . You can use it to view project meetings and deadlines .

spreadsheet formatted as a project calendar

Download this project calendar template .

Why would anyone create an Excel calendar when there are calendar apps that provide more functionality? 🤔

Our thoughts exactly.

Excel calendars aren’t ideal and here’s why:

Not only is creating an Excel calendar from scratch a lengthy process, but most of its templates lack flexibility.

And that’s just the tip of the iceberg. 

Here are three more limitations that might have you searching for an excel alternative .

1. No drag and drop abilities

If you’re looking for a calendar that’s flexible and interactive, an Excel calendar isn’t the right choice.

There’s no way you can drag and drop items on your calendar. Rearranging calendar items will take you a fair amount of time with all the cutting, copying, and pasting.

So an Excel calendar is like a wall calendar on my screen?

Pretty much.

2. Can’t create or assign tasks

A calendar in Excel is… just a calendar. 

It’s not a tool that helps you perform workflow-related tasks.

Need to create tasks on the calendar? Not possible.

Need to assign tasks? Nope, you can’t.

If you’re okay with just knowing the day and date or typing in data on a calendar, Excel works for you. 

However, if you want to do more than that on your calendar, you’ll have to look elsewhere.

3. Creating reminders can be an annoying process

Calendars and reminders should go hand in hand, right?

You don’t want to miss out on important dates, tasks, or meetings. 

Unfortunately, you will if you use an Excel calendar because there are no easily accessible reminder options here. 

Depending on the approach you take, you may have to learn conditional formatting, an Excel formula or two, a bit of Visual Basic, and understand what the developer tab is…

We know, you’re probably already thinking about Excel calendar alternatives .

Well, here’s one for you: ClickUp !

Whether you’re a project manager, company owner, freelancer, or employee, ClickUp is all you need to organize your work.

Use ClickUp’s Calendar view to:

  • Schedule and create tasks quickly
  • Schedule Future Recurring Tasks
  • Plan projects
  • Manage resources
  • And do lots more!

How do you add the Calendar view?

  • Click on the + in your views bar
  • Select ‘Calendar’
  • Add a name for it

ClickUp Calendar view

There you go. Your calendar is ready! 🙌

Or you can use one of ClickUp’s pre-built calendar templates! Try out one of these templates for your team!

Project Management Calendar Template

ClickUp’s Project Management Calendar Template is designed to help you stay organized and productive. With this template, you can easily set deadlines, assign tasks to team members, keep track of progress, and more.

This calendar template is perfect for project managers who need to manage multiple projects at once or teams who want to collaborate better on their tasks. You can customize the columns in the calendar template to

ClickUp Project Management calendar

Content Management Calendar Template

ClickUp offers hundreds of ready-to-use templates in its Template Center, there’s one that stands out for content planning—the ClickUp Content Management Template . This template makes the top of our list because it’s completely flexible and customizable to your specific content workflow.

ClickUp Content Management Template - Calendar View

You can now view your tasks over your desired time period. It can be a day, four days, a week, or even a month. It’s pretty flexible.  

The most fun bit is that any Task with a start or due date in ClickUp will automatically appear on the Calendar. Like magic.

You can even spot a sidebar that contains unscheduled tasks. 

Just drag and drop them in the calendar to schedule them in seconds

Also, make your calendar look exactly how you want it by choosing the task card items. You can hide or show weekends, make Assignees , Priorities , and Tags visible, etc.

But wait, do you already use other calendar apps?

In that case, ClickUp offers you calendar feeds that let you send scheduled tasks directly to your Google Calendar or Outlook calendar, or even Apple calendar .

All the changes you make here on ClickUp will appear on your favorite calendar app.

But hold up. 

This isn’t the end. 

There’s a whole lot you can do in ClickUp.

Check out these fantastic features to find out:

  • PDF Annotation : add comments on a PDF file without the help of a third-party PDF annotator
  • Table views : turn your work into a simple and fast operating spreadsheet
  • Embed view : bring other apps and websites on your workspace alongside your tasks, such as Google Sheets , your Outlook calendar, and more
  • Task Templates : create a template for any task you do repetitively to save time
  • Integrations : tons of native integrations with your favorite apps, including Discord , Timedoctor , Slack , Zoom , HubSpot , and more
  • Hotkeys & Shortcuts : make quicks edits, tag a user, navigate in your Dashboard, create and assign tasks, etc. using just your keyboard
  • Natural Language Processing : let ClickUp interpret time and dates automatically without you having to type out the entire thing
  • Automatic Import : easily import a CSV file or projects from tools like Asana , Jira , and Trello
  • Reminders : never miss an important calendar event or task 

See How ClickUp Can Help your Team ‘ Excel ‘

An Excel calendar is as helpful as a regular calendar. 

You can type things in, see the day and date. But that’s about it.

Even your mobile devices can do a fine job for this, r ight?

You need a calendar that helps you schedule tasks and meetings, send you reminders, and helps you get things done.

And where do you find such a useful calendar?

In ClickUp!

This powerful project management tool can be your calendar, workflow and resource manager, to-do list app, and so much more. 

ClickUp really is an all-in-one tool.

Get ClickUp for free today , and easily keep up with all your calendars!

Related readings:

  • How to create a timesheet in Excel
  • How to make a Gantt chart in Excel
  • How to create a graph in Excel
  • How to create a form in Excel
  • How to make an org chart in Excel
  • How to create a flowchart in Excel
  • How to show dependencies in Excel
  • How to create a database in Excel
  • How to calculate time in Excel
  • How to show work breakdown structures in Excel
  • How to create a capacity plan in Excel

Questions? Comments? Visit our Help Center for support.

Receive the latest WriteClick Newsletter updates.

Thanks for subscribing to our blog!

Please enter a valid email

  • Free training & 24-hour support
  • Serious about security & privacy
  • 99.99% uptime the last 12 months

Free printable calendar templates

Keep track of everything in style with customizable calendar design templates. these calendars are perfect for for personal planning, tracking projects, family organization, or even work, too..

Calendar template surrounded by 3D design elements

Free calendar templates

Without a calendar, it’s hard to stay organized. Keep track of everything in your life with these free calendar templates. These editable calendar templates can be customized in Microsoft Word , Microsoft Excel , or Microsoft PowerPoint , depending on the template you choose. Easily change the font, colors, images, and more. There are a variety of calendar template designs available—explore simple calendars, blank calendars, content calendars, or professional calendars. You can even find calendars that provide space for notes and weekly or monthly calendar templates. Once you’ve edited your calendar, download it or print it out to hang on your fridge, office wall, or wherever you want. To access your calendar from anywhere, upload it to OneDrive, then make changes to your schedule and add new calendar events from any device. Even share your calendar in OneDrive with your family to keep them in the loop about upcoming important events. If you’re looking for more ways to stay organized, explore these free schedule templates .

Free Monthly Planner Template

Our free printable Monthly Planner template was designed for inserting into common 3-ring binders. You can edit and customize the planner using Excel or OpenOffice and then print the monthly planner page using regular letter-size paper.

The monthly planner below works well in combination or in place of our daily planner and weekly planner templates. If you don't need the notes and to-do list section of this planner, try our monthly calendar template .

Printable Monthly Planner Template

If you would like to include holidays and events, try the new Personal Planner Template !

Other Versions

License : Private Use (not for distribution or resale)

"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer

Description

This Monthly Planner is a spreadsheet that lets you print a planner page for any month of almost any year . You can print a blank monthly planner page, or you can customize and edit the planner within Excel.

If you are going to edit the planner within Excel, then first duplicate the planner worksheet so that you have different months on separate worksheet tabs within the same workbook.

2-Page Monthly Planner

2-Page Monthly Planner

This version of the monthly planner is designed for printing on 2 facing pages in a 3-ring binder, as shown in the image to the left.

Monthly Planner Features

Our spreadsheet gives you a great deal of flexibility to customize your own personal monthly planner . If you insert rows or insert columns into the calendar-portion of the planner, the formulas used for the dates will be messed up, but other than that, it is pretty simple to customize. Change fonts, add some color, add cute little images on specific days ... whatever.

Unlike our daily and weekly planners, this planner does not automatically add holidays and birthdays. Instead, it lets you duplicate the planner worksheet so that you have a separate month on different tabs. Just right-click on the planner worksheet tab, select "move or copy...", check the "copy..." box, click on OK, and then rename the new tab to Jan, Feb, etc. Then you can enter holidays, events, and birthdays directly into the monthly planner. If you want a monthly calendar that will store yearly events and holidays, try Excel Calendar Pro (not free).

Other Monthly Planner Features

  • Mini monthly calendars showing the next two months.
  • Goals section
  • Notes section for recording homework assignments, listing people to call, grocery lists, doodling, or whatever.
  • Choose Monday-first or Sunday-first.

FYI: The format for the day numbers use Conditional Formatting to "gray out" the days not in the current month. Keep that in mind if you make formatting changes to the planner.

More Monthly Planners

Many printable monthly planners that you'll find on the internet are really just calendars, without any extra features like notes, to-do lists, goals, etc. Here are a few planners that are not just calendars:

  • Monthly Menu Planner by Vertex42.com
  • Free Monthly Planner - by David Williams at https://www.davidwilliams.biz/free-printables.htm - A monthly planner for Word (kind of hard to find the link)

Follow Us On ...

Related templates.

Thumbnail - Personal Planner Template

Sponsored Listings  

Schedules & planners, calendar templates, common types, specific types.

  • LPL Financial Holdings-stock
  • News for LPL Financial Holdings LPL Financial Holdings

LPL Financial Reports Monthly Activity for January 2024

SAN DIEGO, Feb. 22, 2024 (GLOBE NEWSWIRE) -- LPL Financial LLC (“LPL Financial”), a wholly owned subsidiary of LPL Financial Holdings Inc. ( Nasdaq: LPLA ) (the “Company”), today released its monthly activity report for January 2024.

Total advisory and brokerage assets at the end of January were $1.36 trillion, an increase of $7.7 billion, or 0.6%, compared to the end of December 2023.

Total net new assets for January were $2.0 billion, translating to a 1.8% annualized growth rate. Total net new advisory assets were $2.4 billion, translating to a 3.9% annualized growth rate.

Total client cash balances at the end of January were $47.3 billion, a decrease of $1.2 billion compared to the end of December 2023. Net buying in January was $12.0 billion.

For additional information regarding these and other LPL Financial business metrics, please refer to the Company’s most recent earnings announcement , which is available in the quarterly results section of investor.lpl.com .

Investor Relations [email protected]

Media Relations [email protected]

About LPL Financial

LPL Financial Holdings Inc. (Nasdaq: LPLA) was founded on the principle that the firm should work for advisors and enterprises, and not the other way around. Today, LPL is a leader in the markets we serve, serving more than 22,000 financial advisors, including advisors at approximately 1,100 enterprises and at approximately 570 registered investment advisor (“RIA”) firms nationwide. We are steadfast in our commitment to the advisor-mediated model and the belief that Americans deserve access to personalized guidance from a financial professional. At LPL, independence means that advisors and enterprise leaders have the freedom they deserve to choose the business model, services and technology resources that allow them to run a thriving business. They have the flexibility to do business their way. And they have the freedom to manage their client relationships because they know their clients best. Simply put, we take care of our advisors and enterprises, so they can take care of their clients.

Securities and Advisory services offered through LPL Financial LLC (“LPL Financial”), a registered investment advisor. Member FINRA/SIPC. LPL Financial and its affiliated companies provide financial services only from the United States.

Throughout this communication, the terms “financial advisors” and “advisors” are used to refer to registered representatives and/or investment advisor representatives affiliated with LPL Financial.

We routinely disclose information that may be important to shareholders in the “Investor Relations” or “Press Releases” section of our website.

monthly activity calendar excel

LPL Financial Holdings News MORE

Related stocks.

monthly activity calendar excel

February 2024 updates for Microsoft Office

Introduction.

Microsoft released the following security and nonsecurity updates for Office in February 2024. These updates are intended to help our customers keep their computers up to date. We recommend that you install all updates that apply to you.

To download an update, select the corresponding Knowledge Base article in the following list, and then go to the "How to download and install the update" section of the article.

List of Office updates released in February 2024

Microsoft office 2016, sharepoint server subscription edition, microsoft sharepoint server 2019.

Facebook

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

monthly activity calendar excel

Microsoft 365 subscription benefits

monthly activity calendar excel

Microsoft 365 training

monthly activity calendar excel

Microsoft security

monthly activity calendar excel

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

monthly activity calendar excel

Ask the Microsoft Community

monthly activity calendar excel

Microsoft Tech Community

monthly activity calendar excel

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

Yearly Planners for Microsoft Excel

  • Yearly calendars 2024
  • Other planners:  hourly   ·  daily   ·  weekly   ·  monthly   ·  quarterly
  • Other calendars for 2024:  weekly   ·  monthly   ·  quarterly
  • Multi-year calendars:  split year   ·  school year   ·  academic year   ·  fiscal year   ·  two years   ·  three years
  • Yearly planner templates in other file formats:  Word   ·  Excel   ·  PDF

Yearly planners in landscape orientation (19 templates)

Download  template 1: Yearly planner template for Microsoft Excel, landscape, 1 page

Template 1: Yearly planner landscape

  • page orientation: landscape (horizontal), 1 page
  • shows months at the top and dates for every months (but no days of the week)
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download  template 2: Yearly overview planner template for Microsoft Excel, landscape, 1 page, day numbers at each side

Template 2: Yearly overview planner landscape, day numbers at each side

  • day numbers at each side of the page
  • shows months at the top and dates (but no days of the week)

Download  template 3: Yearly planner template for Microsoft Excel, landscape, 1 page, days aligned

Template 3: Yearly planner landscape, days aligned

  • days aligned horizontally, Sunday start
  • shows months and days of the week (but no dates)

Download  template 4: Half-yearly planner template for Microsoft Excel, landscape, 2 pages

Template 4: Half-yearly planner on 2 pages landscape

  • page orientation: landscape (horizontal)
  • year on 2 pages, six months / half a year per page
  • shows months and dates (but no days of the week)
  • also handy for planning business meetings or as a yearly productivity planner

Download  template 5: Half-yearly planner template for Microsoft Excel, landscape, 2 pages, days aligned

Template 5: Half-yearly planner on 2 pages landscape, days aligned

  • for creating yearly lists of all kinds, yearly diet plans, yearly school planners and many other uses

Download  template 6: Quarterly planner template for Microsoft Excel, landscape, 4 pages

Template 6: Quarterly planner on 4 pages landscape

  • year on 4 pages, three months / one quarter per page

Download  template 7: Quarterly planner template for Microsoft Excel, landscape, 4 pages, days aligned

Template 7: Quarterly planner on 4 pages landscape, days aligned

Download  template 8: Yearly planner template for Microsoft Excel, landscape, 1 page, linear

Template 8: Yearly planner landscape, linear

Download  template 9: Yearly planner template for Microsoft Excel, landscape, 1 page, linear, days aligned

Template 9: Yearly planner landscape, linear, days aligned

  • days aligned vertically, Sunday start

Download  template 10: Yearly planner template for Microsoft Excel, landscape, 1 page, lined, year divided into 2 columns

Template 10: Yearly planner landscape, 2 columns, lined

  • year divided into two six-monthly columns, arranged side by side
  • months lined - use as monthly to do list, yearly month planner or check list

Download  template 11: Yearly planner template for Microsoft Excel, landscape, 1 page, multi-colored, year divided into 2 columns

Template 11: Yearly planner landscape, 2 columns, multi-colored

  • shows months but neither dates nor days of the week
  • every month in a different color ("rainbow planner")
  • handy for advance planning of yearly activities

Download  template 12: Yearly planner template for Microsoft Excel, landscape, 1 page, two six-month blocks, minimalist

Template 12: Yearly planner landscape, two six-month blocks, minimalist

  • year divided into two rows of six months each
  • minimalist design
  • great for a yearly to do list or as a yearly family planner

Download  template 13: Yearly planner template for Microsoft Excel, landscape, 1 page, minimalist

Template 13: Yearly planner landscape, minimalist

  • months arranged horizontally

Download  template 14: Yearly planner template for Microsoft Excel, landscape, 1 page, year at a glance

Template 14: Yearly planner landscape, year at a glance

  • classic design annual planner

Download  template 15: Blank yearly planner template for Microsoft Excel, landscape, 1 page, year at a glance

Template 15: Blank yearly planner landscape, year at a glance

Download  template 16: Yearly box planner template for Microsoft Excel, landscape, 1 page, multi-colored

Template 16: Yearly box planner landscape, multi-colored

  • with ample space for notes under each month - use as yearly diary, routine planner or revision planner

Download  template 17: Yearly box planner template for Microsoft Excel, landscape, 1 page, lined

Template 17: Yearly box planner landscape, lined

Download  template 18: Two-year planner template for Microsoft Excel, landscape, 1 page, lined

Template 18: 2-year planner landscape, years side by side

  • months aligned vertically, years arranged side by side

Download  template 19: Two-year planner template for Microsoft Excel, landscape, 1 page, lined

Template 19: 2-year planner landscape, years stacked

  • months aligned vertically into two six-monthly columns, years stacked

Yearly planners in portrait orientation (17 templates)

Download  template 20: Yearly planner template for Microsoft Excel, portrait, 1 page, two half-year blocks

Template 20: Yearly planner portrait, 2 half-year blocks

  • page orientation: portrait (vertical), 1 page
  • year divided into two half-year / six-month blocks

Download  template 21: Yearly overview planner template for Microsoft Excel, portrait, 1 page

Template 21: Yearly overview planner portrait

Download  template 22: Yearly planner template for Microsoft Excel, portrait, 1 page, days aligned

Template 22: Yearly planner portrait, days aligned

Download  template 23: Half-yearly planner template for Microsoft Excel, portrait, 2 pages

Template 23: Half-yearly planner on 2 pages portrait

  • page orientation: portrait (vertical)
  • use it as a bi-yearly workout, fitness or exercise planner, among other uses

Download  template 24: Half-yearly planner template for Microsoft Excel, portrait, 2 pages, days aligned

Template 24: Half-yearly planner on 2 pages portrait, days aligned

Download  template 25: Quarterly planner template for Microsoft Excel, portrait, 4 pages

Template 25: Quarterly planner on 4 pages portrait

  • great for yearly life planning or as a yearly activity tracker

Download  template 26: Quarterly planner template for Microsoft Excel, portrait, 4 pages, days aligned

Template 26: Quarterly planner on 4 pages portrait, days aligned

  • with ample space for notes - handy for a yearly to do list, to write down yearly goals or as a yearly food planner

Download  template 27: Yearly planner template for Microsoft Excel, portrait, 1 page, lined, list design (months vertically)

Template 27: Yearly planner portrait, list design, lined

  • list design (months aligned vertically), lined

Download  template 28: Yearly planner template for Microsoft Excel, portrait, 1 page, lined, list design (months vertically in two six-monthly columns)

Template 28: Yearly planner portrait, 2 columns, list design, lined

Download  template 29: Yearly planner template for Microsoft Excel, portrait, 1 page, list design (months vertically), multi-colored

Template 29: Yearly planner portrait, list design, multi-colored

  • list design (months aligned vertically)

Download  template 30: Yearly planner template for Microsoft Excel, portrait, 1 page, two half-year blocks, minimalist design

Template 30: Yearly planner portrait, two half-year blocks, minimalist

  • year divided into two six-month blocks
  • with ample space for notes under each month heading - great for a yearly to do list, a yearly goal list or a yearly holiday planner

Download  template 31: Yearly planner template for Microsoft Excel, portrait, 1 page, year at a glance

Template 31: Yearly planner portrait, year at a glance

Download  template 32: Blank yearly planner template for Microsoft Excel, portrait, 1 page, year at a glance

Template 32: Blank yearly planner portrait, year at a glance

Download  template 33: Yearly box planner template for Microsoft Excel, portrait, 1 page, multi-colored

Template 33: Yearly box planner portrait, multi-colored

  • with ample space for notes under each month - use as life planner, job planner or yearly journal

Download  template 34: Yearly box planner template for Microsoft Excel, portrait, 1 page, lined

Template 34: Yearly box planner portrait, lined

  • use to create yearly payment or budget plans, a yearly financial plan or for other activities repeating regularly throughout the years

Download  template 35: Two-year planner template for Microsoft Excel, portrait, 1 page, years side by side, lined

Template 35: 2-year planner portrait, years side by side

Download  template 36: Two-year planner template for Microsoft Excel, portrait, 1 page, years stacked, lined

Template 36: 2-year planner portrait, years stacked

Statcounter

Microsoft Power BI Blog

Power bi february 2024 feature summary.

Headshot of article author Saveen Reddy

Welcome to the Power BI February 2024 update. We’ve got a lot of great features this month. Here are some key highlights:

  • Visual calculations make it easier than ever to do calculations that were very hard or even impossible.
  • The Power BI home provides a centralized location for all your Power BI desktop activities.
  • Fabric Copilot for Power BI can now add measure descriptions to your semantic model measures.
  • The Power BI add in now supports shareable links to make it easier for people to consume reports.
  • The new Explore feature gives you a better understanding of what’s in the data you’re exploring.

Fabric Community Conference

Join us at the Microsoft Fabric Community Conference the ultimate Microsoft Data & AI learning event, on March 26-28, 2024, at the MGM Grand, Las Vegas. With over 150 sessions for everyone who works with Power BI, Microsoft Fabric, SQL, Azure AI, and Purview , the conference promises a rich learning experience.

This is a unique opportunity to meet the Microsoft product teams building these technologies, the customers betting their businesses on them, and the partners that are at the forefront of deployment and adoption. Engage with this vibrant community, learn from their real-world experiences, stay abreast of the latest developments.

Please note that this event is in-person only. Sessions will not be recorded, streamed or made available for on-demand consumption.

Register today using code MSCUST for an exclusive discount ! Need help convincing your boss to attend? No problem!  Use this letter  to share with your boss about this unforgettable opportunity.

monthly activity calendar excel

  • Version number: v: 2.126.927.0
  • Date published: 02/16/2024

monthly activity calendar excel

On-object Interaction Updates

  • Enhanced Reference Layer in Power BI Azure Maps Visual 

Data connectivity

Certified connectors updates, storytelling in powerpoint – replace report urls with shareable links in power bi add-in, data overview in explore, directquery connections update, shared device mode is now ga, power bi custom visuals new local storage api, on-object interaction support for custom visuals, tmdl in power bi desktop developer mode, editor’s pick of the quarter, new visuals in appsource, multiple sparklines, rose donut pie chart by powerviz, xviz gantt chart by lumel, control chart xmr by nova silva, drill down graph pro, more users can now collaborate with protected pbix in power bi desktop.

Visual calculations 

A new way of doing calculations has arrived! You can now add calculations directly on your visual using visual calculations, which are DAX calculations that are defined and executed directly on a visual. A calculation can refer to any data in the visual, including columns, measures, or other visual calculations. This approach removes the complexity of the semantic model and simplifies the process of writing DAX. You can use visual calculations to complete common business calculations such as running sums or moving averages. Visual calculations make it easy to do calculations that were previously very hard or even almost impossible to do.

To use visual calculations while in preview, you need to enable it in Options and Settings  ➡️  Options  ➡️  Preview features . Select visual calculations and select OK . Visual calculations will be enabled after Desktop is restarted.

To add a visual calculation, you first need to select a visual. Next, select the New calculation button in the ribbon:

The new calculation button is shown on the Home tab of the ribbon in Power BI Desktop in the Calculations group.

To add a visual calculation, type the expression in the formula bar in the visual calculations edit mode that opens. For example, in a visual that contains Sales Amount and Total Product Cost by Fiscal Year , you can add a visual calculation that calculates the profit for each year by simply typing: Profit = [Sales Amount] – [Total Product Cost].

The visual matrix is updated as you add visual calculations using in the formula bar. New visual calculations are added as columns to the visual matrix.

Additionally, you can easily add a running sum of profit by writing:

Here is a visual with the two visual calculations we have just created:

A screenshot of a graph Description automatically generated

You can use many existing DAX functions in visual calculations. Functions specific to visual calculations are also available, such as RUNNINGSUM , PREVIOUS and MOVINGAVERAGE . Using these and other functions, visual calculations are much easier to read, write and maintain than the current DAX required.

We are only just getting started with this preview. There is a lot more that we have planned, so please stay tuned for updates in future releases. However, we invite you to jump in now!

For more information, read the dedicated blog post and documentation . Please try the preview today and let us know what you think .

Dynamic subscriptions for Power BI reports

Dynamic per recipient subscriptions is now available in Preview for Power BI reports! Like dynamic subscriptions for paginated reports , you can now distribute a personalized copy of a Power BI report to each recipient of an email subscription.

Imagine you have a report that includes sales data for your entire team. You want to schedule an email subscription that sends out a PDF copy of this report to each salesperson on a weekly basis, with the report filtered to only show their sales results.

This can now be done by connecting to a semantic model (previously Power BI dataset) that defines the mapping between recipients and respective filter values. When it’s time to send out the report, the latest data available in your semantic model will determine which employees should receive a report in their inbox, and with what filter values applied.

A screenshot of a computer New dynamic subscription, select and filter data.

See the documentation for dynamic subscriptions here.

This February release we added multi-visual container format support ! Previously, when multi-selecting across different visual types, the format pane did not support any options for formatting the visuals. Now, when multi-selecting different visuals, we’ve added formatting support for container formatting such as changing the size, background color, adding a shadow or turning on/off titles in bulk.

When multi-selecting different visual types (e.g. a line chart and bar chart):

A screenshot of a graph, Visualizations. Order Quantity by Year, Sales by Category.

We’ve also added the ability to format a visual’s container size and position even if it’s empty:

A screenshot of a graph, Visualizations. Select or drag fields to populate the visual.

This month we also bring you a handful of quality improvements to the on-object experience:

  • Bug fix : when working with a non-visual (text box, button, image, shape) the build pane accidentally closing automatically. The build pane now stays open unless explicitly closed regardless of selected item type.
  • Bug fix : style bug where the build pane was showing 5 icons across instead of the usual 6 has been fixed.
  • Bug fix : in some cases, the data flyout was extending beyond the window size making the search box hard to use, this has now been fixed.
  • Enhancement : When choosing a field using the data flyout – you can now click anywhere on the name, not just the checkbox next to it to select the field.

A screenshot of a computer, Data selecting Order Quantity.

5.Enhancement : If replacing a field in a visual that does not use an aggregation or date hierarchy (other dropdowns are disabled), we auto open the data dropdown to save an extra click.

A screenshot of a graph, Data selecting Category.

Power BI Home in Desktop is Enabled by Default  

We are excited to announce the new and improved Power BI Home as the default experience! The Power BI Home has been redesigned to provide a centralized and familiar location for all your Power BI activities within the desktop application. Our aim is to enhance your productivity and make it easier to discover and consume content.

With Power BI Home, you no longer need to navigate through multiple menus or tabs to access your files and reports. This intuitive interface serves as a hub, like other popular office products, where you can effortlessly manage your reports, all from a single location.

Whether you’re a seasoned Power BI user or new to the platform, Power BI Home ensures a consistent and seamless experience across all your Power BI activities.

Now, you can:

  • Initiate a new report directly from the new home screen.
  • Access reports from recommendations that we have curated.
  • Locate your most recent reports through the Quick Access lists.

A screenshot of a computer abilities within the new home screen.

Please continue to submit your feedback directly in the comments of this blog post or in our feedback forum .

Enhanced Reference Layer in Power BI Azure Maps Visual

We’re excited to introduce a significant enhancement to the Power BI Azure Maps visual reference layer feature. In response to valuable user feedback and in alignment with evolving industry standards, we have expanded the capabilities of the reference layer. Now, in addition to supporting the existing GeoJSON format, users can also utilize KML (Keyhole Markup Language) and WKT (Well-Known Text) formats.

We’re also adding URL as a data source alongside file upload. This addition offers users even more flexibility and convenience in importing spatial data into Power BI. Whether your data resides in GeoJSON, KML, WKT, or through a URL link, the Power BI Azure Maps visual seamlessly integrates these formats, ensuring a comprehensive and versatile geospatial analysis experience.

Measure descriptions with Copilot

Add descriptions to your semantic model measures with Fabric Copilot for Power BI! People building reports from your semantic model can see the name and description of your measures, making the description property essential documentation. And Fabric Copilot is here to help!

A screenshot of a computer Description automatically generated

Streamline your semantic model documentation by creating measure descriptions with Copilot .

1. Click on the model measure in the Data pane of Model view to see the measure properties .

2. Click on the Create with Copilot (preview) button under the Description textbox.

3. Review the measure description from Copilot, then click Keep it .

4. Now the measure description is in the Description box. Fine tune the description, as needed.

5. You update the measure later? No worries, just click the button again when you need the description updated!

Try this out today and let us know what you think! Get started today by turning on this public preview feature in Options > Preview features and learning more about how to get access to Fabric Copilot for Power BI on your tenant at https://learn.microsoft.com/power-bi/create-reports/copilot-introduction#copilot-requirements .

DAX query view improvements  

We released the public preview of DAX query view in November 2023, and in this release, we made the following improvements:

A screenshot of a computer, Boolean values are now showing in the Results grid.

  • A share feedback link has been added in Options > Preview features. We would love to hear your feedback on DAX query view!
  • A bug causing active query tab to stop being highlighted is fixed.
  • A bug with close brackets of a nested IFs DAX formula is fixed.

And we have released additional INFO DAX functions.

  • INFO.CHANGEDPROPERTIES()
  • INFO.EXCLUDEDARTIFACTS()
  • INFO.FUNCTIONS()
  • INFO.LINGUISTICMETADATA()

A screenshot of a computer, we have released additional INFO DAX functions.

Learn more about DAX query view at https://learn.microsoft.com/en-us/power-bi/transform-model/dax-query-view .

SingleStore, we’re thrilled to inform you that our connector has now officially moved out of beta. We want to express our gratitude for your valuable feedback and for being an essential part of our beta journey. Your insights have played a crucial role in shaping the enhancements we’ve made.

This upgrade comes with an exciting new feature – you can now cancel running queries, hassle-free. No more queries running in the background after you refresh the UI/visual or navigate across the pages in the report.

Our team is dedicated to continuously improving and adding even more useful features to enhance your experience. Thank you for your ongoing support, and we can’t wait to continue providing you with top-notch features that elevate your data connectivity and reporting capabilities.

When you add the Power BI add-in to a presentation, you can pick a report suggested to you or paste a link to a specific report.

When you paste a standard report link (the URL copied from the browser address bar), and if sharable links are enabled for your organization and allowed for this report, you have re-share permissions to this report, Power BI add-in can replace the link you pasted with shareable link. In that case you will see a checkbox added below the report URL that offers you automatic access to this report. Just mark this checkbox and Power BI add-in will create a shareable link for you.

Using a sharable link ensures that other users viewing the presentation have the required permission to see the report, and do not need to request access when viewing the presentation.

A screenshot of a computer, Using a sharable link ensures that other users viewing the presentation have the required permission to see the report, and do not need to request access when viewing the presentation.

Have you tried out the new Explore feature yet? This month we added a data overview feature to Explore that allows you to get the “gist” of what your data is all about. Powered by Copilot, data overview gives you a summary of what’s contained in the data you’re exploring and highlights some interesting tidbits to get you started. Let us know what you think!

A screenshot of a computer, Powered by Copilot, data overview gives you a summary of what’s contained in the data you’re exploring and highlights some interesting tidbits to get you started.

Maximum connections per data source  is a setting to configure the maximum number of connections DirectQuery opens for each underlying data source. This controls the maximum number of queries that can be executed concurrently against each data source and is configurable per semantic model.

We recently updated the upper limit of the number of concurrent Direct Query connections allowed per semantic model. The updated limits for each SKU are listed in the table below.

The upper limit for Power BI PPU is 100 active connections. Note that there is no change to the Power BI Pro and Report Server limits and the default maximum value remains as 10 concurrent connections.

Introduced last September, shared device mode is now generally available! With shared device mode, organizations can safely deploy the Power BI mobile app across their pool of shared devices.  Check it out !

This API allows Custom Visuals to store data directly in the local browser. Data stored locally is more secure and improves the performance of web apps. The API will be controlled by a global admin setting. Learn more about the API.

Our February release introduces the support of the new on-object interaction. This enhancement allows users to build and customize visuals directly on the visual in Power BI Desktop. It puts common actions for creating and formatting visuals on the visuals themselves, actions such as adding fields, changing visualization types, and formatting text.

The primary objective of Power BI Desktop developer mode is to provide friendly source control and co-development experience. With this objective in mind, you can now save your Power BI Project files (PBIP) using  Tabular Model Definition Language (TMDL)  format. TMDL has been designed from the ground up to be human-friendly, facilitating not only readability but also easy editing in any text editor. This represents a substantial enhancement for source control and collaborative development experiences, particularly when dealing with complex file diffs.  

Saving as a PBIP using TMDL is currently in preview. Before giving it a try, you must first enable this feature in Preview features: go to  File  >  Options and settings  >  Options  >  Preview features  and check the box next to “Store semantic model using TMDL format”.  

After enabling the preview feature, when saving as PBIP, your semantic model will be saved as a TMDL folder named “\definition” with separate files for each table, perspective, role, culture:  

After enabling the preview feature, when saving as PBIP, your semantic model will be saved as a TMDL folder named “\definition” with separate files for each table, perspective, role, culture: 

You can also upgrade existent PBIP files to TMDL , by just opening them and choosing “Upgrade” when you save:  

You can also upgrade existent PBIP files to TMDL, by just opening them and choosing “Upgrade” when you save: 

By default, Fabric Git Integration will still use Tabular Model Scripting Language (TMSL) to export the semantic model during the Public Preview. However, if the semantic model is imported into Fabric using TMDL, then Fabric Git Integration will export the definition into Git using TMDL in the event of any semantic model changes in the service.  

Learn more about TMDL in Power BI Project files  here .  

Visualizations

  • Inforiver Analytics+ (Charts+Cards+Tables)
  • Inforiver Premium Matrix / Table
  • Drill Down Donut PRO (Filter) by ZoomCharts
  • Date Picker
  • Enlighten Aquarium
  • Deneb: Declarative Visualization in Power BI
  • Comment – Dynamics 365 Finance business performance planning
  • Reporting – Dynamics 365 Finance business performance planning
  • Variance – Dynamics 365 Finance business performance planning
  • Matrix planning – Dynamics 365 Finance business performance planning
  • Copy – Dynamics 365 Finance business performance planning
  • Table edit – Dynamics 365 Finance business performance planning
  • Graphical planning – Dynamics 365 Finance business performance planning
  • Waterfall-Visual-Extended
  • Processifier Process Mining
  • flashbi fantail
  • Map by Squillion
  • Charticulator Visual Community (View)

New features were added to Multiple Sparklines on Oct 23

  • When you double click a line chart, it will zoom in to screen size of visual and you can then compare it with any other line chart in that column.
  • You can use different colors for each line chart in a field/column.
  • You can insert ratings with bands.
  • You can add beeswarm / distribution microchart.

A screenshot of a graph New features were added to Multiple Sparklines on Oct 23

Once you double click the line chart, it zooms in to the visual size. You can then compare it with another line chart in the same column. This is shown below:

A graph with purple lines Once you double click the line chart, it zooms in to the visual size. You can then compare it with another line chart in the same column.

Download this visual from APPSOURCE

For more information visit https://www.excelnaccess.com/sparklines/

or contact [email protected]

Rose/Donut/Pie Chart is a powerful visual that lets you build four types of charts – a rose, a rose donut, a donut, and a pie chart. These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison.

Key Features:

  • Chart Options: Rose, donut, pie charts with style customization.
  • Data Colors: Choose from 30+ palettes, including color-blind mode.
  • Fill Patterns: Apply patterns or use custom images.
  • Smart Labels: Improve readability with data and leaf labels.
  • Arc Customization: Easily adjust arc radius, padding, and stroke.
  • Ranking: Filter Top/Bottom N, show others intelligently.
  • Center Circle: Multiple layers, text, icons, and images in the center.
  • Mouseover Text: Display dynamic details when hovering over arcs.
  • Image Labels: Integrate dynamic image URLs for enhanced visuals.
  • Conditional Formatting: Detect outliers and set smart rules for measures/categories.

Other features included are annotation, grid view, show condition, and accessibility support.

Business Use Cases: Finance, Healthcare, E-commerce, Education, Customer Demographics

🔗 Try Rose/Donut/Pie Chart for FREE from AppSource

📊 Check out all features of the visual: Demo file

📃 Step-by-step instructions: Documentation

💡 YouTube Video: Video Link

📍 Learn more about visuals: https://powerviz.ai/

✅ Follow Powerviz : https://lnkd.in/gN_9Sa6U

A screenshot of a chart Rose/Donut/Pie Chart is a powerful visual that lets you build four types of charts - a rose, a rose donut, a donut, and a pie chart. These chart types are commonly used to display part-to-whole relationships, proportions of categorical data, and ratios. Each arc represents the ratio from the total for easy comparison.

xViz Gantt Chart by Lumel is a Microsoft Power BI Certified Visual. As the most feature rich Gantt in Power BI – it is widely used across most Fortune 500 companies world-wide.

Why Large Enterprises Choose xViz Gantt Chart:

Real-time Alerts for Project Managers: Leverage Conditional Formatting to receive color-coded alerts and status flags, ensuring timely awareness of schedule delays or progress issues.

Visualize Task Dependencies: Easily identify causes of delays with the ability to plot task dependencies using connectors within the roadmap view.

Adaptable for Different Users: From Stakeholders tracking yearly progress to Project Managers analysing monthly views and Developers scrutinizing smaller time grains with flexibility across three distinct timeline levels.

Strategic Planning with Reference Lines and Ranges: Utilize Reference Lines and Ranges to mark crucial dates, holidays, sprints, or deadlines across projects.

Customization Galore:   Wide range of customizable options, including adjustable timeline limits, selectable week start days, and indentation customization for ragged hierarchies.

Hassle-Free Licensing:   The visual is free for use in Power BI Desktop. For sharing & collaborating on Power BI service, the licenses can be purchased directly from Microsoft AppSource.

A screenshot of a computer

Try xViz Gantt Chart today after watching the 2-minute video highlights.

Years ago, Stacey Barr introduced us to the magic of Control Charts. Magic it is, because it allows everyone to split their temporal data in two: random noise and real signals. And we all are looking for real signals, and don’t want to be distracted by random noise.

In our last release of the Control Chart XmR we have added several new features to make it even easier to find real signals and ignore random noise in your data.

First, we added a feature to allow any report consumer to override the applied rules. This allows everyone to analyze the effects of one specific rule or set of rules.

A screenshot of a computer First, we added a feature to allow any report consumer to override the applied rules. This allows everyone to analyze the effects of one specific rule or set of rules.

Several customers asked for a possibility to download the calculated values from the visual. Now you can download all values calculated by the Control Chart XmR, like: LCL, CL, UCL, sigmas and signals.

Don’t hesitate and try the new Control Chart XmR now on your own data by downloading it from the AppSource . All features are available for free to evaluate this visual within Power BI Desktop.

Questions or remarks? Visit us at: https://visuals.novasilva.com/ .

Drill Down Graph PRO lets you create elegant and user-friendly graphs to represent complex relationships between nodes. It’s ideal for both small and large network graphs and offers advanced features like cross-chart filtering and vast customization options. You can create hierarchies and explore them using this visual’s intuitive interactions.

Main features include:

  • Multiple layout options – dynamic, hierarchical, and radial
  • Focus nodes mode – for gradual exploration of graphs.
  • Customization options – choose colors, shapes, images, and labels.
  • Bidirectional links – show reciprocal relationships between nodes.
  • Touch device support – explore your data anywhere.

Popular use cases:

  • IT – asset management, IT infrastructure, IoT monitoring
  • Logistics – fleet management, stock management, parcel tracking
  • Sales & Marketing – community detection, account management, web analytics

ZoomCharts Drill Down Visuals are known for interactive drilldowns, smooth animations, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu. Use them to create visually appealing and intuitive reports that business users will love on any device.

Get Drill Down Graph PRO from AppSource!

Learn more about Drill Down Graph PRO by ZoomCharts.

A screenshot of a computer ZoomCharts Drill Down Visuals are known for interactive drilldowns, smooth animations, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu. Use them to create visually appealing and intuitive reports that business users will love on any device.

Have you ever wondered how to collaborate with your colleagues on sensitive data without compromising its security? Do you want to learn how to use Microsoft Purview Information Protection sensitivity labels to protect your data ?

If so, you’re in the right place! We’ll show you how to use sensitivity labels with protection to encrypt and protect your data, and how to enable more users to edit and republish encrypted PBIX files. By the end of this article, you’ll be able to collaborate more securely with your data in Power BI.

Protecting your data with Microsoft Purview

Compliance admins in your organization can use Microsoft Purview Information Protection  sensitivity labels  to manage their org’s sensitive data across different apps and services and meet regulatory and compliance requirements.

They define file protection policies for the sensitivity labels, which result in files being encrypted when such labels are applied, allowing only authorized users to open and edit these files in Office apps and Power BI Desktop.

Sensitivity labels are widely adopted by enterprises today and used to label and protect content in  Microsoft 365  apps such as Excel, PowerPoint, Word, and Outlook, and now in Power BI and Fabric as well.

All you have to do is enable Information Protection in Microsoft Fabric’s Admin Portal and let the labels do the rest.

A screenshot of a computer All you have to do is enable Information Protection in Microsoft Fabric’s Admin Portal and let the labels do the rest.

How Power BI Desktop enforces sensitivity label protection

In Power BI Desktop , we enforce label protection on PBIX files. To open a PBIX file, you either must be the label issuer or have one of the following usage rights .

These usage rights are elevated permissions, as they grant permission to change the sensitivity label. Because Power BI and Office apps use the same label policies, compliance admins may prefer not to grant these usage rights for Highly confidential labels. This might block you from collaborating with your colleagues when you’re sharing or downloading Power BI reports and trying to open them in the desktop app.

Collaborating and keeping label protection on PBIX files

By enabling “ Increase the number of users who can edit and republish encrypted PBIX files (preview) ” in your tenant, users that have been assigned with all of the following usage rights should be able to open, edit, and republish the protected PBIX file to the Power BI service:

  • View Content (VIEW)
  • Edit Content (DOCEDIT)
  • Save (EDIT)
  • Copy and extract content (EXTRACT)
  • Allow Macros (OBJMODEL)

Thus, users who were once restricted can now collaborate with protected files, while keeping protection consistent with the organizational policy.

Note: These usage rights are a sub-set of the “Co-Author” permissions preset in Microsoft Purview compliance center.

What are the restrictions and why?

In order to align with compliance requirements, users with these usage rights are lightly restricted while editing a protected PBIX file.

No exporting to unsupported formats –The user won’t be able to export to formats that don’t support sensitivity labels, such as CSV files.

A screenshot of a computer In order to align with compliance requirements, users with these usage rights are lightly restricted while editing a protected PBIX file. No exporting to unsupported formats –The user won’t be able to export to formats that don’t support sensitivity labels, such as CSV files.

No label change – The user can’t change the label on the PBIX file.

A screenshot of a computer No label change - The user can't change the label on the PBIX file.

Republishing to the original workspace only

Republishing to the original workspace only

Why restrict republishing into the original workspace only?

To remain compliant, we must keep users from gaining more permissions, including Power BI permissions (i.e., Read, Write, Reshare and Build). Meaning that a user who wishes to publish should not be able to publish to a workspace that might grant them additional permissions through Workspace roles.

Additionally, this feature is meant for collaborating and sharing items that are more restricted than usual, and confidential data is usually managed in a dedicated workspace. This restriction will prevent users from publishing confidential data across the tenant.

Side note: The file must be published at least once for other users to be able to republish it to that specific workspace. If the file has not yet been published, then the latest label issuer (the one who set the protected label) or a user with sufficient usage rights must publish it and then share the file with the other editors.

How to enable it

Prerequisite: The compliance admin must assign you and your colleagues the proper permissions for that sensitivity label.

Next, Fabric/Power BI admins must enable the feature in Admin Portal > Information protection > Increase the number of users who can edit and republish encrypted PBIX files (preview).

In Power BI Desktop, users who would like to open and edit protected PBIX files must enable the feature by opening File > Options and settings > Options > Preview feature > Less elevated user support.

Final words

With this new feature, users can now collaborate more easily with other users when working on confidential data in Power BI Desktop, without any loss of protection along the way.

That is all for this month! Please continue sending us your feedback and do not forget to vote for other features that you would like to see in Power BI! We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store,  please leave us a review .

Also, don’t forget to vote on your favorite feature this month on our community website. 

As always, keep voting on  Ideas  to help us determine what to build next. We are looking forward to hearing from you!

  • Microsoft Fabric
  • visual calculations

Sign up for the Power BI Newsletter

Sign up below to get the latest from Power BI, direct to your inbox!

I would like to receive the Power BI newsletter. Privacy Statement.

Participation requires transferring your personal data to other countries in which Microsoft operates, including the United States. By submitting this form, you agree to the transfer of your data outside of China. Privacy Statement .

IMAGES

  1. WinCalendar: Excel Calendar Creator with Holidays

    monthly activity calendar excel

  2. Samples Of Monthly Activity Calendar Templates And Designs

    monthly activity calendar excel

  3. Monthly Schedule Template Excel

    monthly activity calendar excel

  4. Ultimate monthly calendar for Excel

    monthly activity calendar excel

  5. Monthly Activity Calendar

    monthly activity calendar excel

  6. Schedule Of Activities Calendar Format

    monthly activity calendar excel

VIDEO

  1. MAGICAL CALANDER

  2. Excel Trick: How to create dynamic monthly calendar in Excel #shorts

  3. 🗓️2024 Calendar in Excel #excel #shorts

COMMENTS

  1. Excel calendar templates

    Excel calendar templates - Microsoft Support Excel calendar templates Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 More... Many calendar templates are available for use in Microsoft Excel. A template provides a basic calendar layout that you can easily adapt for your needs.

  2. Free Excel Calendar Templates

    Download 2024 Blank Monthly Calendar Template (Landscape) Excel | PDF Monthly Calendar Template for 2024 - Landscape: This blank calendar template shows a monthly view with plenty of space for notes under each date. It also provides a glimpse of the previous and following months to make planning easier.

  3. Monthly Calendar Template for Excel and Sheets

    Description This new version of our monthly calendar lets you create a 12-month calendar starting in January, for any year. Each month is on a separate worksheet. You can also choose to start with a different day of the week, such as Monday. This version is compatible with Online Excel (Office 365) and Mobile Office!

  4. Monthly Planner Templates for Microsoft Excel

    Template 1: Monthly planner for Microsoft Excel (.xlsx file), landscape, 1 page Template 1: Monthly planner landscape monthly planner on one page page orientation: landscape (horizontal) days arranged vertically (below each other)

  5. Excel Calendar Template

    2024 Monthly & Yearly Excel Calendar Templates Free printable 2024 monthly excel calendar planner templates with public holidays and ample space for daily and monthly notes. Customize Download A customizable 2024 quarterly calendar excel template with the US holidays in landscape layout spreadsheet. Customize Download

  6. Excel Calendar Template for 2024 and Beyond

    How to Make a Calendar in Excel using Built-In Templates. To use one of the calendar templates from the Microsoft template gallery, follow these steps after opening Excel: Go to File > New. Look for a calendar in the featured set of templates or enter "calendar" in the search field. Click on the template thumbnail to preview or open directly in ...

  7. Free, Printable Excel Calendar Templates for 2023 & On

    How to Use a Monthly or Yearly Calendar Excel Template Using a calendar template is incredibly easy. All you need to do is choose whether you need a monthly or yearly calendar, and add your scheduled events to the template. You can also customize the font types, font sizes, and colors.

  8. Excel Calendar Template

    Printable Calendar in Excel format. Blank templates XLS files for 2023 and 2024. All calendar files are editable & ideal for use as a planner. Available in monthly, weekly and full year layouts. Click to download.

  9. Monthly Calendar Templates for Microsoft Excel

    Monthly Calendars for Microsoft Excel Printable monthly calendar templates in Microsoft Excel format - 22 layouts, blank and undated Sponsored links Practical and versatile monthly calendar templates, undated, fully editable and customizable, free to download and print.

  10. How to Make an Interactive Calendar in Excel? (2024 Template)

    Click here to download the monthly calendar Excel template And on similar lines, below I have the yearly calendar template, where when you change the year value the calendar automatically updates to give you the calendar for that year. Interactive Yearly Calendar in Excel

  11. Excel Tutorial: How To Create A Monthly Calendar In Excel

    To start creating your monthly calendar, open a new Excel spreadsheet on your computer. This will serve as the foundation for building your calendar layout. B. Adjust the column widths and row heights for the calendar layout Click and drag to adjust the column widths and row heights to create a grid layout for your calendar.

  12. Monthly Schedule Template For Excel

    A typical Microsoft Excel or Google Sheets monthly schedule template will include an outline for each month of the year, either as a single worksheet or 12 individual worksheets. Each month is broken down into the days of the week, beginning with Sunday or Monday.

  13. Free 2024 Excel Calendar Templates

    Download this horizontal Excel 2024 monthly calendar for printing purposes. For daily or monthly planning, the organizer template has huge boxes with the previous and following months listed at the top. ... The year-at-a-glance template has an area for planning and activities and organizes the months in a vertical pattern. Customize Download ...

  14. Easiest Way to Make a Calendar in Excel

    This tutorial uses the latest version of Excel in Microsoft Office 16 for Windows. Open Microsoft Excel on your PC. Click on the New icon in the left nav menu. Click Calendar under the search bar to see included Microsoft calendar templates. Click on the calendar you want to use, and click the Create button.

  15. How to Make a Calendar in Excel? (2024 Guide With Templates)

    To do so, right-click on the January tab and select Move or Copy. When the Move or Copy dialogue box appears, select (move to end) > check off Create a copy > click OK. Excel will create a new calendar sheet as ' January (2) .'. Rename the sheet as 'February' and then edit the days' numberings on the sheet accordingly.

  16. Free calendar templates online

    Yearly, weekly, or monthly—design your perfect 2024 calendar in seconds, for free. Start with Word, PowerPoint, and Excel templates and use powerful AI tools to customize.

  17. Monthly Schedule Templates for Microsoft Excel

    Template 3:Monthly schedulelandscape, lined. monthly schedule on one page, lined/ruled. page orientation: landscape (horizontal) weeks start on Sunday (see below for Monday start schedules) with room for week numbers at the sides. blank, undated, editable, printable. easy to customise and adapt to your needs.

  18. How to Make an Interactive Calendar in Excel (2 Easy Ways)

    Make an Interactive Calendar in Excel: 2 Easy Ways In this article, you will see two different approaches to making an interactive calendar in Excel. In my first method, I will make a monthly interactive calendar. For my second procedure, you will see the steps of creating an interactive yearly calendar in Excel.

  19. FREE Printable Monthly Calendar

    December Contents 1 Monthly Calendar 2024, 2025, 2026, 2027, and 2028 2 Monthly Blank Calendar Template 2.1 Undated 2.2 Dated 3 Calendar Maker 4 Word Calendar 5 Excel Calendar 6 Photo Calendar 7 Monthly Planner 7.1 Daily Planner with 2024 Calendar 7.2 Weekly Monthly Planner 8 Bullet Journal Monthly Spread 9 Cute Calendar 9.1 Cute Blank Calendar

  20. Creating a Calendar in Excel

    Here's my entire playlist of Excel tutorials: http://bit.ly/tech4excel Learn how to easily and quickly create a customized monthly calendar in Excel. You'll ...

  21. Free Printable Monthly Planner for Excel

    Free Monthly Planner Template. Create a Monthly Planner by Printing Your Own Planner Page - by Jon Wittwer. Our free printable Monthly Planner template was designed for inserting into common 3-ring binders. You can edit and customize the planner using Excel or OpenOffice and then print the monthly planner page using regular letter-size paper.

  22. LPL Financial Reports Monthly Activity for January 2024

    PRESS RELEASE GlobeNewswire. Feb. 22, 2024, 04:05 PM. SAN DIEGO, Feb. 22, 2024 (GLOBE NEWSWIRE) -- LPL Financial LLC ("LPL Financial"), a wholly owned subsidiary of LPL Financial Holdings Inc ...

  23. February 2024 updates for Microsoft Office

    Introduction. Microsoft released the following security and nonsecurity updates for Office in February 2024. These updates are intended to help our customers keep their computers up to date. We recommend that you install all updates that apply to you. To download an update, select the corresponding Knowledge Base article in the following list ...

  24. Yearly Planners in Microsoft Excel Format

    Yearly planner templates in Excel format (undated) - 36 designs, free to download & print. Practical, customizable and versatile yearly planner templates suitable for a wide variety of uses. The templates are blank, printable and macro-free and are easy to edit, amend, save and use again later.

  25. Power BI February 2024 Feature Summary

    Welcome to the Power BI February 2024 update. We've got a lot of great features this month. Here are some key highlights: Visual calculations make it easier than ever to do calculations that were very hard or even impossible. The Power BI home provides a centralized location for all your Power BI desktop activities. Fabric Copilot for Power BI can now add measure descriptions to your ...