Advanced Excel Projects
Project 1 - Chocolate Sales Dashboard
I've developed a Sales Dashboard in Excel, employing advanced functions to enhance reporting capabilities. Key features include linking and filtering with images within Excel data, utilizing functions like Offsets, Index, and Sort By. Pivot tables and charts facilitate data analysis, supported by the integration of advanced Excel formulas for comprehensive insights.
Project 2 - Super mart Sales Dashboard
I developed an Excel Sales Dashboard using a sample dataset from a supermarket store, featuring user-friendly visuals. The dashboard incorporates essential elements like slicers, pivot charts, off-set functions, and pivot tables for comprehensive data analysis. This project honed my skills in Excel functions, data visualization, and report creation, providing valuable hands-on experience.