Forum Discussion
Converting excel data into a printable calendar template
tammyangel Perhaps you are willing and able to move away from Word, because you could do all within Excel, with Power Query / Power Pivot (provided you are working on a PC, not a Mac).
The attached workbook contains an example that demonstrates what's possible. Sheet1 contains the Events listing (Date, Event) and Sheet2 has a (power) pivot table with the Annual Calendar view you described. All don in a quick-and-dirty manner and most likely it needs to be adapted to your real situation.
Change the events listing (change a date, add, delete, rename), and refresh the pivot table. That's it!
Edit: Added another file ("tammyangel-2.xlsx) . Power Query only. Personally I prefer that one.
Hi Riny,
Do you have a solution for multi-day events? I am trying to implement the same concept for a year-long calendar of conferences and many are multi-day.
Thanks in advance!
sophiaperigee This is an old and long thread and many different calendar options were discussed. Perhaps better to start a new thread where you focus on your specific situation.
So far you have been very helpful. I still can't adapt the table for my needs. Some of my needs are for a class name
Class name | Date| Date| Date| etc. (up to 12 possible dates)
Is there a way to see the table on a normal calendar view or is the list the only way to use that raw data?
Thanks for your insight
RickJ80 Share a file please, because it's difficult to visualise how Class, Date, Date, etc will affect the calendar.
- I couldn't figure out how to send a file
Hi Riny_van_Eekelen. Can you possibly please explain how you would turn the attached data spreadsheet into a monthly or annual calendar of events - like a monthly planner view not a list as it is now using power query/power pivot? Thank you 🙂
tahnee_h That's a very broad question and not so easy to answer, but the basis for any scheduling would be a list of columns in the correct structure. In your case a table with columns for Date, Time, Location, Function Name, Function Type and Pax.
But that's going to be a lot of information to be fitted inside a calendar template like the one being discussed in this thread. I dare to say that it would be best to use an out of the box calendar system like the ones that are included in your e-mail system. I would never consider developing such a system in Excel myself.
- This kind of calendar is exactly what I generated for the time off calendar I was making. There's no doubt it takes work to produce but it can be done
Riny_van_Eekelen This was really helpful! Thanks.
Let's add a few more levels of complexity...
1. Let's use the previous example of 200+ events. Is it possible to add an event type to the data? Without it being part of the event name?
2. I understand that the original question was to format the calendar to be the large yearly calendar. Is it possible to format the pivot table to look like a 'regular' calendar?
Thanks in advance,
1) Yes, that is possible. How would you want to use the event type in the calendar?
2) How would a "regular" calendar look like for you?
Thanks for the quick reply.
In my use case, I'm collecting a list of workouts related to different running races. I'm training for several races and each one has a different schedule. I'm trying to consolidate all of those in one place.
I'm attaching a spreadsheet based off your original reply.
- Riny_van_Eekelen
how do I create this file please?
could you just give me a few pointers on how I start it?
Thankslearn700 Which file do you mean? This is an old thread. I need to refresh my memory.
Riny_van_Eekelen no worries. I have never used power pivot and feel like I have been stuck in time with Excel as this power world is new to me!
I'm just trying to work out from the basics using the excel help bit and learn it as I don't know anything about it to be able to follow the steps. But it sounds pretty amazing all these functionalities!
