Analyzing Data with Tables & Charts in Excel for the Web

Excel for the Web    |    Intermediate
  • 9 videos | 39m 44s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 154 users Rating 4.7 of 154 users (154)
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 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
  • 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 text item that you have added, and change the overall visual style of your chart. 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 chart. 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. You can also move your PivotTable or remove it definetly. 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 settings. 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 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
  • 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 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.

YOU MIGHT ALSO LIKE

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course CompTIA Data+: Creating Charts & Graphs
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Analyzing & Manipulating Data Entries in Excel for the Web
Rating 4.4 of 27 users Rating 4.4 of 27 users (27)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Inferential Statistics
Rating 4.4 of 187 users Rating 4.4 of 187 users (187)
Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Course Excel Visualization: Getting Started with Excel for Data Visualization
Rating 4.5 of 435 users Rating 4.5 of 435 users (435)