Vikram bist Microsoft excel
No reviews yet

I’m Vikram bist, an Advanced Excel professional with 6+ years of expertise in building custom dashboards, automating reporting workflows, and transforming raw data into actionable insights. My proficiency in Excel VBA, Power Query, Power Pivot, and advanced formulas allows me to deliver solutions that save time and enhance decision-making. With a passion for detail and problem-solving, I’ve helped clients across various industries streamline processes and unlock the full potential of their data
Excel Automation: VBA macros to streamline repetitive tasks.

Data Modeling: Power Pivot and DAX for complex analysis.

Data Transformation: Power Query for efficient data cleansing and reshaping.

Advanced Formulas: Dynamic arrays, nested functions, and troubleshooting.

Custom Dashboards: Interactive visualizations for real-time decision-making.

Reporting: MDX cube formulas and custom-built templates for scalable reporting.

Integration: Seamless data flows between Excel and Power BI.

Optimization: Performance tuning for large datasets and formula efficiency.

Subjects

  • Microsoft Excel Beginner-Expert

Experience

  • MIS HEAD (Aug, 2021–Nov, 2024) at Commqui technologies pvt ltd Thane
    Sales Performance Dashboard: Automated tool tracking key metrics by region, team, and product.

    Financial Projection Model: Created a scenario-based budgeting tool using Power Pivot and advanced formulas.

    Custom Reporting Template: Designed a reusable template automating multi-source data aggregation.

Education

  • Higher Secondary (Mar, 2008–Mar, 2009) from National Institute of open Schooling

Fee details

    ₹600–1,000/hour (US$7–11.66/hour)

Reviews

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