[Episode] Excel + Python (Basic)

Python, the hot topic for data analysis, now available in Excel ❗ ❓
Everyone uses Excel, so I'd be upset if I were the only one who didn't know about the new features. So, let's follow up with this .

Microsoft and Anaconda team up to add Python to Excel. (2023-08-22)
※ Click here to see the official announcement post → [Click]

It's currently in beta, so there will be a lot of updates in the future, but if you learn it quickly when you're new , it'll be less difficult later~ Bottom __ line __ 윏

Python is a general-purpose language that can be used for a variety of purposes, including program development, task automation, and data analysis.

Anyway, if you learn it while you're at it, you'll find it useful in many ways later.
Let's organize how to use it with Excel.

• Automation : VBA and macros are difficult to write, and finding resources is also difficult. But Python is easy.

• Graphs : Graphs drawn in Excel are just plain ugly. Now, let's draw more diverse and beautiful graphs!

• Statistics : Excel also supports analysis functions, but has many limitations.

• Machine Learning : Machine learning used to be incredibly difficult without separate add-ons. Now, it can be implemented with just a few functions!

• Deep Learning : Will It Get an Update? (Brain Official)

  
  

"But I can't code....😥"

Have you tried nesting two Excel if() functions?
Have you ever tried organizing data with a pivot table?
If you can do that, you can do anything.
However, I cannot guarantee how long it will take to learn how to use the desired function.

Fortunately, these days there are many generative AIs like ChatGPT, so you can ask them to do it for you.
Let's take it easy for now.

ㅖ... You can download them all.
Everything from PPT files to Excel files used in the video!

※ Check the attached file for the second video

Rloha CEO Seungwook Kim

I began my career in data analysis after earning a master's degree in business analytics from UNIST. I began my career working on a data analytics team, and I'm currently actively involved in not only corporate and academic lectures, but also outsourcing data analysis-related work. 😎

My main job is teaching, and I average about 1,000 hours a year.

History

• Corporate lectures: Samsung Group, Shinhan Group, Hana Financial Group, SK Group, LG Electronics, GS Caltex, S-Oil, and many others.

• University lectures: Seoul National University, Sookmyung Women's University, Sungkyunkwan University, Kyungnam University, Seoul Women's University, Sangmyung University, and many others.

• Writing-related works: Give R a Little R (authored), Efficient R Programming (co-translated), Doing Data Science (translation reviewed), etc.

• Research Results: Google Scholar Profile

• Blog: Data Doctor

  
  

• Any unauthorized distribution or commercial use of any materials provided through the Inflearn platform may result in punishment under applicable laws. Please be aware! 🔒

• For external lecture requests or inquiries: contact@rloha.io