You will get Data Extraction | Python Utility | Access, SQL Database | Excel VBA macro
Top Rated
Top Rated
Project details
I developed this Python Tkinter GUI, Microsoft Access & Excel VBA Integration utility for a client.
Furthermore, I also own the following skillset:
1. Basic Excel (Simple Manual Excel Assistance)
✅ Excel Formatting, Formula, Built-in & Custom Functions
✅ Manual Excel Data Entry for Google OR Excel spreadsheets
✅ Spread Sheet in Excel Designed and Dashboard
✅ Short-term Excel Work like Data Formatting etc in Excel Docs
2. Excel Automation (VBA Macros, Custom Formulas):
✅ KPI in Excel Chart, Pivot Tables, Graphs etc
✅ Automatically create Excel Invoices, Reporting, and Templates and Make PDF Files
✅ Develop Excel Macros for Automated Data Entry
✅ VBA Developer (Visual Basic for Applications)
✅ VBA Excel helps Data Cleaning super-fast
3. VBA Programming for Management Solutions & Financial Modeling:
✅ Excel Dashboards
✅ MS Excel Interactive Forms (Dynamic Controls & UI)
✅ VBA Functions to turn Microsoft Spreadsheet into an Excel Database
✅ Convert Google / PDF to Excel Sheets
✅ Super-fast Data Analysis with Advanced Excel Skills
✅ Excel Add-ins (VSTO) for Excel Office. (MS Access, Word, PowerPoint) and VBA APIs Integration with many other services using Excel Macro
Furthermore, I also own the following skillset:
1. Basic Excel (Simple Manual Excel Assistance)
✅ Excel Formatting, Formula, Built-in & Custom Functions
✅ Manual Excel Data Entry for Google OR Excel spreadsheets
✅ Spread Sheet in Excel Designed and Dashboard
✅ Short-term Excel Work like Data Formatting etc in Excel Docs
2. Excel Automation (VBA Macros, Custom Formulas):
✅ KPI in Excel Chart, Pivot Tables, Graphs etc
✅ Automatically create Excel Invoices, Reporting, and Templates and Make PDF Files
✅ Develop Excel Macros for Automated Data Entry
✅ VBA Developer (Visual Basic for Applications)
✅ VBA Excel helps Data Cleaning super-fast
3. VBA Programming for Management Solutions & Financial Modeling:
✅ Excel Dashboards
✅ MS Excel Interactive Forms (Dynamic Controls & UI)
✅ VBA Functions to turn Microsoft Spreadsheet into an Excel Database
✅ Convert Google / PDF to Excel Sheets
✅ Super-fast Data Analysis with Advanced Excel Skills
✅ Excel Add-ins (VSTO) for Excel Office. (MS Access, Word, PowerPoint) and VBA APIs Integration with many other services using Excel Macro
Programming Languages
C#, Python, VB, JavaScriptOperating System
WindowsDevelopment Technology
Microsoft Excel, MySQL, Powershell, WinformsDesktop App Expertise
App Design, Application Setup & Installation, Development, Software Debugging, Performance Optimization, Application Review & OptimizationWhat's included $50
These options are included with the project scope.
$50
- Delivery Time 3 days
- Number of Revisions 3
- Source Code
- Setup File
- Detailed Code Comments
Optional add-ons
You can add these on the next page.
Fast 1 Day Delivery
+$100
Additional Revision
+$30
Provisioning of following features depends on the Project Cost & Scalablity
+$1
66 reviews
(63)
(1)
(0)
(2)
(0)
This project doesn't have any reviews.
BW
Benn W.
May 28, 2026
RCTI Automation - Sample blanks and further use of app
BW
Benn W.
Jun 10, 2025
RCTI Automation
Very impressed with his knowledge and willingness to want the job to the be perfect before excepting payment. Highly recommend.
BL
Ben L.
Feb 20, 2025
Excel Analysis - Optimization Of Formulas
Great work!
AS
Automotive S.
Feb 19, 2025
Advanced Excel Data Manipulation Specialist for E-commerce Inventory Management
AS
Automotive S.
Dec 24, 2024
Advanced Excel Data Manipulation Specialist for E-commerce Inventory Management
About Ishtiaque
Excel VBA Automation Expert | Power BI Developer | Python Data Analyst
100%
Job Success
Kasur, Pakistan - 9:09 pm local time
What I bring: ✅ Advanced Excel — Pivot Tables, Power Query, Power Pivot, complex formulas, VBA/Macro automation ✅ Power BI dashboard development — KPI tracking, performance & revenue reporting ✅ Python for data processing, automation pipelines, and Excel/database integration ✅ SQL (PostgreSQL, MySQL, SQL Server, SQLite) and Microsoft Access for structured data work ✅ Google Sheets + Apps Script automation
Track record:
Automated reporting workflows, cutting manual effort by up to 85%
Processed and validated datasets with 10M+ records
Delivered 50+ interactive dashboards for operational and financial reporting
Completed 150+ analytics/automation projects across logistics, finance, sales, inventory, and government sectors
Recent examples of my work: building a fully automated visitor management system in Excel/VBA with a live dashboard, running recurring invoice reconciliation and shipment analytics automation for a logistics company (SMSA Express, Riyadh), and developing a Python-based fuzzy-matching data classification pipeline with confidence scoring.
I focus on solutions your team can actually maintain — clear documentation, clean structure, no black boxes. 100% Job Success, Top Rated, 80 plus (out of 112 completed jobs) five-star reviews.
Have a manual process that's outgrown Excel, a dashboard that needs to actually drive decisions, or a dataset too large/messy for spreadsheets alone? Let's talk.
1. Custom Automated Visitor Management System (Excel VBA + Dashboard):
Built a fully automated visitor management system in Excel using VBA — replacing manual sign-in logs with a tool that auto-updates a live dashboard. Eliminated data entry errors and cut admin time for the client's front-desk process.
2. MS Excel-Based Inventory & Accounting System:
Designed a complete inventory management and accounting application inside Excel, combining VBA automation with structured data validation — giving the client a lightweight, budget-friendly alternative to dedicated inventory software.
3. RCTI Automation System (repeat client, multiple contracts 2025–2026)
Built and maintained an automated RCTI (Recipient Created Tax Invoice) generation system, including sample-based testing and ongoing feature extensions. Long-term repeat engagement — client returned for further automation work across multiple contracts.
4. Generic-to-Specific Data Classification with Fuzzy Matching (Python)
Designed a Python-based data-matching pipeline using fuzzy matching and confidence scoring to automatically classify generic product/data entries into specific categories — reducing manual classification work on a large dataset.
5. Logistics Invoice Reconciliation & KPI Dashboard (SMSA Express, Riyadh)
Built Excel/VBA-based automation for invoice reconciliation and shipment analytics, plus a Power BI dashboard tracking performance and revenue KPIs — supporting operational decision-making for a regional logistics provider.
Skillset includes:
Microsoft Excel · Excel VBA · Macro Programming · Power Query · Automation · Data Analysis · Microsoft Power BI Data Visualization · Python · SQL · Data Visualization · Data Cleaning · Financial Modeling · Google Sheets · Spreadsheet Software · File Conversion
Steps for completing your project
After purchasing the project, send requirements so Ishtiaque can start the project.
Delivery time starts when Ishtiaque receives requirements from you.
Ishtiaque works on your project following the steps below.
Revisions may occur after the delivery date.
Get your prototype before going too deep
At this step, I will deliver a prototype which will build up a mutual confidence on understanding of project outcomes.