Hi all... Hope you found the video useful. Like this comment if you want to see an "ADVANCED" version of this gantt chart with progress indicator, switch between daily / weekly and option to exclude weekends.
Lovely Video clip! Sorry for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my m8 after a lifetime of fighting got amazing results with it.
I must have been living under a stone that I didn't notice your youtube channel before. Your tools and tips on the internet have helped me so many times over the last 2 decades. You are brilliant!
This is fantastic, thanks! Features that I'd like to see: 1. Exclude weekends and holidays 2. Effort estimation 3. Fill the activity Gantt chart with planned vs actual progress 4. Move completed activities to history and always view activities in progress and upcoming activities first 5. Select the Week for which you want to view the data ( to view past activities)
You are welcome Gaurav... You can easily customize the file to add these things. 1. Use workday() instead of +1 2. Effort = duration x hours per day 3. This is something I plan to cover in an advanced video 4. You can use Power Query to remove old & completed activities when they reach pivot table. 5. Add a form control and link it to either start.date or change the formula logic. All the best.
Wonderful. Years ago I used Excel for Projects because it gave me more flexibility that MS Project and was more accessible for others. This is a more robust PM than the ones I created long ago. Thank you!
Hello all... The full series is out now. Watch the next videos here - Part 2 - Project progress charts - ua-cam.com/video/C0F_VKlTX1c/v-deo.html Part 3 - Preparing the final dashboard - ua-cam.com/video/Exlj5qH0rhc/v-deo.html
The Lego mini-figures absolutely made my day! I just found your channel while looking for info about Power BI and I'm already excited to watch more! Keep up that wonderful sense of humor 😁😁
Thank you so much. This tutorial made Gantt chart making a piece of cake. Amazed by the procedure, I visited your website which turned out to be a gold mine. Kudos🤩🤩
Thank you that in the current lock down I happen to visit one of your videos and could connect with you in this life of mine ..... I do work a Lot in excel and I am aware of many short cuts and tricks but you are really amazing ! Thanks for enriching the life of poor souls ! My compliments and prayers for you ! Thanks a ton ! I must have watched many videos of yours by this time and look forward for all new uploads.
Hi Chandoo! this video is gold! I have 2 questions: 1.- is there a way to get the into the Gantt "in progress" tasks and 2.- how can we red flag delayed tasks?
Anna.. Baahu and Bhalla made me chuckle .. too much creativity boss!! You can even create an analysis to find why did katappa kill baahubali!! Lol.. Jokes apart. I love the way you deliver your lectures. More power to you, keep going!!
Chandoo great tips. Thanks for sharing your knowledge. I am looking for a way to stay organized in my day today things to do lists. Any tips on where and how to manage “ things to do” tasks while on a job. I use pen and paper becoz I can be flexible the way I want yo use it. Being an IT consultant I sometimes draw a process a flow diagram to capture my thoughts in things to do list and so on. Any suggestions is welcome. Thanks Chandoo.
Thanks Ari... I use notebooks and have built a collection of them over years as I am _kinda_ old school. But for more intense projects, I use One Note and add events to my calendar. These days, for my UA-cam videos, I have been making a list of *things to do* on my paper notebook and check them off as I progress. Hope that helps.
You are welcome. Instead of =previous date + 1, try this pattern first cell after start.date = previous date + 0.25 next cell = previous date + 0.75 now repeat this.
Hey i love watching your videos and i learned a lot but i have a question. i started trying to leave more about because of my work where i have to crunch data (i'm not good at it) that has been exported from Service Now and i try to use your examples to do this but sometimes i get lost. Can you make a video based on Service Now?
Hi Chandoo, can you add 2 things in the gantt chart as per project requriement. 1. Plan dates & Actual dates 2. Critical pathes of the process. Please advice
Thanks Nischal for the comments. Adding Plan vs. Actual view is straight forward. You can do it as a challenge. Adding Critical path is tricky with Excel formulas alone. I suggest not using Excel for performing CPM / PERT analysis.
Hi, can you also include planned start and end dates along with Actual start and end dates. Also if the Gantt chart can show the highlights of the dates or the lag that is caused.
Hi there Chandoo🌈🌞, I really learned a lot from you videos, and is currently following your Project Management Dashboard Excel Demo. I tried applying IF Formulae to get rid of those Blank Date after the slicer applied, it was not working. I wonder if you could teach me how to do that (About those 0 value in your video shown at 10:40 clips). Thank you very much!🌈🌞
This is an awesome tutorial. Although, when the start and end dates on the 'people and data' page are empty (before starting a project for me), the pivot table removes the min/max columns. Is there any way I can keep these here even when the date fields are empty on the other table. Thanks!
👉 *Read this If you have trouble with MIN & MAX dates* in Pivot tables: This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
Hi Sanjeev... please refer to the article here for a detailed tutorial of the dashboard. It has extra links on the individual bits too. chandoo.org/wp/interactive-project-dashboard-with-excel/ Happy learning.
Great share ! thx much ! How would you insert a ◄ at the start and ► at the end of the gannt bar. I can do it comparing the activity start date to the date on top of that col ; ie activity start date = the col date then col = ◄, and similarly for the end of the bar. But since the bar is made of format control it doesnt fit in. The entire bar also has to be made up of shapes like ▇ ; any thoughts ?
Chandoo, Thank you for this video! is it possible to have 3 different teams (in my case architects, engineers and construction teams) then create projects or jobs for those teams as well as a actual team members for each job?
Hi Alex.. you can tweak this file to make such project plans. Alternatively, you can create a base version with all team & people data and then split to three files (and may be use Power Query to bring relevant data to each file) and use that to make the dashboards.
With Excel 365, you can place the file on onedrive or teams folders and others can update it. As the focus here is on one project, it would be tricky to add multiple in this format. See my other article for a project portfolio dashboard - chandoo.org/wp/design-project-portfolio-dashboard/
hello chandoo thanks for the videos and your website is filled with great lessons currently I''m working on excel form for daily production. which is for my manufacturing plant. and i learnt lot from you ... thank you once again . PEACE
Thank you for the great video! Can you have in the same progress bar in the Gantt Chart view, but with different color, the Actual Start and Actual End dates of the project?
Hi Chandoo, I'm awesome at excel because of your channel. Why at 7:57 you used Xlookup to fetch the data instead of including them in the initial Pivot table? Thanks
Thanks Abdulaziz. You can do either. I used XLOOKUP as we may want o fetch few more details from the data and adding everything to Pivots can be a pain.
@@chandoo_ it seems as you said that adding everything to a pivot is a paint ..I’ve added all of the Gantt Chart headings into the “rows” field of the pivot . For some reason the slicer is not working !
This is amazing Chandoo!!! I just have a question. I have my Gantt Chart arranged in mmm-yy format, instead of your format. How do I highlight the current month column?
@@chandoo_ Thanks so much Chandoo!! It worked :) but I didn't start my formula like how you showed in the video with =(date cell)= .... it wasnt working when i did that... it worked only when i started the formula with =AND(........) .... I hope that wont cause any issues...
Hi, Can you please help to provide one formula to calculate Interest on Balance but based on different Slab. Since INT is daily, so Amount has to be divided by 360 at end. My formula is working fine on positive balance but not on negative balances. Thanks in advance!
hi sir am working as event manager in private company ... here we are doing multiple event in a month with same vendors how to maintain vendors list payment and due list with help of dashboard for all event ... could you pls give me solutions for this problems..
Hie Sir, do you have any real time example that how project scope and project planning for any project actually look like??? If you have , it will help me for my further studies and preparations
Hi Chandoo, I really appreciate the effort you put in, i downloaded your blank file and when i summarize by MIN it does not allow me to do it because startdate and enddate is not date data type, i tried to reformat the data to date type in activity table, but it does not work, hope you can help with this, Thank you !
Hi Minh... You are welcome :) This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result. Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date]) Do the same for max, but use the DAX formula =LASTDATE()
@chandoo Hi Sir, Hope you are doing great! I want to make my career in data management. Pls suggest which excel reports should I need to prepare for interview. Kindly guide 🙏
Thanks Rameshwar. All good here and hope you are doing well. I suggest brushing up on concepts like data preparation with Power Query & connections, basic lookup & summary formulas, business uses of Pivot tables and example reports. Refer to below videos. Power Query - ua-cam.com/video/PiFAa_jjaEI/v-deo.html Top 10 formulas - ua-cam.com/video/Q-XGJbHG8Vo/v-deo.html & ua-cam.com/video/P7w6JeNS_SA/v-deo.html Pivot tables overview - ua-cam.com/video/Kg7aZBtAWd0/v-deo.html Sample dashboards & reports - chandoo.org/wp/excel-dashboards/ All the best.
Hi all... Hope you found the video useful.
Like this comment if you want to see an "ADVANCED" version of this gantt chart with progress indicator, switch between daily / weekly and option to exclude weekends.
LOL... 'This' is the simple version?? (great vid, just very complex to the junior user).
Great vid, Could be possible to add actual progress to that Gant chart?
Lovely Video clip! Sorry for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my m8 after a lifetime of fighting got amazing results with it.
I must have been living under a stone that I didn't notice your youtube channel before. Your tools and tips on the internet have helped me so many times over the last 2 decades. You are brilliant!
Thank you Mo. So good to have you here too.
You've been my go to right form 2011 but I used your website alone not your videos.
This is fantastic, thanks!
Features that I'd like to see:
1. Exclude weekends and holidays
2. Effort estimation
3. Fill the activity Gantt chart with planned vs actual progress
4. Move completed activities to history and always view activities in progress and upcoming activities first
5. Select the Week for which you want to view the data ( to view past activities)
You are welcome Gaurav...
You can easily customize the file to add these things.
1. Use workday() instead of +1
2. Effort = duration x hours per day
3. This is something I plan to cover in an advanced video
4. You can use Power Query to remove old & completed activities when they reach pivot table.
5. Add a form control and link it to either start.date or change the formula logic.
All the best.
Wonderful. Years ago I used Excel for Projects because it gave me more flexibility that MS Project and was more accessible for others. This is a more robust PM than the ones I created long ago. Thank you!
Thank you Elizabeth... Excel offers flexibility and creativity that other tools lack.
Hello all... The full series is out now. Watch the next videos here -
Part 2 - Project progress charts - ua-cam.com/video/C0F_VKlTX1c/v-deo.html
Part 3 - Preparing the final dashboard - ua-cam.com/video/Exlj5qH0rhc/v-deo.html
Every time I get stuck, I know you will have great resources to help. You rock!
The Lego mini-figures absolutely made my day! I just found your channel while looking for info about Power BI and I'm already excited to watch more! Keep up that wonderful sense of humor 😁😁
Thanks DB. I love 😍 LEGO and it was adding a bit of that to this video series. Welcome to my channel btw...
Chandoo, trust me you are everybody’s friendly bandhu 🙃
Thanks for making life a lil easy through your informative content.
Hey @Chandoo. I just came for first time on your channel. I subscribed.
This is gold !
Thanks !
Welcome aboard!
Thank you so much. This tutorial made Gantt chart making a piece of cake. Amazed by the procedure, I visited your website which turned out to be a gold mine. Kudos🤩🤩
Thank you Chandrani. Welcome to my channel and site. 😀
Awesome Chandoo! Lots of great tips and tricks in this video. Thanks for sharing :)) Thumbs up!!
My pleasure 😊
You're an "excel"lent teacher. Thanks a ton, Chandoo!
I'm loving your videos, you keep me entertained long enough to learn things!
Thank you so much, Chandoo! This is very useful for me. Downloaded your templates on your website! Thank you so so much!
You are welcome Rainymay...
Thank you and a bear hug, Poorna.
Hugs to you....
Thank you that in the current lock down I happen to visit one of your videos and could connect with you in this life of mine ..... I do work a Lot in excel and I am aware of many short cuts and tricks but you are really amazing ! Thanks for enriching the life of poor souls ! My compliments and prayers for you ! Thanks a ton ! I must have watched many videos of yours by this time and look forward for all new uploads.
Thank you Dharmendra for your love and appreciation. Stay safe.
This is awesome work, Chandoo. Now I am thinking on how to use PTs from another sheet to do calculations at the next level
Thank you.. Go for it!
Hi Chandoo! this video is gold! I have 2 questions:
1.- is there a way to get the into the Gantt "in progress" tasks and
2.- how can we red flag delayed tasks?
What a trick sir, never thought about using color filter like that.
Glad you liked it
Hi sir I am using Excel 2013 and I am not able to Right click on the table name in pivot table field list , so what should i do now ??
Sir this is simply insane. I'll surely use it to track my own work performance 😀😍😍 blessed that I came to know about you❤❤❤❤
Thanks Raghavendra.
Chandoo bhai ko mein 10 years sey track kar raha hoon. From his website
Yes mate, a Chandoo a legend
@@arindamdutta9371 Thanks Arindam for all your love and support :)
Awesome video as always Chandoo, this will help be massively. Thanks.
Excellent tutorial and thanks for the freebies!!!
A great video Chandoo. Thinking of marketing campaign tracking I would add a days remaining column, highlight weekend and public holidays.
Hi Chandoo , thanks bro , I came here when I saw your smile on the thumbnail ) ...
So nice of you
Anna.. Baahu and Bhalla made me chuckle .. too much creativity boss!! You can even create an analysis to find why did katappa kill baahubali!! Lol..
Jokes apart.
I love the way you deliver your lectures. More power to you, keep going!!
Liked the episode. Humor is good.. Concept and teaching is amazing.
Thanks Priti. :)
Chandoo great tips. Thanks for sharing your knowledge. I am looking for a way to stay organized in my day today things to do lists. Any tips on where and how to manage “ things to do” tasks while on a job. I use pen and paper becoz I can be flexible the way I want yo use it. Being an IT consultant I sometimes draw a process a flow diagram to capture my thoughts in things to do list and so on. Any suggestions is welcome. Thanks Chandoo.
Thanks Ari... I use notebooks and have built a collection of them over years as I am _kinda_ old school. But for more intense projects, I use One Note and add events to my calendar. These days, for my UA-cam videos, I have been making a list of *things to do* on my paper notebook and check them off as I progress. Hope that helps.
love this.. very clear explanation
Glad you think so!
This is great. Will definitely use this in future.
Thanks Purna!!!!!!!
Thank you Pektus...
Chandoo the man! Our very own Wiz ✌️
Thank you ...
Your pronunciation of 'Gantt' and referencing it to Wendy... got me rolling on floor.... overall I enjoyed the tutorial...
This is awesome! How would I break up the dates into AM and PM sections?
You are welcome.
Instead of =previous date + 1, try this pattern
first cell after start.date = previous date + 0.25
next cell = previous date + 0.75
now repeat this.
@@chandoo_ Thanks!!
Hey i love watching your videos and i learned a lot but i have a question. i started trying to leave more about because of my work where i have to crunch data (i'm not good at it) that has been exported from Service Now and i try to use your examples to do this but sometimes i get lost. Can you make a video based on Service Now?
Excellant explanation. Thanks a lot sir.
i like this video, you can add the display week by using scroll bar option , it will easy to display by weekly progress.
Thanks Ramasubbu... Yes, this can be easily enhanced with many other features.
Sir very informative. Can you help me link to download. Also can we show target vs Actual in Gantt chart ?
I learned to apply multiple conditional formatting on single cell in which order matters.
Do your templates provide monitoring for key stages and dependencies?
Thanks.. pls make video on inventory management dashboard
Hi Chandoo, can you add 2 things in the gantt chart as per project requriement.
1. Plan dates & Actual dates
2. Critical pathes of the process.
Please advice
Thanks Nischal for the comments. Adding Plan vs. Actual view is straight forward. You can do it as a challenge.
Adding Critical path is tricky with Excel formulas alone. I suggest not using Excel for performing CPM / PERT analysis.
Wholesome and informative
This is awesome my friend !! Liked, commented :) and subscribed!! Cheers
Thanks Chandra and welcome to Chandoo community.
Awesome video, great work. You make it look so easy 😃
Excellent one quick and superb fast. Thank you Chandru ❤️
Thanks Kannan
This is so good to learn, straight subs to your channel. Thanks a lot for that simple explaination.
Thanks brother...:)
Thank you much Chandoo , great video as always. Looking forward for your 2nd part of this video 👍🏼⭐️⭐️⭐️🙏⭐️👍🏼
Won't be long Rekha...
Hi, can you also include planned start and end dates along with Actual start and end dates. Also if the Gantt chart can show the highlights of the dates or the lag that is caused.
Thanks for the suggestions. I will consider these features when making v2.0 of the gantt chart.
Hi there Chandoo🌈🌞, I really learned a lot from you videos, and is currently following your Project Management Dashboard Excel Demo. I tried applying IF Formulae to get rid of those Blank Date after the slicer applied, it was not working. I wonder if you could teach me how to do that (About those 0 value in your video shown at 10:40 clips). Thank you very much!🌈🌞
Awesome. Can't wait for part 2.
Thanks Vincent... won't be long.
You are amazing
Thanks for the love and super Matoell 😍
This is an awesome tutorial. Although, when the start and end dates on the 'people and data' page are empty (before starting a project for me), the pivot table removes the min/max columns. Is there any way I can keep these here even when the date fields are empty on the other table. Thanks!
Thank you very much. I will share it in my circle.
Thanks for the share.
What is the benefit in relationship, I do not see that we have used here, am I right? please advice
Bhai, You are awesome!
Thank you Salahuddin... 😊
Awesome stuff ...can't wait for your ADVANCED deck :)
👉 *Read this If you have trouble with MIN & MAX dates* in Pivot tables:
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
Thanks Sir really it will helpful to all of us👍
You are welcome Taizoon.
Nice but very fast. Thankyou brother
You are welcome Sam.. may be you are on a 1.5 speed setting? Adjust the speed or pause the video at various points to take notes.
Fabulous! Thank you!
Hi chandoo, awesome video but please explain formulas which you use like xlookup and relationship bcoz I am not able to use this in Excel please...
Hi Sanjeev... please refer to the article here for a detailed tutorial of the dashboard. It has extra links on the individual bits too.
chandoo.org/wp/interactive-project-dashboard-with-excel/
Happy learning.
Great share ! thx much ! How would you insert a ◄ at the start and ► at the end of the gannt bar. I can do it comparing the activity start date to the date on top of that col ; ie activity start date = the col date then col = ◄, and similarly for the end of the bar. But since the bar is made of format control it doesnt fit in. The entire bar also has to be made up of shapes like ▇ ; any thoughts ?
I'll have watch from your first video to understand this rocket science
You won't regret the journey. Awesomeness to you.
@@chandoo_ sure
will go through all relevant latest videos as u’ve been doing this for a really long time
Great content…
Satisfying…
Really appreciate
Great and simple, thanks alot
Glad you liked it!
Chandoo, Thank you for this video! is it possible to have 3 different teams (in my case architects, engineers and construction teams) then create projects or jobs for those teams as well as a actual team members for each job?
Hi Alex.. you can tweak this file to make such project plans. Alternatively, you can create a base version with all team & people data and then split to three files (and may be use Power Query to bring relevant data to each file) and use that to make the dashboards.
Спасибо, очень полезно.
Thank you man for this great work.
You are welcome Ben
Amazing, I’m definitely gonna use this bro
Thank you & Let me know how it goes...
If i Arrange 3rd row in week format, how can i highlight current week similar to what you have used =J$3=TODAY()
Hi, I am having trouble with the AND function - it is not returning an TRUE values. - Mr. B
WOOOOW!! Brilliant!! Thank you
You are welcome Laura...
Amazing... a lot of tips ! thanks!
Thank you.
Awesome !!!!
😊
Amazing
How we can accommodate multiple project in same file or one file?? Also how multiple stakeholders can update their progress??
With Excel 365, you can place the file on onedrive or teams folders and others can update it. As the focus here is on one project, it would be tricky to add multiple in this format. See my other article for a project portfolio dashboard - chandoo.org/wp/design-project-portfolio-dashboard/
@@chandoo_ is it possible for your to shared actual locked excel template of PM dashboard
On changing the date to min or max in pivot table it is showing error i.e. Cannot apply formula on text. Why and how to solve it?
Please make this in power BI too ...
hello chandoo thanks for the videos and your website is filled with great lessons currently I''m working on excel form for daily production. which is for my manufacturing plant. and i learnt lot from you ... thank you once again . PEACE
I cannot get the relationships to work if the cells are blank and also it says there are duplicate values
Except "Gantt chart" everything else sounded serious ;)
cheers
Thanks Ajay :) I like peppering my videos with a dad jokes 😅
@@chandoo_ You are really an adorable person. Totally original.
You are awesome
plz make a video about Mis Report
Good work
Thank you...
Thank you for the great video! Can you have in the same progress bar in the Gantt Chart view, but with different color, the Actual Start and Actual End dates of the project?
You are welcome. I am hoping to make v2.0 of this template with some additional features. It would be released in future. Stay tuned.
Many thanks Chandoo
You are welcome Mehran
Hi Chandoo, I'm awesome at excel because of your channel. Why at 7:57 you used Xlookup to fetch the data instead of including them in the initial Pivot table? Thanks
Thanks Abdulaziz. You can do either. I used XLOOKUP as we may want o fetch few more details from the data and adding everything to Pivots can be a pain.
@@chandoo_ it seems as you said that adding everything to a pivot is a paint ..I’ve added all of the Gantt Chart headings into the “rows” field of the pivot . For some reason the slicer is not working !
wow you are amazing explain
Thank you! 😃
This is amazing Chandoo!!! I just have a question. I have my Gantt Chart arranged in mmm-yy format, instead of your format. How do I highlight the current month column?
Thanks KLrishnan... Instead of =TODAY(), check for =AND(MONTH(date cell) = MONTH(TODAY()), YEAR(date cell) = YEAR(TODAY()))
@@chandoo_ Thanks so much Chandoo!! It worked :) but I didn't start my formula like how you showed in the video with =(date cell)= .... it wasnt working when i did that... it worked only when i started the formula with =AND(........) .... I hope that wont cause any issues...
Hi,
Can you please help to provide one formula to calculate Interest on Balance but based on different Slab.
Since INT is daily, so Amount has to be divided by 360 at end.
My formula is working fine on positive balance but not on negative balances.
Thanks in advance!
hi sir am working as event manager in private company ... here we are doing multiple event in a month with same vendors how to maintain vendors list payment and due list with help of dashboard for all event ... could you pls give me solutions for this problems..
Hie Sir, do you have any real time example that how project scope and project planning for any project actually look like??? If you have , it will help me for my further studies and preparations
Unfortunately no Karan... I am not actively working in Project Management space anymore. I will share my thoughts next time I plan a big project.
Dumb question. We cant change the people? Love Batman - but where and how does this get done? Thanks Great sheet
Hi Matthew... You can do this by updating the people table and changing the task ownership in the activities table.
@@chandoo_ Many thanks - saved the day
Super, Chandoo
Thank you Venkat.
Hi Chandoo, I really appreciate the effort you put in, i downloaded your blank file and when i summarize by MIN it does not allow me to do it because startdate and enddate is not date data type, i tried to reformat the data to date type in activity table, but it does not work, hope you can help with this, Thank you !
Hi Minh... You are welcome :)
This seems to a problem with Excel 2016. You can use Power Pivot measures to get the same result.
Right click on the table name in pivot table field list and select "add measure" option. Then name the measure as "start of activity" or something and use the =firstdate(activity[start date])
Do the same for max, but use the DAX formula =LASTDATE()
@@chandoo_ Thank you, very clear instruction and easy to follow💯💯
Pls explain Composite index
💥💯 BoOM
@chandoo
Hi Sir, Hope you are doing great!
I want to make my career in data management. Pls suggest which excel reports should I need to prepare for interview.
Kindly guide 🙏
Thanks Rameshwar. All good here and hope you are doing well.
I suggest brushing up on concepts like data preparation with Power Query & connections, basic lookup & summary formulas, business uses of Pivot tables and example reports. Refer to below videos.
Power Query - ua-cam.com/video/PiFAa_jjaEI/v-deo.html
Top 10 formulas - ua-cam.com/video/Q-XGJbHG8Vo/v-deo.html & ua-cam.com/video/P7w6JeNS_SA/v-deo.html
Pivot tables overview - ua-cam.com/video/Kg7aZBtAWd0/v-deo.html
Sample dashboards & reports - chandoo.org/wp/excel-dashboards/
All the best.
Amazing, as usual!
Thank you Margarett.
How can you do this on Excel for Mac since there is no relationship function available?