5 Essential Excel functions for Data Analysts

Подписаться 910

50% 1

Today I’m going to show you the 5 functions you need to know for data analysis in Excel.
There are over 450 functions in Excel and with all of those functions a Data Analyst only needs to know a few to get the job done. I’ll go over the ones I used every single day when Excel was my primary tool. Not only that, one or few of these will 99% be on a data analytics technical interview (if you are having a technical interview that involves Excel or Google Sheets)
Create a copy of the Excel file and practice! 👇
1drv.ms/x/c/32ee2d3b672dd14f/...
🔥Resources that landed me my first job in data:
Excel: bit.ly/3TuCQ5t
SQL: bit.ly/3PwtPru
Tableau: bit.ly/4aoOTsc
30% OFF Maven Analytics Annual Subscription: bit.ly/Maven30
MY SOCIALS:
📰 Newsletter - ianklosowicz.substack.com/
👨‍💻 Linkedin - / ian-klosowicz
💬 Discord - / discord
WHO AM I?
If we haven’t yet before - Hey 👋 I’m Ian, a self-taught Data Analyst and I have been helping thousands of people break into a career in data. Through my videos here on my channel, my newsletter, and LinkedIn, I share how you can become a Data Analyst and also be a more productive Analyst in a wide range of tools.
⌚️Timestamps:
0:00 - Intro
0:30 - Number 1
2:20 - Number 2
3:45 - Number 3
4:45 - Number 4
5:18 - Number 5
7:25 - Real-world Example
PS: Some of the links in this description are affiliate links that I get a kickback from 😜

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@karishmajain0102 Месяц назад

Great video! I'd love to see a Data Analyst bootcamp playlist and portfolio projects. Your content is fantastic, and I think a structured series like that would be incredibly helpful for aspiring analysts like myself. Keep up the excellent work!

@IanKlosowicz Месяц назад

That's a great suggestion! As I create more videos, I will put them in playlists as well as create series!

@Sandhya_MS7 Месяц назад

I follow your LinkedIn content. Great to have you here! The video is informative! Please try to continue the Tableau series.

@IanKlosowicz Месяц назад

Thanks for the support! And noted. There will be a lot of Tableau videos since that will be the BI tool I focus on creating content around.

@Mai.Data123 Месяц назад

Discovered your channel by LinkedIn. I will start my Data Analysis journey while you start your YT channel. 😊 Hoping to absorb as much knowledge from you and the other data-knowledgeable people. Thanks for sharing your knowledge.

@IanKlosowicz Месяц назад

Haha we both have an exciting journey! Feel free to join my Discord if you want to surround yourself with like-minded people!

@Mai.Data123 Месяц назад

@@IanKlosowicz Thanks! Will have to make a Discord account then. :) By the way, when you say "lock it" in your video, what actually are you pressing to lock the cell in?

@theunder7456 Месяц назад

Can we have access to the Excel spreadsheet to practice? Love the video!

@IanKlosowicz Месяц назад

Good idea! Here is the link to make a copy: 1drv.ms/x/c/32ee2d3b672dd14f/EWGewURH0hpMlJA4Kh0OslMBAYNtso5aA2s-FWcCqLarTQ?e=glq34L

@DigitalGhost007 Месяц назад

This is very helpful! Thank you Ian and Congratulations 🎉 🎉 for starting your channel. Looking forward to more informative videos.

@IanKlosowicz Месяц назад

Thanks! And they will get better as I get more comfortable talking to a camera haha

@bengill1980 Месяц назад

Hey Ian welcome back. Glad to see your second video.

@IanKlosowicz Месяц назад

Thanks Ben! I'm trying to push out one a week but that might be a bit much to chew haha. We will get there

@hindmansour7866 Месяц назад

Hi Mr. Lan, how can I get connected to you?, I need a help on how to get data analyst job I have been applying since the last year without getting any interview.

@IanKlosowicz Месяц назад

Check out the description and join my discord. Plenty of people (including myself) that are willing to help!