Analyzing Data with Tables & Charts in Excel for the Web
Excel for the Web
| Intermediate
- 9 videos | 39m 44s
- Includes Assessment
- Earns a Badge
Analyze and present your data in a visually attractive manner in Excel for the Web. Learn how to prepare your data to insert your charts. Discover also how to change the appearance of your charts by changing the chart type or formatting different elements as titles, legends, and axis. Excel for the Web includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables. You can also sort and filter your data with labels, values, or even slicers. Even if Excel for the Web does not have an option to insert PivotCharts, you will see how to insert one from the Recommended Charts options and the Ideas tool.
WHAT YOU WILL LEARN
-
insert, edit and remove a chart
add chart titles, labels, and axis
format a chart
customize chart axes
insert and edit data and field setup in a PivotTable -
edit and configure a PivotTable
use sort tools to show and hide data in a PivotTable
use filter tools to show and hide data in a PivotTable
visualize data in a PivotChart
IN THIS COURSE
-
1. Inserting a chart in Excel for the Web2m 50sCharts can be used to analyze and present your numeric data in a visually appealing way. Excel for the Web comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
-
2. Labeling your chart in Excel for the Web3m 58sYour Excel for the Web charts will often contain a large amount of information. Make your charts easier to read by adding and adjusting different informational elements, including gridlines, axes, titles, and labels. FREE ACCESS
-
3. Formatting a chart in Excel for the Web4mOnce you have created your chart in Excel for the Web, you can begin to change its appearance by using the formatting tools. You can, for example, change the color setup for each element, adjust the font styles of any… FREE ACCESS
-
4. Customizing chart axis in Excel for the Web5m 8sYour chart axes can be modified to display a large amount of information. In Excel for the Web, you can adjust the measurement unit, move the maximum and minimum values, and even change where the two axes cross in the… FREE ACCESS
-
5. Creating a PivotTable in Excel for the Web5m 38sPivotTables are particularly useful when working with large amounts of data to quickly create summaries or reports based on the categories that you choose. Learn how to create a PivotTable and choose the data you need.… FREE ACCESS
-
6. Editing a PivotTable in Excel for the Web4m 23sPivotTables in Excel for the Web are extremely customizable. You can update your data source or even select new data from a different worksheet. In this video you will also how to configure your PivotTable appearance and… FREE ACCESS
-
7. Sorting data in a PivotTable in Excel for the Web3m 30sWhen you have created your PivotTable, you will be able to sort your data to prioritize the information you want. In Excel for the Web, you have several sorting options available: by columns labels, row labels or by value. FREE ACCESS
-
8. Filtering data in a PivotTable in Excel for the Web6m 16sThe PivotTable in Excel for the Web can cross different types of information vertically and horizontally. You can apply a filter to your table to display only the information that interests you, without deleting the… FREE ACCESS
-
9. Inserting a PivotChart in Excel for the Web4mIn Excel for the web, data can be presented more visually in a PivotChart. Learn how to insert a PivotChart from the Recommend Charts or use the Ideas tool to get suggestions about how to analyze your data. With the Ideas… FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
