Analyzing Data with Tables & Charts in Excel for the Web


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.7

Lesson Objectives

Analyzing Data with Tables & Charts in Excel for the Web

  • 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
  • Course Number:
    ds_msexon20_06_enus

    Expertise Level
    Intermediate