Subrata Saha Excel, Tally Prime
No reviews yet

✅ Extended Profile Description – Excel Expert

Highly proficient Microsoft Excel Specialist with a proven track record of delivering efficient, automated, and insightful spreadsheet solutions to meet diverse business needs. Over [X] years of hands-on experience in designing, developing, and maintaining complex Excel workbooks across various industries, including finance, supply chain, sales, HR, and analytics.

I specialize in solving business problems through Excel-based tools, enabling data-driven decisions, streamlining workflows, and eliminating manual errors through automation and robust design.

🛠️ Areas of Expertise:

Advanced Excel Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP, IF/IFS, SUMIFS, COUNTIFS, TEXT functions, and array formulas.

Data Analysis & Visualization: PivotTables, Conditional Formatting, Dynamic Charts, Slicers, Interactive Dashboards.

Data Automation & Cleanup: Power Query (Get & Transform), Data Cleaning Routines, Automated Import/Export of Data.

Data Modeling: Power Pivot, DAX formulas, and relational data models within Excel.

Cross-Tool Integration: Excel with Power BI, SQL databases, Access, SharePoint, and Google Sheets.

🧠 What I Bring to the Table:

Ability to translate complex requirements into easy-to-use Excel tools.

Strong focus on data integrity, scalability, and user experience.

Deep understanding of business processes, allowing me to create tailored Excel models that support real-world workflows.

Collaborative approach—I work closely with teams to ensure tools are not only technically sound but also aligned with business goals.

🧾 Example Projects Delivered:

Built a fully automated sales dashboard with real-time KPI updates using Power Query and PivotTables.

Developed an HR workforce planning tool that projected hiring needs, attrition, and headcount costs.

Created a budget vs. actual tracker integrated with finance databases for a large enterprise.

Automated repetitive month-end reporting tasks with Excel macros, saving 20+ hours per month.

📈 Industries Served:

Finance & Accounting

Supply Chain & Logistics

Sales & Marketing Analytics

HR & Workforce Management

Education & Training

E-commerce Operations

🎯 Ideal For:

Businesses needing custom Excel tools to support operations

Teams overwhelmed by manual reporting and repetitive data tasks

Professionals seeking to upgrade legacy spreadsheets into efficient, automated systems

Managers needing decision-support dashboards built in Excel

Would you like a version tailored to a resume, freelancer platform (like Upwork), or LinkedIn? Let me know the target use—I can adapt the language to match. Also, if you share your actual experience (years, industries, notable projects), I can personalize it further.

Subjects

Excel Beginner-Expert
Tally Prime GST Beginner-Expert

Experience

Process Associate (Jan, 2023–Present) at 3+ years of experience in Tata Consultancy service Hyderabad

Accounting

Education

B.COM (Jan, 2015–Dec, 2017) from Calcutta university,

Fee details

₹200–1,000/hour (US$2.11–10.53/hour)

Courses offered

Excel
- ₹100
- Duration: 2 Hours
- Delivery mode: Flexible as per the student
- Group size: Individual
- Instruction language: English
- Certificate provided: No
Work Description:

Developed and maintained complex Excel workbooks for data analysis, budgeting, reporting, and forecasting.

Created dynamic PivotTables and PivotCharts to summarize and visualize large data sets.

Utilized Power Query to clean, transform, and merge large data sets from various sources (CSV, Excel, SQL).

Designed interactive dashboards using formulas, slicers, drop-downs, and conditional formatting for senior management.

Automated repetitive tasks and reports using VBA macros, saving time and reducing manual errors.

Built scalable financial models and scenario analysis tools for business planning.

Performed advanced data analysis using functions such as INDEX-MATCH, XLOOKUP, IFERROR, TEXT, INDIRECT, and array formulas.

Ensured data accuracy and consistency through data validation, protection, and auditing tools in Excel.

Integrated Excel reports with external tools like Power BI, Google Sheets, and SharePoint.

Trained team members on best practices in Excel usage, formulas, and data management techniques.

📌 Excel Work Description by Function
🔹 Data Analysis & Reporting

Cleaned and prepared raw data for analysis using Power Query.

Built custom reports with PivotTables, slicers, and filters to support data-driven decisions.

Applied statistical functions to analyze trends, outliers, and KPIs.

🔹 Financial Modeling & Budgeting

Developed complex financial models (cash flow, P&L, balance sheet).

Created monthly and quarterly budget templates with dynamic projections.

Linked Excel models to real-time data feeds for up-to-date analysis.

🔹 VBA & Automation

Wrote custom VBA macros to automate data imports, report generation, and formatting.

Designed user-friendly interfaces in Excel using form controls and VBA code.

Reduced manual work by automating repetitive tasks (e.g., email reports, data refreshes).

🔹 Dashboard Creation

Created professional dashboards with conditional formatting, charts, KPI indicators, and interactive components.

Used formulas and visual elements to create self-updating performance trackers.

Connected dashboards to multiple data sources using Power Query.

🔹 Data Validation & Quality Control

Set up data validation rules to restrict incorrect inputs.

Used conditional formatting to highlight anomalies and outliers.

Developed audit tools to trace errors and inconsistencies in datasets.

📎 Sample Excel Project Descriptions

Here are a few specific examples you can use or modify:

Sales Tracker Automation:

Designed an Excel-based sales tracker for a retail business with automatic commission calculations, monthly summaries, and visual dashboards.

Automated monthly reporting using VBA, reducing manual effort by 80%.

Inventory Management Tool:

Built a dynamic inventory tool that tracked stock levels, reorder points, and supplier details.

Included alerts for low stock and expiry dates using conditional formatting and formulas.

Payroll Calculator:

Created a multi-sheet Excel payroll system with tax and deduction logic, integrated leave tracking, and payslip generation.

KPI Dashboard:

Built a real-time business performance dashboard for the management team using Power Query and PivotTables.

Enabled filtering by department, region, and product category.