Course

Table, Pivot Tables & Charts in Excel

Simon Sez IT

Updated Feb 03, 2020

Course Overview

In this short course, we first introduce you to the power of tables before moving onto how to pull insight from your data using the PivotTable function. We then move on to showing you how to display and communicate that insight through charts and graphs.

Target Audience

Administrators, Graduates, people in Financial Services, Accountancy.

Learning Objectives/Outcomes

In this course you will learn:

How tables work in Microsoft Excel
All about different table styles
How a pivot table works
How to use the PivotTable function to analyse your data
How to apply filters and slicers to your pivot table
How Pivot Charts work
How to use Area Charts, Radar Charts and Bubble Charts
How Sparklines and Stock Charts work

Related learning

Analyzing Data in Excel 2016: Create and Modify TablesInteractive ⋅ 7 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Simon Sez ITGLOBAL

Self-paced, affordable software training is what Simon Sez IT is all about. They teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks®️. Their approach to teaching comes from their passion to fully explain how something works. They don’t skirt around the edges. With 50+ courses and over 1000 learning resources now available in Go1 globally, Simon Sez IT makes business and technical software simple to learn. From Excel to photo editing, their step-by-step tutorials will kickstart your software skills and help you learn IT. Simon Sez IT is based in the US, however all of their content is globally relevant.