Pivot tables - Excel 2010

Microsoft Excel Pivot tables General instructions with exercises on BI4 Dynamics data 1 1 PREFACE 3 How to use this document 3 BI4 Dynamics 3 2 INTRODUCTION 4 Understanding dimensions and cubes 4 General features of BI4 Dynamics 4 Pivot tables 5 3 CONNECTING TO DATA 6 Creating a new Connection 6 Using an existing connection 8 Changing an existing report connection 9 Refreshing a connection 10 Connection properties 10 Changing language 12 Exercises 13 4 Pivot table OVERVIEW 14 Show fields related to area 14 Pivot table field list 15 Pivot table preview 16 Pivot table tools tabs 16 5 WORKING WITH Pivot tables 18 Creating, modifying and deleting the Pivot table layout 18 Nesting dimensions 18 Exercises 19 6 DATA DISPLAY OPTIONS 22 Dimension browsing (hierarch)

Microsoft Excel Pivot Tables General instructions with exercises on BI4Dynamics data

Loading..

Tags:

  Excel, Table, Pivot, Excel pivot tables, Pivot table

Information