Excel 2016: Pivot Tables In Depth

NB: There are Video Tutorials supporting this eBook. Link to video training is inclusive.

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016. We will show you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables.

Topics include:

Formatting data for use in a PivotTable

Creating a new PivotTable

Connecting to data sources

Consolidating data from multiple data sources

Creating calculated fields

Summarizing field data

Sorting and filtering PivotTables

Working with Excel slicers

Formatting PivotTables with styles and formats

Applying conditional formats

Creating PivotCharts

Printing PivotTables

Running macros

Creating a PivotTable using the data model

In this course, we will show you how to use pivot tables to analyse your data. We will start by showing you how to create pivot tables, manage pivot table options, and use pivot table data and formulas. We will also show you how to sort and filter pivot table data, create custom styles for your pivot tables, and apply conditional formats that change your data's appearance based on its value. Chapter six shows you how to create pivot charts, change your pivot chart's layout and formatting, and add a trendline to project future values.

The skills acquired from this version are mostly applicable to newer versions of Excel.

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Computer Based Training (CBT) is a way to master MS Excel. This is where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

The concept of spreadsheeting has been around for hundreds of years. The process can be described as the ability to arrange numbers, characters and other objects into rows and columns. It is most common that spreadsheets only contain numbers and text. The software version of spreadsheeting basically takes the manual processes described above and puts them into an electronic format. Whilst the accounting industry which most commonly uses spreadsheets they can be used in any situation.

Dettagli