Microsoft Excel 2016 Level 2 Bundle

While pure data can be analyzed by those familiar with this data and the tools that Excel provides, sometimes you need graphical assistance to help interpret it. Additionally, charts are an enormous help when people do not have time to study the data and only need a brief overview of the relevant information. Over the course of this topic, you will learn how to create charts of different types, using different methods in Excel 2016.

One of the most powerful tools that you have your disposal when analyzing data in Excel is the PivotTable. While extremely useful, these interactive objects are somewhat cumbersome to execute properly and are often misused. For this reason it is important to understand how they work and gain some fundamental understanding of their purpose before creating PivotTables of your own data.

While the default appearance of your worksheets can be quite plain, Excel offers you access to a variety of graphical objects that you can use to enhance their visual appeal. Over the course of this topic, you will learn all about the various different types of graphical objects that you can add to your worksheets, as well as the various contextual tabs that are used to work with them.