Excel Project Portfolio
Below you can find examples of past and completed projects.
Forms Management Software
Manage fillable forms & reports, automatically collect and save information from forms, and share data between users in real time.
Interested in this application? Learn more.
Dashboard
- Organize, store and display critical information from multiple data sources in one place
- Allow users to easily search and find records
- Users can generate custom reports and load reports on demand with a single click.
Email Campaign Manager
Email campaign manager developed for accountancy firm. Based on multiple criteria, emails are automatically sent out and tracked.
Includes integration with Outlook.
Reports Generator
- Automatically create summary reports (e.g. for revenue or expenditures)
- Specify time period
Data Entry System
Developed for a childcare provider, this data entry system allows for adding, editing and deleting data in a controlled, streamlined environment.
Data Analysis & Visualization
Power Pivot data model which provides deep insights into one’s data.
Web Scraping
Web scraping is the process of automatically collecting large amounts of data from online sources.
Example: A client needed to get the user names from 30,000 instagram pictures. After building a web scraper tool, the information was automatically collected by Excel.
Mosaic Grid Generator Mosaic Grid Generator Mosaic Grid Generator
(finally a bit of Excel Art)
Grid generation software developed for renowned Mosaic artist Helen Marshall. Allows for creating mosaic grids, extracting information from single pictures and locating picture positions.
For example, the program was used in the Rainbows for the NHS project, where a gigantic mosaic consisting of 13,000 pictures was displayed at London Piccadilly Lights.
Excel Calendar
- Pick dates or date ranges and populate cells with selection
- Display holidays for different countries
- Switch between calendar formats (e.g. US format: Sunday to Saturday)
@ 2019 Smart Excel Solutions – Malte Hartmann – malte@smartexcelsolutions.com – Tel.: +49 15752722839 – Get in touch