Hello, now let me answer the above questions for you. Excel data analysis how to do ppt, Excel data analysis how to do I believe many friends still don't know, let's take a look now!
1. Data collection, entry and table setting, for example: 2. Select the data range to analyze.
2. As shown in the figure: EXCEL-Insert-Figure 3. Set the secondary navigation, click the conversion rate-right-click to pop up the menu-click to set the data series format, as shown in figure 4. Change the conversion rate into a graph.
3. Click Data Map-Right Click-Select the series whose icon type you want to change, and confirm submission as shown in the figure below.
4. ok.