I will clean, automate, and craft dynamic Excel dashboards

0 sales

Sold by Nurlan_Jabbarli 0 sales

With a Bachelor's and Master's in Finance, plus 2.5+ years at a Top Investment Bank, I bring precision and insight. My 5+ years in different organizations honed my dashboard creation and automation skills. Let's optimize your Excel experience!

1. Data Cleansing and Transformation: Implement data cleansing and transformation techniques to standardize, validate, and clean datasets, ensuring data integrity and consistency.
2. Financial Reporting: Design professional-looking financial reports and statements, including balance sheets, income statements, and cash flow statements, with dynamic formatting and automated calculations.
3. Financial Modeling: Develop sophisticated financial models for budgeting, forecasting, valuation, and decision-making purposes, incorporating cash flow analysis, NPV calculations, and sensitivity analysis.
4. Scenario Analysis: Create scenario analysis models to evaluate different business scenarios and assess their impact on key performance indicators (KPIs).
5. Data Visualization: Generate compelling visualizations and charts to communicate insights effectively, including slicers, sparklines, and conditional formatting.
6. Automation: Develop advanced automation solutions using Visual Basic for Applications (VBA) to streamline repetitive tasks, generate reports, and enhance productivity.
7. Custom Functions: Create custom functions using VBA to extend Excel's functionality and perform specific calculations or tasks tailored to clients' needs.
8. Macros Optimization: Optimize existing macros and VBA code for performance, readability, and maintainability, incorporating best practices and error handling techniques.
9. Python Integration for Data Consolidation: Utilize Python scripts to automate the process of gathering data from various Excel files, sheets, or external sources, and consolidating them into a centralized dataset.
10. Custom Template Development: Develop tailored Excel templates for specific business processes or reporting needs, ensuring consistency and efficiency in data management and analysis.

1. Basic Package: Data Cleansing and Automation - 40$, delivered in 5 days.
2. Premium Package: Data Cleansing, Automation, and Dynamic Dashboard Creation - 70$, delivered in 10 days.
3. Ultra Package: Comprehensive Excel Transformation with Advanced Financial Modeling and Dashboard Optimization - 100$, delivered in 15 days.

I will clean, automate, and craft dynamic Excel dashboards

  • €40.00

Extra options

All prices are excluding tax and bank fees. The total amount will be calculated during payment.

  1. Order
    your preferred service
    from one of our sellers
  2. Communicate securely via the website’s chat box
    from start to finish
  3. Sellers only get paid
    once you have validated the delivery

About the seller

Nurlan_Jabbarli 17 mars 2024

“With over two years at Morgan Stanley and pivotal roles in Azerbaijan's fintech sector, I combine deep financial expertise with strong technical skills. My seven-year academic journey in Finance, including a Bachelor's and Master's degree, has laid a solid foundation for my career.

I specialize in regulatory reporting, process automation, and data analysis, leveraging skills in MS Office, Python, Alteryx, PowerBI, and SQL. At Morgan Stanley, I've improved reporting processes, leading to significant time savings and enhanced accuracy.

My experience extends beyond technical skills, having mentored interns and volunteered with AIESEC for leadership and project management. My ability to thrive under pressure and a constant pursuit of efficiency make me a valuable asset in fast-paced and challenging environments.”

  • Average response time —
  • Orders in progress 0
  • Sales in total 0
  • Seller since Feb 2024
Learn more