EXCEL PROJECTS
These are the projects that I have executed using MS Excel.
The main focus of this project was to clean the data within excel and later on analyze it using pivot tables. In the cleaning process, duplicate data was removed, data was converted to showcase correct formatting, and additional columns were added to simplify the data for analytical purposes. For example, with the help of nested IF statements a new column for "Age" was created to fit the data within three brackets: Adolescent, Middle Age, and Old. This helped in the second graph for simple data visualization.
After the data was cleaned, pivot tables were used to convert the data into meaningful information. Furthermore, to properly visualize the data, proper charts were inserted. Lastly, a simple dashboard was created along with slicers on the left to further filter the data according to need.
