Download this course and learn Excel 2016: Dynamic Tables - Learn how to organize, manage and present large tables dynamically and visually
This product is no longer in stock
Information of: Excel 2016: Dynamic tables
Download this course and learn Excel 2016: Dynamic tables - Learn how to organize, manage and present large tables dynamically and visually
Speed of calculation, versatility, ability to sort and filter ... all these are some of the adjectives and characteristics that we can apply to the dynamic tables. Therefore, they are one of the most useful and productive tools that exist in the field of spreadsheets. Pivot tables can perform tasks in a few seconds that would take several hours to complete. They are ideal for structuring, ordering, summarizing and filtering large amounts of data. With this course, mastering them will be within your reach and you will also see how to create, configure and format your tables, learning some advanced uses through practical examples.
Introduction to dynamic tables with Excel 2016
We begin in this chapter by discovering what dynamic tables are and how they work. It will also be very important to know the different ways we have when organizing information in Excel.
Ways to organize information in Excel 05:49
What is a dynamic table and what can it do for us 01:20
Who should or should not use dynamic tables 01:05
Creating dynamic tables in Excel 2016
In this chapter we will discuss the construction and general design of a dynamic table. We will learn to create simpler models to move towards dynamic tables with filters, with hierarchies, etc.
Data source and workspace of dynamic tables 04:26
Create row, column and value fields in a dynamic table 06:28
Create filter fields in Excel 2016 02:22
Create hierarchies with the fields in Excel 2016 03:52
Create groupings for date fields in Excel 2016 05:42
Create groupings for other fields in Excel 2016 05:30
Set the value field in Excel 2016 03:45
Additional actions with dynamic tables in Excel 20156 03:48
Insert fields and calculated elements in Excel 2016 05:09
The recommended dynamic tables wizard in Excel 2016 01:58
Configure options for a pivot table in Excel 2016
The behavior of a newly built pivot table does not usually coincide with our needs. Therefore, it is necessary to know the customization possibilities that we have at our disposal in the PivotTable Options dialog box.
Design and format of dynamic tables in Excel 2016 02:29
Totals and filters in dynamic tables in Excel 2016 01:16
Options in the Show tab of Excel 2016 02:17
Dynamic table printing options in Excel 2016 01:35
Data options in dynamic tables with Excel 2016 02:42
Format, design and order in dynamic tables in Excel 2016
Once our table is fully configured and its operation is adapted to our needs, we have to decide what it will look like. Almost all the commands that will help us do this are on the Design tab.
Activate or deactivate subtotals and totals in Excel 2016 02:31
Decide the structure of the pivot table report 01:25
Apply dynamic table styles in Excel 2016 01:52
Create and modify dynamic table styles in Excel 2016 01:54
Introduction to the conditional format in Excel 2016 06:37
Conditionally format dynamic tables with Excel 2016 03:31
Sort the information of the dynamic tables in Excel 2016 05:02
What it is and how to create a dynamic graphic in Excel 2016 05:14
Advanced ways to use pivot tables in Excel 2016
This chapter will be devoted to knowing some secrets stored by Microsoft Excel 2016 and that enhance the possibilities of using dynamic tables. This is a section for users near the advanced Excel.
Right button versus ribbon in Excel 2016 05:34
Filters to segment dynamic table data 04:32
Dynamic table data segmentation settings 03:15
Report connections to segment data in Excel 2016 02:01
Consolidate tables with dynamic tables in Excel 2016 04:51
Relational data models with dynamic tables 05:51
The IMPORTARDATOSDINAMICOS function of Excel 2016 01:41
Have always updated a pivot table in Excel 2016 05:60
Practical applications of dynamic tables in Excel 2016
In this chapter we can see a totally practical orientation and examples of how dynamic tables are applied to everyday problems in various areas of the professional world, among others the financial economic.
Get a list with unique values in Excel 2016 02:42
Get a ranking of a list of values in Excel 2016 02:38
Get a table with cumulative values in Excel 2016 01:53
Personnel costs and quarterly IRPF in Excel 2016 07:20
Analysis of sales by country and line of business in Excel 2016 06:53
Size: 396 MB
Formators: José Manuel Pomares
Content: 39 Videos
Duration: 2:24 hours
Software: Office, Office 2016, Excel, Excel 2016
Base Files: Yes Includes
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the program, to improve the content.
If you like or help this article. Support the developers by buying this material.
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.