Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Subrato Samadda
@subrato7331
I will create dynamic Excel dashboards, formulas, and PDF to Excel conversion
Inde
Anglais, Hindi, Bengali
À propos de moi
Hi! I’m a professional Data Analyst and Advanced Excel Expert dedicated to turning complex data into clear, actionable insights. I specialize in accurate data cleaning, PDF to Excel conversion, dynamic visualization, interactive Excel dashboards, and VBA/macro automation to streamline your workflow and save you hours of manual labor.
Whether you need robust financial modeling, custom Excel formulas, or efficient data transformations, I deliver secure and user-friendly solutions tailored to your business. Let’s transform your data into a powerful asset—message me today to get started!
Compétences
Subrato Samadda
hors ligne •
Voir mes services
Nettoyage des données
I will do excel spreadsheet formatting,excel report formatting
Portfolio
Expérience professionnelle
MIS Executive
New Beginnings • Temps plein
Apr 2017 - Nov 2024 • 7 yrs 7 mos
**Achievements as MIS Executive – MyTasker** * Managed and maintained large volumes of business data using Microsoft Excel, ensuring high levels of accuracy and data integrity. * Developed and automated MIS reports to support daily, weekly, and monthly business operations, reducing manual effort and improving reporting efficiency. * Created interactive dashboards using Pivot Tables, Pivot Charts, slicers, formulas, and conditional formatting to provide actionable business insights. * Cleaned, validated, and standardized raw datasets by removing duplicates, correcting inconsistencies, and resolving data quality issues before reporting. * Utilized advanced Excel functions such as XLOOKUP, VLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, TEXT, and DATE functions to streamline data analysis. * Consolidated data from multiple sources using Power Query, enabling faster report generation and improved decision-making. * Generated performance reports, KPI summaries, and management dashboards that helped stakeholders monitor business performance effectively. * Performed regular data audits and reconciliations to ensure report accuracy and compliance with organizational standards. * Collaborated with cross-functional teams to understand reporting requirements and deliver customized MIS solutions within agreed timelines. * Improved spreadsheet usability through professional formatting, structured layouts, data validation, and error-checking techniques. * Reduced report preparation time by implementing reusable Excel templates and automated workflows. * Demonstrated strong analytical, problem-solving, and time-management skills while handling multiple reporting tasks in a fast-paced virtual work environment. **Key Skills:** Advanced Excel, Pivot Tables, Pivot Charts, Power Query, Data Cleaning, Data Validation, Dashboard Creation, Report Automation, Data Analysis, MIS Reporting, Data Formatting, Business Reporting, KPI Tracking, Excel Formulas, Microsoft Office.
