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
-
2m 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
-
3m 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 text item that you have added, and change the overall visual style of your chart. 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 chart. 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. You can also move your PivotTable or remove it definetly. 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 settings. 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 others.A slicer is a special filter tool offered by Excel. It can be used to adjust the data that is visible in your PivotTable. It can also allow you to identify quickly the data filters that are currently applied. You can also use multiple slicers to gradually filter out the data that is not required for the task at hand. 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 tool you can even select the fields you need to analyze to get more useful insights. 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.
