Course Excel Pivot Tables
The Excel PivotTables course is intended for users who daily encounter the requirement to process a large amount of data in MS Excel, as well as outputs from external databases. Users will learn to choose an effective way of working and automate it as much as possible.
Minimum input knowledge
Standard computer operation, experience with Microsoft Windows. Experience with Excel: moving around a document, basics of formatting, copying content and format, basics of working with formulas.
Course dates Excel Pivot Tables
Daily courses (1 day): 09:00 - 15:00
Course price: 150.00 / 184.50 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Excel Pivot Tables
Basic Rules for Working with Tables in Excel
- Review of functional possibilities.
- Working with a database as a source for a PivotTable.
Creating a PivotTable
- Working with row fields, column fields, page fields and the data area.
Modifying a PivotTable
- Setting the properties of the table value field.
- Setting the properties of the table label field.
- Setting the properties of the whole table.
- Formatting a table using an automatic format.
- Working with a calculated field of a PivotTable.
- Displays in sheets using the page field.
Creating a PivotChart
- Formatting a chart.
- Selected numeric axis formats.
- Changing axis ranges.
- Adding data and data series to a chart.
- Changing the chart type.
- Access to external data sources, multiple consolidation ranges.
Options for Automating Data Processing
- Creating a macro - running a data query and subsequent processing with a PivotTable, creating a predefined chart and using it.
- Discussion.
- Conclusion.
Output knowledge
Independent and effective mastery of working with extensive data in Excel. Creating, editing and effectively working with a PivotTable and PivotChart.
Recommended courses after completing Excel Pivot Tables
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel Pivot Tables
Average rating