08/13/2025 updated

**** ******** ****
100 % available

Excel & VBA Expert | Automation, Dashboards & Data

marrakech, Morocco
Morocco
Specialization in Excel Automation & Data Analysis
marrakech, Morocco
Morocco
Specialization in Excel Automation & Data Analysis

Application Programming Interfaces (APIs)Data AnalysisTechnical SupportTeachingAutomationBusiness ProcessesDatabasesData CleansingFile SystemsExcel FormulasExcel Pivot TablesOffice SuitePivot TableVisualizationRaw DataElearningWorkflowsExcel SolverVba Programming Language
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:
  • 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.
What makes my work stand out is my client-focused approach. I take the time to fully understand your needs, design the most efficient solution, and provide clear documentation so you can use and maintain the tools confidently. I aim not just to “deliver a file,” but to create a real time-saving asset for your business.
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
I am passionate about creating solutions that combine technical accuracy with visual clarity. Whether you need to automate a manual process, analyze complex data, or learn Excel from scratch, I can help you achieve your goals efficiently and professionally.
Let’s work together to transform your Excel challenges into streamlined, automated, and visually impactful solutions.

Languages

ArabicNative speakerEnglishFluentFrenchNative speaker

Project history

Data Processing

Other

10-50 team member

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.
2. Dynamic Dashboard for HR Management
  • 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.
3. Financial Analysis Template
  • 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.
4. Online Excel & VBA Tutoring
  • 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.
5. Inventory Management Tool
  • 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.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in