I will teach excel and perform advanced data analysis

India

I speak Telugu, English, Hindi

1 order completed

Data Analysis, MS Excel, Data transformation, Automation, Visualizatio

Data analyst with 6+ years of experience working with leading consulting firms. Demonstrated experience in working with large data sets, creating excel models, generating insights and creating dashbo...
About this Gig

I will teach you Excel in a highly practical, real-world way:

Beginner to Intermediate

  • Basic formulas (SUM, IF, VLOOKUP, COUNTIFS)
  • Sorting, filtering, data formatting
  • Pivot tables
  • Data cleaning best practices

Advanced Excel

  • Power Query
  • Power Pivot + DAX basics
  • Nested formulas
  • INDEX-MATCH / XLOOKUP
  • Advanced conditional logic
  • Array formulas

Automation & Productivity

  • How to build templates
  • Smart data models
  • Workbook automation (no coding needed)
  • Handling large data efficiently

Each session is live, interactive, and task-oriented.


ADVANCED DATA ANALYSIS SERVICES

If you want me to do the work for you, choose the analysis packages:

Business Analysis

  • Sales data analytics
  • Profitability insights
  • KPI dashboards
  • Monthly/quarterly reporting sheets

Financial & Trading Analysis

  • OHLC + indicator calculations
  • Pivot table driven reports
  • Rolling returns / moving averages
  • Risk/volatility modelling

Automation & Data Transformation

  • Power Query data pipelines
  • Merging multiple files
  • Cleaning messy datasets
  • Converting raw data into structured tables

Dashboards (Professional & Clean)

Includes:

  • Interactive slicers
  • Graphs & KPI cards
  • Dynamic charts
  • Auto-refresh datasets

Technology:

Excel

•

Power BI

Analysis type:

Quantitative analysis

•

Qualitative analysis

Expertise:

Business Insights

•

Business intelligence

Programming language:

Other