b
bogishaaa

Bogdan

@bogishaaa

Excel Specialist and Business Analytics Student

Serbie
Anglais, Serbe
Certaines informations sont présentées en anglais.
À propos de moi
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.... Plus d’infos

Compétences

b
bogishaaa
Bogdan
hors ligne • 

Voir mes services

Nettoyage des données
I will do professional excel data cleaning, formulas, and redesign
De15 $US / projetPlus de détails
Formules & Macros
I will create excel bill of materials
De15 $US / projetPlus de détails

Portfolio

Expérience professionnelle

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.