Skip to content
BackNov 5
Anouar E.

Anouar E.

Expert VBA & Automation & Visualizations & Data Analysis

✔ +10 years of professional experience ✔ Engineering Degree ✔ Expert in Excel (Using tools, formulas, pivot tables/charts, dashboard and all functions) ✔ Expert in VBA (Programming and Macros) ✔ Best proficient in Data analytics professional ✔ Web development --------------------------------------------------------- * Provide a simple and faster solution for the more complicated projects * Suggest automation whenever possible to mitigate risks and increase productivity. * Do an extra effort to guarantee the perfect solution * Calm, Rigor, Organization, Attention to detail and Total Respect for deadlines --------------------------------------------------------- ✔ Microsoft Excel : - Perfect mastery of complex functions and conditions in calculation formulas (VLOOKUP, INDEX, MATCH, INDIRECT, CONCATENATE, NBCAR, FIND & REPLACE, ADDRESS, VAR(s), NB(s), SUM(s), DATE(s), If(s) and all other Logic Functions...) - Using Complex Formulas (Functions & Conditions) in Conditional Formatting - Creation of complex pivot tables - Creation of complex and dynamic graphs and tables - Realization of dashboards & Reports - Modeling of simulations and solvers - Strong mastery of layout and Formatting ✔ Microsoft Word : - Creation of manuals and user guide - Strong mastery of layout and Formatting ✔ VBA "Visual Basic for Application" - Creation of functions and conditions in complex loops (Find, Remove Duplicate, Copy/Paste, Count, etc.) with regular comments - Creation of dynamic and conditional formatting - Creation of dynamic and complex pivot tables - Creation of dynamic and complex graphs and tables - Creation of profiles sessions with limitation of access - Creation of forms / dialog boxes / Interfaces with better views - Creation of dashboards and reports - Customize and hide bars, ribbons and tools - Import/export and analyze data from other files (CSV, Excel and TXT) - Create communication between Outlook and Excel - Use of APIs for interaction with the operating system - Using XML and mapping websites ✔ Data Cleaning ✔ Data Analysis ✔ Data Visualization to generate insightful tables, charts and reports

🇲🇦Casablanca, Morocco$30/hr100% JSS4.77 (28)Since Sep 2020

Earnings and projects

MRR (estimate)
≈$0

An estimate from an earlier read

World#237,966 / 412k
🇲🇦Country#809 / 1,706
Revenue, last 30 days
$0
Total earnings
$6.1k

Billed in all: $6.1k

World#237,966 / 412k
🇲🇦Country#809 / 1,706
Per project
$152
Projects, last 6 months
0
World#209,850 / 412k
🇲🇦Country#872 / 1,706
Projects in all
40

Across 44 contracts

57% fixed43% hourly
World#75,668 / 412k
🇲🇦Country#244 / 1,706

Earnings, last 30 days

$6.1kNothing earned in the last 30 daysBilled in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$6.0k$6.1k$6.2k$6.3kOct 8Oct 23Nov 7

No data since Nov 5, 2026.

Skills