Automate your excel work and formating with python scripts with combining, splitting, converting whole excel-sheets. Or calculate, aggregate, filter, group change, visualize and clean the data as you need it.
Automate Excel tasks and improve productivity with professional Excel automation services.
Excel Automation & Macros | Save Time by Automating Excel
Automated Sales & Commission Reporting Solution
What:
This tool automates sales summaries and commission calculations using quarterly performance thresholds, saving time and ensuring accuracy.
Used Modules:
xlwings
Overview
This Excel automation solution reads sales data for each employee, summarizes total revenue, and automatically generates a quarterly commission table based on multiple performance thresholds.
What It Does
- Processes employee sales data from Excel
- Aggregates revenue per employee and per quarter
- Calculates commissions automatically using defined thresholds
- Produces clear, structured commission reports
Why It Matters
- Eliminates manual sales and commission calculations
- Ensures accurate and consistent reporting
- Saves time for finance and management teams
Portfolio Highlight
This project demonstrates how Excel automation and business rules can turn raw sales data into transparent, reliable commission reports that support better financial decisions.
Automated Excel Data Updater
What:
Updates Excel files with various information, including ZIP code–specific details, allowing for automated data management and accurate record keeping using Python.
Used Modules:
xlwings
Overview:
This tool updates Excel files automatically with a range of information, including ZIP code–specific details, enabling accurate record keeping and efficient data management.
Why It Matters:
- Automates repetitive Excel updates
- Ensures accurate and consistent data
- Saves time and reduces manual errors
Technologies Used:
Python, Xlwings, Pandas
Portfolio Highlight:
This project demonstrates how automation and intelligent data handling can simplify Excel-based workflows, making record keeping faster, more accurate, and fully scalable.
TV Spot Scheduling Tool
What:
Arrange tv-spots in an output-excel-sheet so its a best fit and the budget is not exceeded for the products
Used Modules:
xlwings
Overview:
This tool arranges TV spots in an Excel sheet to ensure the best fit for each product while keeping the budget under control. It automates planning for advertising campaigns, making scheduling efficient and accurate.
Why It Matters:
- Optimizes TV ad placement for maximum impact
- Keeps campaigns within budget
- Saves time compared to manual scheduling
Technologies Used:
Python, Xlwings, Excel Automation
Portfolio Highlight:
This project demonstrates how automation and intelligent scheduling can simplify media planning, helping businesses maximize ad effectiveness while controlling costs.
Handle Transactions Data (s)
What:
Read transactions-data from csvs and build report with categorization, summarization, etc.
Used Modules:
xlwings, csv
Transactions Data Reporting Tool
Overview
This tool reads transaction data from CSV files and generates comprehensive reports with categorization, summarization, and key insights for better financial tracking and analysis.
Why It Matters
- Automates transaction data processing
- Provides structured, easy-to-read reports
- Saves time and improves accuracy for finance and accounting teams
Technologies Used
Python, Pandas, CSV Handling, Excel/Xlwings
Portfolio Highlight
This project demonstrates how automated data processing and reporting can transform raw transaction records into actionable business insights, supporting informed decision-making and financial oversight.
Bank Statements Dashboard (s)
What:
Read transactions from different bank-statements, categorize them and build some reports and dashboards out of it
Used Modules:
xlwings, csv
Merge CRM data (s)
What:
Merge 3 different leads csv-files out of a CRM-system, with informations for boxes, contacts and organizations
Used Modules:
xlwings
Create summary for farms and plots (s)
What:
Create a summary excel-sheet out of 2 other sheets with informations about different farms and different plots
Used Modules:
xlwings
Google Sheet Template for Therapy (s)
What:
Create a google sheet template for a therapy questionnaire for several clients a time protocol, detailed explanations and diagrams for visualization
Used Modules:
google sheet
Summarize Reports for Shops (s)
What:
Summarize different reports for shop, waterjet and machineshop with different employees and responsibilities
Used Modules:
xlwings
Create a Unit Cost list (s)
What:
Create a unit cost list for different materials and components with different price units and pieces
Used Modules:
xlwings
Check Timeslots (s)
What:
Check times ranges in which slots they are fitting for every scheduled work plan
Used Modules:
xlwings
Read Football Statistics (s)
What:
Read football-statistics from a ms-access-db and provide the data in an excel-sheet. Select several parameters before the program run like leagaue coffeeAndBeer date-range
Used Modules:
pyodbc, xlwings
Aircrafts Inspection (s)
What:
Read inspections-list for aircraft vehicles, check the next service date regarding flight hours, cycles and days
Used Modules:
xlwings
Driver Statistics (s)
What:
Read source data for drivers with their stopps, duty hours, etc. and build summary-data and overview for every driver
Used Modules:
xlwings
Parse Contracts
What:
Parse contract-informations, and build a summary overview, input percentages for every employee and detailed contract informations
Used Modules:
xlwings
Create Provisions
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings, docx
Financial Overview
What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
Syndicate Summary
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings
Check Machine Downtimes
What:
Run the program every few minute and check machine downtimes, register special downtimes and get an hourly statistics output
Used Modules:
xlwings
Create Working Plan
What:
Create a working plan for creating beds and other furniture – select article, parameterize the step and create a working plan including pictures for the individual steps
Used Modules:
xlwings
Student Overview
What:
Create report for different students and show their strenghts, experience, rating, educaton, etc.
Used Modules:
xlwings
Merchants and Syndicates
What:
Create a summary information for merchants and sydicates for a specific time and date
Used Modules:
xlwings
Forecast With Binding
What:
Create forecast for different products, filter according to new products and end of life ignore lists and prepare binding window
Used Modules:
xlwings
Presence Overview
What:
Create presence sheet for differet employees – getting all the start and end times and provide a report-overview with different measures
Used Modules:
xlwings
Machine Operating
What:
Create and update a machine plan for different articles, products on different types of production machines
Used Modules:
xlwings
Sorting Worksheets
What:
Sort data in an excel-sheet – reading a master-list and splitting this to different worksheets, with changed columns
Used Modules:
xlwings
Create Trade Statistics
What:
Create a customized excel-sheet for trade statistics with Trades, Easiness of Getting Along, Rediential vs. Commercial, Contact Person, EMail, Website, etc.
Used Modules:
xlwings
Create List Template
What:
Read some input-information and create a list-template for further use
Used Modules:
xlwings
Process ERP Data (s)
What:
Process some ERP-data and match some additonal information from 2 other system in a final list
Used Modules:
xlwings
Add Summarization With OpenAI / ChatGPT
What:
Add summarization for longer text and update the files
Used Modules:
openai, dotenv, xlwings
Excel automation expert, Excel macros freelancer, automate Excel tasks
Excel Automatisierung Freelancer, Excel Makros erstellen lassen, Excel Aufgaben automatisieren