Analyzing Data with Tables & Charts in Excel for the Web

Excel for the Web    |    Intermediate
  • 9 videos | 39m 44s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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

  • Playable
    1.  Inserting a chart in Excel for the Web
    2m 50s
    Charts 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
  • Playable
    2.  Labeling your chart in Excel for the Web
    3m 58s
    Your 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
  • Locked
    3.  Formatting a chart in Excel for the Web
    4m
    Once 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
  • Locked
    4.  Customizing chart axis in Excel for the Web
    5m 8s
    Your 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
  • Locked
    5.  Creating a PivotTable in Excel for the Web
    5m 38s
    PivotTables 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
  • Locked
    6.  Editing a PivotTable in Excel for the Web
    4m 23s
    PivotTables 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
  • Locked
    7.  Sorting data in a PivotTable in Excel for the Web
    3m 30s
    When 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
  • Locked
    8.  Filtering data in a PivotTable in Excel for the Web
    6m 16s
    The 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
  • Locked
    9.  Inserting a PivotChart in Excel for the Web
    4m
    In 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE