5 Essential Excel Functions for Data Analysts

Описание: 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! 👇
https://1drv.ms/x/c/32ee2d3b672dd14f/...

🔥Resources that landed me my first job in data:

Excel: https://bit.ly/3TuCQ5t
SQL: https://bit.ly/3PwtPru
Tableau: https://bit.ly/4aoOTsc

MY SOCIALS:

📰 Newsletter - https://ianklosowicz.substack.com/
👨‍💻  Linkedin -   / ian-klosowicz  
💬 Community - https://bit.ly/4m7LuV9

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 😜