Tanu rai Excel
No reviews yet

Capturing and recording important data. Some workplace tasks may involve recording information in an Excel spreadsheet.
Using shortcuts and formula functions.
Building charts and graphs.
Sorting and filtering data.
Utilizing pivot tables.
Data Analyst
[nihon kohntsu india pvt ltd], [gurgaon, haryana]
[jan, 2021] – Present

Developed complex financial models and forecasts using advanced Excel functions to support strategic decision-making.
Automated data processing tasks using VBA, reducing manual work by 50% and increasing efficiency.
Created dynamic dashboards and reports for senior management, providing actionable insights through data visualization.
Conducted data cleaning and validation to ensure the accuracy and integrity of datasets.
Collaborated with cross-functional teams to gather requirements and deliver customized Excel solutions.
Financial Analyst
[munjal kiriu], [[gurgaon, haryana]
april, 2018] – [jan,2021]

Built and maintained financial models to analyze business performance and forecast future trends.
Utilized PivotTables and PivotCharts to summarize and present large datasets effectively.
Conducted variance analysis to identify discrepancies between actual and budgeted financial results.
Automated routine financial reporting tasks using Excel Macros, saving the finance team significant time.
Prepared detailed financial reports and presentations for executive leadership.
Analyzed business processes and identified opportunities for improvement using Excel-based solutions.
Developed and maintained comprehensive Excel dashboards to monitor key performance indicators (KPIs).
Implemented Power Query and Power Pivot to handle and analyze large datasets more efficiently.
Provided training and support to team members on advanced Excel techniques and best practices.
Conducted statistical analysis to support market research and business development initiatives.
Certifications
Microsoft Office Specialist: Excel Expert
Data Analysis and Visualization with Excel (Coursera)
Financial Modeling & Valuation Analyst (FMVA)®
Projects
Automated Sales Reporting System

Developed an automated sales reporting system using VBA, reducing the report generation time from hours to minutes.
Comprehensive Financial Dashboard

Created a financial dashboard that consolidated data from multiple sources and provided real-time insights into financial performance.
Customer Segmentation Analysis

Conducted a customer segmentation analysis using Excel to identify key customer groups and tailored marketing strategies accordingly.

Subjects

  • Excel & Research Data Analysis Expert

  • Data analysis in Excel Expert

Experience

No experience mentioned.

Education

  • MBA( Hr & Marketing) (Sep, 2015–Jun, 2017) from Bansthali vidhyapith,rajsthan

Fee details

    ₹800–1,500/hour (US$9.51–17.84/hour)

Reviews

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