Thank you so much for this amazing tool! I was able to incorporate some of the main features into my own Calendar and made it based on a traveling agenda. Great content!
Thank you. Nice video. This is the first time I visit your site as well. Looking forward to come back again. Very nice to use the camera and take a screenshot.
Hello, this is a very nice video. I also want to create a similar format. Can you please share step by step guide this would help me yo create as per the requirement. Thanks
If I just wanted to track assignments and their due dates, how would I create that? I love this video, and it is the most in tune to what I’ve been searching for. I basically have a list of assignments, and when they are due. I want to display that data in to a calendar dashboard like what you have.
With new array based formulas, I belive creating the calendar is much simpler. Assuming, you have Month in C3 in MMM format and Year in D3, the below formula will generate entire dynamic calender in one go, without any other supporting formula or function: =SEQUENCE(6,7,LET(A,DATE($D$3,MONTH($C$3&1),1),(A)-(WEEKDAY(A,2)-1)),1)
@@GoodlyChandeep thank you. Is there a way to conditionally format > 1 entry differently in the same cell? Ex. cell contains entries “Truck” and “Car”. Desired outcome is to conditionally format BLUE for “Car” and RED for “Truck” in the same cell…
Your dashboards are visually stunning and, might I say, each an work of art. Will you make one similar to this for appointment purpose? Say, tracking appointment and cost in a small clinic?
@@GoodlyChandeep I made one myself with Microsoft access which does basic record keeping,billing and rudimentary appointment tracking for a small clinic. Back then I didn't know Excel could be developed into such excellent user interface. I had to learn access from scratch. Had I known before, I would have spent my efforts on Excel. Thanks anyway.
Hi Sandi, At the time of writing this.. A calendar visual wasn't very friendly in Power BI so I did it in Excel. Nevertheless "Now" you can pull up a calendar custom visual and nearly do the same thing in Power BI Hope this helps
Do you know how to adjust the size of the calendar if there are many events in the same day? Awesome video! Cant wait for your website to be up again and check it out
@@GoodlyChandeep This is what I ended up doing and I think it works well! Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Call autofit1 Call PicReset1 End Sub Sub PicReset1() 'expression.ScaleHeight(Factor, RelativeToOriginalSize) 'Factor 1 = 100% With ActiveSheet.Shapes("test1") .ScaleHeight 1, msoTrue .ScaleWidth 1, msoTrue End With End Sub Sub autofit1() ' Worksheets("Calculations").Range("U4:AA8").Columns.AutoFit Worksheets("Calculations").Range("U4:AA8").Rows.AutoFit End Sub
Hi Chandeep, Thank you for a very informative video Bruv. for my day to day purposes, I do not really fiddle with Excel but a task on my queue requires me to figure out an automated way to convery tasks with start and end dates to be plaotted on a calendar in excel which is what lead me to your video. I am still not fully sure how do I do that. and was hoping if you could help. Please remember, you are talking to someone who can just about navigate his way in excel.
Hey thanks for writing. The month Tab is a slicer. You can read two things 1. How to make a slicer - www.goodly.co.in/slicers-in-excel/ 2. How to customize a slicer - www.goodly.co.in/slicer-formatting-tricks/ hope this helps
Hi Ola, I'll soon be launching an online course on Power Query. Also might do another live workshop on Power BI in Mumbai (India) early next year. Please sign up for the email list to be informed - www.goodly.co.in Thanks Chandeep
I was successful in replicating this worksheet. However, I have events that have a duration longer than one day. How can I incorporate a start and finish date.
Great video content! Excuse me for chiming in, I would appreciate your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good one of a kind guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some amazing things about it and my best friend Jordan after many years got great success with it.
I love you bro.
U just saved a brother...
Forever grateful
Thank you so much for this amazing tool! I was able to incorporate some of the main features into my own Calendar and made it based on a traveling agenda. Great content!
You're very welcome!
Thank you. Nice video. This is the first time I visit your site as well. Looking forward to come back again. Very nice to use the camera and take a screenshot.
Thanks Bart. I am glad you liked my work
Hello, this is a very nice video. I also want to create a similar format. Can you please share step by step guide this would help me yo create as per the requirement.
Thanks
i'm not understanding where teh calendar table came from, how was it created and how did you link it to events table?
Is it possible that you can show us step by step it looks amaze
If I just wanted to track assignments and their due dates, how would I create that? I love this video, and it is the most in tune to what I’ve been searching for. I basically have a list of assignments, and when they are due. I want to display that data in to a calendar dashboard like what you have.
@jim did you ever get a fix for what you are looking for? I am looking for the same thing
@@elitarang759 I haven’t figured it out yet. Got busy with work, and it dropped in priorities.
I’m working on this right now for my job.. hoping to come up with something this year.
Same here
nice perfomance excel , thanks
With new array based formulas, I belive creating the calendar is much simpler. Assuming, you have Month in C3 in MMM format and Year in D3, the below formula will generate entire dynamic calender in one go, without any other supporting formula or function:
=SEQUENCE(6,7,LET(A,DATE($D$3,MONTH($C$3&1),1),(A)-(WEEKDAY(A,2)-1)),1)
Hi. Could you please share the link to download this dashboard? Thank you!
Hi, how can I create a range of event (start date to end date) to show up on the calendar by using the pivot table?
This looks awesome! How would you deal with possibility of multiple events on the same day?
The events would be concatenated and shown together on that date
@@GoodlyChandeep thank you. Is there a way to conditionally format > 1 entry differently in the same cell?
Ex. cell contains entries “Truck” and “Car”. Desired outcome is to conditionally format BLUE for “Car” and RED for “Truck” in the same cell…
Awesome video
awesome thank you ❤
Hello, I found your tutorial to be amazing. What would be the best way to get in touch with you about a small project for my company?
goodly.wordpress@gmail.com
Your dashboards are visually stunning and, might I say, each an work of art. Will you make one similar to this for appointment purpose? Say, tracking appointment and cost in a small clinic?
Thanks, Can't promise :(
@@GoodlyChandeep I made one myself with Microsoft access which does basic record keeping,billing and rudimentary appointment tracking for a small clinic. Back then I didn't know Excel could be developed into such excellent user interface. I had to learn access from scratch. Had I known before, I would have spent my efforts on Excel. Thanks anyway.
@@DrMohammadArifulHoque Wish you all the very best! :)
Mate pls post the step by step to create the format of the calendar please 🙏🏼
Can you make this for multiple years?
I love you man❤
Love you too!
In the calculations sheet, when i try to add the weekdaycalc formula in doesn't work, it gives me REF, what should i do?
Can you show us the same in Power BI ?
Could you possibly show how to do this in Power BI?
Hi Sandi, At the time of writing this.. A calendar visual wasn't very friendly in Power BI so I did it in Excel. Nevertheless "Now" you can pull up a calendar custom visual and nearly do the same thing in Power BI
Hope this helps
hi goodly...how I can find it download in your website? ...amazing video
How can I use your chart but change the dates to begin with 1/1/2023 instead of 2017?
Do you know how to adjust the size of the calendar if there are many events in the same day? Awesome video! Cant wait for your website to be up again and check it out
Working now.. thanks for letting me know
@@GoodlyChandeep This is what I ended up doing and I think it works well!
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Call autofit1
Call PicReset1
End Sub
Sub PicReset1()
'expression.ScaleHeight(Factor, RelativeToOriginalSize)
'Factor 1 = 100%
With ActiveSheet.Shapes("test1")
.ScaleHeight 1, msoTrue
.ScaleWidth 1, msoTrue
End With
End Sub
Sub autofit1()
' Worksheets("Calculations").Range("U4:AA8").Columns.AutoFit
Worksheets("Calculations").Range("U4:AA8").Rows.AutoFit
End Sub
@@Qweertyyuiiop Hi, where did you put this code?
Hi Chandeep, Thank you for a very informative video Bruv. for my day to day purposes, I do not really fiddle with Excel but a task on my queue requires me to figure out an automated way to convery tasks with start and end dates to be plaotted on a calendar in excel which is what lead me to your video. I am still not fully sure how do I do that. and was hoping if you could help. Please remember, you are talking to someone who can just about navigate his way in excel.
Tutorial???
how do you make the month tab?
Hey thanks for writing.
The month Tab is a slicer. You can read two things
1. How to make a slicer - www.goodly.co.in/slicers-in-excel/
2. How to customize a slicer - www.goodly.co.in/slicer-formatting-tricks/
hope this helps
When is the next power pivot and power bi training?
Hi Ola, I'll soon be launching an online course on Power Query. Also might do another live workshop on Power BI in Mumbai (India) early next year. Please sign up for the email list to be informed - www.goodly.co.in
Thanks
Chandeep
I was successful in replicating this worksheet. However, I have events that have a duration longer than one day. How can I incorporate a start and finish date.
Great video content! Excuse me for chiming in, I would appreciate your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good one of a kind guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some amazing things about it and my best friend Jordan after many years got great success with it.
I'm trying to replicate this for an event calendar I need to make. Did you use the template provided or create yours from scratch?
5:54
Thank you
Too much talk, with no benifit