How I use Excel as a Data Analyst

Follow the Data 👸🏻 & 🤴🏻 @TinaHuang1 @KenJee_ds

Certificates & Courses
==================================
Coursera Courses:

DataCamp Courses:

Build a Portfolio Online
==================================
Rebate Code: "LUKE"

Books for Data Nerds
==================================

Tech for Data Nerds
==================================

Social Media / Contact Me
======================

As a member of the Amazon, Coursera, Hostinger, Parallels, Interview Query, and Data Camp Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.

00:00 Intro
01:46 Spreadsheets
03:39 VBA
06:04 PowerQuery
09:16 PowerPivot

#datanerd #dataanalyst #datascience

[LukeBarousse]

Also, thank you Tina and Ken for your help with this video!! 🙌🏼

[KenJee_ds]

Great video bud. Can you re-do it completely for Vimeo though?

[kendall]

HI Luke, I wanted to thank you. I come from an Education Background and I make a carreer shift. Your videos inpired me to become a Data Analyst. And a week ago I starded my first job as a Finance Analyst at Citi. This has been a long year and half Journey but I made it happen. Than you so much for all your tips and advice.

Gretting from Costa Rica. Keep good content coming : )

[Mareeyaaaaa]

I personally took this Excel course in Coursera and I absolutely love it! This course introduced me to Power Query and building an interactive dashboard. I applied all the skills I’ve learnt into my current role and created a wow moment to my boss. I created an automated interactive dashboard and with just a single click on the refresh button, all the data is automatically updated. Highly recommend for someone looking to improve excel skills. I am hoping there will be another course released soon!

[aliaziz]

This video deserves at least 2 mil views. High production value and fantastically edited! Great job!

[raghunandanr]

I'm taking notes for every videos, Luke. You are like my mentor. Love to see your videos every week.
Your videos are impressive. Love you!

[khaled]

The best crossover ! again a wonderful video, seeing you guys cheer me up all the time, the video is not only informative, but its also fun to watch!, keep it up Luke !
The BI Analyst joke at the end is HILARIOUS!

[jaemms]

I loved this Video plus the collaboration with Tina and Ken, Very insightful and it's always great to see what you all do for the data community. I was just thinking of upping my Excel Skills, the coursera course you highlighted will surely do the trick. Thanks

[dmitry]

This guy really knows what he's talking about. Kudos to you Mr. Luke Barousse! You've been an inspiration not just to me but to many aspiring Data Analyst out there.

[chuchuabe]

Love to see all data nerds together. Thank you Luke. Your videos are inspiring!

[moisesadames]

Great video! It was very interesting since Excel is normally not talked about enough in the DA/DS world, given there are other tools to use instead. Loved the collab! Also, keep up the good work!

[godsfavoritedaughter]

The video is quite engaging and informative.
Thank you Luke, I really look up to y'all, Tina, Ken and the rest of the data family 🤗❣️.

Keep doing what you know how to do best😌💪🏾.

[milner]

Wow! This video was amazing! I've always wondered what a data analyst does, and the way you broke it down was as simple as could be. Especially enjoyed the way you'd "bosses" came in with certai requests/demands which further emphasizes situations that you are put into. This was a great one? Thanks again Luke, and looking forward to more of your content!😃

[saltesc]

I feel this. I was hired as a Workforce Analyst and the past 6 months have just been migrating everything into Power BI because I made a BI report. Now life is data wrangling, cleaning with queries, and mooshing so many data source together into different reports for different departments...

[caneman]

You pretty summed up my daily work and my bosses! May the force be with you Luke. Great video!

[victorbegnini]

Man, it’s fantastic the funny ways you put things up on YouTube channel 😂
Always a pleasure to watch.
Thanks for that!
🎉

[nurtihani]

I just got started with Data Analysis recently. I have no background in programming so I’m learning a lot from online resources among them are Luke’s videos. Such a lucky time to live in terms of skills sharing for people with the access to the internet.

[frak]

This is not only the best but the ONLY helpful video about this topic. I've been searching for months for a video like this

[elmago]

LOVE the collab with Ken and Tina!! Great video!

[GUARIVERA]

One of my fav videos yet. For my first data analyst role they only use excel but this video helped me look beyond what I am doing now.