8 Essential Excel Functions | Become a PRO User
ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- In this video I break down 8 essential Excel functions for any role.
| Top Courses for Data Analysts |
___________________________________
📑 Excel from Beginner to Advanced → click.linksynergy.com/deeplin...
📊 Power BI for Business Intelligence → click.linksynergy.com/deeplin...
📈 Tableau for Data Analysis and Visualization → click.linksynergy.com/deeplin...
⌨️ SQL for Business Intelligence→ click.linksynergy.com/deeplin...
🐍 Python for Data Analysis & Business Intelligence → click.linksynergy.com/deeplin...
| Additional Resources |
___________________________________
💼 Build a portfolio → try.carrd.co/m8jcb15r
💻 Download Power BI on a Mac → parallels.sjv.io/ankQ6W
🧑💻 Master Data Analytics Interviews → www.dataford.io/?via=matthew
| More Content |
___________________________________
🧔♂️ LinkedIn → / matthewmike
📩 Substack → thdatapoint.substack.com/
As an affiliate with the brands mentioned above, I earn a commission from qualifying purchases in the links provided that help support this channel.
00:08 - SUMIF
00:41 - COUNTIF
01:18 - IFERROR
02:19 - LEFT/RIGHT/MID
04:09 - CONCATENATE
05:05 - XLOOKUP
Well done, Matt! Straightforward and very instructive. Thanks for sharing!
Appreciate it! 😊
Glad to see you joining the YT game, Matt! Good work. /subbed
Thank you! Glad to be here !
Really powerful stuff Matt! This is definitely one that will be watched for a long time to come
Thanks Asa! I certainly hope so!
I didn't realize until later that my screen recordings didn't pick up the pop-up syntax box that appears while you're typing in a formula.This was because I recorded the window rather than the entire screen. Sorry about that! I'll make sure it's there next time.
This is great Matt! Thank you so much
Thank you! 🙂
This is great!! Thanks!!
Glad to hear that! 🙂
I see you Matt! Keep it up 👌
Thanks Injae 😉
Outstanding video! Thanks for sharing it 👏
Thank you!
Greatr! we wanna more like this and please give us all the essential functions for as data analyst
That’s the plan! Stay tuned for plenty more like this. Glad it was helpful!
Great information 👍
Thank you!
great video, and good luck on your channel. I'd appreciate to see similar content for tableau & sql
Thank you! Definitely planning to do some content like that in the future.
also, would you be doing portfolio review videos?
I’d be interested to send you mine and you can butcher it in front of everyone 💅🤌 architect moving to data analytics here ✋
@@travelsizearchitect I actually love that idea for a video. I’d be glad to! Feel free to send it over and I’ll queue that up for a future video. You can email me or DM on LinkedIn too so I can keep you posted.
Sir please clear my doubt
Copilot 365 soon available in Excel & other ai tools are there
So is it still important to learn ms Excel deeply all functions and advance formulas??
You don't need to memories everything, but it's helpful to have a core understanding of many essential functions. ChatGPT is already here and I use it very often when I'm stuck with a particular formula or problem. It's a great assist but it also shouldn't become a crutch.
I cant concentrate. Seriously, id go for a date w you then ill learn data stuff 😅🥰
😅