#How to use data analysis in excel 2013 how to#
#How to use data analysis in excel 2013 series#
#How to use data analysis in excel 2013 download#

To resize a chart, select the chart, and then drag one of the handles on the chartвЂ™s edges.

In that case, he would display the chart and data for each business unit on the same worksheet, so he would want to make his charts small. For example, Gary Schare, the chief executive officer of Consolidated Messenger, could create a workbook that summarizes the performance of each of his companyвЂ™s business units. In this chapter, youвЂ™ll create a chart and customize its elements, find trends in your data, create a dual-axis chart, summarize data by using sparklines, create diagrams by using SmartArt, and create shapes that contain mathematical equations.ДЄfter you create your chart, you can change its size to reflect whether the chart should dominate its worksheet or take on a role as another informative element on the worksheet. If the data in the worksheet used to create a chart represents a progression through time, such as sales over several months, you can have Excel extrapolate future sales and add a trendline to the graph that represents that prediction. You have a great deal of control over your chartsвЂ™ appearance-you can change the color of any chart element, choose a different chart type to better summarize the underlying data, and change the display properties of text and numbers in a chart.

#How to use data analysis in excel 2013 series#

In addition to the standard charts, with Excel 2013, you can create compact charts called sparklines, which summarize a data series by using a graph contained within a single cell. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually. However, a list of values in cells canвЂ™t communicate easily the overall trends in the data. When you enter data into a Microsoft Excel 2013 worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, or the price of a product. Summarizing your data by using sparklines.Д¬reating shapes and mathematical equations. Once we use Goal Seek, cell B6 will show us the minimum grade we'll need to make on that assignment.Creating shapes and mathematical equations

In this case, each assignment is weighted equally, so all we have to do is average all five grades by typing =AVERAGE(B2:B6). Even though we don't know what the fifth grade will be, we can write a formula-or function-that calculates the final grade. In the image below, you can see that the grades on the first four assignments are 58, 70, 72, and 60. You can use Goal Seek to find out what grade you need on the final assignment to pass the class. Luckily, you have one final assignment that might be able to raise your average. You currently have a grade of 65, and you need at least a 70 to pass the class.

#How to use data analysis in excel 2013 how to#

We'll use a few examples to show how to use Goal Seek. Goal Seek works in the opposite way: It lets you start with the desired result, and it calculates the input value that will give you that result. Whenever you create a formula or function in Excel, you put various parts together to calculate a result.

#How to use data analysis in excel 2013 download#

Optional: Download our practice workbook.