From Excel to Python

You already think in tables, formulas and lookups: that's most of the way to data analysis in Python. We map what you do in Excel onto Python, one habit at a time, until the monthly report that takes a day builds itself in a minute.

Duration: 3 days · Level: beginner

For: people who live in spreadsheets (finance, HR, sales, operations, research) and have never programmed.

Prerequisites: being comfortable with Excel formulas. No programming experience needed.

Pricing Contact
From Excel to Python

Day 1 — Python for spreadsheet people

  • Why Python when you have Excel
  • Installing everything with uv and opening Jupyter
  • Cells, but for code: working in a notebook
  • Numbers, text and dates
  • Conditions: the IF of Python
  • Lists and dictionaries
  • Loops: dragging the formula down, the Python way
  • Functions: your own formulas
  • Understanding error messages

Day 2 — Your tables in pandas

  • Reading xlsx and CSV files with pandas
  • Looking at a table: rows, columns, types
  • Selecting and filtering: the autofilter replacement
  • Computed columns: formulas become code
  • Cleaning: blanks, duplicates, badly typed cells
  • Sorting and ranking
  • Pivot tables become groupby
  • VLOOKUP becomes merge
  • Dealing with dates and periods

Day 3 — Reports that build themselves

  • Charts with matplotlib and pandas
  • Writing several sheets to one xlsx file
  • Formatting cells and adding formulas with openpyxl
  • Combining dozens of files into one
  • Automating the monthly report from start to finish
  • Generating a PDF report
  • From notebook to script you run in one click
  • Where to go next

Elevate Your Python Proficiency!

Contact Examples of programs