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
Earnings and projects
An estimate from an earlier read
Billed in all: $6,126$6.1k
Across 44 contracts
Earnings, last 30 days
No data since Nov 5, 2026.