Let it do the Monday spreadsheet.
Your first Python project. Scripts are brilliant at the boring, exact, repeatable work of combining and cleaning spreadsheets.
Starter Prompt
Every Monday I combine five branch Excel files into one summary with totals per branch. Write a Python script that reads every file in a folder and writes the summary to a new Excel file. Don't change the originals.
You'll Learn
Level
Installing Python, running a script with python summary.py, and how scripts read and write files.
Done when
One command makes the summary
Totals match last week's manual version
Originals are untouched
A README says how to run it
Check it against last week's manual numbers.