Welcome to the Excel Wizard in Minutes Channel! With 250+ videos, you will learn all the tricks to master excel from shortcuts to formulas passing by painful formatting...If you are more advanced, you can even learn about pivots, charts, power query and how to develop macros to automate your dashboards.
The catch is that all videos are short and straight to the point! No time wasted!
If you are: - Totally new to excel - Advanced in excel but want to deepen your knowledge - Short on time
I think this will help: www.skillademia.com/blog/pivot-table-slicer/#:~:text=However%2C%20if%20the%20%E2%80%9CReport%20Connections,the%20%E2%80%9CData%E2%80%9D%20group%20tools
Am not sure i understood what you mean. You can set the values of the y axis from the chart options. Feel free to look at the basic videos in my chart playlist
Hello, thank you for this helpful video , is it possible to change the adress that is listed in the Excel that you provide ? because i have tried to change it but the formula only works on the adress you gave and not mine and if it's possible can you please tell me how i am trying to modify it so it can give me the distance between adress ( street postal code city)
Hello, yes of course. You have to look at the comments before yours. Some ppl had issues and i listed all the possible options (such as not having a working key) i know about.
@@EXCELWIZARDINMINUTES Thank you for your time , the Problem i am facing is not listed in the commets before because i do have a working API key but when i use the formula to calculate the distance with the adress that i enter (form : street postal code city) it's always the #VALUE error
That s so nice of you! Please spread the word to colleagues and friends 😇 i m tryin to help as many ppl as possible with excel. I know excel can be such a headache!
U have to follow the methods in the video. I suggest u try it on dummy data (like 20 - 30 lines of data) to get the hang of it before u do it on the full dataset
Hello, thank you for making this video. I have been trying to use the excel that you have created, but the distance produced is an integer. For example, the real distance is 5.3 km but what appears in excel is 5 km. Or 4.4 km becomes 4 km. Could you help me with this?
You will have to go to the code. There is a formula that returns the distance with round. There u might have to do modifications. (Search for round in the the vba code)
Thanks for creating this video - it's very helpful. I've downloaded it and added some local Australian addresses but Bing is replying with US lat and long giving low results. Can you tell me how I can debug this issue?
U might have to be more specific with addresses (it s probably not catching the names), or u get ur lat long on google maps and use them in the distance and time matrix. Try one address on google maps (not excel) and see what it gives for lat long. That might tell you why it s not catching it properly and you can correct accordingly coz the api works like google maps.
Hi, Thank you for the really helpful turtorial but i am really wondering if i need the data to be in meter and not rounded will it be possible? Thank you so much!
You can convert between unit of measures easily. For the rest you might need to check the API documentation and potentially make modifications to the code
i just remembered, there is a line of code in VBA: GetDistance = Round(Round(WorksheetFunction.FilterXML(objHTTP.responseText, "//TravelDistance"), 3) * 1.609, 0) This is where you can play with round and the meters (1.609).
@@verrelnathaniel2741 Somebody asked me about this long time back in the comments. honestly, i ve never done it. here is what you can do. in the VBA code, there is a http request (ie some line with http) that calls the API. Have a look at the API documentation, I am sure they will tell you where you have to change this to get cycling, walking, etc...
Hi i tried this but for me I'm not getting it why... Please can you help me with mail id that i can share dummy data and please you can help me... Thanks in advance
I suggest you download the file: mega.nz/file/TCw2WKRJ#Mz7K0AgU0i6enV1Ozvr5vCc-MLGOT6vupVuAo4RfnaY Try to follow the instructions step by step and i m sure u will ace it! :)
@@EXCELWIZARDINMINUTES This Yes i am getting it when I have only 1 row of category data as you have in your data, but my requirement is I am having for Examples: Group 1 -- Major cat 1 & Major Cat 2 & Major cat 3 Group 2 - Major cat 1 & Major Cat 2 & Major Cat 3 Group 3 - Major cat 1 & Major Cat 2 & Major Cat 3 As I have 3 rows after each group it's not giving this output, but when I have only 1 row like your dataset I am getting this result. Please help me how to do if I have 3 or more rows for each group. Thanks in advance
U only have 2 axis to do the work. In ur case, u might try to make several charts and make them one on top of the other one (removing border colot and chart area color)