I will do any excel task, power query, power pivot, vba, macro, dashboard, or da

Egypt

I speak English, Arabic

2 orders completed

- Organizing data related to sales numbers, market research, logistics, linguistics, or other behaviors. - Utilizing technical expertise to ensure data is accurate and high-quality. - Using automated ...
About this Gig

Need an Excel expert who can solve almost anything in Microsoft Excel?

You've come to the right place.

I am a professional Excel specialist with hands-on experience in advanced spreadsheet development, data analysis, automation, reporting, and business intelligence solutions. Whether you need a simple formula fix or a complete Excel-based system, I can deliver accurate, efficient, and professional results.

Services Included

Excel Formulas & Functions

  • XLOOKUP, VLOOKUP, HLOOKUP
  • INDEX/MATCH
  • SUMIFS, COUNTIFS
  • IF, IFS, SWITCH
  • Dynamic Array Functions
  • TEXT, DATE, and Logical Functions
  • Advanced Formula Troubleshooting

Data Analysis & Reporting

  • Data Cleaning & Transformation
  • Large Dataset Processing
  • Data Validation
  • Statistical Analysis
  • KPI Reporting
  • Business Reports
  • Trend Analysis

Power Query (ETL)

  • Importing data from multiple sources
  • Data transformation and cleansing
  • Merging and appending tables
  • Automated refresh processes
  • Building repeatable data workflows

Power Pivot & Data Modeling

  • Data Model Creation
  • Relationships Between Tables
  • DAX Measures & Calculated Columns
  • Business Intelligence Reporting
  • Advanced Analytics
  • Star Schema Design

Dashboards & Visuali

Technology:

Excel

Google Analytics

Google Sheets

Power BI

VBA

Analysis type:

Quantitative analysis

Qualitative analysis

Expertise:

Business Insights

Statistics

Business intelligence

Programming language:

Python

SQL

DAX

My Portfolio