Introduction To Python For Excel Users

If you’re an Excel user looking to level up your analytics skills, Python is a great choice for repeatable processes, compelling visualizations, and robust data analysis. And while learning to code may seem too difficult, your Excel knowledge gives you a significant head start.

This introduction is intended for Excel users with no prior knowledge of Python. By the end of this session, you will know:

- How Python differs from Excel as an open-source software tool
- How to identify and implement useful packages for data analytics
- How to navigate and execute code in Jupyter notebooks
- How to translate common Excel concepts such as cells, ranges, and tables to Python equivalents
- How to enhance Excel and Power BI with Python

Here are some useful resources shared during the presentation.

White paper: stringfestanalytics.com/five-things-python-excel/
Repository: github.com/stringfestdata/python-for-excel-users-crash-course
eBook: stringfestanalytics.com/book/

Table of Contents:
0:00 – Introduction
1:17 – Resources
2:50 – Book giveaway
3:00 – Origins of Data
4:00 – Open Source
6:10 – Jupyter Notebook
13:55 – Questions
18:58 – Use cases
25:18 – Apps
26:32 – Packages
24:31 – Uses
27:47 – Time check
32:34 – Audience questions
36:04 – Giveaway
36:53 – Python packages
45:18 – QnA

Looking for more crash courses? Check out our playlist: youtube.com/playlist?list=PL8eNk_zTBST9SJS5gUw_HYGSk5MdyC89-

--

At Data Science Dojo, we believe data science is for everyone. Our data science trainings have been attended by more than 10,000 employees from over 2,500 companies globally, including many leaders in tech like Microsoft, Google, and Facebook. For more information please visit: hubs.la/Q01Z-13k0

💼 Learn to build LLM-powered apps in just 40 hours with our Large Language Models bootcamp: hubs.la/Q01ZZGL-0

💼 Get started in the world of data with our top-rated data science bootcamp: hubs.la/Q01ZZDpt0

💼 Master Python for data science, analytics, machine learning, and data engineering: hubs.la/Q01ZZD-s0

💼 Explore, analyze, and visualize your data with Power BI desktop: hubs.la/Q01ZZF8B0

--

Unleash your data science potential for FREE! Dive into our tutorials, events & courses today!

📚 Learn the essentials of data science and analytics with our data science tutorials: hubs.la/Q01ZZJJK0

📚 Stay ahead of the curve with the latest data science content, subscribe to our newsletter now: hubs.la/Q01ZZBy10

📚 Connect with other data scientists and AI professionals at our community events: hubs.la/Q01ZZLd80

📚 Checkout our free data science courses: hubs.la/Q01ZZMcm0

📚 Get your daily dose of data science with our trending blogs: hubs.la/Q01ZZMWl0

--

📱 Social media links

Connect with us: linkedin.com/company/data-science-dojo

Follow us: twitter.com/DataScienceDojo

Keep up with us: instagram.com/data_science_dojo/

Like us: facebook.com/datasciencedojo

Find us: threads.net/@data_science_dojo

--

Also, join our communities:

LinkedIn: linkedin.com/groups/13601597/

Twitter: twitter.com/i/communities/1677363761399865344

Facebook: facebook.com/groups/AIandMachineLearningforEveryone/

Vimeo: vimeo.com/datasciencedojo

Discord: discord.com/invite/tj8ken4Err

_

Want to share your data science knowledge? Boost your profile and share your knowledge with our community: hubs.la/Q01ZZNCn0

#python #excel

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk