Profile

  • Projects 12
  • Rating 4.7
  • Rating 986
Register

If you have an account, log in

Indicators

  • Last project: 6 months back
  • Bids in the last two weeks: 29
  • Collaboration with clients: 12
  • Last visit: 21 hours 48 minutes ago

CV

Expertise Profile: Excel and Automation

Key Competencies:

  • Development and automation of Excel projects: creating efficient tools for data processing, analysis, and visualization
  • Building custom dashboards using conditional formatting, pivot tables, formulas, and Power Query
  • Workflow optimization through integration of VBA macros and scripts to reduce routine tasks
  • Creation of structured reporting templates with flexible filtering and time-period parameters
  • Data visualization: designing charts, diagrams, and infographics to simplify the perception of key metrics

Experience with Big Data:

  • Handling large datasets (100,000+ rows) using Power Query, Power Pivot, and external sources (CSV, SQL, API)
  • Building reports with dynamic updates and connections across multiple data sources
  • Utilizing tools for trend analysis, anomaly detection, and data classification

Examples of Completed Projects:

  • Automated financial performance monitoring system for small businesses
  • Excel-based content planning app with auto-formatting and dynamic filtering
  • Visual tracker for TikTok/Telegram metrics with integrated analytics and PDF report generation

Tags

Skills and abilities

Services

Programming

Outsourcing & consulting

Translation

Writing