Peter L.-Excel and Access Applications

Check rate
Experience
Calculator Redesign
TD Synnex GmbH & Co. oHG
- Two suppliers made extensive changes to the calculation and data provision. The calculation tool therefore needs to be adapted.
Database Optimization
HVU Bildungsakademie gGmbH
- An existing Access database is to be optimized. This includes its structure, usability, and above all the expected significant time savings in its use.
- The optimization is to be carried out step by step because all data must be retained and the changes must be made during ongoing operations.
- The existing budget should be kept rather low.
- Used: Access, VBA
Inventory
MV E-Systems UG
- The company's product is made from a large number of individual components and parts, some of which have to be pre-assembled.
- A simple, cost-effective Access database is needed to provide an overview of inventory, orders, and purchase orders.
- Used: Access, VBA
New Calculator
TD Synnex GmbH & Co. oHG
- TD Synnex needs a new calculator for another supplier. The existing (original) calculator is therefore redesigned to display the modified price list structure.
- Core areas such as simple item selection and creating customer calculators remain in place.
- Used: Excel, Access, VBA
Data Consolidation
COLIFT GmbH
- Personnel data from various sources is to be loaded into a single Excel "database". Formatting corrections are made to ensure a consistent presentation.
- Used: Excel, VBA
Income and Expenses
Fit4Business GmbH
- Clearly present income and expenses from account transactions, including comparisons, expense categorization, and an overview of changes over time.
- Used: Excel
Three Excel Applications
BLM Büroservice GmbH
- Added to and improved three small Excel applications.
- Used: Excel, VBA
Calculator / Report Redesign
TD Synnex GmbH & Co. oHG
- Made major adjustments due to several changes on the suppliers' side (changes to source data, products, and calculations).
- Increased requirements from the country organizations also made adjustments and extensions necessary.
- A report tool had to be adapted due to new data sources.
- Used: Excel, VBA
Hotel Database
bikeAlpin GmbH
- Ongoing support, enhancement, and change requests.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Created an Excel calendar application so that the Access front end controls the Excel application, and the Excel application manipulates the Access front end.
- The data is stored cleanly in the Access back end, changes can be made easily in the Access front end, and the overview is provided through an Excel calendar.
- Maximum ease of use, because when switching between Excel and Access, the target application is already positioned on the correct records or cells.
- Used: Access, Excel, VBA
Calculator Redesign
TD Synnex GmbH & Co. oHG
- Change the calculation basis for a supplier from Listprice to Cost+.
- Completely rebuild the exchange rate calculation to also allow any sales currency to be offered independently of the purchase currency.
- Used: Excel, Access, VBA
Calculator Redesign
TD Synnex GmbH & Co. oHG
- Reactivate country-specific settings so that the subsidiaries in Austria and Switzerland can use the changes to the tool.
- Used: Excel, Access, VBA
Heat Loss
ACE - Andrea Costa Engineering
- Add correct energy loss data to an existing Excel calculation tool. The calculations come from Andrea Costa, while I implemented them in Excel.
- Used: Excel
Calculator Redesign
TD Synnex GmbH & Co. oHG
- The proven and repeatedly modified calculation tool had to be extensively changed to represent the completely new item structure of one of the suppliers. The change was also used to implement performance improvements.
- Used: Excel, Access, VBA
Project Controlling
Nidec GmbH
- The presentation that must be prepared every year needs to be updated. For this, many analyses and charts have to be checked and improved if necessary. The goal is both to complete the presentation and to identify and implement possible improvements.
- Used: Excel
Hotel Database
bikeAlpin GmbH
- The database started in Jan. 2013 and continuously improved and expanded over the years must be completely redesigned due to changed requirements. This includes a modified data structure and, as a result, different workflows and output options.
- The newly developed structure enables advanced functionalities that were not possible with the old approach. It also allows other time-saving workflows to be implemented. Many limitations that previously required extensive manual intervention are eliminated.
- Used: Access, VBA
Bills of Materials
Höckh GmbH
- Bills of materials from CAD and the enterprise resource planning system must be compared. The Excel tool displays the differences in color and as a list.
- Used: Excel, VBA
Reconciliacion Files
TD Synnex GmbH & Co. oHG
- The Excel tool created from 11/2018 to 03/2019 had to be quickly converted to Access because there were more records than Excel allows in rows.
- Used: Excel, Access, VBA
Diverse
Diverse
- Various minor adaptations and changes to different projects for several companies (e.g. TD Synnex, Audi).
- Used: Access, Excel, VBA
Patient Data
Julius-Maximilians-Universität
- Patient data from various research and observation systems must be appropriately consolidated in an Access database and jointly output via export.
- An analysis of patient histories was previously not meaningfully possible due to the different systems. The database provides the first cross-system evaluation option.
- Used: Access, VBA, Excel
Invitation Database
Marketing Gesellschaft Mönchengladbach mbH
- Creating an Access database to manage invitations to larger cultural events.
- Creating invitations.
- Tracking responses (attending / not attending, including the number of accompanying guests).
- Taking specific groups of invitees into account.
- Providing the option to manage seating assignments.
- Used: Access, VBA, Excel
Contact Database
RuhrFutur gGmbH
- Creating an Access database to manage all people with whom RuhrFutur has been or is in contact.
- Linking people with business partners (universities, ministries, companies, …).
- Linking projects with people or business partners.
- Creating and managing lists (e.g. Christmas mailings) for people at their business partners.
- Enabling export and selection options across all areas (people, business partners, projects, lists).
- The many separate Excel tables previously required are now combined in one database. This eliminates problems with duplicates, outdated data, inconsistencies, etc.
- Used: Access, VBA, Excel
Excel Pricing Tool Enhancement
Tech Data GmbH & Co. oHG
- Improving the tool created from 03/2018 - 10/2019 and incorporating supplier changes.
- Adding further functionalities.
- Improving performance.
- Taking changes caused by suppliers into account.
- Used: Excel, VBA, Access
Green Tourism
Leuphana Universität
- Supporting an Excel-based analysis: Data on the social and environmental criteria of package holidays was to be combined in an Excel tool and presented in a clear and useful way. The analysis logic was created by Leuphana, while I created the Excel-based analysis.
- Used: Excel, VBA
IT Continuity
Audi AG
- Continuation of the project from 08/2017-11/2021.
- Changing the calculation basis.
- Expanding the graphical presentation.
- Expanding the analyses.
- Support and advice on current topics.
- Improving data analysis.
- Incorporating changes resulting from external requirements.
- Used: Access, VBA, Excel, Powerpoint
GMC Revision
MGS GmbH
- Revising and supplementing the "GMC" project from 12/2015 to 4/2016, and from 12/2016 and 5/2018 to 6/2018.
- Used: Excel, VBA
Consulting on BCM Controls
KfW IPEX-Bank GmbH
- The Excel-based workflow is to be transferred to an Access database. Existing weaknesses are to be eliminated and the possibilities of a database utilized. Purely consulting work by me; another company was to handle the implementation.
- The customer knows and appreciates my solution approaches (from another project at another company) and the very fast implementation. The company carrying out the work can benefit from my knowledge of BCM, my ability to identify opportunities for improvement, and exotic Access application scenarios.
Price Lists 1
Tech Data GmbH & Co. oHG
- The supplier's monthly price list is automatically restructured so that an individual price list can be created for selected customers.
- Used: Excel, VBA
Automating TNW
Schober Beratung für Logistik
- The consultants' monthly activity reports are automatically transferred to summary tables; plausibility checks are also performed.
- Used: Excel, VBA
Expanding Project Overview
Hermes Arzneimittel GmbH
- Modifying an existing Excel document to significantly improve its processing and clarity.
- Designing the modifications so that other documents with the same structure can easily be adapted. Transferring them into a template.
- Selected topics for training in the use of Excel.
- Used: Excel, VBA
Excel Pricing Tool 2 / 3
Tech Data GmbH & Co. oHG
- Based on the Excel Pricing Tools developed so far, create another one to represent an additional supplier.
- Used: Excel, VBA, Access
Excel Pricing Tool Extension
Tech Data GmbH & Co. oHG
- Extend the tool created from 03/2018 - 10/2019. Additional calculation methods (bonus models) are offered.
- Extend the tool so that it can also be fully provided to customers, including its visual appearance.
- Support for displaying the tool in other languages (currently DE, in the future at least EN).
- Used: Excel, VBA, Access
Scan-Print
Wiesendanger medien GmbH
- Create a small Excel-based tool. An RFID scanner reads a code, and the corresponding value from a CSV file is then output as a barcode on a label printer.
- Used: Excel, VBA
IT Continuity
Audi AG
- Continuation of the project from 08/2017-03/2020.
- Transfer to a production environment.
- Create an extended calculation ("Impact Matrix") that enables significantly more accurate results.
- Add several analyses.
- Additions to the graphical display of the current state, including information on possible measures and prioritization.
- Used: Access, VBA
Excel Pricing Tool Extension
Tech Data GmbH & Co. oHG
- Extend the tool created from 03/2018 - 10/2019 so that it can be used in several country offices.
- Used: Excel, VBA, Access
Distances
Schober Beratung für Logistik
- Calculate and enter road distances using the Google Maps API in an Excel list with starting points and destinations.
- Used: Excel, VBA
Excel Macro Programming PMO
Hewlett-Packard GmbH
- Created and modified several small tools to process monthly internal time records.
- Used: Excel, VBA
GMC Revision
MGS GmbH
- Revised and expanded the "GMC" project from 12/2015 to 4/2016.
- Used: Excel, VBA
Excel Pricing Tool / Reconciliacion Files
Tech Data GmbH & Co. oHG
- An existing Excel-based pricing tool had to be completely rebuilt. It creates a calculation interface from supplier price lists that takes the very frequent dependencies and restrictions into account and includes the customers' individual conditions.
- For the first time, a tool was created that takes all the specifics of both suppliers into account, with simple and intuitive operation through filters and dropdown fields.
- The basis for years of improvements and adjustments due to changes made by the suppliers.
- Extremely efficient tool for preparing quotes, giving the inside sales team a unique selling point in the market.
- Selected customers receive their own tool, which they can use to create quotes or orders themselves. None of the competitors offers even a remotely comparable tool, providing a major competitive advantage.
- Created a tool to present monthly billing data for customers in both summary and detailed form.
- Unmatched presentation of business transactions for customers, with the option of using them to create calculations for end customers as well. The volume of data no longer allows for manual processing.
- Used: Excel, VBA, Access
Tours
Privat
- Created a private Access tour database to record and analyze sports activities (mountaineering, road cycling, MTB, ski touring, …).
- Created to meet personal needs that were not covered by standard solutions.
- No dependence on standard software that could eventually be discontinued and shut down by the manufacturer.
- Used: Access, VBA
IT Continuity
Audi AG
- Revising an Access database design and creating the finished Access database for managing, tracking, and calculating continuity processes.
- Contributing to the redesign of the underlying processes. In practice, recreating the Access database.
- Data previously compiled manually is calculated within seconds and converted into standardized reports.
- Changes can be implemented extremely efficiently thanks to a clean database structure. Significant reduction in staffing requirements while greatly expanding functionality and calculation accuracy.
- Basis for further streamlining measures and functional enhancements.
- Used: Access, VBA, Excel, Powerpoint
Database Dictionary
Allianz AG
- Revising an Access database design and creating the finished Access database for documenting database fields.
- Used: Access, VBA
Development Support
EKM GmbH
- Implementing change requests or creating new functionalities for various EKM customers.
- Software environment: GDI.
- Used: GDI
Cost Savings 2
GfK SE
- Completely rebuilding and functionally expanding the Access database worked on in May 2016.
- Used: Access, VBA
GMC Revision
MGS GmbH
- Revising and supplementing the "GMC" project from 12/2015 to 4/2016.
- Used: Excel, VBA
Hotel DB Lists
bikeAlpin GmbH
- Improving the appearance of some lists and letters.
- Creating another list and customer letter.
- Used: Access, VBA
Hotel DB Calendar
bikeAlpin GmbH
- Integrating a calendar in Access to display all trips and guides over an entire season.
- Links from the calendar directly to edit the trips.
- Changes to the trips are displayed immediately in the calendar.
- Used: Access, VBA
Equal Opportunities
Fraunhofer Gesellschaft
- Automating an Excel application previously operated manually to visualize key figures using VBA.
- Used: Excel, VBA
Hotel DB Post-Calculation
bikeAlpin GmbH
- Continuing the work from Dec. 2015.
- Used: Access, VBA
Cost Savings
GfK SE
- Getting an existing, faulty Access application up and running.
- Used: Access, VBA
Evaluation Tool
benchex GmbH
- Based on an existing Excel solution, create a new Excel tool that makes it possible to filter and consolidate the individual survey results and display the results.
- Used: Excel, VBA
GMC
ais Werbeagentur GmbH
- MGS Münchner Gesellschaft für Stadterneuerung mbH needed an Excel-based way to create an individual energy check for existing buildings for its customers.
- First solution "from a single source" (Excel only).
- Free data entry with no quantity restrictions.
- The result is an approximately 30-page booklet that does not reveal that it was generated with Excel.
- Used: Excel, VBA
Hotel DB Post-Calculation
bikeAlpin GmbH
- Expanded the hotel database to record and evaluate all invoices.
- Used: Access, VBA
Training Management / Weclapp
Laufcampus GmbH
- Repeatedly expanded and improved the application upgraded in Feb. 2015.
- Consolidated and cleaned up approximately 10,000 addresses from various sources in Excel.
- Set up a database for the CMS Weclapp together with the customer.
- Imported the addresses into Weclapp.
- Used: Excel, VBA
CREDIT
Munich Re AG
- Modified the Access database created from July to Aug. 2011.
- Switched to Office 2013 and Win7.
- Made minor adjustments.
- Used: Access, VBA, Excel
Training Management
Laufcampus GmbH
- Improved an existing Excel file in terms of functionality and appearance.
- Used: Excel, VBA
Cycling Jerseys
bikeAlpin GmbH
- Created a small Access database to provide an overview of sold cycling jerseys by size.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Improved the database created the previous year.
- Used: Access, VBA
ENP Database / Renewal 2014 / MGA Monitoring Tool
Munich Re AG
- Created an Access database for managing risks, with quarterly data delivery from Excel and a 4-step update process.
- Mainly reformatted customer claims data in Excel tables into machine-processable formats, partly with the help of self-created VBA tools.
- Also created smaller tools, analyses, etc.
- Converted the Excel solution created from Apr. to May 2011 to Access.
- Used: Access, VBA, Excel
Hotel Database
bikeAlpin GmbH
- Created an Access database for booking all trips, hotel stays, luggage transport, return trips, and shuttles.
- Created various lists and documents for customers and guides.
- Created a calendar to provide an overview of the status of all trips.
- The new Access database made things much easier and created the basis for several extensions.
- Used: Access, VBA
Occupations Database
Munich Re AG
- Creating an Access database to manage occupational figures.
- Connecting to an existing database via Excel interfaces.
- Used: Access, VBA, Excel
Renewal 2013 / CREDIT 2
Munich Re AG
- Primarily reformatting Excel spreadsheets containing customers' claims data into machine-readable formats, partly with the help of self-created VBA tools.
- Expanding the database created in July and Aug. 2011 with additional functionality and linking it to another Access database.
- Used: Access, VBA, Excel
Sampling
Techem GmbH
- Completing an Excel-based database for managing water sampling points (Legionella testing).
- Interface for data communication with the testing laboratory.
- Printing forms and sample labels.
- Used: Excel, VBA
Fahr & Spar Summer/Autumn 2012
BMW AG
- Adapting the existing database to the requirements of an additional campaign.
- Used: Access, VBA
Fahr & Spar 2012
BMW AG
- Adapting an existing Access database to the requirements of this year's campaign.
- Migration from Access 2003 / Win XP to Access 2007 / Windows 7.
- Used: Access, VBA
Renewal 2012
Munich Re AG
- Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats, partly with the help of self-created VBA tools.
- Also creating smaller tools, analyses, etc.
- Used: Excel, VBA
Maps
bikeAlpin GmbH
- Arranging for maps to be scanned.
- Calibrating, cropping, and assembling scans.
- Converting into various formats.
- Used: QuoVadis, GlobalMapper
CREDIT 2
Munich Re AG
- Creating a new Access database that enables monitoring of business transactions.
- Revising the existing Excel transfer frontend.
- Converting the existing Excel database.
- Automating daily booking processes, including importing data from Outlook, posting entries, checking limits, and generating emails.
- Generating several analyses to monitor business transactions.
- Automation made it possible to obtain exact data for the first time.
- Used: Access, VBA, Excel, Outlook
MGA Monitoring Tool
Munich Re AG
- Creating an Excel-based monitoring program that compares insurance data with claims data.
- Quarterly cumulative import of data deliveries from the customer.
- Displaying approximately 30 KPIs, both in tables and graphs.
- Integrating an extensive filter.
- Used: Excel, VBA
Maps
bikeAlpin GmbH
- Creating digital maps.
- Calibrating, cropping, and assembling scans.
- Converting into various formats.
- Used: QuoVadis, GlobalMapper
Renewal 2011
Munich Re AG
- Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats.
- Also creating smaller tools, analyses, etc.
- Used: Excel, VBA
Renewal 2010
Munich Re AG
- Primarily reformatting Excel spreadsheets containing customers' claims data into machine-processable formats.
- Massive time savings and elimination of manual errors through automation.
- Used: Excel, VBA
Elevation Profile Generator
bikeAlpin GmbH
- Creating an Excel program to generate elevation profiles for the tours offered.
- Importing GPX files and providing layout options for the elevation profiles.
- Output as scaled elevation profiles including point labels.
- Used: Excel, VBA
Order Processing
Fa. Schiedel / BTG Schornsteintechnik
- Production and distribution of chimney systems.
- Order processing.
- Creation and maintenance of an Excel-based order form.
- Creation and maintenance of an Access database for order tracking, production planning and coordination across multiple locations, as well as assigning freight forwarders.
Wealth Management Clerk
Bankhaus Merck Finck & Co
- Reviewing daily automatically imported account transactions and corporate actions.
- Manually updating corporate actions that cannot be automated.
- Preparing daily reconciliations of internal clearing accounts using Excel: extracting data from print files, creating account balances, and reconciling them with externally supplied total balances.
Export Order Processing
Ortovox Sportartikel GmbH
- Production of sporting goods for ski touring equipment, backpacks, and clothing.
- Creation of production and requirements plans with Excel.
Trainee Commercial Specialist
F.W. Schubert GmbH
- Training to become a commercial specialist through a work-integrated education program.
- Examination for commercial specialist in May 1995.
- AdA examination in Dec 1994.
- Examination to become a wholesale and foreign trade merchant in Jan 1994.
Surveying Student
FH-Studium
Military Service / Administrative Work
Bundeswehruniversität Neubiberg
- Basic training in Amberg.
- Administrative work in the student housing department of the Bundeswehruniversität.
Student
Asam-Gymnasium
- Graduation: Abitur with advanced courses in mathematics and physics.
Student
Volksschule Sauerlach
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Education, Manufacturing, Construction, Automotive, Information Technology, and Banking and Finance.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Operations, Logistics, Production, Business Intelligence, and Finance.
Summary
Creation and optimization of Excel and Access applications
- Comprehensive knowledge across various industries
- Flexible and timely implementation of your programming requirements
- Attentive, committed, and structured working style
- All the advantages of an external employee
Skills
- Windows Environment (Xp, Vista, Windows 7, Windows 10, Windows 11)
- Microsoft Office (2003, 2007, 2010, 2013, 2016, 2024)
- Excel Including Vba Programming
- Access Including Vba Programming
Languages
Education
F.W. Schubert GmbH
Business Specialist through an integrated vocational education program · Munich, Germany
Surveying
Asam-Gymnasium
Abitur · Munich, Germany
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Peter is based in Holzkirchen, Germany.
Peter speaks the following languages: German (Native), English (Advanced), French (Elementary), Italian (Elementary).
Peter has at least 44 years of experience. During this time, Peter has worked in at least 66 different roles and for 42 different companies. The average length of individual experience is 1 year and 7 months. Note that Peter may not have shared all experience and actually has more experience.
Based on recent experience, Peter would be well-suited for roles such as: Calculator Redesign, Database Optimization, Inventory.
Peter's most recent position is Calculator Redesign at TD Synnex GmbH & Co. oHG.
In recent years, Peter has worked for TD Synnex GmbH & Co. oHG, HVU Bildungsakademie gGmbH, MV E-Systems UG, COLIFT GmbH, and Fit4Business GmbH.
Peter is most experienced in industries like Education, Manufacturing, and Construction. Peter also has some experience in Automotive, Information Technology, and Banking and Finance.
Peter is most experienced in business areas like Information Technology, Operations, and Logistics. Peter also has some experience in Production, Business Intelligence, and Finance.
Peter has recently worked in industries like Automotive, Information Technology, and Education.
Peter has recently worked in business areas like Information Technology, Business Intelligence, and Finance.
Peter attended F.W. Schubert GmbH for Business Specialist through an integrated vocational education program.
Peter is immediately available for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 6 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Calculator Redesign
Nearby freelancers
Professionals working in or nearby Holzkirchen, Germany
