5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 365     Excel for the Web

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.



Objectives

Excel for the Web: Analyzing Data with Tables & Charts

  • 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