This repository contains my work in Microsoft Excel.
The Income Survey aims to collect data from participants regarding their income and financial status. The data is then used to analyze and gain insights into the distribution of income levels, identify trends, and inform decision-making processes.
Survey Design: The survey is designed in Excel, a widely accessible and user-friendly spreadsheet software. Excel provides a familiar interface for participants to input their responses, making it easier to gather data from a diverse group of respondents.
Dashboard Creation: The dashboard is a visual representation of the survey data, presenting key metrics and trends in a clear and concise manner.
Data Visualization: Excel's charting and graphing capabilities are utilized to create various visualizations such as bar charts, pie charts, line graphs, and histograms. These visuals help in presenting the income distribution, average income, income categories, and other relevant insights.
Interactive Elements: Excel allows for the creation of interactive elements within the dashboard, such as drop-down lists, checkboxes, and slicers. These interactive features enable users to filter and explore the data dynamically, gaining deeper insights based on their preferences.
Basic Knowledge of Pivot Tables, Basic, Charts, and formatting in Excel.
Excel for the Income Survey and Dashboard offers a practical and efficient way to collect, analyze, and present income-related data. With its features for data visualization, analysis, and interactivity, Excel can help researchers and decision-makers gain valuable insights from survey data.