Hi Alex, I wanted to express my gratitude to you because I’ve learned a lot from your videos. Three months ago, I started my career as a data analyst, and your content has been incredibly valuable to me. Thank you for providing such high-quality content. My best wishes to you!
Many companies still rely so heavily on Excel, even though their analytics positions require things like Power BI or Tableau. Excel isn’t going away, like, ever!
Maybe make a video about differences between google Sheets and Excel, especially that google Sheets will bring fire features at the beginning of next month + many unique functions on google sheets is a game changing like query (sql) or let, and all of that for free
I still use INDEX(MATCH) at times, but also use XLOOKUP a lot. Started when I first was able to. It is a lot harder to break the formula when changes are made to the data table. And at 55, I absolutely never was a hipster.
Hi Alex, I started watching your SQL videos last February and since then you are my number 1 teacher here on YT. You explain complex things clearly and made it simple. I started applying for DA roles this month and on Tuesday, I finally got a job offer!!!!!! I was beyond happy and couldn't believe a career shifter like me has been given an opportunity to work in data analytics. I owe this milestone to you. Words can't express what I truly feel but I still want to say my sincerest gratitude to you. This wouldn't be possible without your tutorials and realistic advices. Gosh I am tearing up. From the bottom of my heart, thank you very much. This is just the start and I will continue on learning new skills and improve myself. I will keep on watching your videos as I navigate the real world of data analytics. Again, thank you and I salute you. You are the MAN. 🫡🧑💻 Truly grateful, Klay
Hi Alex,
I wanted to express my gratitude to you because I’ve learned a lot from your videos. Three months ago, I started my career as a data analyst, and your content has been incredibly valuable to me.
Thank you for providing such high-quality content. My best wishes to you!
You can also use Alt + A E to split the text much faster.
Many companies still rely so heavily on Excel, even though their analytics positions require things like Power BI or Tableau. Excel isn’t going away, like, ever!
Thanks u very much mr alex
Thank u Alex!!
Hey Alex your videos are very good and helpful, I can't find some function like XLOOKUP and TEXTSPLIT in my version of excel is this normal?
Maybe make a video about differences between google Sheets and Excel, especially that google Sheets will bring fire features at the beginning of next month + many unique functions on google sheets is a game changing like query (sql) or let, and all of that for free
hello can you put some more stuff for the data analytics bootcamp with the use of generative ai
Hi Alex, do you have a video/resource for array formulas and array logic?
Do I need the XLookup when there’s power query and power pivot?
let’s go thanks 🙏🏽
Alex please how to i download all those files to work along with you ?
There's a link to the GitHub dataset in the description. You can download it from there :)
@@AlexTheAnalyst thanks so much Alex on my way to becoming data analyst with your boot camp , which is so so helpful
I remember a few years ago when these hipsters showed me XLOOKUP. I'm that grandma in the office who still uses INDEX and MATCH.
I still use INDEX(MATCH) at times, but also use XLOOKUP a lot. Started when I first was able to. It is a lot harder to break the formula when changes are made to the data table.
And at 55, I absolutely never was a hipster.
I wonder which one is better?
How can I perfect in data analysis please
Hi Alex, long time
Mentor 🥰
Text to column is more simple than textsplit
*if you have 365
Hi Alex,
I started watching your SQL videos last February and since then you are my number 1 teacher here on YT. You explain complex things clearly and made it simple.
I started applying for DA roles this month and on Tuesday, I finally got a job offer!!!!!! I was beyond happy and couldn't believe a career shifter like me has been given an opportunity to work in data analytics. I owe this milestone to you. Words can't express what I truly feel but I still want to say my sincerest gratitude to you. This wouldn't be possible without your tutorials and realistic advices. Gosh I am tearing up. From the bottom of my heart, thank you very much. This is just the start and I will continue on learning new skills and improve myself. I will keep on watching your videos as I navigate the real world of data analytics.
Again, thank you and I salute you. You are the MAN. 🫡🧑💻
Truly grateful,
Klay
Second.
I hate excel.