Thank you Alex for the knowledge you are imparting to us. I can listen to you forever. We appreciate you. I used this formula formula to create the age bracket which was much simpler so anyone interested should try it; =IF(L2
@tedf Жыл бұрын
IFS is the way to go here. For the purposes of the video, its great to show the nested IF statement, but IFS can be a simpler solution.
@Celeste-.-marie9 ай бұрын
Great tips! I chose to use the terms Senior, Middle Age, Young Adult, and adjusted the age brackets so they were more even to Senior 55+, Middle Age 35-54, Young Adult 18-34. I sorted the age column from smallest to largest and noticed there's nobody younger than 25, so I left out "adolescent." The fact that there are no bike purchases between the ages of 18-25 is interesting.
@moizzuddinrizwan44349 ай бұрын
Thank you for this! The IFS() statement is much nicer to look at. Since the formula tends to be on just one line, the nested IF() can be hard to look at but the IFS() is far less cluttered
@bodhihungerford70843 ай бұрын
I was gearing up to write this exact statement 😂
@faithayubakwarkas44712 ай бұрын
Thank you so much. This was really helpful
@Aakanksha19 Жыл бұрын
I just completed the entire excel series. It was the first time ever that I created an entire dashboard myself. I feel really good. And as a beginner in the field, the basic steps to learn about cleaning the data and why that step in the cleaning process is being performed played an important role in understanding its importance. Thanks, Alex!
@devanshgoyal3188 Жыл бұрын
can you please upload the excel files
@mujtabakhan4521 Жыл бұрын
are you from IT background?
@vishalshambhu8558 Жыл бұрын
@@devanshgoyal3188 did you get excel files?
@olawalejohnson8011 Жыл бұрын
Pls kindly upload the excel files
@nurudeenalhassan2797 Жыл бұрын
hello, can you kindly point me to where I can download the dataset used in the video, I have tried downloading the file from the link he provided but it's not working
@kazeemibrahim7673 Жыл бұрын
Your video just taught me how to make my first dashboard. It's amazing how you show the world that everybody is a learner and nobody is just perfect. That is humility in it's purest form. THANK YOU SIR.
@PhiGonz Жыл бұрын
Something very cool to know when your making dashboards is that if you press "Alt" while your dragging your charts/slicers/bottons/whatever they will align automatically. This helps a lot to make a cleaner dashboard
@oladiipooluwajomilojuibuku7759 Жыл бұрын
Good evening please how did you get the link to download the excel data used for creating the dashboard?
@NgocNguyen-oj4tv Жыл бұрын
@@oladiipooluwajomilojuibuku7759 The excel file is in the description
@VitthalGaneshPagrut Жыл бұрын
@@NgocNguyen-oj4tv but how to download I can't download from there
@oluwabusuyi3896 Жыл бұрын
@@VitthalGaneshPagrut Click on "view raw" or "download"
@vitaliksew Жыл бұрын
The best advice, thank you!
@agarwalvishal002 жыл бұрын
Thank you for the project. I have been looking for such videos lately. Marriedarrtial Singlestatus sounds like a Harry Potter spell.
@AlexTheAnalyst2 жыл бұрын
😂
@TinomShokfaibambina2 жыл бұрын
😂
@lindadelalisey5408 Жыл бұрын
😂
@onomemafuru9496 Жыл бұрын
I unknowingly casted the spell too .
@atvnbi2 жыл бұрын
I like how Alex run into problems and walk you through how to solve them. Just as it's done in real life.
@polokomonama6526 Жыл бұрын
I just completed the excel series in less than 24hrs leisurely! I have to say as someone who was intimidated by excel for some time, you have not only managed to help me understand it, but somehow made it enjoyable. For anyone who sees this I suggest you go through the entire excel series, believe me it is worth it! Thank you so much Alex for your time and effort!
@santhoshram1724 Жыл бұрын
I am unable to download the project dataset any solution pls
@obinnanwaneri82082 жыл бұрын
Man, your channel is beyond amazing. Thank you for all you're doing for the community. It's really priceless.
@AlexTheAnalyst2 жыл бұрын
Thank you! I appreciate it and I'm glad it helps :)
@xhiah5894 Жыл бұрын
I've been doing all i can to self study comp sci and data analytics so i get my first job and fund school and turn my life in a new direction. I quit my job so i can get real time to invest in these aspirations. I'll have a job before October. Thank you for doing all this, education should be free for all and i wish great blessing to you and your family thank you so much for giving to so many what the system refuses to make readily available. When i get the job i will be back here again. A great day to you Alex :)
@HeavenlyCritico7 ай бұрын
did you get a job?
@jameskorankye60966 ай бұрын
@@HeavenlyCriticotoo early I think.
@elnosh60725 ай бұрын
Where can i get jobs in this field, i would wish to earn from this skill.
@benandrew85962 жыл бұрын
Thanks, Alex, for putting all of this content out there; it really helps in improving my skills as an entry-level data analyst. I was able to move the 10+ miles to the bottom without having to edit it to "more than 10 miles" by right-clicking on it and using the move option.
@miracleabhulimen810 Жыл бұрын
Thank you!
@Judy_VicАй бұрын
Thank you
@TasosKaraiskosVEVO24 күн бұрын
for some reason, for me, replacing "10+ Miles" with "10 Miles+" worked and it went to the bottom (Microsoft Excel 2013)
@brandondiaz-lopez39452 жыл бұрын
Alex this is great! I was an active duty Air Force Analyst for 7 years (currently in the reserves now), and i have to say that this is spot on. This is basically how we built our reports and then used PowerPoint to present them. Thank you for all these amazing tutorials !
@PaulasPicks2 жыл бұрын
Thank you for your service, Brandon!
@AlexTheAnalyst2 жыл бұрын
So awesome! Thank you for your service :)
@handrianoperwira26262 жыл бұрын
how did you use PowerPoint to present the dashboard?
@AkramEl-Araby-wb6pt Жыл бұрын
I just finished the whole Excel Tutorials for Data Analyists playlist, and it's absolutely fantastic! Really helpful and added a lot to me. Thanks Alex for the simple yet awesome way of delivering the message!
@customerexperiencewithjose50968 ай бұрын
Please, how do I get the complete video of the data analyst playlist?
@Cappurnikus2 жыл бұрын
Great video! Certainly helpful for beginners. This may be role specific but for me, over 90% of my projects need to be repeated by myself or a user. A very small number are adhoc so I end up automating most of my reporting. It may be helpful to your viewers to make another video where you automate this same report for future data pulls. Power Query/VBA/SQL/Python are generally my tool of choice, depending on the needs of the project. One more note on why I think it's important to automate (for any beginners that may be reading). If you spend all day refreshing reports using a manual process, you'll have no time to develop new solutions for the business. One more note for beginners. Alex knows his stuff and is a good resource. His experiences are very similar to mine, just with a different beginning. I find myself often just nodding along.
@AljIsHere1282 жыл бұрын
I haven't gotten to this full project yet but I THANK U for your insight!
@NathanEckelTV2 жыл бұрын
Big upvote for you (if you haven't already) to add an automation video per @Cappernikus suggestion @Alex.
@AljIsHere1282 жыл бұрын
I agree about automating the reporting. Especially if you have continuous updates.
@sundayamoo84 Жыл бұрын
Hi, thanks for the resources been shared out. Pls as a new beginner in data analyst, must we know all the software for data analysis or we should base on a particular one, Pls replying to this will be helpful. Thanks.
@Nrsouth12 Жыл бұрын
Hey how do you automate a report? Ima recently hired data analyst that would be very helpful for me at my job
@abdelrahmanalqali59317 ай бұрын
I actually recommended your data analyst bootcamp playlist to one of the doctors in my university. This course is a godsend to anyone who can't afford to pay for paid courses or formal education.
@dilipkrishna5559Ай бұрын
is that free?
@abdelrahmanalqali5931Ай бұрын
@@dilipkrishna5559 you can find the data analyst bootcamp playlist on his channel
@ruthyagatha2 жыл бұрын
Thank you so much Alex. As a nurse trying to get my foot into data analysis i have found your channel so helpful. Thank you for the time you pour into creating for us such exceptional content for free. Much love from Uganda 🇺🇬
@AljIsHere1282 жыл бұрын
Sister God Bless U for being a nurse ok. I know it isn't easy at all and I can empathize transitioning into a different field. But Thank U for your works and best wishes sister in doing data analysis work.
@ruthyagatha2 жыл бұрын
@@AljIsHere128 yes its no easy task but i'm putting in the work and I'm progressing and once i grasp the data analysis concepts i will merge it with my medical knowledge. Thank you so much for reaching out and God bless you too
@AlexTheAnalyst2 жыл бұрын
You’re most welcome! Glad to help :)
@NathanEckelTV2 жыл бұрын
Plenty of health domain-specific information for you @Ruthy - you can utilize both skillsets for much higher impact because of it. I had the privilege of doing some off-grid medical missions next door in Tanzania not far from Uganda and am very hopeful for health improvements in your corner of the world. You might also find Omdena to be an excellent place to apply data skills for global good - or to eventually partner with them.
@danieseadams16422 жыл бұрын
Hey Alex. This was an amazing tutorial. For the 10 + Miles portion you could have just dragged the column down to the bottom vs renaming. You have to click on the cell right near the bottom border and the cross sign will turn into an arrowed cross sign. When you see the arrowed cross sign just drag it to where you want it and it will bring the corresponding cells to where ever you choose to move it.
@taoridirafiu82892 жыл бұрын
By dragging column here, I think you meant row. I did that too initially but realised the it will go back to it's original position every time you refresh the data. So it's better to correct it from the data source
@shivashankarirajaram4231 Жыл бұрын
@@taoridirafiu8289 I tried refreshing the data after pulling that row down and it's completely fine. It doesn't go back to its original place and so I think this works!
@BlooDh3xx Жыл бұрын
Another option is to add a blank space between 10 and +. It worked in my pivot table / chart.
@sj17959 ай бұрын
Loved the parts when you say, "Let's think about this", "Nevermind. Guys, that was a terrible idea", and "Excel is trying to destroy my whole video." lol These types of issues shown in real-time where you then walk us through how to solve the problems is why your content stands out above all the rest. As always, THANK YOU ALEX!!
@Thechanterramarie9 күн бұрын
For the commute distance pivot table, all you have to do is select the 10+ Miles cell, hover towards the corner til the see the 4-point arrow cursor, then hold shift and drag the cell down to the bottom of the pivot table where you want it
@Thechanterramarie9 күн бұрын
And for renaming the age brackets for the chart, just rename them on the pivot table. It won't break anything.
@joneluwilaine32972 жыл бұрын
I am an aspiring data analyst and your videos are a great help for beginners like me. Your videos are very informative and easy to grasp. I am learning a lot. Thank you
@Applefanboy2012 Жыл бұрын
Hey. How is it going?
@lifewithwambuimuthaka Жыл бұрын
How is the going...I am starting now😅
@moseslugalia02 Жыл бұрын
@@lifewithwambuimuthaka hows the going am starting now
@lifewithwambuimuthaka Жыл бұрын
@moseslugalia4690 with excel now I can say I am an expert...
@rowanlavellan975520 күн бұрын
Thank you so much, Alex! I'm still working through the SQL series, but I have decades of experience in Excel and figured I'd give these videos a watch before starting on the Intermediate SQL...I've now got 2 Excel portfolio projects. :)
@wearevenom36452 жыл бұрын
You are a mind reader.. this channel is a blessing to all of mankind. ❤️
@viktoriaballa462211 ай бұрын
I'm on my 6th day of my official Data Analyst journey and I love to experience that even if I have advanced skills in Excel, I can still learn new things from your tutorials. I really liked this project and I can't wait to continue with your Tableau tutorials tomorrow ❤❤❤
@Gian-oz7hs4 ай бұрын
These tutorials really help me a lot, man. I can't thank you enough, but I kind of wish you would specify a bit more what exactly we are looking for from this data (which you did at 19:24), preferably in the form of a question, because that's what we're going to put in the project description. I feel like it will immediately spark my newbie brain into thinking like an analyst.
@vikramvarun-q5h Жыл бұрын
Thank you so much Alex I created a dashboard in Excel by following your Excel series and as a beginner in this field I feel proud.
@rociob7022 жыл бұрын
Thank you for being such an easy going teacher I finally got to this wonderful video. I have a Mac and one thing I figured out is that Excel isn't as user friendly than what it would be if I was to use a Microsoft computer lol go figure. Anyway, Ctrl+A was not working for me but I found out that Ctrl+Shift+v+> works just as well to select all data. I learned a lot from your teachings thank you Alex!
@sherifabdelhameed1613Ай бұрын
Hi Alex, thank you for the educational content. I am following the boot camp and it's a very good refresher with reminders and additions to my knowledge on the different software. In this example, I would suggest using a stacked column for the number of buying customers per commute - stakeholders can see the "Yes" and "No" as a percentage of total, and have an intuitive idea of their wider client base, and who they should focus retention or new offers to.
@shivsharma91532 жыл бұрын
Continue these amazing videos...you are a one-stop-shop for all the data analytics related content...thanks for your efforts
@victorbegnini575411 ай бұрын
Alex, no words to express my gratitute for all your time, effort, patience! You're helping lots of people - myself included! Wish nothing but all the best, multiplied by 100. God bless, man.
@lorraineantonie377511 ай бұрын
Your words @victorbegnini5754 exactly! Thank you Alex!
@victorbegnini575411 ай бұрын
@@lorraineantonie3775 👏🏻😄
@MsDreamzHD2 жыл бұрын
Great video! A tip for rearranging the order at 22:00, and still make it look clean, is to make it " >10 Miles "
@AlexTheAnalyst2 жыл бұрын
Good idea!
@IanKlosowicz2 жыл бұрын
You can also Sort > More Options > Manually sort just FYI!
@felipepereira30612 жыл бұрын
I put "+10 Miles" too great ideia =)
@Judy_VicАй бұрын
@@AlexTheAnalystI tried to clean the commute distance column but unfortunately it's locked so I left just like it was
@loriwostal868428 күн бұрын
Such a great bootcamp, thank you so much for all the work you put into this, it's really appreciate!!! Also, you can drag and drop the rows in your pivot to an position you want by clicking on the row you want to move, move cursor over cell frame until you see the crosshair arrows (not the solid down arrow, you almost have to go outside the line), click and drag wherever you want. You can do this for columns as well. Hope that helps... just a little tid-bit compared to this amazing content. Thank you so much Alex!
@franciscoretuertadiaz21 Жыл бұрын
Excellent, just finished a couple of Excel courses and with this video I been able to put all the learning in one project, thank you so much Alex!
@AlexTheAnalyst Жыл бұрын
That's great! Good work!
@sundayamoo84 Жыл бұрын
Hi, thanks for the resources been shared out. Pls as a new beginner in data analyst, must we know all the software for data analysis or we should base on a particular one, Pls replying to this will be helpful. Thanks.
@adedijiwasiu7059 Жыл бұрын
For the first-time, I create dashboard of my own. Thank you for all the knowledge you pass willingly to your learners.
@nurudeenalhassan2797 Жыл бұрын
please how did you download the dataset? I'm unable to download the file from the link he provided
@aliceemma1352 жыл бұрын
Thank you so much for creating these fascinating tutorial videos! I was just thinking of building a project to showcase my excel skill, and your video just showed up right away! Have been following this channel for a while, and this is the most informative and supportive channel I've ever seen! Thank you so much, Alex!
@guscantwell4180 Жыл бұрын
Alex ruthlessly throwing his Dad under the bus by making sure he's in the old category! Excellent content - much appreciated.
@yaya14every812 жыл бұрын
I like this video a lot. I love the fact it has a clear goal and you know your audience. I also like how you explained why you have a working sheet and why you are looking through the data to see if it makes sense. The fact you are detailed when explaining your thought process made it easier to understand! I had no idea you could Find/Replace by row or column!
@AlexTheAnalyst2 жыл бұрын
So glad to hear it was helpful!
@sunsetwithmee9 ай бұрын
Just completed this excel series. Able to do a whole dashboard myself. Couldnt stop myself from commenting this. Thankyou so much.
@vishwaschaudhary13649 ай бұрын
Can you share the source dataset provided by Alex? I am unable to get it through the link given in the description. Please help me
@sunsetwithmee9 ай бұрын
@@vishwaschaudhary1364 if u have problem with the link in description, give me ur email i will send those files.
@vidhitiwari14789 ай бұрын
Can you send me also? I am having this problem since 2 days
@sundayajagbe14568 ай бұрын
@@sunsetwithmee I need the dataset please
@213yasy5 ай бұрын
Hey! How are you displaying this project on your portfolio? I’m been trying to figure it out since you can’t necessarily upload it onto GitHub..?
@tsmith4907 Жыл бұрын
Awesome video! One edit I would make is in the Alignment section and setting up the Dashboard. You can have the charts snap to each other instead of trying to manually line them up. If you click on a chart, go to Format > Align > Snap to Shape. You can also have it snap to the grid as well.
@bruhbruh4635 Жыл бұрын
like holding alt when moving?
@becRAHULTHAKUR4 ай бұрын
Hey Alex , i just love the way you trying different things to resolve a query and you also shows this in a tutorial so that we can get comfortable with the tutorial
@grecokap78812 жыл бұрын
Thank you Alex. This is what i was looking for. A simple real project. It was so much helpful!
@sundayamoo84 Жыл бұрын
Hi, thanks for the resources been shared out. Pls as a new beginner in data analyst, must we know all the software for data analysis or we should base on a particular one, Pls replying to this will be helpful. Thanks.
@omodolaposikiru9 ай бұрын
This is my first time of learning Excel(data analytic). And I learnt a lot, thank you, thank you so much for sharing your knowledge with us 🙏🏼❤️
@beaut112 жыл бұрын
Hi Alex, 28:44 wasn't a terrible idea lol. The rows weren't ordered by ascending hence the change in chart. I'm definitely adding this to my work. Thank you!
@nanaboateng19833 ай бұрын
Thank you Alex. You deserve a GRAMMY award for all the good work you putting out here
@hamdaniftikhar2 жыл бұрын
So dependable! Thank you for the consistent quality content Alex! :)
@AlexTheAnalyst2 жыл бұрын
I try my best! :D
@Dxgreen2 жыл бұрын
I'm so glad I found you on KZbin. You really have changed my life with the work you do. Thank you!
@AlexTheAnalyst2 жыл бұрын
So awesome to hear! I'm glad you found me too :)
@dubeypushpendra45582 жыл бұрын
Hey Alex, Learnt alot from this video and did the project simultaneously while watching the video. Please do post more videos related to such project from intermediate to advance level. Love from India ❤️
@angelacatherine3752 Жыл бұрын
Thank you so much Alex, following your video step by step made me to create my first dashboard and i am very proud of my self staring at it.
@ghostofjudah56872 жыл бұрын
Thank you so much for this whole series. You helped me refine my basic skills and create my first dashboard. Amazing work man. Please keep it up!
@MissP32242 ай бұрын
Coming back to this channel and playlist during my journey is a breath of fresh air. 😌
@ranitaghosh4177 Жыл бұрын
I don't know how to thank you Alex! For you and your videos , I got my first job today as a Data Analyst. Thank you so much. May God bless you♥️
@prashantsharma2522 Жыл бұрын
in which company? can you give some reference?
@amrutharamesh1097 Жыл бұрын
In which company?
@Ghazanfierce Жыл бұрын
WoW Good luck I hope i too score a good job or long term projects soon.. 💯
@sonakushwaha9641 Жыл бұрын
Can u suggest me where can we practice of excel
@swetachaudhary6826 Жыл бұрын
For data analytics do we have knowledge of VBA and macro
@madisonschneid3066 Жыл бұрын
Thank you so much for the guidance! I will link my final presentation below with a full breakdown of business task (that I made up, lol), a summary of the findings, deliverables and insights, just to show y'all. Before this I had struggled to even upload data into BigQuery, downloaded tons of software, etc. You were so helpful!
@AxelYates2 жыл бұрын
Love the quality of your videos Alex. Thank you so much for everything you do, I know it's not easy.
@victorialatavish4266 Жыл бұрын
Thank you so much! Retired teacher here switching careers - so I'm a little on the 'older' :) side. Your videos are helping me so much! I just finished following along with you on this tutorial. You gave me such a boost of confidence that I can do this! Thank you, again!
@victorola7461 Жыл бұрын
Please how did you get the data he used in this video? he said he's going to provide a link but I can't find the link
@kelvinkhiew1292 жыл бұрын
Hi Alex! BIG SHOUTOUT to you for coming up with all these AMAZING REALISTIC videos. Currently looking for Data Analyst job, and just dropping by your latest video to say THANK YOU!
@followrajah774311 ай бұрын
Thank you very much Alex. Words can't really capture my gratitude - when I land my first DA gig, I'm definitely sending a "thank you donation" your way.
@chukwuebukaikwueze8422 жыл бұрын
Wonderful video! Thank you Alex I've spent most of my time learning formulas and concepts in excel but haven't put together any project yet. This is a great idea for things I can do going forward
@remy07055 ай бұрын
Thank you so much for your information. I got so lost in term of building Excel Projects for my porfolio. You really save my life.
@boluwatifeoyelami57972 жыл бұрын
I needed this. An awesome video. Thank you, Alex.👍👍🔥💯
@sundayamoo84 Жыл бұрын
Hi, thanks for the resources been shared out. Pls as a new beginner in data analyst, must we know all the software for data analysis or we should base on a particular one, Pls replying to this will be helpful. Thanks.
@abdulhafizalmasri18622 жыл бұрын
Thank you Alex for this wonderful video. what's most important is u make us change the way we think about numbers and data
@moulibanerjee47392 жыл бұрын
Thank you so much for all your mentoring, it has been a great help in my transition to my dream job. I just absolutely love your content and way of teaching. I have learnt a lot from you.
@ladislauandre44922 жыл бұрын
One of the best videos i've seen so far. Congratulations Alex, i just don't know how to express how this videos has helped me in my careear.
@mj-fm4bp2 жыл бұрын
Timestamps ✅ 02:03 Setting up and Cleaning Data 14:00 Making Pivot Tables 29:10 Creating a Dashboard 35:20 Adding Filter Buttons 39:34 Outro
@sahanamgowda5125 Жыл бұрын
Why they won't provide how client approach. Or dashboard sample.
@seunogor9970 Жыл бұрын
Thanks Alex for this video, pls how do u structure the data? I tried mine it is bringing out "this formula is missing a range reference or a defined name" pls what is the way forward. really looking forward from hearing from u.
@jayshreekasera380510 ай бұрын
Could you please share me the raw data , I could not download that file from github
@ShahrukhJ Жыл бұрын
Thank you appreciate it - Have watched all your excel videos under the Data Analyst Playlist! You rock!!
@DrDemolition2 жыл бұрын
I recently started Google's DA course on Coursera based on your recommendations and I found this video really helpful! However, I had a few questions while I was watching the video 1. Is there a better way to categorize ages? Nested Ifs will not be ideal if you have more than 3 categories. 2. I don't quite understand the placements for categories in the pivot table, how do I know where to place the categories among rows, columns and values? From what I understand, values is what you want to visualize and rows and columns are interchangeable, is that correct? 3. Charts! Line chart felt really off for bikes purchased vs commute distance because it's supposed to be used with data that changes over time, stock price for example, and I thought that it didn't really provide any good insight. Wouldn't a bar chart or stacked bar chart have been better for the commute distance vs bike purchased? 4. Regarding the chart for age bracket, line chart looks really pretty! but I think histogram might have looked better for the uncategorized ages because I aim for line charts only when it deals with variation over time. Any insights on what charts are 'industry standard' or do we just go with what looks best? 5. I recently learned that dashboards are used to provide real-time data analysis and I fail to see how the dashboard you created achieves that. It felt more of a report than a dashboard. Also ++ Cappurnikus down in the comments for great suggestions.
@aniquekhan564011 ай бұрын
I can't express my gratitute Alex after watching the series i realized in the data world anyone can moved if they have followed the path which you have showned in the series. Thanks a lot May ALLAH Bless you Man..❤
@kamabrapa882 жыл бұрын
I finished the whole project! Thanks so much! It gave me confidence that I can do this!
@BetulSahin-jn2ll3 ай бұрын
Thank you so much Alex for this wonderful tutorial. One thing I want to share is that the reason about the 10+ miles being in the second row probably was because the first numbers were listed to smallest to largest. What could also be done is clicking the cell, bringing the cursor near the bottom border, when it turn into a down arrow right click and drag it.
@AacharyaLaxminarayanRatrey11 ай бұрын
00:00 Learn to create an Excel dashboard with interactive filters 05:08 Cleaned and formatted data for visualization 10:26 Creating pivot tables to build dashboard visualizations. 15:38 Creating a visualization to analyze income and bike purchases 20:27 Creating three pivot tables for bike purchase data 25:42 Create a dashboard to visualize bike purchases by age group. 30:55 Creating a clean dashboard with aligned elements 35:55 Create a dashboard with slicers to filter data by demographics.
@khaledhamadi7720 Жыл бұрын
You're changing lives. Thank you so much, I wish you best.
@ebubeochu567210 ай бұрын
I'm a beginner in becoming a data analyst and I will love to be interacting with a guide. My seniors in the program, I will appreciate to have you guide me through both from knowledge and experience
@aguadline82294 ай бұрын
This is so informative and well explanatory, thank you Alex. Your videos are always so helpful.
@ideas.in.action6 ай бұрын
Thank you so much for the amazing tutorial! I have learned so much with the Portfolio Projects. FYI: You can manually rearrange the rows of the Pivot Table by right-clicking on it, going to the 'Move' option and selecting the place where you want it. Might be helpful :) Keep up the great work! 🙌
@hafsahshazmeen1446 Жыл бұрын
Just completed The project gonna add it to my portfolio THANK YOU SO MUCH ALEX u are helping a lot n if I get a job in Data Analytics its all thanks to u
@prateekcod10 ай бұрын
As a Beginner to Excel, Your playlist has been very helpful
@vikrantalmelkar Жыл бұрын
Thank you very much for this video. I am starting on the Data Analytics journey and this video has helped me a lot. Thank you
@BellaskinRevive Жыл бұрын
I must confess, I love you!! This is one of the most interesting walkthrough projects I've come across. I followed through and I laughed alot. Thank you so much for this. I hope I'll become the data analyst I dream of.
@momohtimothy6898Ай бұрын
Alex my mentor. Thank you so much.
@nickukragan72283 ай бұрын
Thanx a lot! Your videos are the best. The most important thing in your videos is the sequence - it is just so right to understand analytics the best way.
@alan_benedictАй бұрын
We can hold the Alt key while moving things around, to place them exactly on a cell to cell basis. This will help to solve the alignment issues while dealing with multiple charts and slicers etc. Thanks for the content, Alex❤
@rbk_96 Жыл бұрын
Thanks Alex! To be Frank I have done many courses but never did a project once. Thanks for your guidance, this is really helpful !!
@nimrod4463 Жыл бұрын
in 22:20, it helped writing as :"10 Miles +" Like that with space worked for me. Thank you for the tutorial! Really impressive job!
@olodiobuma2738 Жыл бұрын
If you were my teacher in school. I would have understood every course. Thanks Alex 😊
@saragintaperezmosesa7 ай бұрын
I just completed my own dashboard. Thank you Mr.Alex. I learned a lot from your videos 🎉
@emmanuelejiga181110 ай бұрын
Thank you so much Alex for this. For some reason, people can't download the dataset you used. If you can fix it, we would really appreciate. Thanks for all you do.
@jeramiebalabat88427 ай бұрын
I am so ecstatic! I just finished your Excel series and am currently working on the Excel project. I am very thankful for your short but concise teaching videos. Next stop: SQL! :)
@becomehustler1M7 ай бұрын
hey bro good to hear that u done it but i wanna help from u that 7:54 using IF statement not work for me and popup that formula u type contain an error
@Lifeis_cool14 күн бұрын
Learnt so much from you through out this excel project. Thanks Alot Alex ! Cheers !
@okashajabbar3500 Жыл бұрын
And.. this marks the end of my excel tutorial w Alex, and omw to making my own first dashboard. Thank You so much, Alex!
@rakeshbasak68423 ай бұрын
Thanks a ton Alex,,, whatever you are contributing is bless for us ❤️
@timwhooper12 жыл бұрын
Really enjoyed this project! I am a new analyst right here with you in Dallas and this is helping me build my portfolio and moving toward getting hired as an analyst! Thanks!
@victoradeoke72777 ай бұрын
So great, went through the Excel tutorial playlist and learnt some new stuffs.
@munamackenzie4048 ай бұрын
It felt so great achieving the project and having this complete beautiful dashboard! I thought Pivot Tables, Dashboards and other Excel features were hard which made it intimidating for me to learn Excel, but after finishing your tutorials turned out things are actually easy and simple! Thank you Alex for your time and hard work!
@cesarantia5 ай бұрын
Awesome video as usual Alex! Small tip for everyone on min 28:30. You can name it however you guys want an simply dragging the cells to change the order, it is also doable by copying and pastying them. 👍
@nathanchamberlain5356 Жыл бұрын
Absolutely amazing, I knocked out this full series today. I can wait to make my own Excel project.
@mirzoyuldawev3293 Жыл бұрын
one of the fantastic tutorial I ever had
@kwakusarpongmensah-bonsu66006 ай бұрын
I've loved and appreciated every bit of these tutorials, awesome work Alex thank you. A little contribution - for the part where you changed "10+ miles to "More than 10 miles" in order for the pivot table to be sorted in ascending order, an alternative would have been to drag that particular row containing "10+ Miles" to the bottom of the table beneath "5 - 10 Miles". Or right click on the cell containing "10+ Miles" and select "move" and "move to end". Worked for me. Let me know if this works for any of you as well.
@akintimehinmoromoke5 ай бұрын
I love this.. the transition, theme.. love to love it.. Best tutor ever
@ashutoshmohanty385910 ай бұрын
Watching the video and doing side by side is really fun. Enjoyed and learned a lot from this video.
@David-th5nx10 ай бұрын
I followed through the exercises and I am really excited to build my first dashboard. Thank you for all you do.
@jayshreekasera380510 ай бұрын
Could you please share the raw data , I could not download that file from github
@jeremyv12 Жыл бұрын
Just finished up and I'm forever grateful sir!🤓
@JERKINSRICE8 ай бұрын
My good Lord! Sir Alex, I am extremely grateful for the knowledge and good understanding I have received in the course of this so well thought and illustrative lesson. Thank you so much!
@ikennanwankpa63542 жыл бұрын
Thanks so much Alex for all the love you pour into your tutorials. God bless you. Please I'd like your permission to refer to you as my mentor on this journey. Thanks again.