This service is not available, please contact for more information.

EXCEL Level 3

ANALYSE DATA WITH EXCEL PIVOTTABLES

  • By Quotation
  • Canberra

Service Description

ANALYSE DATA WITH EXCEL PIVOTTABLES EXCEL Level 3 Contents Analyse Excel Data Excel Tables and PivotTables Preparing your data Field Names Fields Records Create a table Sort Data Filter Data Create Subtotals Remove a table Create PivotTables PivotTable Areas for Field Placement Row and Column Fields Report Filter Fields Values fields Adding Fields Filtering data Manage row subtotals Add multiple Values fields Values fields calculations Values number format Show source data Show report filter pages Calculated Fields Grouping fields Grouping Labels Grouping to collapse data Pivot Charts Apply Slicers Use Relational tables Create Related Tables Create Relationships Combine related data Useful Key Commands btitle

Upcoming Sessions

Contact Details

  • Canberra ACT, Australia

    +61419298012

    john@acorntraining.com.au