b
bogishaaa

Bogdan

@bogishaaa

Excel Specialist and Business Analytics Student

Serbia
English, Serbian
About me
Hello! I'm Bogdan Krstevski, a Business major in Operations Management at FON, University of Belgrade. I turn messy sales, supply chain, and operational datasets into clean, automated, and executive-ready Excel spreadsheets. What I offer: • Data Cleaning: Fixing misaligned columns, missing/null values, and duplicates. • Advanced Formulas: Proficient in XLOOKUP, VLOOKUP, HLOOKUP, IFS, IFERROR, and LET. • Smart Data Controls: Custom Data Validation drop-downs for error-proof entry. • Executive Redesign: Professional color-coded headers, zebra striping, and clean conditional formatting.... Read more

Skills

b
bogishaaa
Bogdan
Offline • 

See my services

Data Cleaning
I will do professional excel data cleaning, formulas, and redesign
From$15 / projectMore details
Formulas & Macros
I will create excel bill of materials
From$15 / projectMore details

Portfolio

Work experience

Freelance

Freelance Data Analyst

Freelance

Oct 2026 - Present • 1 mo

Data Analyst & Excel Specialist Specialized in raw data cleaning, dataset restructuring, and business performance reporting for clients. Key Responsibilities & Core Skills: • Data Cleaning & Restructuring: Cleaning messy raw system exports (PDF/CSV/XLSX), fixing column misalignments, correcting data types, and removing duplicate values. • Financial & Business Modeling: Rebuilding dynamic formulas for revenue, profit margins, VAT, and sales commissions. • Automation & Validation: Setting up interactive Data Validation drop-down controls, custom popup guidance, and conditional formatting rules. • Data Analytics & Visualization: Constructing automated Pivot Tables, dynamic array matrix views (PIVOTBY), and multi-chart dashboards for management presentations.