Skip to main content

Video: Intro to Python for Spreadsheet Users

In this video tutorial, you'll watch the end-to-end automation of a routine spreadsheet task being completed using Python.
Mar 2019  · 1 min read

If you would like to learn more about transitioning from spreadsheets to Python, take Chris Cardillo's Python for Spreadsheet Users Course.

Every day, millions of workers head into the office and open up a spreadsheet, a workbook, or a series of workbooks to accomplish routine tasks. These tasks take time. They can be repetitive and sometimes even downright boring. So in the 21st century, where most routine tasks can be automated, what's the alternative?

In this video, DataCamp Data Scientist Chris Cardillo will help to demystify the Python programming language for those familiar with spreadsheets, and will draw parallels between common spreadsheet techniques (like VLOOKUP and pivot tables) in order to give spreadsheet users an entry point into Python. Viewers will watch the end-to-end automation of a routine spreadsheet task, and hopefully, by the end feel comfortable giving it a try themselves!

Check out DataCamp's tutorial on Using Python to Power Spreadsheets in Data Science.

Python Data Science Toolbox (Part 1)

3 hours
Learn the art of writing your own functions in Python, as well as key concepts like scoping and error handling.
See DetailsRight Arrow
Start Course

Pivot Tables in Spreadsheets

4 hours
Explore the world of Pivot Tables within Google Sheets, and learn how to quickly organize thousands of data points with just a few clicks of the mouse.

Intermediate Spreadsheets

4 hours
Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
See all coursesRight Arrow

How to Become a Data Analyst in 2023: 5 Steps to Start Your Career

Learn how to become a data analyst and discover everything you need to know about launching your career, including the skills you need and how to learn them.
Elena Kosourova 's photo

Elena Kosourova

18 min

Sports Analytics: How Different Sports Use Data Analytics

Discover how sports analytics works and how different sports use data to provide meaningful insights. Plus, discover what it takes to become a sports data analyst.
Kurtis Pykes 's photo

Kurtis Pykes

13 min

The 23 Top Python Interview Questions & Answers

Essential Python interview questions with examples for job seekers, final-year students, and data professionals.
Abid Ali Awan's photo

Abid Ali Awan

22 min

Getting started with Python cheat sheet

Python is the most popular programming language in data science. Use this cheat sheet to jumpstart your Python learning journey.
DataCamp Team's photo

DataCamp Team

8 min

How to Make a Gantt Chart in Python with Matplotlib

Learn how to make a Gantt chart in Python with matplotlib and why such visualizations are useful.
Elena Kosourova 's photo

Elena Kosourova

17 min

How to Write a Bash Script: A Simple Bash Scripting Tutorial

Discover the basics of bash scripting and learn how to write a bash script.
Kurtis Pykes 's photo

Kurtis Pykes

5 min

See MoreSee More