08/13/2025 updated


100 % available
Excel & VBA Expert | Automation, Dashboards & Data
marrakech, Morocco
Morocco
Specialization in Excel Automation & Data AnalysisApplication Programming Interfaces (APIs)Data AnalysisTechnical SupportTeachingAutomationBusiness ProcessesDatabasesData CleansingFile SystemsExcel FormulasExcel Pivot TablesOffice SuitePivot TableVisualizationRaw Data
I am a highly skilled Excel & VBA Developer with several years of experience delivering customized, efficient, and user-friendly solutions for businesses and individuals. My expertise covers everything from advanced Excel automation to interactive dashboards and data analysis, allowing my clients to save time, reduce errors, and make better decisions based on accurate, well-presented information.
Over the years, I have worked on a wide range of projects, including:
In addition to development work, I also offer online tutoring in Excel, VBA, and data analysis. I have helped students, professionals, and small business owners improve their skills, from complete beginners to advanced users. My teaching style is practical, clear, and adapted to your pace, ensuring you can apply what you learn immediately to real-world situations.
Core Skills & Tools:
Let’s work together to transform your Excel challenges into streamlined, automated, and visually impactful solutions.
Over the years, I have worked on a wide range of projects, including:
- VBA Automation: Creating macros to automate repetitive tasks such as data cleaning, report generation, file processing, and importing/exporting data between Excel, CSV, and other formats.
- Dashboard Design: Building visually appealing and interactive dashboards that summarize key business metrics and allow for dynamic filtering and analysis.
- Data Analysis & Visualization: Using formulas, pivot tables, Power Query, and charts to transform raw data into actionable insights.
- Complex Formulas & Logic: Implementing advanced functions such as INDEX-MATCH, dynamic arrays, conditional formatting, and nested logic for tailored reporting.
- Integration with Other Tools: Connecting Excel with external databases, APIs, or other Office applications (Outlook, Word, PowerPoint) for seamless workflows.
In addition to development work, I also offer online tutoring in Excel, VBA, and data analysis. I have helped students, professionals, and small business owners improve their skills, from complete beginners to advanced users. My teaching style is practical, clear, and adapted to your pace, ensuring you can apply what you learn immediately to real-world situations.
Core Skills & Tools:
- Microsoft Excel (all versions, including Office 365)
- VBA programming and macro automation
- Power Query & Power Pivot
- Pivot tables, advanced formulas, and conditional formatting
- Data cleaning and transformation
- Dashboard design and business reporting
- Integration with other MS Office apps
- Online teaching and technical support
Let’s work together to transform your Excel challenges into streamlined, automated, and visually impactful solutions.
Languages
ArabicNative speakerEnglishFluentFrenchNative speaker
Project history
1. Excel VBA Automation for Simulation Data Processing
- Description: Developed a VBA tool that automatically retrieves local simulation files, applies user-selected filters (task type, subgroup, monthly sprint), and exports results to .xlsx for automated reporting.
- Result: Reduced manual processing time from 4 hours to 15 minutes, eliminating human errors.
- Description: Created an Excel dashboard linked to employee attendance, leave records, and backup manager assignments. Included slicers, heatmaps for weekly availability, and automatic updates when data changes.
- Result: Improved decision-making speed and accuracy in workforce planning.
- Description: Designed a multi-sheet Excel template for monthly and yearly budget tracking, profit & loss projections, and savings management.
- Result: Provided clear visibility on expenses and revenues, allowing the client to identify cost-saving opportunities.
- Description: Delivered personalized online lessons in Excel formulas, VBA programming, and dashboard creation.
- Result: Helped over 20 learners improve their Excel skills for academic, personal, and professional use.
- Description: Built a lot-number-based inventory tracker in Excel with product quantities, expiry alerts, and order tracking features.
- Result: Reduced stock discrepancies and improved order fulfillment time.