Analyzing Data with Tables & Charts
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 chartadd chart titles, labels, and axisformat a chartcustomize chart axesinsert and edit data and field setup in a PivotTable
-
edit and configure a PivotTableuse sort tools to show and hide data in a PivotTableuse filter tools to show and hide data in a PivotTablevisualize data in a PivotChart
IN THIS COURSE
-
1.Inserting a chart2m 50sUP NEXT
-
2.Labeling your chart3m 58s
-
3.Formatting a chart4m
-
4.Customizing chart axis5m 8s
-
5.Creating a PivotTable5m 38s
-
6.Editing a PivotTable4m 23s
-
7.Sorting data in a PivotTable3m 30s
-
8.Filtering data in a PivotTable6m 16s
-
9.Inserting a PivotChart4m
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.