Excel 2021 Guided Project 5-3 Tutorial

Introduction to Excel 2021 Guided Project 5-3

In this guided project, we will be exploring the features of Excel 2021, focusing on data analysis and visualization. The project is designed to help users understand how to work with data in Excel, create charts and graphs, and use various tools to analyze and interpret data. By the end of this project, users will have a solid understanding of how to use Excel to make informed decisions based on data analysis.

Step 1: Setting Up the Data

To begin, we need to set up our data in Excel. This involves creating a table with the relevant data, including headers and columns. We will be working with a sample dataset that includes sales data for a company. The dataset includes columns for the date, product, sales amount, and region.

• Create a new Excel spreadsheet and give it a title.
• Create a table with the following headers: Date, Product, Sales Amount, and Region.
• Enter the sample data into the table, making sure to format the date column correctly.

📝 Note: Make sure to save your workbook regularly to avoid losing any data.

Step 2: Creating Charts and Graphs

Now that we have our data set up, we can start creating charts and graphs to visualize the data. We will be creating a bar chart to show the sales amount by region, and a line graph to show the sales trend over time.

• Select the data range that we want to use for the chart.
• Go to the Insert tab and select the chart type that we want to use (in this case, a bar chart).
• Customize the chart as needed, including adding a title and labels.
• Repeat the process to create a line graph showing the sales trend over time.

Region	Sales Amount
North	100,000</td> </tr> <tr> <td>South</td> <td>80,000
East	120,000</td> </tr> <tr> <td>West</td> <td>90,000

Step 3: Analyzing the Data

Now that we have our charts and graphs, we can start analyzing the data to gain insights and make informed decisions. We will be using various tools, including filters, pivot tables, and conditional formatting.

• Use filters to narrow down the data and focus on specific regions or products.
• Create a pivot table to summarize the data and show the total sales amount by region.
• Use conditional formatting to highlight cells that meet certain conditions, such as sales amounts above a certain threshold.

💡 Note: Use the Analyze tab to access various data analysis tools, including Analyze Data and Editor.

Step 4: Visualizing the Data

In this step, we will be using various visualization tools to help us understand the data and identify trends and patterns. We will be creating a map to show the sales amount by region, and a scatter plot to show the relationship between two variables.

• Go to the Insert tab and select Map to create a map showing the sales amount by region.
• Customize the map as needed, including adding labels and a legend.
• Repeat the process to create a scatter plot showing the relationship between two variables, such as sales amount and product price.

In summary, this guided project has covered the basics of data analysis and visualization in Excel 2021. By following these steps, users can gain a solid understanding of how to work with data in Excel, create charts and graphs, and use various tools to analyze and interpret data.