EXPIV

Create Microsoft Excel statements (PIVOT tables)

Form of participation
Form of training
Length of training
  • 1 day (1×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

This course is designed for intermediate Excel users with intermediate knowledge and experience who frequently create reports and statements in their daily work and want to take advantage of Excel's advanced reporting features, from creating Pivot Tables, to referencing statement data, to using statement charts and external data sources.

Outline

  • Data management with spreadsheets - the advantage of creating a pivot table
  • Creating a pivot table, arranging fields
  • Formatting, layout, using styles, creating
  • Setting number format
  • Hide, reveal items
  • Subtotals, totals
  • Statement layout
  • Changing the value summation aspect
  • Individual calculations: calculation of row total, rolled up total
  • Options for displaying values
  • Filtering: use manual, label and value filter, toplist, slicer and timeline
  • Sorting
  • Grouping: dates, numbers, selected items
  • Reference to statement data, use and benefit of defined names
  • Calculated field, calculated value
  • Statement update (short introduction to the use of macros)
  • Eliminate cache sharing
  • Using external data source, data link file
  • Display diagram
  • Combining multiple data tables in a statement
  • Using the Statement Wizard
  • Statement printing options
  • Creating a statement from multiple data sources, building a data model
  • Insights into using PowerPivot
    • Outline (PDF)