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.
how do I create this file please?
could you just give me a few pointers on how I start it?
Thanks
learn700 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!
Riny_van_Eekelen sorry this is the first I have used this community. It's the file you have attached in this thread.
I have a long list of milestones / events throughout the year in a list in excel (date and process), I wanted to put that into a calendar view to make it easier to see when all our deliverables, budget, etc are throughout the year.
Thanks
learn700 Are you familiar with Power Query / Power Pivot? It's required to follow the steps taken in either of the files. I'm not able to go into detail now (on a Mac) and soon closing down for the night.