Basic Excel: Mastered essential tasks such as navigating worksheets, creating formulas, and designing charts to visualize data effectively. Combining Data: Proficient in using VLOOKUP, HLOOKUP, and XLOOKUP to integrate different datasets seamlessly. Data Transformation using Power Query: Skilled in cleaning, combining, and transforming data for deeper analysis and insights. Pivot Table and Power Pivot: Adept at summarizing large datasets, managing complex calculations, and modeling data to uncover trends and patterns.
Utilized Excel for detailed sales and financial analysis, identifying trends and evaluating performance metrics.
Experienced in creating informative and visually appealing reports that communicate valuable insights clearly and effectively.