Analyzing Data with Tables & Charts

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
    2m 50s
    UP NEXT
  • Playable
    2. 
    Labeling your chart
    3m 58s
  • Locked
    3. 
    Formatting a chart
    4m
    FREE ACCESS
  • Locked
    4. 
    Customizing chart axis
    5m 8s
    FREE ACCESS
  • Locked
    5. 
    Creating a PivotTable
    5m 38s
    FREE ACCESS
  • Locked
    6. 
    Editing a PivotTable
    4m 23s
    FREE ACCESS
  • Locked
    7. 
    Sorting data in a PivotTable
    3m 30s
    FREE ACCESS
  • Locked
    8. 
    Filtering data in a PivotTable
    6m 16s
    FREE ACCESS
  • Locked
    9. 
    Inserting a PivotChart
    4m
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE PL-300: Creating & Formatting Charts In Power BI
COURSE Analyzing Data with Tables & Charts
Likes 7 Likes 7  
BOOK Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More