Microsoft Excel - Charts and pivot tables

This course will provide you with a comprehensive introduction to Microsoft Excel Tables, PivotTables and PivotCharts. Creating a PivotTable from a list of data in Excel is an excellent way to analyse the information collected. This course covers how to create a PivotTable and chart the results within in a PivotChart.

Description

After completing this excel course, you will be able to:

  • Create and modify charts
  • Create a chart trendline
  • Analyse data using PivotTables and PivotCharts
  • Organise worksheet and table data

Prerequisites

Add information about prerequisites here such as previous experience, level of subject knowledge, or list specific topics that must have been completed before attending.

Target audience

This is where content about the target audience for this event is displayed. You can also add other sections to this page such as Objectives, Outcomes, and Videos.

?

Similar courses

Learn how to use Microsoft Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is intended for students who wish to gain the foundational understanding of Microsoft Excel.

More Information

Gain the knowledge and skills to become familiar with advanced data-management features and functionality of Microsoft Excel. You will automate some common Microsoft Excel tasks, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

More Information

Find out about excels latest features and how you can use it.

More Information