Jyoti Microsoft Excel (Practical & Job-Oriented)
No reviews yet

Detail-oriented Excel & Power BI professional with strong hands-on experience in data cleaning, formatting, analysis, and dashboard creation. Skilled in transforming raw data into meaningful insights using Excel formulas and Power BI. Adept at supporting business reporting, MIS, and decision-making needs.
SKILLS

Microsoft Excel
• Advanced Excel formulas: VLOOKUP, XLOOKUP, IF, COUNTIF, SUMIF, INDEX-MATCH
• Data cleaning & validation
• Conditional formatting
• Pivot Tables & Pivot Charts
• Excel dashboards & MIS reports
• Data formatting and restructuring

Power BI
• Data import & transformation (Power Query)
• Data modeling & relationships
• DAX basics (measures & calculated columns)
• Interactive dashboards & reports
• Visual storytelling for business insights

Data Handling
• Raw data to structured format
• Removing duplicates & errors
• Standardizing data for reporting
• CSV, Excel, and basic database files

⸻

WORK EXPERIENCE

Excel / Data Analyst (Freelance / Project-Based)
Year – Present
• Cleaned and formatted large Excel datasets for reporting and analysis
• Created automated reports using formulas and Pivot Tables
• Built interactive Power BI dashboards for performance tracking
• Converted raw data into decision-ready MIS reports
• Improved data accuracy and readability for business users
PROJECTS
• Sales Dashboard (Excel & Power BI)
Created a dynamic dashboard showing sales trends, region-wise performance, and KPIs.
• Data Cleaning Project
Cleaned unstructured Excel data by removing duplicates, fixing formats, and validating entries.
ADDITIONAL DETAILS
• Strong analytical and problem-solving skills
• Quick learner with practical approach
• Able to explain data insights clearly to non-technical users

Subjects

  • Excel Beginner-Expert

  • Excel Data Cleaning Beginner-Expert

  • Excel data cleaning and formatting Beginner-Expert

  • Excel cleaning Beginner-Expert

  • Excel analysis and Data entry Beginner-Intermediate

Experience

No experience mentioned.

Education

  • Higher Secondary (Apr, 2004–now) from K V jutogh shimla

Fee details

    ₹1,000–5,000/hour (US$10.53–52.63/hour)

    For extra hours

Reviews

No reviews yet. Be the first one to review this tutor.

© 2016 - 2026 TeacherOn. All rights reserved